Using Sybase DYNAMIC_PREPARE in a prepared statement

Technote (FAQ)
Problem
Configuring DYNAMIC_PREPARE = true in a DataSource results in a "com.sybase.jdbc2.jdbc.SybSQLException" when a prepared statement is executed with "auto commit = true".
Cause
The WebSphereŽ Application Server prepared statement cache and Sybase DYNAMIC_PREPARE property are not compatible due to the auto commit error. WebSphere Application Server code is working as designed.
Solution
Turn off WebSphere Application Server prepared statement caching OR set DYNAMIC_PREPARE = false.

The default value for DYNAMIC_PREPARE is false.












Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, DB Connections/Connection Pooling
Operating system(s): Multi-Platform
Software version: 3.5, 4.0, 5.0, 5.1, 6.0
Reference #: 1190191
IBM Group: Software Group
Modified date: 2004-11-11