Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Deployment HANA Driver in PI 7.31

Dear All,

Regarding the steps I followed HANA JDBC Driver deployment in PI 7.31 sp16(dualstack).

1) Download the "com.sap.ndb.studio.jdbc_2.1.16.jar" file from HANA studio

2) change .jar file to "com.sap.db.jdbc.Driver.jar"

3) Add the modified driver files to the lib directory of the archive com.sap.aii.adapter.lib.sda with the help of a zip program.

Then to modify the provider.xml file in the server directory of the archive com.sap.aii.adapter.lib.sda

4) Deployed into PI successfully.

I see the driver in this path   "usr/sap/SID/DVEBMGS40/j2ee/cluster/bin/ext/com.sap.aii.adapter.lib/lib"

And my configuration in JDBC communicational defined:

Error when trying to connect HANA Database 'SAPClassNotFoundException":

using the JDBC driver 'com.sap.db.jdbc.Driver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection with the registered driver. com.sap.db.jdbc.Driver returns: com.sap.db.jdbc.Driver.

: SAPClassNotFoundException: com.sap.db.jdbc.Driver'

Can you please suggest me about this error that where could be the wrong.

Thank you very much.


Sateesh N

Former Member
Former Member replied

Hi Sateesh,

Extract the jar file com.sap.ndb.studio.jdbc_<version>.jar you will find ngdbc.jar under lib directory.

You need to deploy this jar file into PI server because this one got the Driver Class.

Regards,

Praveen.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question