Re: Newbie - problem accessing DB2 with Java program.

zalek wrote:
> On Mar 16, 7:21 pm, Arne Vajhøj <a...@[EMAIL PROTECTED]
> wrote:
>> zalek wrote:
>>> On Mar 16, 6:49 pm, Arne Vajhøj <a...@[EMAIL PROTECTED]
> 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 im****t 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