DO NOT REPLY [Bug 15672] - DBCP doesn't work on Tomcat 4.1.18 with Oracle JDBC driver
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15672. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15672 DBCP doesn't work on Tomcat 4.1.18 with Oracle JDBC driver [EMAIL PROTECTED] changed: What|Removed |Added Status|NEW |RESOLVED Resolution||INVALID --- Additional Comments From [EMAIL PROTECTED] 2004-02-09 01:39 --- This report has morphed multiple times. Please use the tomcat-user list to first debug a cause for bug. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Autoreply: DO NOT REPLY [Bug 15672] - DBCP doesn't work on Tomcat 4.1.18 with Oracle JDBC driver
Hello, Due to the increased volume of SPAM this mailbox has been closed. Please contact us via http://www.directxtras.com/ContactUS.asp We apology for the inconvenience. Best Regards, -- The DirectXtras Team - DirectXtras - Xtra Power for Director and Authorware - http://www.directxtras.com Sites with something to say - http://www.SpeaksForItself.com - Your message reads: Received: from mail.apache.org (unverified [208.185.179.12]) by mail2.intermedia.net (Rockliffe SMTPRA 4.5.6) with SMTP id [EMAIL PROTECTED] for [EMAIL PROTECTED]; Sun, 8 Feb 2004 17:39:37 -0800 Received: (qmail 5489 invoked by uid 500); 9 Feb 2004 01:39:19 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm Precedence: bulk List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] List-Help: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Id: Tomcat Developers List tomcat-dev.jakarta.apache.org Reply-To: Tomcat Developers List [EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Received: (qmail 4889 invoked from network); 9 Feb 2004 01:39:13 - Received: from unknown (HELO exchange.sun.com) (192.18.33.10) by daedalus.apache.org with SMTP; 9 Feb 2004 01:39:13 - Received: (qmail 14526 invoked by uid 50); 9 Feb 2004 01:39:39 - Date: 9 Feb 2004 01:39:39 - Message-ID: [EMAIL PROTECTED] From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Subject: DO NOT REPLY [Bug 15672] - DBCP doesn't work on Tomcat 4.1.18 with Oracle JDBC driver X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15672. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15672 DBCP doesn't work on Tomcat 4.1.18 with Oracle JDBC driver [EMAIL PROTECTED] changed: What|Removed |Added Status|NEW |RESOLVED Resolution||INVALID --- Additional Comments From [EMAIL PROTECTED] 2004-02-09 01:39 --- This report has morphed multiple times. Please use the tomcat-user list to first debug a cause for bug. - 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]
DO NOT REPLY [Bug 15672] - DBCP doesn't work on Tomcat 4.1.18 with Oracle JDBC driver
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15672. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15672 DBCP doesn't work on Tomcat 4.1.18 with Oracle JDBC driver --- Additional Comments From [EMAIL PROTECTED] 2003-06-13 21:07 --- In trying to make the move to automate my testing I have come up against the same problem. First some background. I am running Tomcat 4.1.18, Java 1.3.1, Win 2k classes12.jar, commons-collections.jar, commons-dbcp.jar, commons-pool are located in $TOMCAT_HOME/common/lib I am attempting to get automated testing running To do this was getting the ANT build to undeploy and then redeploy the war after it got created. In addition, I decided that it was more convenient to have the Test classes located in my app.war instead of a seperate war. Part of getting this dynamic undeploy/deploy cycle to work was removing the context from the server.xml. The reason I want to do this is I have 2 connection pools located there. In a dynamic deploy tomcat generates it's own context for the app. I found there were three ways I could do this. #1. put the connection pool into the GlobalNamingResources section of server.xml #2. create a $APP_NAME.xml file that contains the context of the app and put it into $TOMCAT_HOME/webapps. Both the Tomcat manager and Admin apps do this. #3. Possibly put the context info in the web.xml file for the app. I have tried both 1 and 2 and I am getting the java.sql.SQLException: Cannot load JDBC driver class 'null' error when the DBCP is accessed in both. Below are the relevant files for Option #2 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 display-nameTSR Application/display-name descriptionThis is the web configuration for the TSR application/description !-- SERVLET LISTINGS -- servlet servlet-nameTestServlet/servlet-name servlet-classnet.myco.myapp.servlets.TestServlet/servlet-class /servlet servlet servlet-nameControllerServlet/servlet-name servlet-classnet.myco.myapp.servlets.ControllerServlet/servlet-class /servlet servlet servlet-nameFileDownloadServlet/servlet-name servlet-classnet.myco.myapp.servlets.FileDownloadServlet/servlet- class /servlet servlet servlet-nameStartupServlet/servlet-name servlet-classnet.myco.myapp.servlets.StartupServlet/servlet-class load-on-startup1/load-on-startup /servlet !--servlet servlet-namelog4j-init/servlet-name servlet-classnet.myco.myapp.servlets.Log4jInit/servlet-class load-on-startup1/load-on-startup init-param param-namelog4j-init-file/param-name param-valueWEB-INF\classes\log4j.properties/param-value /init-param /servlet-- !-- integrate the testing -- servlet servlet-nameJUnitEETestServlet/servlet-name descriptionJUnitEE test runner/description servlet-classorg.junitee.servlet.JUnitEEServlet/servlet-class /servlet !-- SERVLET MAPPINGS -- servlet-mapping servlet-nameTestServlet/servlet-name url-pattern/test/url-pattern /servlet-mapping servlet-mapping servlet-nameStartupServlet/servlet-name url-pattern/startup/url-pattern /servlet-mapping servlet-mapping servlet-nameControllerServlet/servlet-name url-pattern/controller/url-pattern /servlet-mapping servlet-mapping servlet-nameFileDownloadServlet/servlet-name url-pattern/download/url-pattern /servlet-mapping !-- integrate the testing -- servlet-mapping servlet-nameJUnitEETestServlet/servlet-name url-pattern/TestServlet/*/url-pattern /servlet-mapping !-- JNDI resource for DB connection pool -- resource-ref description Resource reference to a factory for java.sql.Connection instances that may be used for talking to a particular database that is configured in the server.xml file. /description res-ref-name jdbc/oracle_myapp /res-ref-name res-type javax.sql.DataSource /res-type res-auth Container /res-auth /resource-ref !-- JNDI resource for DB connection pool -- resource-ref description Resource reference to a factory for java.sql.Connection instances that may be used for talking to a particular database that is configured in the server.xml file. /description res-ref-name jdbc/oracle_myco
DO NOT REPLY [Bug 15672] - DBCP doesn't work on Tomcat 4.1.18 with Oracle JDBC driver
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15672. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15672 DBCP doesn't work on Tomcat 4.1.18 with Oracle JDBC driver --- Additional Comments From [EMAIL PROTECTED] 2003-02-04 16:06 --- I am unable to DBCP to work when trying to get a connection at context startup. I tried getting a connection within a ServletContextListener servlet and received Cannot load JDBC driver class 'null'. I received the same error when trying to get a connection within a servlet set to load-on-startup. I have no problem getting a connection if I make the exact same call later. I have my ResourceParams defined within the DefaultContext node. I'm not sure if that could make a difference. Otherwise the server.xml and web.xml is the one described in the Tomcat sample documentation (other than usernames, passwords, etc. of course) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 15672] - DBCP doesn't work on Tomcat 4.1.18 with Oracle JDBC driver
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15672. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15672 DBCP doesn't work on Tomcat 4.1.18 with Oracle JDBC driver --- Additional Comments From [EMAIL PROTECTED] 2003-01-13 20:40 --- It does work indeed. At least the MySQL setup. My bad part was that I didn't notice the Resource/ and ResourceParams/ResourceParams were not included in the Context/Context but were its siblings because the Context tag line was long and didn't wrap. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 15672] - DBCP doesn't work on Tomcat 4.1.18 with Oracle JDBC driver
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15672. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15672 DBCP doesn't work on Tomcat 4.1.18 with Oracle JDBC driver --- Additional Comments From [EMAIL PROTECTED] 2003-01-10 22:23 --- Hello, I am having the same problem with the MySQL driver (connector/j 3.0.4). I checked that the BasicDatasource instance is created. I did not check whether the description is there but the important parameters (driver, url, username, pass) were not there. I am not attaching my sever.xml and web.xml files as they are alomst identical except the driverClassName is com.mysql.jdbc.Driver and the url is mysql specific. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 15672] - DBCP doesn't work on Tomcat 4.1.18 with Oracle JDBC driver
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15672. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15672 DBCP doesn't work on Tomcat 4.1.18 with Oracle JDBC driver --- Additional Comments From [EMAIL PROTECTED] 2003-01-10 22:44 --- I have been able to get Oracle's JDBC Driver working just fine with Tomcat 4.1.18. Below are my specifics from server.xml. Are you sure that classes12.jar is in $CATALINA_HOME/common/lib? Resource name=jdbc/mydatabase auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/mydatabase parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter namemaxActive/name value50/value /parameter parameter namemaxIdle/name value10/value /parameter parameter namemaxWait/name value1/value /parameter parameter nameusername/name valuescott/value /parameter parameter namepassword/name valuetiger/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter nameurl/name valuejdbc:oracle:thin:@host:1521:database/value /parameter parameter nameremoveAbandoned/name valuetrue/value /parameter parameter nameremoveAbandonedTimeout/name value60/value /parameter parameter namelogAbandoned/name valuetrue/value /parameter /ResourceParams -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 15672] - DBCP doesn't work on Tomcat 4.1.18 with Oracle JDBC driver
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15672. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15672 DBCP doesn't work on Tomcat 4.1.18 with Oracle JDBC driver --- Additional Comments From [EMAIL PROTECTED] 2003-01-10 07:38 --- I am having this same error with Postgresql with this version. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 15672] - DBCP doesn't work on Tomcat 4.1.18 with Oracle JDBC driver
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15672. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15672 DBCP doesn't work on Tomcat 4.1.18 with Oracle JDBC driver --- Additional Comments From [EMAIL PROTECTED] 2003-01-03 08:42 --- Hello! I receive the same errore using Informix. Trying to resolve the problems I've modified the classes BasicDataSource and BasicDataSourceFactory and I've seen a strange thing: On startup, Tomcat creates a DataSource correctly according to server.xml. When I execute the ctx.lookup()/getConnection() for my DS, I see BasicDataSourceFactory creates a new BasicDataSource that contains only description, scope and auth (according to my web.xml) while driverClassName, maxWait and the other params doesnt't exist. WHen I do ds.getConnection I receive the error: java.sql.SQLException: Cannot load JDBC driver class 'null' at org.apache.commons.dbcp.BasicDataSource.createDataSource BasicDataSource.java:289) at org.apache.commons.dbcp.BasicDataSource.getConnection (BasicDataSource.java:162) This is normal because createDataSource is called on the patial empty DataSource (that doesn't contain driverClassName etc...) I hope I give you some idea to solve the problem. Bye -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
