JDBC drivers

[former_member223432]

Hi Experts,

we are working on JDBC interfaces..we currently have Oracle 9 JDBC drivers in SAP PI...which is working good..

one of our vendor  DB migrated to Oracle 12c...those messages are failing in PI.

now, we would like to install Oracle 12 in addition to Oracle 9 which is already existing....Is it OK to have 2 Oracle drivers installed in PI?

how will it work? By default which Drivers will be taken into consideration? how can we switch between these 2 drivers?

Please advise.

[former_member223432]

Hi Experts,

will there be any problem for having multiple JDBC drivers installed(10.2 and 9.2) in PI 7.1...will it cause any conflicts?

which version it will take into consideration at runtime?

thanks

[former_member223432]

Thanks Inaki for your reply..was very helpful.

we have now decided to go ahead with ORACL 10 which is compatible for both 9i and 12c....

in order to test, we will now deploy Oracle 10 on top on Oracle 9i...

is there any other setup we need to follow to make oracle 10 to work and how do we make Oracle 9i inactive for our testing...we dont want to delete Oracl9i drivers as we are just testing

Do we need a JAVA restart after the delployment? Please advise

[iaki_vila]

Hi Smith,

As far as i know in PI 7.1 the installation process restarts the java stack, in PI 7.3X i dont know if it is necessary, we usually do it but we didnt check if it was necessary.

Check these documents:

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

REgards.

[iaki_vila]

Hi Smith,

Teorically it is possible. Check this thread

Regards.

[former_member223432]

Hi Inaki,

thanks for your reply.,..So you mean its possible to have both? How will it automatically swtich between the drivers..

means Oracle 9 DB to JDBC 9 drivers

           Oracle 12 BD to JDBC 12 driver

[iaki_vila]

Hi Smith,

I think you need to do a little trick, check Bhavesh Kantilal answer

Regards.