RE: PLEASE HELP! How can I make Tomcat see DB2 jdbc driver?
hiya,
try renaming the driver to db2java.jar
hth
JasonG
-Original Message-
From: Sarah Zou [SMTP:[EMAIL PROTECTED]
Sent: Thursday,4 December 2003 7:09
To: [EMAIL PROTECTED]
Subject: PLEASE HELP! How can I make Tomcat see DB2 jdbc driver?
Hi All,
I am using Tomcat 4.1.29 and DB2 8.1. I try to use the servlet
below to see if it can find DB2 jdbc driver:
public class Test extends HttpServlet {
public void init(ServletConfig config) throws ServletException
{ super.init(config); }
public void service(HttpServletRequest request, HttpServletResponse
response)
{
try{
Class.forName (COM.ibm.db2.jdbc.app.DB2Driver).newInstance ();
} catch (Exception e) {
System.err.println (\n Error loading DB2 Driver...\n + e);
}
}
}
I have tried to put db2java.zip in Tomcat common\lib or
webapp\web-inf\lib. Also I tried to add db2java.zip to set classpath
in
catalina.bat in Tomcat bin. It didnot work.
Your help will be very much appreciated.
Sarah
-
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: PLEASE HELP! How can I make Tomcat see DB2 jdbc driver?
I've run into this before. Although every document I've read refers to the driver as
COM.ibm.db2.jdbc.app.DB2Driver, in actuality the package name is com.blah.blah.
Change your upper case COM to lower case and it should work.
[EMAIL PROTECTED] 12/3/2003 12:13:59 PM
hiya,
try renaming the driver to db2java.jar
hth
JasonG
-Original Message-
From:Sarah Zou [SMTP:[EMAIL PROTECTED]
Sent:Thursday,4 December 2003 7:09
To:[EMAIL PROTECTED]
Subject:PLEASE HELP! How can I make Tomcat see DB2 jdbc driver?
Hi All,
I am using Tomcat 4.1.29 and DB2 8.1. I try to use the servlet
below to see if it can find DB2 jdbc driver:
public class Test extends HttpServlet {
public void init(ServletConfig config) throws ServletException
{ super.init(config); }
public void service(HttpServletRequest request, HttpServletResponse
response)
{
try{
Class.forName (COM.ibm.db2.jdbc.app.DB2Driver).newInstance ();
} catch (Exception e) {
System.err.println (\n Error loading DB2 Driver...\n + e);
}
}
}
I have tried to put db2java.zip in Tomcat common\lib or
webapp\web-inf\lib. Also I tried to add db2java.zip to set classpath
in
catalina.bat in Tomcat bin. It didnot work.
Your help will be very much appreciated.
Sarah
-
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
PLEASE HELP! How can I make Tomcat see DB2 jdbc driver?
Hi All,
I am using Tomcat 4.1.29 and DB2 8.1. I try to use the servlet
below to see if it can find DB2 jdbc driver:
public class Test extends HttpServlet {
public void init(ServletConfig config) throws ServletException
{ super.init(config); }
public void service(HttpServletRequest request, HttpServletResponse
response)
{
try{
Class.forName (COM.ibm.db2.jdbc.app.DB2Driver).newInstance ();
} catch (Exception e) {
System.err.println (\n Error loading DB2 Driver...\n + e);
}
}
}
I have tried to put db2java.zip in Tomcat common\lib or
webapp\web-inf\lib. Also I tried to add db2java.zip to set classpath in
catalina.bat in Tomcat bin. It didnot work.
Your help will be very much appreciated.
Sarah
-
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
Re: PLEASE HELP! How can I make Tomcat see DB2 jdbc driver?
ke, 2003-12-03 kello 22:09, Sarah Zou wrote: Hi All, I am using Tomcat 4.1.29 and DB2 8.1. I try to use the servlet below to see if it can find DB2 jdbc driver: ... I have tried to put db2java.zip in Tomcat common\lib or webapp\web-inf\lib. Also I tried to add db2java.zip to set classpath in catalina.bat in Tomcat bin. It didnot work. Your help will be very much appreciated. Tomcat will only look for .jar-packages, so change the type of the package, and place it in one or the other directory. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: PLEASE HELP! How can I make Tomcat see DB2 jdbc driver?
Hello Sarah,
See:
http://www.cs.wisc.edu/~dbbook/openAccess/thirdEdition/DB2/Database%20Web%20Server%20Software%20Install%20Guide.htm
It works also with DB2 UDB 8.1
Greetings,
Freek.
- Original Message -
From: Sarah Zou [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 03, 2003 9:09 PM
Subject: PLEASE HELP! How can I make Tomcat see DB2 jdbc driver?
Hi All,
I am using Tomcat 4.1.29 and DB2 8.1. I try to use the servlet
below to see if it can find DB2 jdbc driver:
public class Test extends HttpServlet {
public void init(ServletConfig config) throws ServletException
{ super.init(config); }
public void service(HttpServletRequest request, HttpServletResponse
response)
{
try{
Class.forName (COM.ibm.db2.jdbc.app.DB2Driver).newInstance ();
} catch (Exception e) {
System.err.println (\n Error loading DB2 Driver...\n + e);
}
}
}
I have tried to put db2java.zip in Tomcat common\lib or
webapp\web-inf\lib. Also I tried to add db2java.zip to set classpath
in
catalina.bat in Tomcat bin. It didnot work.
Your help will be very much appreciated.
Sarah
-
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
PLEASE HELP! How can I make Tomcat see DB2 jdbc driver?
Hi,
A thousand thanks to everyone for the help! I have made it work!
Cheers,
Sarah
Freek Woerts [EMAIL PROTECTED] wrote:
Hello Sarah,
See:
http://www.cs.wisc.edu/~dbbook/openAccess/thirdEdition/DB2/Database%20Web%20Server%20Software%20Install%20Guide.htm
It works also with DB2 UDB 8.1
Greetings,
Freek.
- Original Message -
From: Sarah Zou
To:
Sent: Wednesday, December 03, 2003 9:09 PM
Subject: PLEASE HELP! How can I make Tomcat see DB2 jdbc driver?
Hi All,
I am using Tomcat 4.1.29 and DB2 8.1. I try to use the servlet
below to see if it can find DB2 jdbc driver:
public class Test extends HttpServlet {
public void init(ServletConfig config) throws ServletException
{ super.init(config); }
public void service(HttpServletRequest request, HttpServletResponse
response)
{
try{
Class.forName (COM.ibm.db2.jdbc.app.DB2Driver).newInstance ();
} catch (Exception e) {
System.err.println (\n Error loading DB2 Driver...\n + e);
}
}
}
I have tried to put db2java.zip in Tomcat common\lib or
webapp\web-inf\lib. Also I tried to add db2java.zip to set classpath
in
catalina.bat in Tomcat bin. It didnot work.
Your help will be very much appreciated.
Sarah
-
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
Re: DB2 JDBC
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 [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] 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: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- Fabio Mengue - Centro de Computacao - Unicamp [EMAIL PROTECTED] [EMAIL PROTECTED] Quem se mata de trabalhar merece mesmo morrer. - Millor -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- Fabio Mengue - Centro de Computacao - Unicamp [EMAIL PROTECTED] [EMAIL PROTECTED] [The Test of Negation] Don't include a sentence in documentation if its negation is obviously false. Bob Martin -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DB2 JDBC
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: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
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: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- Fabio Mengue - Centro de Computacao - Unicamp [EMAIL PROTECTED] [EMAIL PROTECTED] Quem se mata de trabalhar merece mesmo morrer. - Millor -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: DB2 JDBC
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 [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] 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: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- Fabio Mengue - Centro de Computacao - Unicamp [EMAIL PROTECTED] [EMAIL PROTECTED] Quem se mata de trabalhar merece mesmo morrer. - Millor -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
