Hi all,

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,

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Test7_1.adapter:Test7_1.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
com.microsoft.sqlserver.jdbc.SQLServerDriver

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"

Regards,
Faisal

Hi,

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

Regards,
Sumit

First thanks for your reply.

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)

Regards,
Faisal

Hi,

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

I really need hep and appreciate,
Regards,
Faisal