Where to get Oracle jar files for 11.2.0.3 - xdb, aq, i18n, xmlparser

java jdbc oracle11g oracle-aq oracle-xdk
Rich Cowin picture Rich Cowin · Sep 21, 2012 · Viewed 20.2k times · Source

I'm trying to update a legacy Java application to be compatible with Oracle 11g version 11.2.0.3.

The application was running on Oracle 10g version 10.2.0.4 and uses Oracle Advanced Queues. It has Maven dependencies declared for:

  • aq 10.2.0.4.0
  • xdb 10.2.0.4.0
  • xmlparser 10.2.0.4.0
  • i18n 10.2.0.4.0

I'm struggling to find the same files for 11g, specifically for 11.2.0.3. I've looked around in various places such as my Oracle home directory, JDeveloper installation and online, and found a bewildering variety of jar files of various names and versions that are candidates but not quite what I need.

Can anyone let me know where to find the right jar files?

It seems that there are now some aq classes in the JDBC driver, but the package name has changed from oracle.aq to oracle.jdbc.aq. Whilst I'm happy to do some refactoring I'd like some confidence that this is the right thing to do before going ahead. Any advice here would be valuable.

Edit: When trying to run with the mish-mash of versions I've managed to find I get the following error when trying to run the apps unit tests:

java.lang.NoSuchMethodError: oracle.i18n.text.converter.CharacterConverterOGS.getInstance(I)Loracle/i18n/text/converter/CharacterConverter;
at oracle.sql.converter.CharacterConverterFactoryOGS.make(CharacterConverterFactoryOGS.java:43)
at oracle.sql.CharacterSetWithConverter.getInstance(CharacterSetWithConverter.java:97)
at oracle.sql.CharacterSetFactoryThin.make(CharacterSetFactoryThin.java:129)
at oracle.sql.CharacterSet.make(CharacterSet.java:514)
at oracle.sql.CHAR.<clinit>(CHAR.java:72)

Edit: Managed to solve the problem that was causing the error in my unit tests by downloading orai18n.jar and xdb6.jar from Oracle's Oracle Database 11g Release 2 JDBC Drivers page. However, I'm still short of aq and xmlparser.

Edit: Found the Oracle XDK home page which looks promising for getting xmlparser, but there are no downloads available in an obvious place.

Answer

Kalpesh Soni picture Kalpesh Soni · May 13, 2014

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

Oracle Database 11g Release 2 JDBC Drivers

xdb6 and the drivers are here

Edit: Note that oracle 12c drivers will work with 12c and 11g!

https://www.oracle.com/technetwork/database/application-development/jdbc/downloads/index.html

Related questions

IO Error: The Network Adapter could not establish the connection

I am new to Oracle, and am trying to run a simple example code with Java, but am getting this error when executing the code.. I am able to start up the listener via CMD and am also able to …

Read More
java.sql.SQLException: Missing IN or OUT parameter at index:: 1

I made some Java 1.6-Oracle11g-JDBC (using OJDBC 6) code (below). I am getting an exception - java.sql.SQLException: Missing IN or OUT parameter at index:: 1 Why is this happening and how do I fix it ? My output is- create …

Read More
Unable to connect to oracle via Pentaho. 'oracle.jdbc.driver.OracleDriver' could not be found

Hi I've just installed Pentaho Data Integration v. 5.01 and I'm trying to connect to a database. However, I'm unable to test the connection as I get the error (pasted below). I have JDK 1.7 installed on the system as well, however …

Read More