JDBC connection cache

(CRs #440605, #440158, and #427244) An error occurs when closing the database connection with jdbc3 driver. To work around this issue, you can use one of the following methods:

Modify the connection pool driver from com.sybase.jdbc3.jdbc.SybDriver to com.sybase.jdbc2.jdbc.SybDriver.

Retain jdbc3 driver. However, you need to update the jConnect3.jar and jTDS3.jar files. After updating these files, upgrade the database, and set the J2EE_TCK_COMPLIANT to true before running the application:

Download the jConnect for JDBC 6.05 to obtain the latest jConnect3.jar and jTDS3.jar files.
Upgrade the database. Execute the relevant sql file, which is located in \jConnect-6_0\sp. The sql file selected depends on the database version. For example, for ASE 12, select and run sql_server12.sql.

The following example illustrates how to upgrade Zeus database.

isql -S Zeus -U sa -P "" -i E:\tempshared\ jConnect-6_0\sp\sql_server_recreate12.5store_p.sql -c go.

Modify the following codes to set J2EE_TCK_COMPLIANT to true.

Original code	Modified code
`URL = jdbc:sybase:Tds:<hostname>:<portno>`	`URL = jdbc:sybase:Tds:<hostname>:<portno>? J2EE_TCK_COMPLIANT=true`
`NetworkProtocol = Tds:Server=<hostname>:Port=<portno>: DatabaseName=<dbname>`	`NetworkProtocol = Tds:Server=<hostname>:Port=<portno>: DatabaseName=<dbname>:J2EE_TCK_COMPLIANT=true`
`con=DriverManager.getConnection(url,user, password)`	Properties p = new Properties(); p.put(“User”,user); p.put(“Password”,password); p.put(“J2EE_TCK_COMPLIANT”,true); con = DriverManager.getConnection(url,p);

For more information about the JDBC connection cache, see Chapter 4, “Database Access,” in the EAServer System Administration Guide.