do you have your jdbc driver in your classpath?
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 07, 2003 1:59 PM
To: [EMAIL PROTECTED]
Subject: Newbie Q: Cannot load JDBC driver class using Datasource Connection
Am I missing something here? Tomcat keeps on giving me the following
exception about my JDBC connection driver not being loaded when I try to
establish a
datasource connection to a mysql database in struts :
Initializing application data source org.apache.struts.action.DATA_SOURCE
java.sql.SQLException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav
a:529)
at
org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:38
1)
at
org.apache.struts.action.ActionServlet.initApplicationDataSources(ActionServ
let.java:942)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:457)
at javax.servlet.GenericServlet.init(GenericServlet.java:256)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:93
4)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:821)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:
3420)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3608)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:738)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347)
at
org.apache.catalina.core.StandardService.start(StandardService.java:497)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:2189)
at org.apache.catalina.startup.Catalina.start(Catalina.java:512)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
at org.apache.catalina.startup.Catalina.process(Catalina.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcc
essorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)
My struts-config.xml looks like this :
<struts-config>
<!--- other parameters -->
<!--- other parameters -->
<!-- ========== Data Source Configuration
===============================
-->
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="autoCommit"
value="false"/>
<set-property property="description"
value="MyProject Database Datasource Connection"/>
<set-property property="driverClassName"
value="com.mysql.jdbc.Driver"/>
<set-property property="maxCount"
value="4"/>
<set-property property="minCount"
value="2"/>
<set-property property="password"
value="myPassword"/>
<set-property property="url"
value="jdbc:mysql://localhost:3306/Mydatabase"/>
<set-property property="user"
value="root"/>
</data-source>
</data-sources>
<!--- other parameters -->
<!--- other parameters -->
</struts-config>
Info: This driver , com.mysql.jdbc.Driver, does establish connection to this
same database with no exception when I use it in a normal java class.
Can someone tell me or atleast point me to where I can find further
help/information. I could not find anything at
http://jakarta.apache.org/struts/faqs/database.html and also in this list's
archives.
Thanks,
robert
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
