U r welcome :) That configuration I just adopt it from the information at struts-documentation.war from the binary distribution of struts. http://localhost:8080/struts-documentation/faqs/database.html I install it on Tomcat 4.1.29 using default port.
best regards -GI. ----- Original Message ----- From: "Pacheco, Brent" <[EMAIL PROTECTED]> To: "'Struts Users Mailing List'" <[EMAIL PROTECTED]> Sent: Wednesday, November 19, 2003 5:38 AM Subject: RE: MySql BasicDataSource Connection > Gede, > > Thanks so much for your help! The problem was that I had the property > listed as "driverClass" instead of "driverClassName", so the BasicDataSource > couldn never locate my driver. When I fixed that, it fired right up. > > Thanks again!! > > Brent > > -----Original Message----- > From: Gede Indrawan [mailto:[EMAIL PROTECTED] > Sent: Monday, November 17, 2003 10:11 PM > To: Struts Users Mailing List > Subject: Re: MySql BasicDataSource Connection > > > I use data-source defintion below and no problem with it > <data-source type="org.apache.commons.dbcp.BasicDataSource"> > <set-property property="driverClassName" > value="org.gjt.mm.mysql.Driver"/> > <set-property property="url" value="jdbc:mysql://localhost/telkomsel"/> > <set-property property="maxCount" value="5"/> > <set-property property="minCount" value="1"/> > <set-property property="username" value="root"/> > <set-property property="password" value="blahblah"/> > </data-source> > > ----- Original Message ----- > From: "Pacheco, Brent" <[EMAIL PROTECTED]> > To: "'Struts Users Mailing List'" <[EMAIL PROTECTED]> > Sent: Saturday, November 15, 2003 12:31 AM > Subject: MySql BasicDataSource Connection > > > > 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] > > > > > > > --------------------------------------------------------------------- > 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]