on 03-20-2012 6:37 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bravesh,
Just my insight from the experience I have on this. Oracle 11g supports JDK up to 1.6 - ojdbc6 which is possible for oracle driver deployment in PI 7.30 but Oracle 8i only supports JDK up to 1.4 - ojdbc14.jar (I think when I read some note 831162 section 10) in which upgrading it to JDK 1.6 is not possible (correct me if I'm wrong),
So technically speaking from my own experience in connecting to both version is not possible. I tried deploying several combination of drivers like (ojdbc6 + ojdbc14; ojdbc6 + classes12.jar) but didn't work. Once drivers are deployed, PI 7.30 only takes ojdbc6.jar driver parameters as it fits to its JDK version which is 1.6 so lower version of drivers is be disregarded.
To summarize, the only possible solution to this is to have Oracle 8i upgraded to 11g. But for my current setup, we did maintain two middlewares (XI - connecting oracle 8i and PI - connecting oracle 11g) up until my client will be upgrade their oracle8i to oracle 11g. Maintaining 2 middleware systems is not a best practice but it will be a temporary workaround until they'll upgrade it.
Hope it helps.
Cheers,
R-jay
Hello Jay,
Appreciate your response. My research so far has also pointed me to the same direction that Connecting PI 7.3 to a Oracle 8i DB might not be possible.
Ofcourse going to either Oracle or SAP would not help as 8i is out of support.
In our case we have a challenge that we plan to perform a Upgrade rather than Migration and hence having parallel landscapes is ruled out. Guess while the 8i DB is being upgraded we might have to work on a interim solution.
Thanks Once Again.
Regards,
Bhavesh
We have just 1 Interface that connects to a Oracle 8i Database. We plan to look at a option to use a Native Connection directly to the Database from a User Defined Function for the same while the DB is being upgraded. Load the Classes12.zip into Imported Archives and then use the corresponding classes for the Connection.
While I am not sure if this will work, plan to give it a shot. Will keep you updated.
Regards,
Bhavesh
Hello Ray,
We managed to crack this.
1. We created a DataSource in NWA and used ojdbc14.jar in the DataSource.
2. Modified our Lookup UDF to use the DataSource connection rather than the JDBC Adapter.
As we use the Oracle 8i DB for XREF / Lookup, this does the trick ( for now ) till we upgrade the DB.
Regards,
Bhavesh
Just in case some one is facing a similar issue and want a elegant solution.
We had a very similar scenario where we needed to connect with Oracle 8 and Oracle 11 db. We solved the issue by writing a small wrapper class around the JDBC driver. The program gets the version from the driver using (driver.getMajorVersion()) and if it is less than 10 it returns the ojbc 14.jar driver to the Driver Manager else the normal processing which return the default driver.
We have bundled the ojdbc14.jar along with this new program and deployed this as a SDA.
Hi
Java Version on PI 7.3 and Database side java version should be same .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.