Re: Class Not Found Error - MS SQL From RPG

Hi Chris,

that particular Java class is located in the file named sqljdbc.jar from Microsoft (which, as far as I know, is the only JAR file you need. I don't know what all of the other JAR files you mentioned are, but you might try removing them in case they cause a conflict.)

Please ensure that the sqljdbc.jar file is not corrupt, and that it's the Type 4 driver from Microsoft.

Please also ensure that you are using version 1.4 (or higher) of the JVM. Microsoft does not support older versions.

If you've placed the JAR file in /QIBM/UserData/Java400/ext, then please, please DO NOT add it to your CLASSPATH. You'll only make matters worse. The best course of action is to REMOVE it from the /QIBM/UserData/Java400/ext directory, and ONLY put it in your CLASSPATH, but it should also work if it's not in your CLASSPATH, but is only in that "ext" directory.

If you decide to use the CLASSPATH as I recommend, then please ensure the following:

a) The word CLASSPATH should be in all caps. No lowercase.

b) The full jar file should be listed in the CLASSPATH. i.e., it should be /my/dir/sqljdbc.jar. If you only provide the directory name, it won't work.

c) The CLASSPATH must be set before using *any* Java in the job, because the JVM is only loaded once per i5/OS job, and the CLASSPATH is only considered at the time that the JVM is loaded. If you've already run something that uses Java, you will need to sign off and sign back on, then set the CLASSPATH, then run your JDBC program.

d) The QIBM_RPG_JAVA_PROPERTIES variable is not necessary to find the class, but it might be useful for other things (such as selecting which JVM is used if more than one are installed on your system.) Like CLASSPATH, QIBM_RPG_JAVA_PROPERTIES must be set prior to running any Java in the job.

Good luck


Christopher Anderson wrote:

Hello everybody!
I'm attempting to access a MS SQL Server database from RPG and am basing
my attempts on Scott Klement's article on the subject (Here -
http://www.systeminetwork.com/artarchive/newsletter/w/1001/i/-1/a/54759/
index.html)

I have created all of the objects recommended in the article but when I
run the program, I get the following error:

java.lang.NoClassDefFoundError:
com/microsoft/sqlserver/jdbc/SqlServerDriver at java.lang.Throwable.<init>(Throwable.java:195)

at java.lang.Error.<init>(Error.java:49)

at
java.lang.NoClassDefFoundError.<init>(NoClassDefFoundError.java:40
)


This error seems to be telling me the classpath is set incorrectly or
that the correct class cannot be found at the location. I have
msbase.jar, mssqlserver.jar, msutil.jar and sqljdbc.jar in directory
/QIBM/UserData/Java400/ext. I'm under the impression that the java
virtual machine on the System I defaults to looking in that directory
without any modifications to the classpath variable.
I also have tried adding the QIBM_RPG_JAVA_PROPERTIES environment
variable to the list but still got the error. I tried manually setting
the classpath at both the *sys and *job level.
I'm sorry if this is a stupid question but I'm running out of ideas.
What am I missing?

Thank you,
Chris Anderson
Waukesha, WI