Configuring JDBC Adpater

, ,
1

I have installed JDBC Adpater 6.0.3 on WM6.0.1.

How to configure the JDBC Adapter for MSSQL server

2

UMG,
Kindly Refer page no:58 <isdir\integrationserver\packages\wmjdbcadapter\doc\wmjdbcadapteruserguide.pdf>
Documentation about Configuring JDBC Adapter for MSSQL Server 2000 is also given.

Regards,
Puneet Saxena

3

I configured the JDBC Adpater as per the pdf.

Here are the list of parameters:

transaction type =local_transaction
DataSource Class=com.microsoft.jdbcx.sqlserver.SQLServerDataSource
servername=IP of database
user/pasword
databaseName=DBNM
portNumber=1433

But when I try to enable the connection I get following error,

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource newconn:conn.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
javax/sql/DataSource

I have copied the jar files for MSSQL db in lib\jar
am I missing anything

4

Hi,

Please follow the below link. This case has been resolved long time.

[url=“wmusers.com”]wmusers.com

Keep the following things in mind while confg the JDBC adapter.

  1. Put the classes.zip or driver classes in the webMethods lib dir.

  2. Restart the WM server.

  3. Make sure that u have new version of driver classes.

Regards,
Rama

5

I followed the thread. The solution was not provide in the thread.
i have place the driver classes in webMethods/lib/jar and also in JDBCAdapter/code/jar as per the thread.
No luck, problem is not solved

6

Please add the following javaxsql.zip to your class path of environmental variables and restart the server. It will solve your problem.
F:\IntegrationServer\packages\WmJDBCAdapter\code\jars\javaxsql.zip;

7

thanks sreenivas.
By adding the javaxsql.zip to the class path has solved the problem