org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
Hi, I´m a newbie with problems configurating Tomcat, I´ve been reading examples and the mailing list, but I can´t configure correctly Tomcat 5.0.28 with Oracle 9, I´m a bit desperate it´s what I got: in my Tomcat 5.0\common\lib folder I´ve got ojdbc14.jar --- Tomcat 5.0\conf\server.xml: --- ?xml version='1.0' encoding='utf-8'? Server Listener className=org.apache.catalina.mbeans.ServerLifecycleListener/ Listener className=org.apache.catalina.mbeans.GlobalResourcesLifecycleListener/ GlobalNamingResources Environment name=simpleValue type=java.lang.Integer value=30/ Resource auth=Container description=User database that can be updated and saved name=UserDatabase type=org.apache.catalina.UserDatabase/ ResourceParams name=UserDatabase parameter namefactory/name valueorg.apache.catalina.users.MemoryUserDatabaseFactory/value /parameter parameter namepathname/name valueconf/tomcat-users.xml/value /parameter /ResourceParams /GlobalNamingResources Service name=Catalina Connector acceptCount=100 connectionTimeout=2 disableUploadTimeout=true port=8080 redirectPort=8443 maxSpareThreads=75 maxThreads=150 minSpareThreads=25 /Connector Connector port=8009 protocol=AJP/1.3 protocolHandlerClassName=org.apache.jk.server.JkCoyoteHandler redirectPort=8443 /Connector Engine defaultHost=localhost name=Catalina Host appBase=webapps name=localhost Logger className=org.apache.catalina.logger.FileLogger prefix=localhost_log. suffix=.txt timestamp=true/ Resource name=jdbc/myoracle auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/myoracle parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter nameurl/name valuejdbc:oracle:thin:@10.0.100.6:1521:bddesa/value /parameter parameter nameusername/name value*/value /parameter parameter namepassword/name value*/value /parameter parameter namemaxActive/name value20/value /parameter parameter namemaxIdle/name value10/value /parameter parameter namemaxWait/name value-1/value /parameter /ResourceParams /Host Logger className=org.apache.catalina.logger.FileLogger prefix=catalina_log. suffix=.txt timestamp=true/ Realm className=org.apache.catalina.realm.UserDatabaseRealm/ /Engine /Service /Server --- Tomcat 5.0\webapps\ROOT\WEB-INF\web.xml --- ?xml version=1.0 encoding=ISO-8859-1? !-- Copyright 2004 The Apache Software Foundation Licensed under the Apache License, Version 2.0 (the License); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an AS IS BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. -- web-app xmlns=http://java.sun.com/xml/ns/j2ee; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xsi:schemaLocation=http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd; version=2.4 display-nameWelcome to Tomcat/display-name description Welcome to
RE: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
Hi, I´ve seen tomcat 5.0.28 has different *.xml files for each context in catalina/localhost, then I´ve modified ROOT.xml instead server.xml here it is: - ROOT.xml - ?xml version='1.0' encoding='utf-8'? Context displayName=Welcome to Tomcat docBase=C:\Archivos de programa\Apache Software Foundation\Tomcat 5.0\webapps\ROOT path= workDir=work\Catalina\localhost\_ Logger className=org.apache.catalina.logger.FileLogger prefix=localhost_ROOT_log. suffix=.txt timestamp=true/ Resource name=jdbc/bbdesa type=javax.sql.DataSource/ ResourceParams name=jdbc/bbdesa parameter nameurl/name valuejdbc:oracle:thin:@10.0.100.6:1521:bddesa/value /parameter parameter namevalidationQuery/name valueselect * FROM componentes_correos/value /parameter parameter namemaxIdle/name value30/value /parameter parameter namemaxActive/name value10/value /parameter parameter namedriverClassName/name valuecom.mysql.jdbc.Driver/value /parameter parameter namemaxWait/name value1/value /parameter parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter nameusername/name value/value /parameter parameter namepassword/name value/value /parameter /ResourceParams /Context -- web.xml -- ?xml version=1.0 encoding=ISO-8859-1? !-- Copyright 2004 The Apache Software Foundation Licensed under the Apache License, Version 2.0 (the License); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an AS IS BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. -- web-app xmlns=http://java.sun.com/xml/ns/j2ee; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xsi:schemaLocation=http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd; version=2.4 display-nameWelcome to Tomcat/display-name description Welcome to Tomcat /description !-- JSPC servlet mappings start -- servlet servlet-nameorg.apache.jsp.index_jsp/servlet-name servlet-classorg.apache.jsp.index_jsp/servlet-class /servlet servlet-mapping servlet-nameorg.apache.jsp.index_jsp/servlet-name url-pattern/index.jsp/url-pattern /servlet-mapping !-- JSPC servlet mappings end -- resource-ref descriptionOracle Datasource example/description res-ref-namejdbc/bbdesa/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref /web-app test2.jsp out.print(1); Context initContext = new InitialContext(); out.print(2); Context envContext = (Context)initContext.lookup(java:/comp/env); out.print(3); DataSource ds = (DataSource)envContext.lookup(jdbc/bbdesa); out.print(4); conn = ds.getConnection(); out.print(5); Anyway, it gives me the same error: 1234org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' any help? thanks. -Mensaje original- De: Licinio Gomez Delgado [mailto:[EMAIL PROTECTED] Enviado el: miércoles, 13 de abril de 2005 9:49 Para: tomcat-user@jakarta.apache.org Asunto: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' Hi, I´m a newbie with problems configurating Tomcat, I´ve been reading examples and the mailing list, but I can´t configure correctly Tomcat 5.0.28 with Oracle 9, I´m a bit desperate it´s what I got: in my Tomcat 5.0\common\lib folder I´ve got ojdbc14.jar --- Tomcat 5.0\conf\server.xml: --- ?xml version='1.0' encoding='utf-8'? Server Listener className=org.apache.catalina.mbeans.ServerLifecycleListener/ Listener className=org.apache.catalina.mbeans.GlobalResourcesLifecycleListener/ GlobalNamingResources Environment name=simpleValue type=java.lang.Integer value=30/ Resource auth=Container description=User database that can be updated and saved name=UserDatabase type=org.apache.catalina.UserDatabase/ ResourceParams name=UserDatabase parameter namefactory/name valueorg.apache.catalina.users.MemoryUserDatabaseFactory/value /parameter parameter namepathname/name valueconf/tomcat-users.xml/value /parameter /ResourceParams /GlobalNamingResources
RE: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
Hmm I have fixed the problem, but in a weird way. Instead of using host resk, which I specified inside my /etc/hosts: # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 localhost.localdomain localhost 127.0.0.1 localhost.localdomain resk And I had no problem retrieveing my JSPs under that host Everything seemed to be just fine, but for some reason the JDBC resources coulndt be found I wonder I didnt change anything at all, except for moving my ROOT.xml into /conf/Catalina/localhost and changing the docBase= directory. So, Looks like it wasnt Tomcats fault after all. or was it? :-) However, if any of you know what the problem was, Id be glad to find out, so if I face this kind of stuff in the future, Id know what to do -Original Message- From: Ivan Jouikov [mailto:[EMAIL PROTECTED] Sent: Sunday, July 11, 2004 10:04 PM To: 'Tomcat Users List' Subject: RE: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' Just to make sure that theres no problems with my code, I wrote the following page and tried it. TADA! I get the same goddamn error: %@ page language=java import=javax.naming.*, javax.sql.*, java.sql.* % Hello! Running DB test... br % DataSource ds = (DataSource)new InitialContext().lookup(java:comp/env/jdbc/RESK); % DS looked up!br %-- IT EXECUTED UP TO HERE. EVRYTHING WAS FINE. THEN I ADDED THE BOTTOM PART AND GOT THE cannot create ERROR! --% Now trying to execute a query...br % Connection con = ds.getConnection(); PreparedStatement st = con.prepareStatement(SELECT CURTIME()); ResultSet rs = st.executeQuery(); rs.next(); String time = rs.getString(1); rs.close(); st.close(); con.close(); % Time is: %=time% !!! br I just wish tomcat developers actually tested their shit before putting it out. _ From: Ivan Jouikov [mailto:[EMAIL PROTECTED] Sent: Sunday, July 11, 2004 9:28 PM To: 'Tomcat Users List' Subject: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' When they compiled the latest stable Tomcat, did they bother to test it before putting it out? I looke through the entire google, and through this entire list, and I found lots of people having this problem. Yet, I didnt find any solutions (that worked for me that is). Basically, heres what I have: Im running Tomcat 5.0.27 on Java 1.5 beta 2; I am using MySQL 4.1.2 Inside /common/lib/ I have mysql-connector.jar which is 3.0.14 production version. Inside my server.xml I have (relevant stuff): Host appBase=/home/resk/web name=resk autoDeploy=true unpackWARs=true liveDeploy=true /Host Inside my /conf/Catalina/resk I have resk.xml: ?xml version='1.0' encoding='utf-8'? Context debug=5 displayName=RESK docBase=ROOT // BY THE WAY I also tried /home/resk/web/ROOT path=/ reloadable=false Environment name=data.source.name type=java.lang.String value=java:comp/env/jdbc/RESK/ // BTW I tried without this line Resource auth=Container name=jdbc/RESK type=javax.sql.DataSource/ ResourceParams name=jdbc/RESK parameter nameurl/name valuejdbc:mysql://127.0.0.1:3306/resk?autoReconnect=true/value /parameter parameter namemaxIdle/name value2/value /parameter parameter namemaxActive/name value10/value /parameter parameter namedriverClassName/name valuecom.mysql.jdbc.Driver/value /parameter parameter namemaxWait/name value1/value /parameter parameter nameremoveAbandoned/name valuetrue/value /parameter parameter nameusername/name valueresk/value /parameter parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter nameremoveAbandonedTimeout/name value60/value /parameter parameter namepassword/name valueRESK/value /parameter /ResourceParams /Context Inside my /home/resk/web/ROOT/WEB-INF/ I have web.xml (relevant stuff): web-app version=2.4 xmlns=http://java.sun.com/xml/ns/j2ee; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xsi:schemaLocation=http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd; resource-ref descriptionDB Connection/description res-ref-namejdbc/RESK/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref !-- Used for startup primarly. Kepping things in one place. -- env-entry
RE: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
Just to make sure that theres no problems with my code, I wrote the following page
and tried it. TADA! I get the same goddamn error:
%@ page language=java import=javax.naming.*, javax.sql.*, java.sql.* %
Hello! Running DB test... br
%
DataSource ds = (DataSource)new InitialContext().lookup(java:comp/env/jdbc/RESK);
%
DS looked up!br
%-- IT EXECUTED UP TO HERE. EVRYTHING WAS FINE. THEN I ADDED THE BOTTOM PART AND
GOT THE cannot create ERROR! --%
Now trying to execute a query...br
%
Connection con = ds.getConnection();
PreparedStatement st = con.prepareStatement(SELECT CURTIME());
ResultSet rs = st.executeQuery();
rs.next();
String time = rs.getString(1);
rs.close();
st.close();
con.close();
%
Time is: %=time% !!! br
I just wish tomcat developers actually tested their shit before putting it out.
_
From: Ivan Jouikov [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 11, 2004 9:28 PM
To: 'Tomcat Users List'
Subject: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of
class '' for connect URL 'null'
When they compiled the latest stable Tomcat, did they bother to test it before
putting it out?
I looke through the entire google, and through this entire list, and I found lots of
people having this problem. Yet, I didnt find any solutions (that worked for me
that is).
Basically, heres what I have:
Im running Tomcat 5.0.27 on Java 1.5 beta 2; I am using MySQL 4.1.2
Inside /common/lib/ I have mysql-connector.jar which is 3.0.14 production version.
Inside my server.xml I have (relevant stuff):
Host appBase=/home/resk/web name=resk autoDeploy=true
unpackWARs=true liveDeploy=true
/Host
Inside my /conf/Catalina/resk I have resk.xml:
?xml version='1.0' encoding='utf-8'?
Context debug=5 displayName=RESK docBase=ROOT // BY THE WAY I also tried
/home/resk/web/ROOT
path=/ reloadable=false
Environment name=data.source.name type=java.lang.String
value=java:comp/env/jdbc/RESK/ // BTW I tried without this line
Resource auth=Container name=jdbc/RESK
type=javax.sql.DataSource/
ResourceParams name=jdbc/RESK
parameter
nameurl/name
valuejdbc:mysql://127.0.0.1:3306/resk?autoReconnect=true/value
/parameter
parameter
namemaxIdle/name
value2/value
/parameter
parameter
namemaxActive/name
value10/value
/parameter
parameter
namedriverClassName/name
valuecom.mysql.jdbc.Driver/value
/parameter
parameter
namemaxWait/name
value1/value
/parameter
parameter
nameremoveAbandoned/name
valuetrue/value
/parameter
parameter
nameusername/name
valueresk/value
/parameter
parameter
namefactory/name
valueorg.apache.commons.dbcp.BasicDataSourceFactory/value
/parameter
parameter
nameremoveAbandonedTimeout/name
value60/value
/parameter
parameter
namepassword/name
valueRESK/value
/parameter
/ResourceParams
/Context
Inside my /home/resk/web/ROOT/WEB-INF/ I have web.xml (relevant stuff):
web-app version=2.4
xmlns=http://java.sun.com/xml/ns/j2ee;
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
xsi:schemaLocation=http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd;
resource-ref
descriptionDB Connection/description
res-ref-namejdbc/RESK/res-ref-name
res-typejavax.sql.DataSource/res-type
res-authContainer/res-auth
/resource-ref
!-- Used for startup primarly. Kepping things in one place. --
env-entry
env-entry-namedata.source.name/env-entry-name
env-entry-typejava.lang.String/env-entry-type
env-entry-valuejava:comp/env/jdbc/RESK/env-entry-value
/env-entry
Now, heres how I load the data source (relevant part of the class):
public class Manager
{
DataSource ds;
static Manager instance;
private Manager()
{
try
{
// This is all the web.xml properties
InitialContext context = new InitialContext();
dbDataSource =
(String)context.lookup(java:comp/env/data.source.name);
ds = (DataSource) new
InitialContext().lookup(dbDataSource);
}
catch ( NamingException e )
{
Logger.getLogger(problem).fatal(Unable to load
database data source!,e);
ds = null; // This will throw enough exceptions to
notice the problem
Re: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null', cause: java.sql.SQLException: No suitable driver
Hello Dan, I finally got it to work. The problem is that for directories in webapps a Context is automatically created, even if it is already declared in server.xml. The automatically created Contexts do NOT contain the context specific configuration of server.xml. The outcome is that a) a context is created twice and b) for the second instance the resources are not found. The addition of deployOnStartup=false on all of my Host elements solved my problem. Thanks for your help. Regards, Andreas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null', cause: java.sql.SQLException: No suitable driver
Andreas, Not sure if you got a response yet. Generally, when I have seen the error above, it seemed to be coming from the web app saying that it didn't get the parameters. I am fighting this same error. Strange enough, though, I had it working as you have yours setup. Another thing is that the order that the XML elements are in is critical...i.e. it needs to follow the dtd. This means that resource-ref elements need to be in the right order relative to the other elements(like servlet and servlet-mapping). Anyway, if it was a driver problem like the jar was in the wrong place, the log would have told you it can't find the class. If you have figured out how to get this working or if you have gotten it to work with the gloabal jndi resource context, please let me know. I will check back later and I will help you figure it out as I will be working on it too. Dan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null', cause: java.sql.SQLException: No suitable driver
I get this error using Tomcat 5.0.18 under Debian/Linux. Using the same configuration under Windows XP, there is no problem. Using the same application under Tomcat 4.1.27, there is no problem (either Linux or Windows). As you can see from the included stack trace, I am using Hibernate which is accessing the configured DataSource in a Servlet Filter at application startup. I have searched for this problem on this Mailing List, but got no clue. I am using a Context local DataSource (no Global), and have everything strictly setup as described in the JNDI HowTo. Given the number of people that could not solve the problem, maybe there is a bug in Tomcat5? Regards, Andreas org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null', cause: java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDriver(DriverManager.java:243) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:743) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518) at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59) at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72) at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1119) at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:748) at de.schildbach.integration.HibernatePersistance.init(HibernatePersistance.java:41) at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:272) at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:355) at org.apache.catalina.core.ApplicationFilterConfig.init(ApplicationFilterConfig.java:126) at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:3646) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4275) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:866) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:850) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:638) at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:320) at org.apache.catalina.core.StandardHost.install(StandardHost.java:875) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:727) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:477) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1008) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:394) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1133) at org.apache.catalina.core.StandardHost.start(StandardHost.java:832) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1125) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:518) at org.apache.catalina.core.StandardService.start(StandardService.java:519) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2345) at org.apache.catalina.startup.Catalina.start(Catalina.java:598) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398) My server.xml: Context path= docBase=schildbach reloadable=false Resource name=jdbc/xxx auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/schildbach parameternamefactory/namevalueorg.apache.commons.dbcp.BasicDataSourceFactory/value/parameter parameternamemaxActive/namevalue5/value/parameter parameternamemaxIdle/namevalue0/value/parameter parameternamemaxWait/namevalue1/value/parameter parameternameusername/namevaluexxx/value/parameter parameternamepassword/namevaluexxx/value/parameter parameternamedriverClassName/namevaluecom.mysql.jdbc.Driver/value/parameter parameternameurl/namevaluejdbc:mysql://localhost/xxx?autoReconnect=trueamp;relaxAutoCommit=true/value/parameter /ResourceParams /Context My web.xml: resource-ref res-ref-namejdbc/xxx/res-ref-name
Re: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null', cause: java.sql.SQLException: No suitable driver
Andreas Schildbach wrote: I get this error using Tomcat 5.0.18 under Debian/Linux. Using the same configuration under Windows XP, there is no problem. Using the same application under Tomcat 4.1.27, there is no problem (either Linux or Windows). Resource name=jdbc/xxx auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/schildbach ^^ of course, this is also jdbc/xxx (changed it for the post) Regards, Andreas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null', cause: java.sql.SQLException: No suitable driver
where did u put the jar? thats what got me. it needs to go in common\lib in your tomcat dir Daniel Schulken - Original Message - From: Andreas Schildbach [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 2:51 PM Subject: Re: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null', cause: java.sql.SQLException: No suitable driver Andreas Schildbach wrote: I get this error using Tomcat 5.0.18 under Debian/Linux. Using the same configuration under Windows XP, there is no problem. Using the same application under Tomcat 4.1.27, there is no problem (either Linux or Windows). Resource name=jdbc/xxx auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/schildbach ^^ of course, this is also jdbc/xxx (changed it for the post) Regards, Andreas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.581 / Virus Database: 368 - Release Date: 2/9/2004 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null', cause: java.sql.SQLException: No suitable driver
[EMAIL PROTECTED] wrote: where did u put the jar? thats what got me. it needs to go in common\lib in your tomcat dir Here is the content of common/lib xxx:/opt/tomcat5# ls -la common/lib total 3376 drwxr-xr-x2 tomcat5 nogroup 4096 Feb 11 17:07 . drwxr-xr-x5 tomcat5 nogroup 4096 Jan 15 18:24 .. -rw-r--r--1 tomcat5 nogroup 54665 Feb 11 10:24 activation.jar -rw-r--r--1 tomcat5 nogroup952104 Jan 15 18:24 ant.jar -rw-r--r--1 tomcat5 nogroup165119 Jan 15 18:24 commons-collections.jar -rw-r--r--1 tomcat5 nogroup100776 Jan 15 18:24 commons-dbcp-1.1.jar -rw-r--r--1 tomcat5 nogroup112341 Jan 15 18:24 commons-el.jar -rw-r--r--1 tomcat5 nogroup 39523 Jan 15 18:24 commons-pool-1.1.jar -rw-r--r--1 tomcat5 nogroup342455 Jan 15 18:24 jasper-compiler.jar -rw-r--r--1 tomcat5 nogroup100925 Jan 15 18:24 jasper-runtime.jar -rw-r--r--1 tomcat5 nogroup188231 Jan 15 18:24 jmx-remote-tools.jar -rw-r--r--1 tomcat5 nogroup168008 Jan 15 18:24 jmx-remote.jar -rw-r--r--1 tomcat5 nogroup365858 Jan 15 18:24 jmx.jar -rw-r--r--1 tomcat5 nogroup 48725 Jan 15 18:24 jsp-api.jar -rw-r--r--1 tomcat5 nogroup327603 Feb 11 10:24 mail.jar -rw-r--r--1 tomcat5 nogroup215441 Feb 11 17:07 mysql-connector-java-3.0.10-stable-bin.jar -rw-r--r--1 tomcat5 nogroup 28015 Jan 15 18:24 naming-common.jar -rw-r--r--1 tomcat5 nogroup 14862 Jan 15 18:24 naming-factory.jar -rw-r--r--1 tomcat5 nogroup 2068 Jan 15 18:24 naming-java.jar -rw-r--r--1 tomcat5 nogroup 41669 Jan 15 18:24 naming-resources.jar -rw-r--r--1 tomcat5 nogroup 91627 Jan 15 18:24 servlet-api.jar - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
