You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by "C.F. Scheidecker Antunes" <na...@antunes.eti.br> on 2005/08/18 10:44:14 UTC

Problems declaring DataSources

Hello All,

I have the following datasource declared. The password, URL and user 
name as well as Database name (on the URL) are corrected and I have them 
tested.
Here it is:

<data-sources>
	<data-source key="ds1" type="org.apache.commons.dbcp.BasicDataSource">
 	  <set-property property="driverClass" value="com.mysql.jdbc.Driver" />
 	  <set-property property="url" value="jdbc:mysql://localhost:3306/Test" />
 	  <set-property property="user" value="antunes" />
      <set-property property="password" value="antunes" />
      <set-property property="description" value="Test_db" />
      <set-property property="readOnly" value="false" />
      <set-property property="autoCommit" value="false" />
      <set-property property="loginTimeout" value="5000" />
      <set-property property="maxWait" value="5000" />
      <set-property property="maxActive" value="500" />
    </data-source>
 </data-sources>


However, when I put it in my struts-config.xml I have the erros bellow.

What am I missing here? Am I missing any properties? Shall I use any 
other type other than org.apache.commons.dbcp.BasicDataSource for MySQL?

Thanks,

C.F.

Errors:

SEVERE: Unable to initialize Struts ActionServlet due to an unexpected exception or error thrown, so marking the servlet as unavailable.  Most likely, this is due to an incorrect or missing library dependency.
java.lang.NoClassDefFoundError: org/apache/commons/pool/impl/GenericObjectPool
	at java.lang.Class.getDeclaredConstructors0(Native Method)
	at java.lang.Class.privateGetDeclaredConstructors(Class.java:2328)
	at java.lang.Class.getConstructor0(Class.java:2640)
	at java.lang.Class.newInstance0(Class.java:321)
	at java.lang.Class.newInstance(Class.java:303)
	at org.apache.struts.util.RequestUtils.applicationInstance(RequestUtils.java:143)
	at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:805)
	at org.apache.struts.action.ActionServlet.init(ActionServlet.java:335)
	at javax.servlet.GenericServlet.init(GenericServlet.java:211)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:894)
	at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:857)
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:475)
	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102)
	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
	at org.apache.catalina.core.StandardService.start(StandardService.java:450)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
	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:585)
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
Aug 18, 2005 2:33:21 AM org.apache.catalina.core.ApplicationContext log
INFO: Marking servlet action as unavailable
Aug 18, 2005 2:33:21 AM org.apache.catalina.core.StandardContext loadOnStartup
SEVERE: Servlet /upload2 threw load() exception
javax.servlet.UnavailableException: org/apache/commons/pool/impl/GenericObjectPool
	at org.apache.struts.action.ActionServlet.init(ActionServlet.java:368)
	at javax.servlet.GenericServlet.init(GenericServlet.java:211)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:894)
	at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:857)
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:475)
	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102)
	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
	at org.apache.catalina.core.StandardService.start(StandardService.java:450)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
	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:585)
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
Aug 18, 2005 2:33:22 AM org.apache.catalina.core.ApplicationContext log



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org

Re: Problems declaring DataSources

Posted by "C.F. Scheidecker Antunes" <na...@antunes.eti.br>.
Hi all,

Problem solved. So I will share the solution in case someone has the 
same problem.

Just use the following class:
com.mysql.jdbc.jdbc2.optional.MysqlDataSource  as the DataSource class.
so, the correct code is:

<data-sources>
    <data-source key="ds1" 
type="com.mysql.jdbc.jdbc2.optional.MysqlDataSource">
      <set-property property="driverClass" value="com.mysql.jdbc.Driver" />
      <set-property property="url" 
value="jdbc:mysql://localhost:3306/Test" />
      <set-property property="user" value="antunes" />
     <set-property property="password" value="antunes" />
     <set-property property="description" value="Test_db" />
     <set-property property="readOnly" value="false" />
     <set-property property="autoCommit" value="false" />
     <set-property property="loginTimeout" value="5000" />
     <set-property property="maxWait" value="5000" />
     <set-property property="maxActive" value="500" />
   </data-source>
</data-sources>

Thanks.

C.F. Scheidecker Antunes wrote:

> Hello All,
>
> I have the following datasource declared. The password, URL and user 
> name as well as Database name (on the URL) are corrected and I have 
> them tested.
> Here it is:
>
> <data-sources>
>     <data-source key="ds1" 
> type="org.apache.commons.dbcp.BasicDataSource">
>       <set-property property="driverClass" 
> value="com.mysql.jdbc.Driver" />
>       <set-property property="url" 
> value="jdbc:mysql://localhost:3306/Test" />
>       <set-property property="user" value="antunes" />
>      <set-property property="password" value="antunes" />
>      <set-property property="description" value="Test_db" />
>      <set-property property="readOnly" value="false" />
>      <set-property property="autoCommit" value="false" />
>      <set-property property="loginTimeout" value="5000" />
>      <set-property property="maxWait" value="5000" />
>      <set-property property="maxActive" value="500" />
>    </data-source>
> </data-sources>
>
>
> However, when I put it in my struts-config.xml I have the erros bellow.
>
> What am I missing here? Am I missing any properties? Shall I use any 
> other type other than org.apache.commons.dbcp.BasicDataSource for MySQL?
>
> Thanks,
>
> C.F.
>
> Errors:
>
> SEVERE: Unable to initialize Struts ActionServlet due to an unexpected 
> exception or error thrown, so marking the servlet as unavailable.  
> Most likely, this is due to an incorrect or missing library dependency.
> java.lang.NoClassDefFoundError: 
> org/apache/commons/pool/impl/GenericObjectPool
>     at java.lang.Class.getDeclaredConstructors0(Native Method)
>     at java.lang.Class.privateGetDeclaredConstructors(Class.java:2328)
>     at java.lang.Class.getConstructor0(Class.java:2640)
>     at java.lang.Class.newInstance0(Class.java:321)
>     at java.lang.Class.newInstance(Class.java:303)
>     at 
> org.apache.struts.util.RequestUtils.applicationInstance(RequestUtils.java:143) 
>
>     at 
> org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:805) 
>
>     at 
> org.apache.struts.action.ActionServlet.init(ActionServlet.java:335)
>     at javax.servlet.GenericServlet.init(GenericServlet.java:211)
>     at 
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091) 
>
>     at 
> org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
>     at 
> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857) 
>
>     at 
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
>     at 
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759) 
>
>     at 
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
>     at 
> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
>     at 
> org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:894) 
>
>     at 
> org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:857) 
>
>     at 
> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:475)
>     at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102)
>     at 
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) 
>
>     at 
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) 
>
>     at 
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
>     at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
>     at 
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
>     at 
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
>     at 
> org.apache.catalina.core.StandardService.start(StandardService.java:450)
>     at 
> org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
>     at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
>     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:585)
>     at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
>     at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
> Aug 18, 2005 2:33:21 AM org.apache.catalina.core.ApplicationContext log
> INFO: Marking servlet action as unavailable
> Aug 18, 2005 2:33:21 AM org.apache.catalina.core.StandardContext 
> loadOnStartup
> SEVERE: Servlet /upload2 threw load() exception
> javax.servlet.UnavailableException: 
> org/apache/commons/pool/impl/GenericObjectPool
>     at 
> org.apache.struts.action.ActionServlet.init(ActionServlet.java:368)
>     at javax.servlet.GenericServlet.init(GenericServlet.java:211)
>     at 
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091) 
>
>     at 
> org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
>     at 
> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857) 
>
>     at 
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
>     at 
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759) 
>
>     at 
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
>     at 
> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
>     at 
> org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:894) 
>
>     at 
> org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:857) 
>
>     at 
> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:475)
>     at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102)
>     at 
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) 
>
>     at 
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) 
>
>     at 
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
>     at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
>     at 
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
>     at 
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
>     at 
> org.apache.catalina.core.StandardService.start(StandardService.java:450)
>     at 
> org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
>     at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
>     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:585)
>     at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
>     at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
> Aug 18, 2005 2:33:22 AM org.apache.catalina.core.ApplicationContext log
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org