JDBC Driver

[former_member192375]

Hi,

How to verify if the JDBC driver for the adapter is deployed?

Regards

Willie Hugo

[former_member192375 · Accepted solution]

Sarvesh,

Please can you also answer:

Does one always have to deploy a JDBC Driver even when the DB for PI (ABAP & JAVA Stacks) itself is the same and the DB type and version than the adapter is going to connect to?

Regards

Willie Hugo

[Former Member · Accepted solution]

Whenever you require to communicate with third pary DB by using JDBC adapter then we deploy JDBC Driver (irrespective of ABAP & JAVA Stack DB).

Regards,

Sarvesh

[former_member192375]

Hi,

We are using SAP PI 7.10 SP8.

The real question here is. Does one always have to deploy a JDBC Driver even when the DB for PI (ABAP & JAVA Stacks) itself is the same and the DB type and version than the adapter is going to connect to?

Or do you only load a separate JDBC driver once you require connecting to a different DB via an adapter.

How does one deal with a scenario where you are connecting, via adapters, to different DB type & version and you require multiple/different drivers for different adapters?

I would greatly appreciate you input on this.

Regards

Willie Hugo

[Former Member]

> Or do you only load a separate JDBC driver once you require connecting to a different DB via an adapter.

Yes, we only deploy a JDBC driver once we require to connect to different DB via using JDBC adapter.

> How does one deal with a scenario where you are connecting, via adapters, to different DB type & version and you require multiple/different drivers for different adapters?

Nice question.

We can deploy multiple/different drivers for different DB. Only thing is you have to pass the correct parameters (based on your DB version) while configuring your Communication Channel to connet the DB.

Regards,

Sarvesh

[Former Member]

Hi,

You can find it in Visual Admin under Service --> JDBC Connector (use the Runtime tab) then

Choose Resources ---> Drivers, there you can find if they have been installed or not.

http://help.sap.com/saphelp_nw04/helpdata/en/80/4f34c587f05048adee640f4c346417/content.htm

Regards,

Sarvesh

[iprieto]

Hi,

Check the directory /usr/sap//DVEBMGS00/j2ee/cluster/bin/ext/com.sap.aii.adapter.lib/lib. The .jar files are saved in.

It applies for SAP PI 7.10.

Best regards

Ivá