Enabling ASE Real-Time Messaging Services

If you require Adaptive Server Enterprise real-time messaging services, you must have met the following prerequisites:

Additional information for these prerequisite steps is provided in the Installation Guide for Sybase Developer Edition Servers.

Configure the ASE server properly. You can configure your ASE server manually or with the ASE Features Enabling wizard.

Use the following procedure to manually enable real-time messaging services.

Install the real-time messaging services stored procedures. You must have an sa role to complete this setup:
isql -i$SYBASE/$SYBASE_ASE/scripts/installmsgsvss
Enable and grant ASE Messaging role:
- isql -Usa -P<password> -S<server>
- sp_configure 'enable real time messaging', 1
- grant role messaging_role to sa
Verify ASE real-time messaging features:
- If not yet started, start your TIBCO EMS server. Find out the URL from TIBCO EMS Server console
- select msgsend("hello","tibco_jms:tcp://<hostname>:7222?queue=q.sample")
- select msgrecv("tibco_jms:tcp://<hostname>:7222?queue=q.sample")
Register a JMS provider:
sp_msgadmin 'register', 'provider', <provider name> 'TIBCO_JMS', <messaging provider URL shown in TIBCO JMS server console>
For example,
sp_msgadmin 'register', 'provider', myTibcoJMS, TIBCO_JMS', 'TIBCO_JMS', 'tcp://localhost:7222'

See Messaging Services User's Guide for Adaptive Server Enterprise: Real-Time Data Services.

See Installation and Release Bulletin for Sybase Real-Time Data Services.

See the TIBCO user documentation available with product download.