JDBC Receiver adapter configuration for MS SQL

[Former Member]

Hi friends,

I have configured receiver jdbc adapter for MS SQL database which are as follows:

jdbc driver : com.microsoft.sqlserver.jdbc.SQLServerDriver

connection: jdbc:sqlserver://USLABWDB01:1433;DatabaseName=Central_Lab_BIDB

In communcation channel i am getting following error:

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://USLABWDB01:1433;DatabaseName=Central_Lab_BIDB': UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver (Unsupported major.minor version 49.0)

Kindly tell me what is the root cause of the issue.

Renu.

[rajasekhar_reddy14 · Accepted solution]

Hi ,

This problem because of the driver jar file you deployed in PI,i think the version of Jar not compatible,check in microsoft website to get updated and compatible version.

then problem will resolve.

Cheers,

Raj

[Former Member]

Hi Shweta,

Pls tell us what was the solution to your issue?

--

Regards

VJ

[Former Member]

Hi Renu,

Just saw the difference in the JDBC drivers:

JDBC driver you have mentioned: com.microsoft.sqlserver.jdbc.SQLServerDriver

JDBC driver provided by me : com.microsoft.jdbc.sqlserver.SQLServerDriver

There is a small difference in them, not sure whether this is creating a problem.

But you can try this.

-Tanaya.

[Former Member]

Hi Renu,

Try foll. 2 steps:

1) Add the IP address of the server(USLABWDB01) to the host file of your PI server, as you are connecting using Hostname.

2)Try the following connection strings:

jdbc driver : com.microsoft.jdbc.sqlserver.SQLServerDriver

connection: jdbc:microsoft:sqlserver://USLABWDB01:1433;DatabaseName=Central_Lab_BIDB

Here, 'microsoft' word is added in connection string.

Try using this, it should work.

-Tanaya.

[Former Member]

Hi Tanaya,

I am encountering same error.

[former_member109058]

it must be that the driver version is incompatible with the DBMS.

You can check with MS which jars are needed for your current SQL Server. Then find "how-to deploy external JDBC/JMS drivers" document from SAP.

[santhosh_kumarv]

>>jdbc:sqlserver://USLABWDB01:1433;DatabaseName=Central_Lab_BIDB

1. Try this URL

URL :jdbc:sqlserver://USLABWDB01:1433;databaseName=Central_Lab_BIDB

2. Check if your are using the correct Driver for the MS SQL

~SaNv...