Try "driverClassName" as the property.
-----Original Message-----
From: Fumo, Vince [mailto:[EMAIL PROTECTED]
Sent: Friday, August 22, 2003 3:32 PM
To: 'Struts Users Mailing List'
Subject: RE: <data source> problems
Thank you David, I gave that a shot and I made some headway, however, now at
Tomcat startup (and obvioulsy Struts startup) I'm getting an exception that
basicly states "Cannot load JDBC driver class 'null'" (full startup is
below). I'm sure I have my struts-config correct and I have the JDBC driver
in the WEB-INF/lib directory and also the tomcat common/lib directory. Any
ideas on where I'm messed up this time?
<relevant struts-config>
<!-- ==================================== Data Source Configuration -->
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="description" value="MySQL
datasource" />
<set-property property="driverClass"
value="com.mysql.jdbc.Driver" />
<set-property property="url"
value="jdbc:mysql://localhost/ed_test" />
<set-property property="username" value="ed-web" />
<set-property property="password" value="dashboard" />
<set-property property="maxActive" value="10"
/>
<set-property property="maxCount" value="10" />
<set-property property="minCount" value="2" />
<set-property property="maxWait" value="5000"
/>
<set-property property="defaultAutoCommit" value="false" />
<set-property property="defaultReadOnly" value="false" />
<set-property property="validationQuery" value="SELECT
COUNT(*) FROM family" />
</data-source>
</data-sources>
<the tomcat startup log>
Starting service Tomcat-Standalone
Apache Tomcat/4.1.24
Aug 22, 2003 3:28:47 PM org.apache.struts.util.PropertyMessageResources
<init>
INFO: Initializing, config='org.apache.struts.util.LocalStrings',
returnNull=true
Aug 22, 2003 3:28:47 PM org.apache.struts.util.PropertyMessageResources
<init>
INFO: Initializing, config='org.apache.struts.action.ActionResources',
returnNull=true
Aug 22, 2003 3:28:47 PM org.apache.struts.util.PropertyMessageResources
<init>
INFO: Initializing, config='resources.application', returnNull=true
Aug 22, 2003 3:28:47 PM org.apache.struts.action.ActionServlet
initModuleDataSources
SEVERE: Initializing application data source
org.apache.struts.action.DATA_SOURCE
java.sql.SQLException: Cannot load JDBC driver class 'null'
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.initModuleDataSources(ActionServlet.j
ava:1087)
at
org.apache.struts.action.ActionServlet.init(ActionServlet.java:472)
at javax.servlet.GenericServlet.init(GenericServlet.java:256)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:93
5)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823)
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.addChildInternal(ContainerBase.java:8
21)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:579)
at
org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.j
ava:307)
at
org.apache.catalina.core.StandardHost.install(StandardHost.java:772)
at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:559
)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:401)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:718)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:358)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:166)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196)
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:2190)
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(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)
-----Original Message-----
From: David Graham [mailto:[EMAIL PROTECTED]
Sent: Friday, August 22, 2003 2:17 PM
To: Struts Users Mailing List
Subject: RE: <data source> problems
--- "Fumo, Vince" <[EMAIL PROTECTED]> wrote:
> Yes..I know that I can include the legacy jar but I don't want to. I'd
> prefer to not use depreciated librarys in my app. The thing I'm confused
> about is that I'm not sure how I'm even using GenericDataSource at all.
> I
> thought that by explicitly using the BasicDataSource I would be avoiding
> this problem.
Having the jar in your lib directory doesn't mean you're using deprecated
functionality. Indeed, you're not even using GenericDataSource. You must
install that jar because Struts uses it internally. It has been removed
for 1.2.
David
>
> -----Original Message-----
> From: David Graham [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 22, 2003 1:08 PM
> To: Struts Users Mailing List
> Subject: Re: <data source> problems
>
>
> --- "Fumo, Vince" <[EMAIL PROTECTED]> wrote:
> > Hi all. I'm sure this has been asked before but I can't seem to find
> it
> > in
> > the archives.
> >
> > I'm building a simple web app and I want to use a connection pool.
> I've
> > decided to use the commons dbcp BasicDataSource class
> > (org.apache.commons.dbcp.BasicDataSource). Here is the struts-config
> I'm
> > using (based on the one from the struts faq) :
> >
> > <data-sources>
> > <data-source type="org.apache.commons.dbcp.BasicDataSource">
> > <set-property property="autoCommit" value="true" />
> > <set-property property="description" value="MySQL datasource" />
> > <set-property property="driverClass" value="com.mysql.jdbc.Driver"
> > />
> > <set-property property="maxCount" value="10" />
> > <set-property property="minCount" value="2" />
> > <set-property property="username" value="username" />
> > <set-property property="password" value="password" />
> > <set-property property="url"
> > value="jdbc:mysql://localhost:3306/databasename" />
> > </data-source>
> > </data-sources>
> >
> > I have placed the following jars in my \WEB-INF\lib folder :
> >
> > commons-collections.jar
> > commons-dbcp.jar
> > commons-pool.jar
> > commons-logging.jar
> > mysql-connector-java-3.0.8-stable-bin.jar
> > struts.jar
>
> GenericDataSource lives in struts-legacy.jar. Add that to your lib
> directory and it should find it.
>
> David
>
> >
> > From what I've read and seen, this should work fine. However, no
> matter
> > what
> > I try, I get the following exception:
> >
> > java.lang.NoClassDefFoundError:
> > org/apache/struts/legacy/GenericDataSource
> >
> > I'm aware that GenericDataSource is depreciated. However, I'm not
> trying
> > to
> > use it. My only guess is that somehow struts/tomcat isn't finding the
> > commons.dbcp.BasicDataSource and it trying to default to the
> > GenericDataSource instead.
> >
> > Does anyone have any idea how I can get this to work? I'm willing to
> try
> > anything but my main goal is to have a pooled connection to my mySQL
> > database.
> >
> > Thanks in advance.
> >
> > v
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
>
> ---------------------------------------------------------------------
> 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 you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
---------------------------------------------------------------------
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]
