Problems in connecting to Teradata from Java on AIX

Connectivity
Fan

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(SecureClassLoader.java:69)

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

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

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

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

        at java.security.AccessController.doPrivileged(AccessController.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.java: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 ?  

3 REPLIES
Teradata Employee

Re: Problems in connecting to Teradata from Java on AIX

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.

Fan

Re: Problems in connecting to Teradata from Java on AIX


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)   

Teradata Employee

Re: Problems in connecting to Teradata from Java on AIX

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