Hi, I have the following problem. I found this solution:
There is in the server.xml the Resource tag describing your dataSource. Move this element into the Context element in the same xml file (at the bottom). See http://tomcat.apache.org/tomcat-5.5-doc/jndi-resources-howto.html section `JDBC Data Sources' Have a nice time PETR On 1/31/06, Lothar Krenzien <[EMAIL PROTECTED]> wrote: > Hi, > > after switching from Tomcat 5.5.9 to 5.5.15 I get the following error : > > 2006-01-31 16:43:38,130 [INFO ] QueryLogger.*** error. > org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of > class '' for connect URL 'null' > at > org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780) > at > org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) > at > org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:298) > at > org.objectstyle.cayenne.access.DataDomainQueryAction.performQuery(DataDomainQueryAction.java:107) > at > org.objectstyle.cayenne.access.DataDomain.performQueries(DataDomain.java:643) > at > org.objectstyle.cayenne.access.DataContext.performQueries(DataContext.java:1100) > at > org.objectstyle.cayenne.access.Transaction.performQueries(Transaction.java:207) > at > org.objectstyle.cayenne.access.DataContext.performQueries(DataContext.java:1068) > at > org.objectstyle.cayenne.access.DataContextSelectAction.performQuery(DataContextSelectAction.java:173) > at > org.objectstyle.cayenne.access.DataContextSelectAction.performQuery(DataContextSelectAction.java:93) > at > org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.java:1200) > at com.sr2.back.dao.UserDAO.getAvailableRoles(UserDAO.java:168) > .... > > Caused by: java.sql.SQLException: No suitable driver > at java.sql.DriverManager.getDriver(DriverManager.java:243) > at > org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773) > > > I have copied the settings and libraries from the old (5.5.9) tomcat version > to the new (5.5.19) version. And there *is* a JDBC driver in the commons/lib > dir. I'm not sure is it a tomcat or cayenne problem. So I will post it here > and in the cayenne group. But database access seems to work anyway. > Additionally I've just realized that the UserDAO class is called twice and > the second one it works without an error. So where does Tomcat searching for > the database ? Normally it should passed per JNDI. > > > Thanks, Lothar > ______________________________________________________________________ > XXL-Speicher, PC-Virenschutz, Spartarife & mehr: Nur im WEB.DE Club! > Jetzt gratis testen! http://freemail.web.de/home/landingpad/?mc=021130 > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >