You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Fabio Mengue <fa...@ccuec.unicamp.br> on 2002/12/16 13:08:14 UTC

Re: DB2 JDBC

Hello,

DB2 JDBC library files are usually in

<db2_user_dir>/sqllib/java12

The file name is db2java.zip. You can copy it to

<tomcat_install_dir>/common/lib

Change its name to db2java.jar or something with .jar extension, so 
Tomcat will be aware of it.

I had to do other things to DB2 work. I added the line

JAVA_OPTS="-Djava.library.path=/<db2_user_dir>/sqllib/java12/"

To <tomcat_install_dir>/bin/setclasspath.sh, and copied db2profile to 
<tomcat_install_dir>/bin, changing its name to

setenv.sh

After that, DB2 worked :)

Good luck,

Fabio.


Sherif D Mohamad wrote:

>I need to make JSP files on tomcat to connect to a DB2 database.
>I installed the DB2 client for Linux, but I have problems, how can I
>configure it to work with JSP files ? where is the JDBC ?
>
>
>--
>To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
>For additional commands, e-mail: <ma...@jakarta.apache.org>
>
>
>  
>

-- 
Fabio Mengue - Centro de Computacao - Unicamp
fabio@ccuec.unicamp.br       fabio@unicamp.br
"Quem se mata de trabalhar merece mesmo morrer." - Millor



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


Re: DB2 JDBC

Posted by Fabio Mengue <fa...@ccuec.unicamp.br>.
Hi,

Sherif D Mohamad wrote:

>Thanks for your help,
>I have done what you said, but I am running tomcat4 on Linux,
>
Me too...

>I do not have <tomcat_install_dir>/bin/setclasspath.sh
>
?!?!

>in <tomcat_install_dir>/bin I have : bootstrap.jar  commons-daemon.jar
>tomcat-jni.jar
>
Did you installed it using RPM's ? What version are you using ?

>so I added JAVA_OPTS="-Djava.library.path=/<db2_user_dir>/sqllib/java12/" to
><tomcat_install_dir>/conf/tomcat4.conf
>
I don't have this file either. tomcat4.conf ? Mine is server.xml...

>I am not sure if that it right or wrong, will test and see, if you find I
>need something else pls advise.
>
I don't know, your tomcat don't look like the one I use.

F.

>
>Thank you.
>Sherif
>
>
>----- Original Message -----
>From: "Fabio Mengue" <fa...@ccuec.unicamp.br>
>To: "Tomcat Users List" <to...@jakarta.apache.org>
>Sent: Monday, December 16, 2002 4:08 AM
>Subject: Re: DB2 JDBC
>
>
>  
>
>>Hello,
>>
>>DB2 JDBC library files are usually in
>>
>><db2_user_dir>/sqllib/java12
>>
>>The file name is db2java.zip. You can copy it to
>>
>><tomcat_install_dir>/common/lib
>>
>>Change its name to db2java.jar or something with .jar extension, so
>>Tomcat will be aware of it.
>>
>>I had to do other things to DB2 work. I added the line
>>
>>JAVA_OPTS="-Djava.library.path=/<db2_user_dir>/sqllib/java12/"
>>
>>To <tomcat_install_dir>/bin/setclasspath.sh, and copied db2profile to
>><tomcat_install_dir>/bin, changing its name to
>>
>>setenv.sh
>>
>>After that, DB2 worked :)
>>
>>Good luck,
>>
>>Fabio.
>>
>>
>>Sherif D Mohamad wrote:
>>
>>    
>>
>>>I need to make JSP files on tomcat to connect to a DB2 database.
>>>I installed the DB2 client for Linux, but I have problems, how can I
>>>configure it to work with JSP files ? where is the JDBC ?
>>>
>>>
>>>--
>>>To unsubscribe, e-mail:
>>>      
>>>
><ma...@jakarta.apache.org>
>  
>
>>>For additional commands, e-mail:
>>>      
>>>
><ma...@jakarta.apache.org>
>  
>
>>>
>>>
>>>      
>>>
>>--
>>Fabio Mengue - Centro de Computacao - Unicamp
>>fabio@ccuec.unicamp.br       fabio@unicamp.br
>>"Quem se mata de trabalhar merece mesmo morrer." - Millor
>>
>>
>>
>>--
>>To unsubscribe, e-mail:
>>    
>>
><ma...@jakarta.apache.org>
>  
>
>>For additional commands, e-mail:
>>    
>>
><ma...@jakarta.apache.org>
>  
>
>
>
>--
>To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
>For additional commands, e-mail: <ma...@jakarta.apache.org>
>
>
>  
>

-- 
Fabio Mengue - Centro de Computacao - Unicamp
fabio@ccuec.unicamp.br       fabio@unicamp.br
----------------------------------------------------------------
[The Test of Negation] Don't include a sentence in documentation if its negation is obviously false. Bob Martin



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


Re: DB2 JDBC

Posted by Sherif D Mohamad <sh...@menanet.net>.
Thanks for your help,
I have done what you said, but I am running tomcat4 on Linux,
I do not have <tomcat_install_dir>/bin/setclasspath.sh
in <tomcat_install_dir>/bin I have : bootstrap.jar  commons-daemon.jar
tomcat-jni.jar

so I added JAVA_OPTS="-Djava.library.path=/<db2_user_dir>/sqllib/java12/" to
<tomcat_install_dir>/conf/tomcat4.conf
I am not sure if that it right or wrong, will test and see, if you find I
need something else pls advise.

Thank you.
Sherif


----- Original Message -----
From: "Fabio Mengue" <fa...@ccuec.unicamp.br>
To: "Tomcat Users List" <to...@jakarta.apache.org>
Sent: Monday, December 16, 2002 4:08 AM
Subject: Re: DB2 JDBC


> Hello,
>
> DB2 JDBC library files are usually in
>
> <db2_user_dir>/sqllib/java12
>
> The file name is db2java.zip. You can copy it to
>
> <tomcat_install_dir>/common/lib
>
> Change its name to db2java.jar or something with .jar extension, so
> Tomcat will be aware of it.
>
> I had to do other things to DB2 work. I added the line
>
> JAVA_OPTS="-Djava.library.path=/<db2_user_dir>/sqllib/java12/"
>
> To <tomcat_install_dir>/bin/setclasspath.sh, and copied db2profile to
> <tomcat_install_dir>/bin, changing its name to
>
> setenv.sh
>
> After that, DB2 worked :)
>
> Good luck,
>
> Fabio.
>
>
> Sherif D Mohamad wrote:
>
> >I need to make JSP files on tomcat to connect to a DB2 database.
> >I installed the DB2 client for Linux, but I have problems, how can I
> >configure it to work with JSP files ? where is the JDBC ?
> >
> >
> >--
> >To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> >For additional commands, e-mail:
<ma...@jakarta.apache.org>
> >
> >
> >
> >
>
> --
> Fabio Mengue - Centro de Computacao - Unicamp
> fabio@ccuec.unicamp.br       fabio@unicamp.br
> "Quem se mata de trabalhar merece mesmo morrer." - Millor
>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>