Hi Steve! X:s and y:s are to hide a few details of our setup, perhaps a little paranoid :-)
I can connect to the database with user and password at that url. My driver is in common/lib, I also check the other libs. Regards Roland Carlsson Den 04-10-26 12.27, skrev "Steve Kirk" <[EMAIL PROTECTED]>: > This type of bug crops up a lot on this list. The best answer seems to be > to make sure you follow the instructions on this page _exactly_: > http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-how > to.html > > I assume that where you have x/y in your config file this is to hide values > before posting here rather than your actual config - worth checking!! > > It might help if you post a snippet of your Java source > > Can you connect to the database called "login" on the IP and port in your > <url><value> tag with the username "xxx" and password "yyy" using the mysql > command line client? If not, then you probably have a mysql account or > security issue that's blocking access to the database. It might be that you > have only created an account [EMAIL PROTECTED], which will deny access from any > other IP apart from the 192.168.x.x address of the server. > > Where is your driver file? It should be in the common\lib folder e.g. on my > machine it is > > C:\jakarta-tomcat-5.0.27\common\lib\mysql-connector-java-3.0.14-production-b > in.jar > > PS even if quotes are allowed in <ResourceLink><description> (which I'm not > sure about), it's the sort of thing I'd avoid, especially when trying to > debug a problem like this. It's an extra unknown you'd be better off > without. > >> -----Original Message----- >> From: Roland Carlsson [mailto:[EMAIL PROTECTED] >> Sent: Tuesday 26 October 2004 10:13 >> To: TomcatUsers >> Subject: JNDI DataSource GlobalResources problem >> >> >> Hi! >> >> I'm trying to use the JNDI DataSource to administer my >> database-connections. >> But it seems like the DataSource doesn't get the properties I >> set. I get the >> following error: >> >> org.apache.commons.dbcp.SQLNestedException: Cannot create >> JDBC driver of >> class '' for connect URL 'null' (Full stacktrace below) >> >> I have checked that the driver is there and I have re-read >> the configuration >> and documentation many times now but doesn't find anything >> wrong. What am I >> missing? >> >> Thanks in advance >> Roland Carlsson >> >> >> ---- from GlobalNamingResources element in server.xml >> -------------------- >> >> <Resource name="jdbc/loginDB" >> auth="Container" >> type="javax.sql.DataSource"/> >> >> <ResourceParams name="login/myDB"> >> <parameter> >> <name>factory</name> >> <value>org.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> >> <name>maxActive</name> >> <value>100</value> >> </parameter> >> >> <!-- Maximum number of idle dB connections to retain in pool. >> Set to -1 for no limit. See also the DBCP >> documentation on this >> and the minEvictableIdleTimeMillis configuration parameter. >> --> >> <parameter> >> <name>maxIdle</name> >> <value>2</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> >> <name>maxWait</name> >> <value>10000</value> >> </parameter> >> >> <!-- MySQL dB username and password for dB connections --> >> <parameter> >> <name>username</name> >> <value>xxx</value> >> </parameter> >> <parameter> >> <name>password</name> >> <value>yyy</value> >> </parameter> >> >> <!-- Class name for the official MySQL Connector/J driver --> >> <parameter> >> <name>driverClassName</name> >> <value>com.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> >> <name>url</name> >> >> <value>jdbc:mysql://192.168.x.x:yyyy/login?autoReconnect=true</value> >> </parameter> >> </ResourceParams> >> >> >> --------- from web-app element in web.xml -------------------- >> >> >> <resource-ref> >> <description>Mysql database "login"</description> >> <res-ref-name>jdbc/loginDB</res-ref-name> >> <res-type>javax.sql.DataSource</res-type> >> <res-auth>Container</res-auth> >> </resource-ref> >> >> ------ Full stacktrace of the exception ------------- >> org.apache.commons.dbcp.SQLNestedException: Cannot create >> JDBC driver of >> class '' for connect URL 'null' >> at >> org.apache.commons.dbcp.BasicDataSource.createDataSource(Basic >> DataSource.jav >> a:780) >> at >> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDat >> aSource.java:5 >> 40) >> at org.apache.jsp.index_jsp._jspService(index_jsp.java:62) >> at >> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) >> at >> javax.servlet.http.HttpServlet.service(HttpServlet.java:802) >> at >> org.apache.jasper.servlet.JspServletWrapper.service(JspServlet >> Wrapper.java:3 >> 24) >> at >> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet >> .java:292) >> at >> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) >> at >> javax.servlet.http.HttpServlet.service(HttpServlet.java:802) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilt >> er(Application >> FilterChain.java:237) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli >> cationFilterCh >> ain.java:157) >> at >> org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter >> (MonitorFilter >> .java:305) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilt >> er(Application >> FilterChain.java:186) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli >> cationFilterCh >> ain.java:157) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardW >> rapperValve.ja >> va:214) >> at >> org.apache.catalina.core.StandardValveContext.invokeNext(Stand >> ardValveContex >> t.java:104) >> at >> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel >> ine.java:520) >> at >> org.apache.catalina.core.StandardContextValve.invokeInternal(S >> tandardContext >> Valve.java:198) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardC >> ontextValve.ja >> va:152) >> at >> org.apache.catalina.core.StandardValveContext.invokeNext(Stand >> ardValveContex >> t.java:104) >> at >> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel >> ine.java:520) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHost >> Valve.java:137 >> ) >> at >> org.apache.catalina.core.StandardValveContext.invokeNext(Stand >> ardValveContex >> t.java:104) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport >> Valve.java:118 >> ) >> at >> org.apache.catalina.core.StandardValveContext.invokeNext(Stand >> ardValveContex >> t.java:102) >> at >> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel >> ine.java:520) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEn >> gineValve.java >> :109) >> at >> org.apache.catalina.core.StandardValveContext.invokeNext(Stand >> ardValveContex >> t.java:104) >> at >> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel >> ine.java:520) >> at >> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) >> at >> org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter. >> java:160) >> at >> org.apache.coyote.http11.Http11Processor.process(Http11Process >> or.java:799) >> at >> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandle >> r.processConne >> ction(Http11Protocol.java:705) >> at >> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoi >> nt.java:577) >> at >> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run( >> ThreadPool.jav >> a:683) >> at java.lang.Thread.run(Thread.java:552) >> Caused by: java.sql.SQLException: No suitable driver >> at java.sql.DriverManager.getDriver(DriverManager.java:243) >> at >> org.apache.commons.dbcp.BasicDataSource.createDataSource(Basic >> DataSource.jav >> a:773) >> ... 35 more >> >> >> >> --------------------------------------------------------------------- >> 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]
