Re: accessing SQL db in RPG

On 1/14/2013 4:35 PM, Graves, Chuck wrote:

******************************************************************************************
Next I check the java Version on the iSeries
******************************************************************************************

java version "1.4.2"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_19-b04)
Classic VM (build 1.4, build JDK-1.4, native threads, jitc_de)
Java program completed

**************************************************************************
Below is the output from the program
***************************************************************************

java.lang.UnsupportedClassVersionError: net/sourceforge/jtds/jdbc/Driver
at java.lang.Throwable.<init>(Throwable.java:195)
at java.lang.Error.<init>(Error.java:49)
at java.lang.UnsupportedClassVersionError.<init>(UnsupportedClassVersionError .java:34)
at java.lang.ClassLoader.defineClass(ClassLoader.java:567)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:168)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:313)
at java.net.URLClassLoader.access$300(URLClassLoader.java:86)
at java.net.URLClassLoader$ClassFinder.run(URLClassLoader.java:636)
at java.net.URLClassLoader.findClass(URLClassLoader.java:222)
at java.lang.ClassLoader.loadClass(ClassLoader.java:317)
at java.lang.ClassLoader.loadClass(ClassLoader.java:310)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
at java.lang.ClassLoader.loadClass(ClassLoader.java:263)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:330)

I suspect your IBM i JVM is too old. The jTDS release notes for 1.3.0
say 'This is the first Java 7 compatible version of the driver,
containing additional bug fixes compared to jTDS 1.2.7 also released
today. Future development will be focused on the 1.3.x line of the
driver, so future enhancements and bug fixes will not necessarily become
available it the Java 1.3 compatible jTDS 1.2.x. You should only stick
to the jTDS 1.2.x line of the driver if you require to use Java versions
prior to Java 7.'

Try downloading the 1.2.x version which should work with Java 3 and Java 4.
--buck