All Forums Connectivity
sid.de 2 posts Joined 08/12
29 Aug 2012
Problems in connecting to Teradata from Java on AIX

Hi Guys , 

 

  This is my first post here , so Hello to Everyone :) 

 

   I am trying to connect to a Teradata database from a AIX box using Java . 

   I have downloaded the TeraJDBC__indep_indep.14.00.00.14.zip file and after unzipping it on a Windows box I ftped the 3                         

   files terajdbc4.jar , tdgssconfig.jar and TdgssUserConfigFile.xml to the AIX box . However now I am  getting the following error :- 

 

  Exception in thread "main" java.lang.ClassFormatError: JVMCFRE067 unknown constant pool entry tag; class=com/teradata/jdbc/TeraDriver, offset=380

        at java.lang.ClassLoader.defineClassImpl(Native Method)

        at java.lang.ClassLoader.defineClass(ClassLoader.java: 275)

        at java.security.SecureClassLoader.defineClass(SecureClas sLoader.java:69)

        at java.net.URLClassLoader.defineClass(URLClassLoader.jav a:540)

        at java.net.URLClassLoader.defineClass(URLClassLoader.jav a:451)

        at java.net.URLClassLoader.access$300(URLClassLoader.java :79)

        at java.net.URLClassLoader$ClassFinder.run(URLClassLoader .java:1038)

        at java.security.AccessController.doPrivileged(AccessCont roller.java:284)

        at java.net.URLClassLoader.findClass(URLClassLoader.java: 429)

        at java.lang.ClassLoader.loadClass(ClassLoader.java:653)

        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.ja va:358)

        at java.lang.ClassLoader.loadClass(ClassLoader.java:619)

        at java.lang.Class.forNameImpl(Native Method)

        at java.lang.Class.forName(Class.java:139)

        at Data_Copier_RULE.main(Data_Copier_RULE.java:26)

 

 

 

Any ideas why this is happening ? 

 

Also the jar files are suppossed to be platform independent right ? So is there any thing like the jar files in the ZIP download  won't work on the AIX box or anything ?  

 

tomnolan 594 posts Joined 01/08
29 Aug 2012

Teradata JDBC Driver 14.00.00.14 does not include TdgssUserConfigFile.xml. It only includes terajdbc4.jar and tdgssconfig.jar. So your TdgssUserConfigFile.xml may be left over from an old installation, and you may not need it.

Teradata JDBC Driver 14.00.00.14 supports JDK 1.4.2, 5.0, 6.0, and 7.0. What JDK version do you have on your AIX machine? Does your AIX machine have an older JDK version that is unsupported?

The download page states that the jar files inside the zip download package are platform independent, and it is telling the truth. The Teradata JDBC Driver jar files can be used on any supported platform.

 

sid.de 2 posts Joined 08/12
29 Aug 2012

 

Hi Tom , 

 

   Thanks for your reply .   

 

   The JDK version on the AIX box is :-   

   $ $JDK_HOME/bin/javac  -version 

    javac 1.6.0-internal  

 

   The JRE version is :- 

   $ $JDK_HOME/bin/java - version 

    java version "1.6.0"    

 

    BTW , the Java Virtual Machine is :-  

    IBM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 AIX ppc64-64 jvmap6460sr9-xxxxxxxx_xxxxx  (JIT          

    enabled, AOT enabled)   

 

 

tomnolan 594 posts Joined 01/08
30 Aug 2012

I just successfully tested the Teradata JDBC Driver on an AIX 5.3 machine using the following JVMs.

32-bit JDK 6.0 from 2007:

java version "1.6.0"
Java(TM) SE Runtime Environment (build pap3260-20071123_01)
IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 AIX ppc-32 jvmap3260-20071121_15015 (JIT enabled)
J9VM - 20071121_015015_bHdSMR
JIT  - r9_20071121_1330
GC   - 20071031_AA)
JCL  - 20071118_01

64-bit JDK 6.0 from 2007:

java version "1.6.0"
Java(TM) SE Runtime Environment (build pap6460-20071123_01)
IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 AIX ppc64-64 jvmap6460-20071121_15015 (JIT enabled)
J9VM - 20071121_015015_BHdSMr
JIT  - r9_20071121_1330
GC   - 20071031_AA)
JCL  - 20071118_01

64-bit JDK 6.0 from this year 2012:

java version "1.6.0"
Java(TM) SE Runtime Environment (build pap6460sr10fp1-20120321_01(SR10 FP1))
IBM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 AIX ppc64-64 jvmap6460sr10fp1-20120202_101568 (JIT enabled, AOT enabled)
J9VM - 20120202_101568
JIT  - r9_20111107_21307ifx1
GC   - 20120202_AA)
JCL  - 20120320_01

 

You may want to try installing a newer JDK from IBM, or try reinstalling your JDK. Perhaps there is a misconfiguration problem.

If you continue to encounter this problem, and you are a Teradata customer, then please open an incident with Teradata Customer Support.

Regards,

--Tom

You must sign in to leave a comment.