I downloaded JDBC drivers 1.2 and 2.0 version for SQL 2005 from Microsoft. I copied jar files for both version each time in WMDir\IntegrationServer\lib\jars. When I try to enable connection JDBC Adapter, I get following error. I also have set the classpath for these jar files,
The reason I am trying to use different JDBC drivers instead of WM Built in drivers because I want to handle explicit transaction commit and rollback and since one week I am not able to acheive it. When I use Built in drivers, Rollback does not work and I get following message by using get last error,
[ART.114.306] Adapter Runtime (Transaction): Unable to rollback transaction.
null"
As per JDBC Adapter Install guide, following drivers are supported for SQL Server 2005 :
Microsoft SQL Server 2005
Driver for JDBC, version
1.0.809.102
I downloaded above mentioned JDBC but still getting below error, Error encountered [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource MyTest.adapter:MyTest. [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager. com.microsoft.sqlserver.jdbc.SQLServerDriver
My Integration Version is, and JVM used 1.4.2_11 (48.0) Product webMethods Integration Server Version 6.5 UpdatesWmPRT_6-5-1_SP1 IS_6-5_SP2 Build Number 394 SSLStrong (128-bit)
Now I updated WM65 Service pack to SP3. Used build in WM JDBC driver for SQL2005 and also provided by microsoft version sqljdbc_1.0.809.102_enu, sqljdbc_1.2.2828.100_enu, sqljdbc_2.0.1008.2_enu.tar but always get following error while Rollback,
[ART.114.306] Adapter Runtime (Transaction): Unable to rollback transaction.
null