MBeanException - ManagedBean not found
Tomcat 4.1 OS = win2000 Here is a snapshot of my error on the console: INFO: Creating MBeanServer Jan 26, 2004 11:22:02 AM org.apache.coyote.http11.Http11Protocol init INFO: Initializing Coyote HTTP/1.1 on port 8080 ServerLifecycleListener: createMBeans: MBeanException java.lang.Exception: ManagedBean is not found with Ajp13Connector at org.apache.catalina.mbeans.MBeanUtils.createMBean(MBeanUtils.java:225 Any ideas as to why this happening or what am I missing? Kevin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Dual Web Apps (IIS), Dual Tomcat instances, How-to?
Hi, Tomcat: 4.1 IIS: 5.0 OS: Windows2000 I currently have a web app. configured in IIS to talk to a Tomcat instance, fine, no problem. But, now, I want to setup a development web app (instance) and a separate QA/Testing web app (instance). The ISAPI_Redirector2.dll has registry settings. In the registry, one of the entries needs to point to the location of the installed Tomcat. So, when I configure IIS with two different web apps, I would need two different installed Tomcat instances, correct? When I installed a new Tomcat (using the .exe), it configured the services to the same name as my original Tomcat instance. So, in the services window, I had a Tomcat 4.1 service. Now, I still have that same service, but it's still pointing to my original Tomcat instance. I was expecting a 2nd service for my 2nd Tomcat instance. Are there instructions for manually installing a specific service? SORRY, more than one question here: Also, when I manually started my 2nd Tomcat instance (while my 1st instance was running), I got a JVM Bind to port message. It said that port 8009 was already in use. I changed all port numbers in the server.xml (I just added one to each number). Those new ports are open on the box. Any ideas? Thanks, Kevin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: isapi_redirector2.dll fails - red arrow
Thanks Frank! Also, I tried http://www.shiftomat.com/opensource, and it worked great. Thanks Daniel! Now, I just need to make my existing site (in IIS) route JSP calls to Tomcat, instead of from the localhost. I'll work on that. Frank Febbraro [EMAIL PROTECTED]To: Tomcat Users List [EMAIL PROTECTED] thlink.net cc: Subject: Re: isapi_redirector2.dll fails - red arrow 01/15/2004 02:55 PM Please respond to Tomcat Users List I looks as if you are following the instructions for the JK1.x connector and not the JK 2.0.2 instructions. The best step-by-step I found was here and it worked like a charm. http://nagoya.apache.org/wiki/apachewiki.cgi?WinJK2IIs - Original Message - From: [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Thursday, January 15, 2004 1:46 PM Subject: Re: isapi_redirector2.dll fails - red arrow I couldn't find the isapi_redirector.dll, just the isapi_redirector2.dll. Registry: extension_uri = /tomcat/isapi_redirector2.dll worker_file = D:\Program Files\Tomcat 4.1\conf\workers.properties worker_mount_file = D:\Program Files\Tomcat 4.1\conf\uriworkermap.properties log_file = D:\Program Files\Tomcat 4.1\logs\jk_iis.log log_level = debug Maybe I'll try your setup program if I can't get this to work. Thanks Daniel Schmitt [EMAIL PROTECTED]To: Tomcat Users List [EMAIL PROTECTED] e cc: Subject: Re: isapi_redirector2.dll fails - red arrow 01/15/2004 12:38 PM Please respond to Tomcat Users List [EMAIL PROTECTED] wrote: I followed http://www.onjava.com/pub/a/onjava/2002/12/18/tomcat.html for instructions. They are out of date - jk1.2 Connector are you pointing to isapi_redirector2.dll not isapi_redirector.dll? could you post your reg entrys here? You can also try our jk2.02 installer at: http://www.shiftomat.com/opensource but you have to undo your manual install first to get it working hope this helps -- Daniel Schmitt http://www.shiftomat.de - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
isapi_redirector2.dll fails - red arrow
Tomcat = 4.1 IIS = 5.0 OS = windows2000 DLL = isapi_redirector2.dll (downloaded from http://apache.mirrors.pair.com/jakarta/tomcat-connectors/jk2/binaries/win32/) I followed http://www.onjava.com/pub/a/onjava/2002/12/18/tomcat.html for instructions. I've made double sure my entries in the registry are correct. I checked read/write/execute when adding the filter to the virtual directory. I have my workers.properties, uriworkermap.properties, and I added the connector tag in the server.xml. All of these are in CATALINA_HOME/conf. Once I was done with all of this configuration, I restarted the server (warm boot, not cold boot). Now, in IIS under ISAPI Filters in the 'default web site' I have a red arrow. The status is 'Not Loaded.' Any suggestions on getting the arrow green? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: isapi_redirector2.dll fails - red arrow
I couldn't find the isapi_redirector.dll, just the isapi_redirector2.dll. Registry: extension_uri = /tomcat/isapi_redirector2.dll worker_file = D:\Program Files\Tomcat 4.1\conf\workers.properties worker_mount_file = D:\Program Files\Tomcat 4.1\conf\uriworkermap.properties log_file = D:\Program Files\Tomcat 4.1\logs\jk_iis.log log_level = debug Maybe I'll try your setup program if I can't get this to work. Thanks Daniel Schmitt [EMAIL PROTECTED]To: Tomcat Users List [EMAIL PROTECTED] e cc: Subject: Re: isapi_redirector2.dll fails - red arrow 01/15/2004 12:38 PM Please respond to Tomcat Users List [EMAIL PROTECTED] wrote: I followed http://www.onjava.com/pub/a/onjava/2002/12/18/tomcat.html for instructions. They are out of date - jk1.2 Connector are you pointing to isapi_redirector2.dll not isapi_redirector.dll? could you post your reg entrys here? You can also try our jk2.02 installer at: http://www.shiftomat.com/opensource but you have to undo your manual install first to get it working hope this helps -- Daniel Schmitt http://www.shiftomat.de - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Multiple webapps talking to same DB
Version of Tomcat - 4.1.24 OS - WinXP (development workstation) DB - MySQL 4.0.13 I currently have a single webapp (test1) that can connect to the database and perform DB operations just fine. This uses JSP, Servlets and JDBC. What I want to do is have other webapps connect to the same database. Here is what I did: 1. I copied my existing webapp, tomcat_home\webapps\test1 and created tomcat_home\webapps\test2. 2. I restarted tomcat and when invoking the test2 webapp, I get the following error: java.sql.SQLException: Cannot load JDBC driver class 'null' This error happens when I call the getConnection() method on the DataSource object. I believe I don't have the correct configuration in the server.xml for the webapp, test2. I tried several different ways to try and get this to work, but those have failed so far. So, when making a straight copy of one webapp like I did above, what would need to change in the server.xml (in the MySQL section) to get this to work? Or, would the culprit be some other configuration? Thanks for any help on this, Kevin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Multiple webapps talking to same DB
Thanks for the tips. Actually, I added another context (context) to the tomcat_home \conf\server.xml, which specifies the database parameters and I'm good to go. Didn't help that I was also working with the wrong server.xml file. Edson Alves Pereira [EMAIL PROTECTED]To: 'Tomcat Users List' [EMAIL PROTECTED] ano.com.br cc: Subject: RE: Multiple webapps talking to same DB 11/06/2003 11:32 AM Please respond to Tomcat Users List If you want to create a default database for all web-apps ( i don´t known if you want the same database´s user also ), you should add a JNDI datasource in GlobalNamingResources, try to use tomcat´s manager. Remeber, you must put your JDBC driver in common/lib also, because tomcat need it to create the datasource, but in your case, maybe you did try a simple connection and forgot to put JDBC driver in shared/lib or WEB-INF/lib. -- De: [EMAIL PROTECTED]:[EMAIL PROTECTED] Responder: Tomcat Users List Enviada: quinta-feira, 6 de novembro de 2003 10:22 Para:[EMAIL PROTECTED] Assunto: Multiple webapps talking to same DB Version of Tomcat - 4.1.24 OS - WinXP (development workstation) DB - MySQL 4.0.13 I currently have a single webapp (test1) that can connect to the database and perform DB operations just fine. This uses JSP, Servlets and JDBC. What I want to do is have other webapps connect to the same database. Here is what I did: 1. I copied my existing webapp, tomcat_home\webapps\test1 and created tomcat_home\webapps\test2. 2. I restarted tomcat and when invoking the test2 webapp, I get the following error: java.sql.SQLException: Cannot load JDBC driver class 'null' This error happens when I call the getConnection() method on the DataSource object. I believe I don't have the correct configuration in the server.xml for the webapp, test2. I tried several different ways to try and get this to work, but those have failed so far. So, when making a straight copy of one webapp like I did above, what would need to change in the server.xml (in the MySQL section) to get this to work? Or, would the culprit be some other configuration? Thanks for any help on this, Kevin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Servlet mapping error
I'm trying to map a Servlet URL and then invoke that Servlet in my web app. When I attempt this, I'm getting the following error in my browser: [start error] HTTP Status 404 - /servlets/LoginServlet type Status report message /servlets/LoginServlet description The requested resource (/servlets/LoginServlet) is not available. Apache Tomcat/4.1.24 [end error] Under tomcat home/webapps/bugtracker/WEB-INF/web.xml, I have the following snippet of lines: servlet servlet-nameLoginServlet/servlet-name servlet-classcom.bugtracker.servlets.LoginServlet/servlet-class /servlet servlet-mapping servlet-nameLoginServlet/servlet-name url-pattern/servlets/LoginServlet/url-pattern /servlet-mapping Under tomcat home/webapps/bugtracker/WEB-INF/classes, I have: /com/bugtracker/servlets/LoginServlet.class In my login.jsp, I have this line: form method=post action=/servlets/LoginServlet Can anyone give me suggestions on what I might be doing wrong? Thanks - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Servlet mapping error
Thanks, I knew it was somthing simple/stupid. Works now. Shapira, Yoav [EMAIL PROTECTED]To: Tomcat Users List [EMAIL PROTECTED] .comcc: Subject: RE: Servlet mapping error 06/27/2003 12:35 PM Please respond to Tomcat Users List Howdy, Under tomcat home/webapps/bugtracker/WEB-INF/web.xml, I have the following snippet of lines: servlet servlet-nameLoginServlet/servlet-name servlet-classcom.bugtracker.servlets.LoginServlet/servlet-class /servlet servlet-mapping servlet-nameLoginServlet/servlet-name url-pattern/servlets/LoginServlet/url-pattern /servlet-mapping Under tomcat home/webapps/bugtracker/WEB-INF/classes, I have: /com/bugtracker/servlets/LoginServlet.class In my login.jsp, I have this line: form method=post action=/servlets/LoginServlet The action URL is wrong, should be /bugtracker/servlets/LoginServlet Yoav Shapira This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
What is the maximum session handling capability
In the past, I've used Tomcat for very small projects. But, now I may be using Apache/Tomcat for an actual business-related project. I've been looking in the documentation, but haven't found this answer just yet. I'm sure this has been asked several times (I did a search in the archives, but didn't find the answer). How many concurrent sessions can Tomcat handle? How many concurrent sessions can Apache handle? Thanks, Kevin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: What is the maximum session handling capability
I thought there might be some numbers along with a few different configurations (cpu/ram/etc.) in the docs somewhere. No problem.thanks for the link to the testing tool! Angus Mezick [EMAIL PROTECTED]To: Tomcat Users List [EMAIL PROTECTED] r.org cc: Subject: RE: What is the maximum session handling capability 05/29/2003 10:29 AM Please respond to Tomcat Users List It sucks when the answer really is it depends. What hardware are you using? The only want to get a REALLY accurate answer is to use a stress testing tool from http://www.opensourcetesting.org/performance.php and see what happens using your hardware/application set up. Then do some config file tuning to see if you can improve on the results. With the data provided I think the best possible answer is A lot. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2003 11:19 AM To: [EMAIL PROTECTED] Subject: What is the maximum session handling capability In the past, I've used Tomcat for very small projects. But, now I may be using Apache/Tomcat for an actual business-related project. I've been looking in the documentation, but haven't found this answer just yet. I'm sure this has been asked several times (I did a search in the archives, but didn't find the answer). How many concurrent sessions can Tomcat handle? How many concurrent sessions can Apache handle? Thanks, Kevin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: java.sql.SQLException: Cannot load JDBC driver class 'null'
Hi Michael, I sent an email to this list yesterday saying that I figured out the problemand yes, I only have the JAR under /lib. Thanks! Tam, Michael [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED] can.gc.ca cc: Subject: RE: java.sql.SQLException: Cannot load JDBC driver class 03/12/2003 11:23'null' AM Please respond to Tomcat Users List Hi Kevin, You should not put any CLASS in lib at all. It is the place for jars only. Get rib of all the MySQL JDBC driver files anywhere in your webapp and put the mysql jdbc driver jar file into lib and restart tomcat and see if this will resolve your problem. By the way, which version of the driver are you using, I believe the recent versions are changing the url to something like 'com.mysql.jdbc.Driver'. 'org.gjt.mm.mysql.Driver' is still valid but I believe it will phase out eventually. Regards, Michael -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 1:58 PM To: [EMAIL PROTECTED] Subject: 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-examples-how to.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
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 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'
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
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' 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'
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:
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-examples-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 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/javatest?autoReconnect=true/value-- valuejdbc:mysql://localhost:3306/bugtracker/value /parameter /ResourceParams /Context 3. Here is my web.xml under $CATALINA_HOME/webapps/dbtest/web-inf/web.xml: ?xml version=1.0 encoding=ISO-8859-1? !DOCTYPE web-app PUBLIC -//Sun Microsystems, Inc.//DTD Web Application 2.3//EN http://java.sun.com/dtd/web-app_2_3.dtd; web-app descriptionMySQL Test App/description resource-ref descriptionDB Connection/description res-ref-namejdbc/TestDB/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref /web-app 4. Added my DB Driver under $CATALINA_HOME/webapps/dbtest/lib/org/git/mm/mysql/Driver.class. I also tried just putting the jar file under the /lib. 5. Created a JSP and class just like in the example above. I just changed my select statement inside the class, that's all. 6. I have verified that my database is indeed running. 7. In my.ini (for MySQL), the port setting is NOT commented. The bind-address IS commented out. Thanks for any help! Kevin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]