Howdy!
I'm using Struts 1.1 in WebSphere and I'm attempting to replace the
GenericDataSource connection pool in my struts-config.xml file with a
BasicDataSource connection pool to hit a mySQL database, but I keep getting
an error. The data-source defintion in my struts-config.xml file is as
follows:
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="autoCommit" value="false"/>
<set-property property="key" value="1" />
<set-property property="description" value="1" />
<set-property property="driverClass"
value="org.gjt.mm.mysql.Driver" />
<set-property property="maxWait" value="10" />
<set-property property="maxCount" value="10" />
<set-property property="minCount" value="2" />
<set-property property="url"
value="jdbc:mysql://localhost:3306/NOL" />
<set-property property="user" value="******" />
<set-property property="password" value="******" />
</data-source>
</data-sources>
I have placed the commons-dbcp.jar and commons-pool.jar in my classpath, as
well as the native mySql driver. There's no problem when using the
GenericDataSource, but as soon as I change to the BasicDataSource, I get the
following error when starting up the server:
[11/14/03 11:30:04:702 CST] 66ad7043 ActionServlet E
org.apache.struts.action.ActionServlet TRAS0014I: The following exception
was logged org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC
driver of class '' for connect URL 'jdbc:mysql://localhost:3306/NOL', cause:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:266)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav
a:743)
at
org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:57
6)
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:258)
at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doInit(StrictServletIn
stance.java:82)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._init(StrictLifecycle
Servlet.java:147)
at
com.ibm.ws.webcontainer.servlet.PreInitializedServletState.init(StrictLifecy
cleServlet.java:270)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.init(StrictLifecycleS
ervlet.java:113)
at
com.ibm.ws.webcontainer.servlet.ServletInstance.init(ServletInstance.java:17
5)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.addServlet(WebAppServlet
Manager.java:761)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadServlet(WebAppServle
tManager.java:257)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadAutoLoadServlets(Web
AppServletManager.java:453)
at
com.ibm.ws.webcontainer.webapp.WebApp.loadServletManager(WebApp.java:1233)
at com.ibm.ws.webcontainer.webapp.WebApp.init(WebApp.java:273)
at
com.ibm.ws.webcontainer.srt.WebGroup.loadWebApp(WebGroup.java:317)
at com.ibm.ws.webcontainer.srt.WebGroup.init(WebGroup.java:194)
at
com.ibm.ws.webcontainer.WebContainer.addWebApplication(WebContainer.java:950
)
at
com.ibm.ws.runtime.component.WebContainerImpl.install(WebContainerImpl.java:
133)
at
com.ibm.ws.runtime.component.WebContainerImpl.start(WebContainerImpl.java:36
0)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.jav
a:401)
at
com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart
(DeployedApplicationImpl.java:743)
at
com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.jav
a:337)
at
com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicati
onImpl.java:531)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(Application
MgrImpl.java:254)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.jav
a:232)
at
com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.jav
a:343)
at
com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:234)
at
com.ibm.ws.runtime.component.ApplicationServerImpl.start(ApplicationServerIm
pl.java:117)
at
com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.jav
a:343)
at
com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:234)
at
com.ibm.ws.runtime.component.ServerImpl.start(ServerImpl.java:182)
at com.ibm.ws.runtime.WsServer.start(WsServer.java:135)
at com.ibm.ws.runtime.WsServer.main(WsServer.java:232)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:94)
at
com.ibm.etools.websphere.tools.runner.api.ServerRunnerV5$1.run(ServerRunnerV
5.java:97)
.
org.apache.commons.dbcp.SQLNestedException:
Cannot create JDBC driver of class '' for connect URL
'jdbc:mysql://localhost:3306/NOL', cause:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:266)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav
a:743)
at
org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:57
6)
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:258)
at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doInit(StrictServletIn
stance.java:82)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._init(StrictLifecycle
Servlet.java:147)
at
com.ibm.ws.webcontainer.servlet.PreInitializedServletState.init(StrictLifecy
cleServlet.java:270)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.init(StrictLifecycleS
ervlet.java:113)
at
com.ibm.ws.webcontainer.servlet.ServletInstance.init(ServletInstance.java:17
5)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.addServlet(WebAppServlet
Manager.java:761)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadServlet(WebAppServle
tManager.java:257)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadAutoLoadServlets(Web
AppServletManager.java:453)
at
com.ibm.ws.webcontainer.webapp.WebApp.loadServletManager(WebApp.java:1233)
at com.ibm.ws.webcontainer.webapp.WebApp.init(WebApp.java:273)
at
com.ibm.ws.webcontainer.srt.WebGroup.loadWebApp(WebGroup.java:317)
at com.ibm.ws.webcontainer.srt.WebGroup.init(WebGroup.java:194)
at
com.ibm.ws.webcontainer.WebContainer.addWebApplication(WebContainer.java:950
)
at
com.ibm.ws.runtime.component.WebContainerImpl.install(WebContainerImpl.java:
133)
at
com.ibm.ws.runtime.component.WebContainerImpl.start(WebContainerImpl.java:36
0)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.jav
a:401)
at
com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart
(DeployedApplicationImpl.java:743)
at
com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.jav
a:337)
at
com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicati
onImpl.java:531)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(Application
MgrImpl.java:254)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.jav
a:232)
at
com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.jav
a:343)
at
com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:234)
at
com.ibm.ws.runtime.component.ApplicationServerImpl.start(ApplicationServerIm
pl.java:117)
at
com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.jav
a:343)
at
com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:234)
at
com.ibm.ws.runtime.component.ServerImpl.start(ServerImpl.java:182)
at com.ibm.ws.runtime.WsServer.start(WsServer.java:135)
at com.ibm.ws.runtime.WsServer.main(WsServer.java:232)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:94)
at
com.ibm.etools.websphere.tools.runner.api.ServerRunnerV5$1.run(ServerRunnerV
5.java:97)
[11/14/03 11:30:04:903 CST] 66ad7043 ServletInstan E SRVE0100E: Did not
realize init() exception thrown by servlet action:
javax.servlet.UnavailableException: Initializing application data source
org.apache.struts.action.DATA_SOURCE
at
org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.j
ava:1091)
at
org.apache.struts.action.ActionServlet.init(ActionServlet.java:472)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doInit(StrictServletIn
stance.java:82)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._init(StrictLifecycle
Servlet.java:147)
at
com.ibm.ws.webcontainer.servlet.PreInitializedServletState.init(StrictLifecy
cleServlet.java:270)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.init(StrictLifecycleS
ervlet.java:113)
at
com.ibm.ws.webcontainer.servlet.ServletInstance.init(ServletInstance.java:17
5)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.addServlet(WebAppServlet
Manager.java:761)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadServlet(WebAppServle
tManager.java:257)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadAutoLoadServlets(Web
AppServletManager.java:453)
at
com.ibm.ws.webcontainer.webapp.WebApp.loadServletManager(WebApp.java:1233)
at com.ibm.ws.webcontainer.webapp.WebApp.init(WebApp.java:273)
at
com.ibm.ws.webcontainer.srt.WebGroup.loadWebApp(WebGroup.java:317)
at com.ibm.ws.webcontainer.srt.WebGroup.init(WebGroup.java:194)
at
com.ibm.ws.webcontainer.WebContainer.addWebApplication(WebContainer.java:950
)
at
com.ibm.ws.runtime.component.WebContainerImpl.install(WebContainerImpl.java:
133)
at
com.ibm.ws.runtime.component.WebContainerImpl.start(WebContainerImpl.java:36
0)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.jav
a:401)
at
com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart
(DeployedApplicationImpl.java:743)
at
com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.jav
a:337)
at
com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicati
onImpl.java:531)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(Application
MgrImpl.java:254)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.jav
a:232)
at
com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.jav
a:343)
at
com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:234)
at
com.ibm.ws.runtime.component.ApplicationServerImpl.start(ApplicationServerIm
pl.java:117)
at
com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.jav
a:343)
at
com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:234)
at
com.ibm.ws.runtime.component.ServerImpl.start(ServerImpl.java:182)
at com.ibm.ws.runtime.WsServer.start(WsServer.java:135)
at com.ibm.ws.runtime.WsServer.main(WsServer.java:232)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:94)
at
com.ibm.etools.websphere.tools.runner.api.ServerRunnerV5$1.run(ServerRunnerV
5.java:97)
[11/14/03 11:30:04:963 CST] 66ad7043 WebGroup E SRVE0020E: [Servlet
Error]-[action]: Failed to load servlet: javax.servlet.UnavailableException:
Initializing application data source org.apache.struts.action.DATA_SOURCE
at
org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.j
ava:1091)
at
org.apache.struts.action.ActionServlet.init(ActionServlet.java:472)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doInit(StrictServletIn
stance.java:82)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._init(StrictLifecycle
Servlet.java:147)
at
com.ibm.ws.webcontainer.servlet.PreInitializedServletState.init(StrictLifecy
cleServlet.java:270)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.init(StrictLifecycleS
ervlet.java:113)
at
com.ibm.ws.webcontainer.servlet.ServletInstance.init(ServletInstance.java:17
5)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.addServlet(WebAppServlet
Manager.java:761)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadServlet(WebAppServle
tManager.java:257)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadAutoLoadServlets(Web
AppServletManager.java:453)
at
com.ibm.ws.webcontainer.webapp.WebApp.loadServletManager(WebApp.java:1233)
at com.ibm.ws.webcontainer.webapp.WebApp.init(WebApp.java:273)
at
com.ibm.ws.webcontainer.srt.WebGroup.loadWebApp(WebGroup.java:317)
at com.ibm.ws.webcontainer.srt.WebGroup.init(WebGroup.java:194)
at
com.ibm.ws.webcontainer.WebContainer.addWebApplication(WebContainer.java:950
)
at
com.ibm.ws.runtime.component.WebContainerImpl.install(WebContainerImpl.java:
133)
at
com.ibm.ws.runtime.component.WebContainerImpl.start(WebContainerImpl.java:36
0)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.jav
a:401)
at
com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart
(DeployedApplicationImpl.java:743)
at
com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.jav
a:337)
at
com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicati
onImpl.java:531)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(Application
MgrImpl.java:254)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.jav
a:232)
at
com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.jav
a:343)
at
com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:234)
at
com.ibm.ws.runtime.component.ApplicationServerImpl.start(ApplicationServerIm
pl.java:117)
at
com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.jav
a:343)
at
com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:234)
at
com.ibm.ws.runtime.component.ServerImpl.start(ServerImpl.java:182)
at com.ibm.ws.runtime.WsServer.start(WsServer.java:135)
at com.ibm.ws.runtime.WsServer.main(WsServer.java:232)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:94)
at
com.ibm.etools.websphere.tools.runner.api.ServerRunnerV5$1.run(ServerRunnerV
5.java:97)
Is there something I am missing? Has anyone else had this experience?
Thanks in advance,
Brent
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
