JDBC receiver: UnsupportedClassVersionError

[Former Member]

Hi,

Am getting this error when using JDBC receiver adapter with SQL server.

"UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver : Unsupported major.minor version 50.0"

The SQL driver used is "com.microsoft.sqlserver.jdbc.SQLServerDriver" and SQL 2008 is used in the target server.

Please help in resolving this.

Thanks,

Jayan

[baskar_gopalakrishnan2 · Accepted solution]

This is a common problem.  The driver jar contains java class which is not compatible with java version.

Since you are using 2008 sql server, you have to upgrade jdbc jar that supports this server version in PI. Please refer microsoft  link to choose ther right jdbc jar .That means you need to have jdk 1.5 version and above to run this jdbc jar.  If your PI version is 7.0 then you cannot use jdk 1.5, you need to stick with jdk 1.4. YOu cannot upgrade the jar and interface with sql server 2008.  If your  PI version is 7.1 and above then you just neeed to install the jdbc jar that support 2008 and no jdk compatible issue. Hope that helps.

[Former Member · Accepted solution]

Hi Baskar,

Our PI version is 7.1 EHP1 (jdk 1.5), and we have installed the sql jdbc driver 4.0.

But still we are getting the error "UnsupportedClassVersionError".

What could be the reason here...

According to microsoft site, jdbc 4.0 support jdk 1.5.

How can we verify which jdbc driver support jdk 1.5 (of PI).

Or has it something to do with the driver class name.

If you can provide the link for the right SQL jdbc driver in this case, it will be of great help.

Thanks,

Jayan

[Former Member]

Hello,

Please refer SAP Notes

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

Note 831162 - FAQ- XI 3.0 &  PI 7.0 &  PI 7.1 & PI 7.3 JDBC Adapter

Regards

Pradeep

[zameerf]

Hi Jayan,

Additionally you can refer the below blog if you have PI 7.0 without EHP1.

http://scn.sap.com/people/dheeraj.kumar5/blog/2010/03/23/sql-server-2008-connectivity-with-sap-pi-70...

Regards,

Zameer