JConnect Type 4 Driver for Sybase ASE 12.5 Databases

The JAR file for the Sybase driver is jconn2.jar. Configure the connection pool using the following settings:

• Name: Use this name when you configure the JDBC resource later.

• Resource Type: Specify the appropriate value.

• Database Vendor: Sybase

• DataSource Classname: Specify one of the following:

  com.sybase.jdbc2.jdbc.SybDataSource
  com.sybase.jdbc2.jdbc.SybXADataSource

• Properties:

  • serverName - Specify the host name or IP address of the database server.

  • portNumber - Specify the port number of the database server.

  • user - Set as appropriate.

  • password - Set as appropriate.

  • databaseName - Set as appropriate. Do not specify the complete URL, only the database name.

  • BE_AS_JDBC_COMPLIANT_AS_POSSIBLE - Set to true.

  • FAKE_METADATA - Set to true.