Skip to Content
avatar image
Former Member

JDBC drivers for SQL Server 2008 and PI7.0

HI,

I have deployed the JDBC drivers (sqljdbc.jar and sqljdbc4.jar) available for the SQL Server 2008 from the microsoft website as described in the how to document for deploying and configuring JDBC and JMS adapters.

I am running a JDBC to FIle(XML) scenario. When I go and see on the RWB CC monitoring, I get this error

Error during database connection to the database URL 'jdbc:sqlserver://hostname:1433;databaseName=123_Nagasatya' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://hostname:1433;databaseName=123_Nagasatya': UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver (Unsupported major.minor version 50.0)'

WRT to the SQL server the port 1433 is open on the host and there is no firewall on the PI server as well as the SQL Server. Both are on different machines.Any help would be greatly appreciated.

Regards.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jul 15, 2009 at 05:50 PM

    Hi,

    Check the version of JDK of PI and see in the documentation which version is required for "sqljdbc.jar" and "sqljdbc4.jar".

    Regards

    Ivan

    Add comment
    10|10000 characters needed characters exceeded