PI JDBC MSSQL - JRE version 1.6 is not supported by this driver

[former_member105769]

Greetings

Im getting this error when trying to connect PI 7.3 to a MS SQL Database:

"Exception Occurred : Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0."

I am actually using the PI_URL/ftpjdbc "Qucik Connectity Test" diagnostic tool to test this.

So I have added sqljdbc4.jar to com.sap.aii.adapter.lib.sda and this has been successfully deployed using JSPM

However, I'm still getting the same error.  The URL I am using is com.microsoft.sqlserver.jdbc.SQLServerDriver

Im not sure if this is related to the fact that I have both sqljdbc.jar  and sqljdbc4.jar included.

Any ideas please?

Regards

Steve

[ambrish_mishra · Accepted solution]

Hi Steve,

I would suggest to remove the sqljdbc.jar and try ...

Ambrish

[Former Member · Accepted solution]

Hi Mishra,

I have deployed JDBC driver (sqljdbc4.0 ) according to http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00b4a020-4ae6-2c10-5a95-fed4ad9a4... .

Driver deployed successfully and I have checked it in folder \usr\sap\xxx\DVEBMGS30\j2ee\cluster\bin\ext\com.sap.aii.adapter.lib\lib and it's found ok. But this adapter type  not showing in Communication Channel only RFC and SOAP are showing there. I have restarted the server also. Can you tell me where the problem is?. I am trying to find the solution from last week but no solution found.

I am using PI 7.3 with dual stack

[former_member227283]

Just for Reference, SAP has provided the note for supported jar file depends on the JRE version.

1745895 - Available Microsoft JDBC drivers

Note can help for anaylses of the error for understanding the supported JAR file.

Regards,

Anil Bhandary

[rodrigoalejandro_pertierr]

take a look to these web site

http://www-01.ibm.com/support/docview.wss?uid=swg21468491

https://forums.oracle.com/thread/1062279

also consider to review this doc

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00b4a020-4ae6-2c10-5a95-fed4ad9a4...

 The problem is that your classpath first points to sqljdbc.jar 
>
...;C:\KEEP\A_SOA_ActiveVOS\SQLserverjdbc_Driver\sqljdbc_2.0\enu\sqljdbc.jar
>
so this dirver is loaded instead of the sqljdbc4.jar.
Remove the old jar from the class path and try again
The classpath is build from the libraries and there contents. I doubt that this jar is part of a library you add to you project, but you can search for it. Check your environment if there is a classpath variable set.