Skip to Content
avatar image
Former Member

JDBC Adapter: Deploying Multiple Database Drivers

Hi Experts,

We are currently connecting multiple database servers (SQL, Oracle 11g and 8i) in PI 7.30. As a prerequisite, database drivers are to be included in deployment (which is already been followed from the documentations provided). From my understanding, it won't cause any conflict as long a the .jar file is not the same from the one that is included in .sda.

Connecting SQL server (sqljbc4.jar) and Oracle 11g (ojdbc6.jar) don't have any problem. I have included classes12.jar and ojdbc14.jar and will be connecting to JDK 1.3.1_13 (JDK 1.3). I'm currently facing an issue in which upon connecting the oracle server, which is

Unable to create new pooled resource: DriverManagerException: Cannot establish connection with the registered driver. oracle.jdbc.driver.OracleDriver returns: 7. : ArrayIndexOutOfBoundsException: 7

Tried restarting JAVA stack and tested the connection but no luck.

Searched some answered concerns above but it all refers on links on HOW TO DEPLOY JDBC adapter, which doesn't help at all since.

Any ideas on how check or did I deploy something that made the those drivers coflict?

Cheers,

R-jay

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 20, 2012 at 06:45 PM

    Your JDK Version should be 1.5+.  PI 7.1  onwards supports 64 bit os. You need to upgrade java version to 1.5 for handling the oracle as well PI 7.3

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Dear JaiShankar,

      did you publish your solution somewhere in SCN? Or ist it possible to receive your solution and the example coding per mail?

      Thanks in advance!

      Daniel

  • avatar image
    Former Member
    Mar 20, 2012 at 06:55 PM

    Hi

    Java Version on PI 7.3 and Database  side java version should be same . 

    Add comment
    10|10000 characters needed characters exceeded