Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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.

like image 747
Rich Cowin Avatar asked Sep 21 '12 10:09

Rich Cowin


2 Answers

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

like image 192
Kalpesh Soni Avatar answered Sep 26 '22 06:09

Kalpesh Soni


The JAR files are included with the Oracle full database client. I don't think the client is available publicly for download for 11.2.0.3 yet, except perhaps as part of Oracle XE. If you have the Oracle EE install, the standalone, full client is available from disk 4.

You'll find the correct JAR files in the client in $ORACLE_HOME/jdbc/lib, $ORACLE_HOME/lib, $ORACLE_HOME/rdbms/jlib, and $ORACLE_HOME/jlib. Remember to include orai18n-collation.jar when including orai18n.jar for XQJ support, and ONLY use the same version of ojdbcX.jar as the JARs from the client (i.e, don't use ojdbc5.jar or ojdbc14.jar - use ojdbc6.jar).

like image 41
Brad Avatar answered Sep 24 '22 06:09

Brad