|
| 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. | |
| | |
| |
|
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
(C) Copyright IBM Corporation 2000, 2004. All Rights Reserved.
|