PI 7.3 JDBC driver dilemma

[Former Member]

Hello Experts,

We are using PI 7.3 system (JDK 6).

We have various versions of db systems in our landscape ranging from Oracle 8i to Oracle 11.

Whats the version of JDBC driver that we should deploy to PI AFW to connect to the various versions of Oracle Dbs.

We are currently using JDBC driver for JdK 6. We are facing issues in connecting to Oracle 8i.

thanks in advance.

Regards,

Sudharshan N A

[baskar_gopalakrishnan2 · Accepted solution]

SAP PI 7.1 and above are based on 64 bit and it uses Jdk 1.6+. That means jdbc drivers are different for different versions of SAP PI.

On the other side jdbc drivers software are again based on java versions. Oracle later versions 10 and above are compatible with jdk 1.6+. Below oracle versions 8,9 supports jdk 1.4.*. So if you want to use PI 7.3 then you need to use jdbc drivers that are compatible with jdk 1.6. You might have to check some external third party drivers that are compatible for both.

[Former Member]

Hi,.

Did you check this threads?

Regards.

Luis