Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 20, 2012 at 06:55 PM

    Hi

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.