Skip to Content
avatar image
Former Member

JDBC Driver

Hi,

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

Regards

Willie Hugo

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 15, 2009 at 02:43 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Oct 15, 2009 at 10:29 AM

    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á

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2009 at 10:33 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2009 at 01:47 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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