Deploying JDBC drivers in PI 7.0

[Former Member]

Dear All,

My PI consultant facing following error,

Error during database connection to the database URL 'jdbc:sqlserver://10.0.96.2;databaseName=GSPCGASAsset;user=**;password=**;' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection :: SAPClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver'

asking for installing JDBC Driver?

which driver i need to install? and how to install that? how to check that?

I checked in visual admin there is already some JDBC Driver Install?

From,

Ketan Kapadi

[kenny_scott · Accepted solution]

Hi Ketan,

PI 7.0 uses the 1.4 JDK therefore the MS SQL driver to deploy is -

sqldriver12

You should remove the other MS SQL driver jar files from the file -

aii_af_jmsproviderlib.sda

Regards

Kenny

[former_member207622]

Please check the version of sqldatabase whether its 2005 , 2008 , go to microsoft site and then search for drivers

please follow the links and how to guide giving you some idea

take help of BASIS wherever required

http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-9644...

thanks

Ninad

[Former Member]

Dear Ninad Sane ,

Thank You very much i have downloaded the driver but post installation steps are for windows i am looking for HP-UX IA64 , Please let me know how to deploy this patches in PI 7.0 in HP-UX

From,

Ketan Kapadi

[former_member854360]

Install the driver using JSPM tool .......Take help from your basis team

[former_member207622]

If you are on PI7.0 you need to log on to visual admin and you have to deploy those drivers using SDM

Please follow this guide and take help from BASIS

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4d...

Thanks

Ninad

[Former Member]

As Ninad said, Install driver with SDM tool.

To start SDM remote GUI, you can follow this help:

http://help.sap.com/saphelp_nw04/helpdata/en/76/fb72ec091f4bf8a2d8ba321bb7e8d9/frameset.htm

If you are not confident with this arguments, take help from Basis Team.

[Former Member]

Dear Ninad,

Guide shows me as follows,

The step-by-step guide also assumes Microsoft Windows as the

operating system.

I am basis consultant and i wants to keep my previous JDBC version and wants to install new JDBC Driver.

I downloaded the Microsoft JDBC Drvier 2.0 for Unix and it is in the .tar extension

[former_member207622]

Hi Ketan ,

Follow this guide it shows how to untar that file and create a jar but i am not too sure whether it will work for PI7.0

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8000cffc-6b92-2d10-3493-f2ac13992...

I have never done this for unix platform

let me know if you succeed

thanks

Ninad

[Former Member]

Dear Ninad,

I have sucessfully installed jdbc driver on unix PI 7.0 but now getting following error,

com.sap.aii.af.ra.ms.api.DeliveryException: Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection :: UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver (Unsupported major.minor version 49.0)

Please suggest some thing

From,

Ketan Kapadi

[rajasekhar_reddy14]

The driver file what you have installed is older version it seems,driver file depend on version of data base.

Please deploy correct driver files.