Multiple Oracle JDBC Drivers

[Former Member]

Hi All,

I have MII 12.0.5 and 3 Oracle databases as data sources, all with different versions: 10.2, 10.1, 9.0.

I downloaded and deployed the Oracle JDBC driver for 10.2 and successfully connected. The status of the other two databases shows "Stopped". I can ping and connect to the other databases successfully using a separate DB client.

The "Stopped" status has indicated incorrect JDBC driver before, however I cannot deploy a second JDBC driver with the same name to the same server. All Oracle drivers for all versions have the same name: ojdbc14.jar.

Do separate Oracle database versions require separate JDBC drivers? If so then how do I handle this in MII?

Thanks in advance.

[jcgood25]

What error are you getting in the NW logs? - with JDBC connections these error are very useful in troubleshooting the root cause of the problem and eliminating guesswork. The error states that show up in the status popup view from the Data Server Editor screen are a bit weak.

If you copied the original data server that connected properly to create your non-functional ones did you re-enter the connection password?

[Former Member]

This is the Error connecting to the 10.2 DB:

Unable to create connection to database for GI_POMSnet

[EXCEPTION]

java.lang.NoClassDefFoundError: oracle.sql.CharacterSetWithConverter

at oracle.sql.CharacterSetFactoryThin.make(CharacterSetFactoryThin.java:123)

at oracle.sql.CharacterSet.make(CharacterSet.java:440)

at oracle.jdbc.driver.DBConversion.<init>(DBConversion.java:145)

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:878)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:268)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)

at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

[Former Member]

This is the error for the Oracle 9 DB:

Unable to create connection to database for GI_POMS

[EXCEPTION]

java.lang.NoClassDefFoundError: oracle.net.ns.RedirectPacket

at oracle.net.ns.NSProtocol.connect(Unknown Source)

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:844)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:268)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)

at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

at com.sap.xmii.Illuminator.tools.database.JDBCDriverWrapper.connect(JDBCDriverWrapper.java:35)

at java.sql.DriverManager.getConnection(DriverManager.java:559)

Any help would be appreciated.

[Former Member]

As you have deployed the Oracle JDBC driver for 10.2 and successfully connected. 10.2 .

Have you checked the same steps for one DB at a time for versions 10.1 & 9.0 ?

Just to make sure that separately all connections are properly working with ojdbc14.jar

[Former Member]

No, Driver versions are relates to the JDK version as classes12.jar are jdbc drivers for java 1.2 & for java 1.4 and above you must use ojdbc14.jar.

Oracle drivers are backward compatible !