JDBC SQL Server

[EdgarTabar]

Hi,

i'm getting the following error message while sending message to a MS SQL Server 2008 DB ;

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Can not establish connection:: SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

The jdbc driver (Version 4.0) i had deployed is the file sqljdbc.jar (not sqljdbc4.jar) file in: \usr\sap\<SID>\DVEBMGSXX\j2ee\cluster\bin\ext com.sap.aii.adapter.lib\lib.

Is this the correct version for the jdbc driver?

The value for the JDBC Driver and Connection parameters are:

com.microsoft.jdbc.sqlserver.SQLServerDriver

jdbc:sqlserver://<SERVER>:1433;databasename=DBNAME

The user has read and write access to all DB table and the port 1433 is also open.

Best regard

Edgar

[MichalKrawczyk · Accepted solution]

Hi,

>>>

The jdbc driver (Version 4.0) i had deployed is the file sqljdbc.jar (not sqljdbc4.jar) file in: \usr\sap\<SID>\DVEBMGSXX\j2ee\cluster\bin\ext com.sap.aii.adapter.lib\lib.

Is this the correct version for the jdbc driver?

did you deploy the driver with JSPM as per OSS notes on this topic?

Note 1138877 - How to Deploy External Drivers JDBC/JMS Adapters

Regards,

Michal Krawczyk

[EdgarTabar · Accepted solution]

With JSPM !

I found the problem:

The the JDBC Driver for 2008 is

com.microsoft.sqlserver.jdbc.SQLServerDriver

and not

com.microsoft.jdbc.sqlserver.SQLServerDriver (this is only for 2000)