Setting Up a Transactional ASE Database Service

You can set up a transactional ASE database service.

If you want to use a transactional Adaptive Service Enterprise (ASE) database service in a business process service, you must disable the Autocommit option in the database service editor, deploy the business process service, and then reconfigure the Connection Cache created in EAServer Manager. You can also select the ASE XA driver when creating a connection profile for ASE. This automatically sets the required properties.

Note: You cannot set up a SQL Anywhere database service to be transactional. To set up a transactional database service for other database types (Oracle), ensure the database is currently configured to handled XA transactions. You must also have the correct DLL or Class identified in EASConnection Cache Properties. For detailed information, see the EAServer documentation located at the main level of the Sybase WorkSpace online bookshelf. If this server documentation is not installed, the documentation is available on the Sybase Product Manuals Web site at http://sybooks.sybase.com.
  1. Open the database service.
  2. Deselect the Autocommit option in the Operations section of the service editor.
  3. Save the service.
  4. Deploy the business process service.
  5. Reconfigure the EAServer Connection Cache properties:
    1. Open EAServer Manager.
    2. In the tree view, expand EAServer Manager and select the machine that runs the business process service.
    3. Double-click Connection Caches to display the cache list in the right pane.
    4. Open the Connection Cache dialog box.
    5. Double-click the <business process service name>.
    6. Specify the following properties and click OK:
      Table 1. General Properties tab
      Property Description
      Server Name NetworkProtocol=Tds:Server=<db_host_name>:Port=<db_listener_port>
      XA Server Name NetworkProtocol=Tds:Server=<db_host_name>:Port=<db_listener_port>
      Table 2. Driver Properties tab
      Property Description
      Connection Library 1PC In the DLL Class name, specify:

      com.sybase. jdbc2.jdbc.SybConnectionPoolDataSource

      Connection Library XA In the DLL Class name, reconfigure the default to be:

      com.sybase.jdbc2.jdb. SybXADataSource

  6. To restart EAServer, right-click Jaguar Manager and select Shutdown and Start.
  7. Reconnect to EAServer using the connection profile in the Enterprise Explorer.
Parent topic: Developing a Database Service
Previous topic: Adding an Endpoint to a Database Service Using the JDBC Endpoint Wizard
Related concepts
Database Services
Related tasks
Creating an ASE Connection Profile
Related reference
ASE Datatypes Supported by Service Container

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.