XI 7.3 SPS03 - JDBC Driver for HP-UX

[Former Member]

Hello

we just did an upgrade from XI 7.0 to XI 7.3 SPS03 and now we are are having issues with the JDBC driver Deployment. After the upgrade we immediatly got an error:

JDBC message processing failed; reason Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection with the registered driver. com.microsoft.sqlserver.jdbc.SQLServerDriver returns: com.microsoft.sqlserver.jdbc.SQLServerDriver.

: SAPClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

We did than applied the sqljdbc.jar as described in here:

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/8000cffc-6b92-2d10-3493-f2ac1399242f

We did also checked #831162, with no sucess.

https://service.sap.com/sap/support/notes/831162

20. ClassNotFoundException while using SQL Server 2005 Driver

u2022 Q: I am not able to connect to DB using SQL Server 2005 driver if I use com.microsoft.jdbc.sqlserver.SQLServerDriver as driver class name. I get classNotFoundException. Why?

A: Driver class names for SQL Server 2000 driver and SQL Server 2005 driver are different.

If you are using SQL Server 2005 driver, then class name should be as follows:

Driver class: com.microsoft.sqlserver.jdbc. SQLServerDriver

URL :jdbc:sqlserver://<db_Server>:port;databaseName=< db_name>

If you are using SQL Server 2000 driver , then class name should be as follows:

Driver class: com.microsoft.jdbc.sqlserver. SQLServerDriver

and URL is as follows:

jdbc:microsoft:sqlserver://<db_server>:port; databaseName=<db_name>

Now we are getting the next error which is:

Delivery of the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection with the registered driver. com.microsoft.sqlserver.jdbc.SQLServerDriver returns: 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..

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

We will now try to apply sqljdbc4.jar.

My general question is does anybody knows which one is the correct one for 7.3?! Did someone got this to work with sqljdbc4.jar?!

I can only find information for 7.1 but I am not sure if the same holds true for 7.3. There is only very little information for 7.3 and not much in OSS.

Thanks for any input

regards

Nesimi

[Former Member]

SAP just updated #1138877 with information regarding 7.3

[Former Member]

Hi,

The Drivers for JDBC is not related to the PI version. You have to download the specific drivers according to the database version. Afert downloading the drivers you need to create a SDA file then have to deploy that file on the server.

Try below link

To download the jar file for SQL

http://www.microsoft.com/downloads/details.aspx?FamilyID=4F8F2F01-1ED7-4C4D-8F7B-3D47969E66AE&displa...

To deploy the Jar file

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/60237e74-ef19-2b10-5a9b-b35cc6a28...

Regards,

Raju.