cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC drivers for SQL Server 2008 and PI7.0

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

The JDK version for PI 7.0 is 1.4.2 and the SQL server is JDK5. I could not find the JDK 1.4.2 version JDBC drivers for SQL Server 2008. Please let me know where I can find them?

Regards.

Former Member
0 Kudos

Hi,

Check out this link will give you all details...

[http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en|http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en]

Hope this will help,

Nilesh

Former Member
0 Kudos

Hi Nagasatya,

The JDBC for SQL 2008 is not complatible with JDK 1.4., But you can use JDBC for 2000/2005 which also can establish connection with SQL 2008 and It be compatible with JDK 1.4.. I give you the link.

Pls, check it:

[ JDBC|http://www.microsoft.com/downloads/details.aspx?FamilyID=4F8F2F01-1ED7-4C4D-8F7B-3D47969E66AE&displaylang=en]

Regards

Ivan

Former Member
0 Kudos

Hey Ivan,

This is Nagasatya.

I did what you said and deployed the drivers for the SQL Server 2005.

Then I configured the Sender and Receiver CCs. I am doing a JDBC 2 JDBC scenario now to check the JDBC connection.

When I go to the RWB to monitor, the Sender CC has the same error while the Receiver CC is working perfectly.

The URL and the driver path are the same for both the sender and receiver channels.

I dont know what is wrong here.

Regards.

Edited by: DNSPK on Jul 22, 2009 7:11 PM

Former Member
0 Kudos

I undepolyed and redeployed the drivers and uninstalled the SQL Server and reinstalled it.

Set the ports and everything is working fine now.

Thank you very much for your help guys.

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

Hi Sujan,

This is the link.

[JDBC|http://www.microsoft.com/downloads/details.aspx?familyid=c47053eb-3b64-4794-950d-81e1ec91c1ba&displaylang=en]

or

You can also use the one on the market place.

Go to http://service.sap.com/msplatforms -> SQL Server

get zip-file sqljdbc_12_hotfix.zip contains the sqljdbc.jar file.

It should work.

Please let me know if you have any questions.

Regards.

Answers (0)