Skip to Content
avatar image
Former Member

JDBC Receiver adapter configuration for MS SQL

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    Nov 25, 2009 at 06:10 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 25, 2009 at 06:07 AM

    >>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...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 25, 2009 at 07:12 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 25, 2009 at 07:17 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 25, 2009 at 07:53 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 30, 2010 at 11:30 PM

    Hi Shweta,

    Pls tell us what was the solution to your issue?

    --

    Regards

    VJ

    Add comment
    10|10000 characters needed characters exceeded