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