Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null'
Gerlinde, Thanks for the response! I placed my jdbc jar file under common/lib, but I still get the same error message. If you or anyone else has any other ideas, that would be greatly appreciated. Gerlinde Fischer [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] amberg.de cc: Subject: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 05:47 AM 'null' Please respond to Tomcat Users List Hi where ist your Database Connection? In the server.xml in the context for your test application. The jdbc.driver must be placed into the directory common/lib. I hope this will help. Regards Gerlinde -Ursprungliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 11. Marz 2003 22:58 An: [EMAIL PROTECTED] Betreff: java.sql.SQLException: Cannot load JDBC driver class 'null' Tomcat version - 4.1.12 MySQL version - 3.23.55-nt OS - WinNT JDK - 1.4.1_01 I have researched this problem on the internet and in the documentation for Tomcat, and I still haven't resolved this issue. So, I'm looking for help from someone from this list. Here is my URL that I invoke: http://localhost:8080/dbtest/test.jsp Here is the error I receive: java.sql.SQLException: Cannot load JDBC driver class 'null' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:529) Referencing this URL - http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-ex amples-howto.html: 1. I have a database and table with 1 row of data 2. Here is the chunk of code that I inserted into my $CATALINA_HOME/conf/server.xml. !-- Database configuration for MySQL -- Context path=/DBTest docBase=DBTest debug=5 reloadable=true crossContext=true Logger className=org.apache.catalina.logger.FileLogger prefix=localhost_DBTest_log. suffix=.txt timestamp=true/ Resource name=jdbc/TestDB auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/TestDB parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter !-- Maximum number of dB connections in pool. Make sure you configure your mysqld max_connections large enough to handle all of your db connections. Set to 0 for no limit. -- parameter namemaxActive/name value100/value /parameter !-- Maximum number of idle dB connections to retain in pool. Set to 0 for no limit. -- parameter namemaxIdle/name value30/value /parameter !-- Maximum time to wait for a dB connection to become available in ms, in this example 10 seconds. An Exception is thrown if this timeout is exceeded. Set to -1 to wait indefinitely. -- parameter namemaxWait/name value1/value /parameter !-- MySQL dB username and password for dB connections -- parameter nameusername/name valuebugtracker/value /parameter parameter namepassword/name valuefootin/value /parameter !-- Class name for mm.mysql JDBC driver -- parameter namedriverClassName/name valueorg.gjt.mm.mysql.Driver/value /parameter !-- The JDBC connection url for connecting to your
Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null'
I am not absolutely sure if this is the problem, but I have placed the database related jars under server/lib. It works for me. -- Uddhav - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 6:04 PM Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' Gerlinde, Thanks for the response! I placed my jdbc jar file under common/lib, but I still get the same error message. If you or anyone else has any other ideas, that would be greatly appreciated. Gerlinde Fischer [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] amberg.de cc: Subject: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 05:47 AM 'null' Please respond to Tomcat Users List Hi where ist your Database Connection? In the server.xml in the context for your test application. The jdbc.driver must be placed into the directory common/lib. I hope this will help. Regards Gerlinde -Ursprungliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 11. Marz 2003 22:58 An: [EMAIL PROTECTED] Betreff: java.sql.SQLException: Cannot load JDBC driver class 'null' Tomcat version - 4.1.12 MySQL version - 3.23.55-nt OS - WinNT JDK - 1.4.1_01 I have researched this problem on the internet and in the documentation for Tomcat, and I still haven't resolved this issue. So, I'm looking for help from someone from this list. Here is my URL that I invoke: http://localhost:8080/dbtest/test.jsp Here is the error I receive: java.sql.SQLException: Cannot load JDBC driver class 'null' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:529) Referencing this URL - http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-ex amples-howto.html: 1. I have a database and table with 1 row of data 2. Here is the chunk of code that I inserted into my $CATALINA_HOME/conf/server.xml. !-- Database configuration for MySQL -- Context path=/DBTest docBase=DBTest debug=5 reloadable=true crossContext=true Logger className=org.apache.catalina.logger.FileLogger prefix=localhost_DBTest_log. suffix=.txt timestamp=true/ Resource name=jdbc/TestDB auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/TestDB parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter !-- Maximum number of dB connections in pool. Make sure you configure your mysqld max_connections large enough to handle all of your db connections. Set to 0 for no limit. -- parameter namemaxActive/name value100/value /parameter !-- Maximum number of idle dB connections to retain in pool. Set to 0 for no limit. -- parameter namemaxIdle/name value30/value /parameter !-- Maximum time to wait for a dB connection to become available in ms, in this example 10 seconds. An Exception is thrown if this timeout is exceeded. Set to -1 to wait indefinitely. -- parameter namemaxWait/name value1/value /parameter !-- MySQL dB username and password for dB onnections -- parameter nameusername/name valuebugtracker/value /parameter parameter namepassword/name valuefootin/value /parameter !-- Class name for mm.mysql JDBC driver -- parameter namedriverClassName/name valueorg.gjt.mm.mysql.Driver/value /parameter !-- The JDBC connection url for connecting to your MySQL dB. The autoReconnect=true argument to the url makes sure that the mm.mysql JDBC Driver will automatically reconnect if mysqld closed the connection. mysqld by default closes idle connections after 8 hours. -- parameter nameurl/name
Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null'
I put it under server/lib, but no such luck.still the same error message. hmmm Uddhav Shirname [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] ent.co.in cc: Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 06:43 AM 'null' Please respond to Tomcat Users List I am not absolutely sure if this is the problem, but I have placed the database related jars under server/lib. It works for me. -- Uddhav - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 6:04 PM Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' Gerlinde, Thanks for the response! I placed my jdbc jar file under common/lib, but I still get the same error message. If you or anyone else has any other ideas, that would be greatly appreciated. Gerlinde Fischer [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] amberg.de cc: Subject: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 05:47 AM 'null' Please respond to Tomcat Users List Hi where ist your Database Connection? In the server.xml in the context for your test application. The jdbc.driver must be placed into the directory common/lib. I hope this will help. Regards Gerlinde -Ursprungliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 11. Marz 2003 22:58 An: [EMAIL PROTECTED] Betreff: java.sql.SQLException: Cannot load JDBC driver class 'null' Tomcat version - 4.1.12 MySQL version - 3.23.55-nt OS - WinNT JDK - 1.4.1_01 I have researched this problem on the internet and in the documentation for Tomcat, and I still haven't resolved this issue. So, I'm looking for help from someone from this list. Here is my URL that I invoke: http://localhost:8080/dbtest/test.jsp Here is the error I receive: java.sql.SQLException: Cannot load JDBC driver class 'null' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:529) Referencing this URL - http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-ex amples-howto.html: 1. I have a database and table with 1 row of data 2. Here is the chunk of code that I inserted into my $CATALINA_HOME/conf/server.xml. !-- Database configuration for MySQL -- Context path=/DBTest docBase=DBTest debug=5 reloadable=true crossContext=true Logger className=org.apache.catalina.logger.FileLogger prefix=localhost_DBTest_log. suffix=.txt timestamp=true/ Resource name=jdbc/TestDB auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/TestDB parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter !-- Maximum number of dB connections in pool. Make sure you configure your mysqld max_connections large enough to handle all of your db connections. Set to 0 for no limit. -- parameter namemaxActive/name value100/value /parameter !-- Maximum number of idle dB connections to retain in pool. Set to 0 for no limit. -- parameter namemaxIdle/name value30/value /parameter !-- Maximum time to wait for a dB connection to become available
RE: AW: java.sql.SQLException: Cannot load JDBC driver class 'null'
Did you define the driver in you classpath? / Clarence Dahlin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: den 12 mars 2003 13:49 To: [EMAIL PROTECTED] Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' I put it under server/lib, but no such luck.still the same error message. hmmm Uddhav Shirname [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] ent.co.in cc: Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 06:43 AM 'null' Please respond to Tomcat Users List I am not absolutely sure if this is the problem, but I have placed the database related jars under server/lib. It works for me. -- Uddhav - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 6:04 PM Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' Gerlinde, Thanks for the response! I placed my jdbc jar file under common/lib, but I still get the same error message. If you or anyone else has any other ideas, that would be greatly appreciated. Gerlinde Fischer [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] amberg.de cc: Subject: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 05:47 AM 'null' Please respond to Tomcat Users List Hi where ist your Database Connection? In the server.xml in the context for your test application. The jdbc.driver must be placed into the directory common/lib. I hope this will help. Regards Gerlinde -Ursprungliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 11. Marz 2003 22:58 An: [EMAIL PROTECTED] Betreff: java.sql.SQLException: Cannot load JDBC driver class 'null' Tomcat version - 4.1.12 MySQL version - 3.23.55-nt OS - WinNT JDK - 1.4.1_01 I have researched this problem on the internet and in the documentation for Tomcat, and I still haven't resolved this issue. So, I'm looking for help from someone from this list. Here is my URL that I invoke: http://localhost:8080/dbtest/test.jsp Here is the error I receive: java.sql.SQLException: Cannot load JDBC driver class 'null' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:529) Referencing this URL - http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-ex amples-howto.html: 1. I have a database and table with 1 row of data 2. Here is the chunk of code that I inserted into my $CATALINA_HOME/conf/server.xml. !-- Database configuration for MySQL -- Context path=/DBTest docBase=DBTest debug=5 reloadable=true crossContext=true Logger className=org.apache.catalina.logger.FileLogger prefix=localhost_DBTest_log. suffix=.txt timestamp=true/ Resource name=jdbc/TestDB auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/TestDB parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter !-- Maximum number of dB connections in pool. Make sure you configure your mysqld max_connections large enough to handle all of your db connections. Set to 0 for no limit. -- parameter namemaxActive/name value100/value /parameter !-- Maximum number of idle dB connections to retain in pool
RE: AW: java.sql.SQLException: Cannot load JDBC driver class 'null'
No I did not, but now I do and I still receive the same error. I have printed out my classpath on the tomcat startup DOS window. This is: setting the jdbc jar to classpath * * classpath is: C:\Development\j2sdk1.4.1_01\lib\tools.jar;C:\development\ja karta-tomcat-4.1.12\common\lib\mysql-connector-java-3.0.6-stable-bin.jar; ** Currently, I have the jdbc jar file under common\lib, server\lib and webapps\dbtest\WEB-INF\lib, hoping Tomcat will 'see' it under one of these locations. btw, I'm a first-timer for connecting Tomcat to a database. Thanks Clarence DahlinTo: Tomcat Users List [EMAIL PROTECTED] clarence.dahlin cc: @pitch.se Subject: RE: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' 03/12/2003 06:55 AM Please respond to Tomcat Users List Did you define the driver in you classpath? / Clarence Dahlin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: den 12 mars 2003 13:49 To: [EMAIL PROTECTED] Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' I put it under server/lib, but no such luck.still the same error message. hmmm Uddhav Shirname [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] ent.co.in cc: Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 06:43 AM 'null' Please respond to Tomcat Users List I am not absolutely sure if this is the problem, but I have placed the database related jars under server/lib. It works for me. -- Uddhav - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 6:04 PM Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' Gerlinde, Thanks for the response! I placed my jdbc jar file under common/lib, but I still get the same error message. If you or anyone else has any other ideas, that would be greatly appreciated. Gerlinde Fischer [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] amberg.de cc: Subject: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 05:47 AM 'null' Please respond to Tomcat Users List Hi where ist your Database Connection? In the server.xml in the context for your test application. The jdbc.driver must be placed into the directory common/lib. I hope this will help. Regards Gerlinde -Ursprungliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 11. Marz 2003 22:58 An: [EMAIL PROTECTED] Betreff: java.sql.SQLException: Cannot load JDBC driver class 'null' Tomcat version - 4.1.12 MySQL version - 3.23.55-nt OS - WinNT JDK - 1.4.1_01 I have researched this problem on the internet and in the documentation for Tomcat, and I still haven't resolved this issue. So, I'm looking for help from someone from this list. Here is my URL that I invoke: http://localhost:8080/dbtest/test.jsp Here is the error I receive: java.sql.SQLException: Cannot load JDBC driver class 'null' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:529) Referencing this URL - http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-ex amples
Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null'
sorry ..you mail arrive in mail address... - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 2:20 PM Subject: RE: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' No I did not, but now I do and I still receive the same error. I have printed out my classpath on the tomcat startup DOS window. This is: setting the jdbc jar to classpath * * classpath is: C:\Development\j2sdk1.4.1_01\lib\tools.jar;C:\development\ja karta-tomcat-4.1.12\common\lib\mysql-connector-java-3.0.6-stable-bin.jar; ** Currently, I have the jdbc jar file under common\lib, server\lib and webapps\dbtest\WEB-INF\lib, hoping Tomcat will 'see' it under one of these locations. btw, I'm a first-timer for connecting Tomcat to a database. Thanks Clarence DahlinTo: Tomcat Users List [EMAIL PROTECTED] clarence.dahlin cc: @pitch.se Subject: RE: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' 03/12/2003 06:55 AM Please respond to Tomcat Users List Did you define the driver in you classpath? / Clarence Dahlin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: den 12 mars 2003 13:49 To: [EMAIL PROTECTED] Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' I put it under server/lib, but no such luck.still the same error message. hmmm Uddhav Shirname [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] ent.co.in cc: Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 06:43 AM 'null' Please respond to Tomcat Users List I am not absolutely sure if this is the problem, but I have placed the database related jars under server/lib. It works for me. -- Uddhav - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 6:04 PM Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' Gerlinde, Thanks for the response! I placed my jdbc jar file under common/lib, but I still get the same error message. If you or anyone else has any other ideas, that would be greatly appreciated. Gerlinde Fischer [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] amberg.de cc: Subject: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 05:47 AM 'null' Please respond to Tomcat Users List Hi where ist your Database Connection? In the server.xml in the context for your test application. The jdbc.driver must be placed into the directory common/lib. I hope this will help. Regards Gerlinde -Ursprungliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 11. Marz 2003 22:58 An: [EMAIL PROTECTED] Betreff: java.sql.SQLException: Cannot load JDBC driver class 'null' Tomcat version - 4.1.12 MySQL version - 3.23.55-nt OS - WinNT JDK - 1.4.1_01 I have researched this problem on the internet and in the documentation for Tomcat, and I still haven't resolved this issue. So, I'm looking for help from someone from this list. Here is my URL that I invoke: http://localhost:8080/dbtest/test.jsp Here is the error I receive: java.sql.SQLException: Cannot load JDBC driver class 'null' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:529) Referencing this URL - http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-ex amples-howto.html: 1. I have a database and table with 1 row of data 2. Here is the chunk of code that I inserted into my $CATALINA_HOME/conf/server.xml. !-- Database configuration for MySQL -- Context path=/DBTest docBase=DBTest debug=5 reloadable=true crossContext=true Logger className=org.apache.catalina.logger.FileLogger prefix=localhost_DBTest_log. suffix=.txt timestamp=true/ Resource name=jdbc/TestDB auth=Container type=javax.sql.DataSource/ ResourceParams name
Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null'
Hi, Are you looking in a load-on-startup servlet Pratt. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 6:50 PM Subject: RE: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' No I did not, but now I do and I still receive the same error. I have printed out my classpath on the tomcat startup DOS window. This is: setting the jdbc jar to classpath * * classpath is: C:\Development\j2sdk1.4.1_01\lib\tools.jar;C:\development\ja karta-tomcat-4.1.12\common\lib\mysql-connector-java-3.0.6-stable-bin.jar; ** Currently, I have the jdbc jar file under common\lib, server\lib and webapps\dbtest\WEB-INF\lib, hoping Tomcat will 'see' it under one of these locations. btw, I'm a first-timer for connecting Tomcat to a database. Thanks Clarence DahlinTo: Tomcat Users List [EMAIL PROTECTED] clarence.dahlin cc: @pitch.se Subject: RE: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' 03/12/2003 06:55 AM Please respond to Tomcat Users List Did you define the driver in you classpath? / Clarence Dahlin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: den 12 mars 2003 13:49 To: [EMAIL PROTECTED] Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' I put it under server/lib, but no such luck.still the same error message. hmmm Uddhav Shirname [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] ent.co.in cc: Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 06:43 AM 'null' Please respond to Tomcat Users List I am not absolutely sure if this is the problem, but I have placed the database related jars under server/lib. It works for me. -- Uddhav - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 6:04 PM Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' Gerlinde, Thanks for the response! I placed my jdbc jar file under common/lib, but I still get the same error message. If you or anyone else has any other ideas, that would be greatly appreciated. Gerlinde Fischer [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] amberg.de cc: Subject: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 05:47 AM 'null' Please respond to Tomcat Users List Hi where ist your Database Connection? In the server.xml in the context for your test application. The jdbc.driver must be placed into the directory common/lib. I hope this will help. Regards Gerlinde -Ursprungliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 11. Marz 2003 22:58 An: [EMAIL PROTECTED] Betreff: java.sql.SQLException: Cannot load JDBC driver class 'null' Tomcat version - 4.1.12 MySQL version - 3.23.55-nt OS - WinNT JDK - 1.4.1_01 I have researched this problem on the internet and in the documentation for Tomcat, and I still haven't resolved this issue. So, I'm looking for help from someone from this list. Here is my URL that I invoke: http://localhost:8080/dbtest/test.jsp Here is the error I receive: java.sql.SQLException: Cannot load JDBC driver class 'null' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:529) Referencing this URL - http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-ex amples-howto.html: 1. I have a database and table with 1 row of data 2. Here is the chunk of code that I inserted into my $CATALINA_HOME/conf/server.xml. !-- Database configuration for MySQL -- Context path=/DBTest docBase=DBTest debug=5 reloadable=true crossContext=true Logger className=org.apache.catalina.logger.FileLogger prefix=localhost_DBTest_log. suffix=.txt timestamp=true/ Resource name=jdbc/TestDB auth=Container type=javax.sql.DataSource
Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null'
1. starting from tomcat-home\bin, I type in the command - startup. 2. starting from tomcat-home\bin, I type in the command - shutdown. I do this after every change I make to the tomcat configuration. After I issue the command 'startup,' then I see the classpath output in that same DOS window. Does my server.xml and web.xml setting look correct to all? Tomcat-RND [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] mail.comcc: Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003'null' 07:22 AM Please respond to Tomcat Users List Hi, Are you looking in a load-on-startup servlet Pratt. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 6:50 PM Subject: RE: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' No I did not, but now I do and I still receive the same error. I have printed out my classpath on the tomcat startup DOS window. This is: setting the jdbc jar to classpath * * classpath is: C:\Development\j2sdk1.4.1_01\lib\tools.jar;C:\development\ja karta-tomcat-4.1.12\common\lib\mysql-connector-java-3.0.6-stable-bin.jar; ** Currently, I have the jdbc jar file under common\lib, server\lib and webapps\dbtest\WEB-INF\lib, hoping Tomcat will 'see' it under one of these locations. btw, I'm a first-timer for connecting Tomcat to a database. Thanks Clarence DahlinTo: Tomcat Users List [EMAIL PROTECTED] clarence.dahlin cc: @pitch.se Subject: RE: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' 03/12/2003 06:55 AM Please respond to Tomcat Users List Did you define the driver in you classpath? / Clarence Dahlin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: den 12 mars 2003 13:49 To: [EMAIL PROTECTED] Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' I put it under server/lib, but no such luck.still the same error message. hmmm Uddhav Shirname [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] ent.co.in cc: Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 06:43 AM 'null' Please respond to Tomcat Users List I am not absolutely sure if this is the problem, but I have placed the database related jars under server/lib. It works for me. -- Uddhav - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 6:04 PM Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' Gerlinde, Thanks for the response! I placed my jdbc jar file under common/lib, but I still get the same error message. If you or anyone else has any other ideas, that would be greatly appreciated. Gerlinde Fischer [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] amberg.de cc: Subject: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 05:47 AM 'null' Please respond to Tomcat Users List Hi where ist your Database
Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null'
please control whern send a mail - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 2:37 PM Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' 1. starting from tomcat-home\bin, I type in the command - startup. 2. starting from tomcat-home\bin, I type in the command - shutdown. I do this after every change I make to the tomcat configuration. After I issue the command 'startup,' then I see the classpath output in that same DOS window. Does my server.xml and web.xml setting look correct to all? Tomcat-RND [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] mail.comcc: Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003'null' 07:22 AM Please respond to Tomcat Users List Hi, Are you looking in a load-on-startup servlet Pratt. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 6:50 PM Subject: RE: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' No I did not, but now I do and I still receive the same error. I have printed out my classpath on the tomcat startup DOS window. This is: setting the jdbc jar to classpath * * classpath is: C:\Development\j2sdk1.4.1_01\lib\tools.jar;C:\development\ja karta-tomcat-4.1.12\common\lib\mysql-connector-java-3.0.6-stable-bin.jar; ** Currently, I have the jdbc jar file under common\lib, server\lib and webapps\dbtest\WEB-INF\lib, hoping Tomcat will 'see' it under one of these locations. btw, I'm a first-timer for connecting Tomcat to a database. Thanks Clarence DahlinTo: Tomcat Users List [EMAIL PROTECTED] clarence.dahlin cc: @pitch.se Subject: RE: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' 03/12/2003 06:55 AM Please respond to Tomcat Users List Did you define the driver in you classpath? / Clarence Dahlin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: den 12 mars 2003 13:49 To: [EMAIL PROTECTED] Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' I put it under server/lib, but no such luck.still the same error message. hmmm Uddhav Shirname [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] ent.co.in cc: Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 06:43 AM 'null' Please respond to Tomcat Users List I am not absolutely sure if this is the problem, but I have placed the database related jars under server/lib. It works for me. -- Uddhav - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 6:04 PM Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' Gerlinde, Thanks for the response! I placed my jdbc jar file under common/lib, but I still get the same error message. If you or anyone else has any other ideas, that would be greatly appreciated. Gerlinde Fischer [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] amberg.de cc: Subject: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 05:47 AM 'null' Please respond to Tomcat Users List Hi where ist your Database Connection? In the server.xml in the context for your test application. The jdbc.driver must be placed into the directory common/lib. I hope this will help. Regards Gerlinde -Ursprungliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 11. Marz 2003 22:58 An: [EMAIL PROTECTED] Betreff: java.sql.SQLException: Cannot load JDBC driver class 'null' Tomcat version - 4.1.12 MySQL version - 3.23.55-nt OS - WinNT JDK - 1.4.1_01 I have researched
Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null'
'please control whern send a mail' I'm not sure what you mean by this statement? alessio marinelli To: Tomcat Users List [EMAIL PROTECTED] alessio_marinel cc: [EMAIL PROTECTED] Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' 03/12/1998 07:42 AM Please respond to Tomcat Users List please control whern send a mail - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 2:37 PM Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' 1. starting from tomcat-home\bin, I type in the command - startup. 2. starting from tomcat-home\bin, I type in the command - shutdown. I do this after every change I make to the tomcat configuration. After I issue the command 'startup,' then I see the classpath output in that same DOS window. Does my server.xml and web.xml setting look correct to all? Tomcat-RND [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] mail.comcc: Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003'null' 07:22 AM Please respond to Tomcat Users List Hi, Are you looking in a load-on-startup servlet Pratt. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 6:50 PM Subject: RE: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' No I did not, but now I do and I still receive the same error. I have printed out my classpath on the tomcat startup DOS window. This is: setting the jdbc jar to classpath * * classpath is: C:\Development\j2sdk1.4.1_01\lib\tools.jar;C:\development\ja karta-tomcat-4.1.12\common\lib\mysql-connector-java-3.0.6-stable-bin.jar; ** Currently, I have the jdbc jar file under common\lib, server\lib and webapps\dbtest\WEB-INF\lib, hoping Tomcat will 'see' it under one of these locations. btw, I'm a first-timer for connecting Tomcat to a database. Thanks Clarence DahlinTo: Tomcat Users List [EMAIL PROTECTED] clarence.dahlin cc: @pitch.se Subject: RE: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' 03/12/2003 06:55 AM Please respond to Tomcat Users List Did you define the driver in you classpath? / Clarence Dahlin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: den 12 mars 2003 13:49 To: [EMAIL PROTECTED] Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' I put it under server/lib, but no such luck.still the same error message. hmmm Uddhav Shirname [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] ent.co.in cc: Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 06:43 AM 'null' Please respond to Tomcat Users List I am not absolutely sure if this is the problem, but I
Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null'
when you send a mail [EMAIL PROTECTED] this mail arrive at me - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 2:43 PM Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' 'please control whern send a mail' I'm not sure what you mean by this statement? alessio marinelli To: Tomcat Users List [EMAIL PROTECTED] alessio_marinel cc: [EMAIL PROTECTED] Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' 03/12/1998 07:42 AM Please respond to Tomcat Users List please control whern send a mail - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 2:37 PM Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' 1. starting from tomcat-home\bin, I type in the command - startup. 2. starting from tomcat-home\bin, I type in the command - shutdown. I do this after every change I make to the tomcat configuration. After I issue the command 'startup,' then I see the classpath output in that same DOS window. Does my server.xml and web.xml setting look correct to all? Tomcat-RND [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] mail.comcc: Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003'null' 07:22 AM Please respond to Tomcat Users List Hi, Are you looking in a load-on-startup servlet Pratt. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 6:50 PM Subject: RE: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' No I did not, but now I do and I still receive the same error. I have printed out my classpath on the tomcat startup DOS window. This is: setting the jdbc jar to classpath * * classpath is: C:\Development\j2sdk1.4.1_01\lib\tools.jar;C:\development\ja karta-tomcat-4.1.12\common\lib\mysql-connector-java-3.0.6-stable-bin.jar; ** Currently, I have the jdbc jar file under common\lib, server\lib and webapps\dbtest\WEB-INF\lib, hoping Tomcat will 'see' it under one of these locations. btw, I'm a first-timer for connecting Tomcat to a database. Thanks Clarence DahlinTo: Tomcat Users List [EMAIL PROTECTED] clarence.dahlin cc: @pitch.se Subject: RE: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' 03/12/2003 06:55 AM Please respond to Tomcat Users List Did you define the driver in you classpath? / Clarence Dahlin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: den 12 mars 2003 13:49 To: [EMAIL PROTECTED] Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' I put it under server/lib, but no such luck.still the same error message. hmmm Uddhav Shirname [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] ent.co.in cc: Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 06:43 AM 'null' Please respond to Tomcat Users List I am not absolutely sure if this is the problem, but I have placed the database related jars under server/lib. It works for me. -- Uddhav - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 6:04 PM Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' Gerlinde, Thanks for the response! I placed my jdbc jar file under common/lib, but I still get the same error message. If you or anyone else has any other ideas, that would be greatly appreciated. Gerlinde Fischer [EMAIL
Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null'
If you don't want to be on the mailing list, then you can just unsubscribe. alessio marinelli To: Tomcat Users List [EMAIL PROTECTED] alessio_marinel cc: [EMAIL PROTECTED] Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' 03/12/1998 07:49 AM Please respond to Tomcat Users List when you send a mail [EMAIL PROTECTED] this mail arrive at me - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 2:43 PM Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' 'please control whern send a mail' I'm not sure what you mean by this statement? alessio marinelli To: Tomcat Users List [EMAIL PROTECTED] alessio_marinel cc: [EMAIL PROTECTED] Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' 03/12/1998 07:42 AM Please respond to Tomcat Users List please control whern send a mail - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 2:37 PM Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' 1. starting from tomcat-home\bin, I type in the command - startup. 2. starting from tomcat-home\bin, I type in the command - shutdown. I do this after every change I make to the tomcat configuration. After I issue the command 'startup,' then I see the classpath output in that same DOS window. Does my server.xml and web.xml setting look correct to all? Tomcat-RND [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] mail.comcc: Subject: Re: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003'null' 07:22 AM Please respond to Tomcat Users List Hi, Are you looking in a load-on-startup servlet Pratt. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 6:50 PM Subject: RE: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' No I did not, but now I do and I still receive the same error. I have printed out my classpath on the tomcat startup DOS window. This is: setting the jdbc jar to classpath * * classpath is: C:\Development\j2sdk1.4.1_01\lib\tools.jar;C:\development\ja karta-tomcat-4.1.12\common\lib\mysql-connector-java-3.0.6-stable-bin.jar; ** Currently, I have the jdbc jar file under common\lib, server\lib and webapps\dbtest\WEB-INF\lib, hoping Tomcat will 'see' it under one of these locations. btw, I'm a first-timer for connecting Tomcat to a database. Thanks Clarence DahlinTo: Tomcat Users List [EMAIL PROTECTED] clarence.dahlin cc: @pitch.se Subject: RE: AW: java.sql.SQLException: Cannot load JDBC driver class 'null' 03/12/2003 06:55 AM Please respond to Tomcat Users List
Re: AW: java.sql.SQLException: Cannot load JDBC driver class 'null'
I have this working now. Here is what I did: * First of all, I changed my server.xml. Here is the section of that file that matters to this issue: !-- Database configuration for MySQL -- Context path=/bugtracker docBase=bugtracker debug=5 reloadable =true crossContext=true Logger className=org.apache.catalina.logger.FileLogger prefix =localhost_DBTest_log. suffix=.txt timestamp=true/ Resource name=jdbc/bugtracker auth=Container type =javax.sql.DataSource/ ResourceParams name=jdbc/bugtracker parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter !-- Maximum number of dB connections in pool. Make sure you configure your mysqld max_connections large enough to handle all of your db connections. Set to 0 for no limit. -- parameter namemaxActive/name value100/value /parameter !-- Maximum number of idle dB connections to retain in pool. Set to 0 for no limit. -- parameter namemaxIdle/name value30/value /parameter !-- Maximum time to wait for a dB connection to become available in ms, in this example 10 seconds. An Exception is thrown if this timeout is exceeded. Set to -1 to wait indefinitely. -- parameter namemaxWait/name value1/value /parameter !-- MySQL dB username and password for dB connections -- parameter nameusername/name valuebugtracker/value /parameter parameter namepassword/name valuefootin/value /parameter !-- Class name for mm.mysql JDBC driver -- parameter namedriverClassName/name valuecom.mysql.jdbc.Driver/value /parameter !-- The JDBC connection url for connecting to your MySQL dB. The autoReconnect=true argument to the url makes sure that the mm.mysql JDBC Driver will automatically reconnect if mysqld closed the connection. mysqld by default closes idle connections after 8 hours. -- parameter nameurl/name valuejdbc:mysql://localhost:3306/bugtracker?autoReconnect=true/value /parameter /ResourceParams /Context * The jdbc jar file only works under \common\lib * Changed the jndi line in the Java class to reference 'bugtracker' * Thanks for all your help! Gerlinde Fischer [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] amberg.de cc: Subject: AW: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 05:47 AM 'null' Please respond to Tomcat Users List Hi where ist your Database Connection? In the server.xml in the context for your test application. The jdbc.driver must be placed into the directory common/lib. I hope this will help. Regards Gerlinde -Ursprungliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 11. Marz 2003 22:58 An: [EMAIL PROTECTED] Betreff: java.sql.SQLException: Cannot load JDBC driver class 'null' Tomcat version - 4.1.12 MySQL version - 3.23.55-nt OS - WinNT JDK - 1.4.1_01 I have researched this problem on the internet and in the documentation for Tomcat, and I still haven't resolved this issue. So, I'm looking for help from someone from this list. Here is my URL that I invoke: