You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Pl...@netscape.net on 2004/01/25 20:32:17 UTC

dbcp and mysql

I have:

Struts 1.1
Tomcat 4.1
mysql-connector-java-3.0.10-stable
last version of commons-dbcp

and

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.1//EN" "http://jakarta.apache.org/struts/dtds/struts-config_1_1.dtd">
<struts-config>
  <data-sources>
    <data-source key="dataSource" type="org.apache.commons.dbcp.BasicDataSource">
      <set-property property="driverClassName" value="com.mysql.jdbc.Driver" />
      <set-property property="url" value="jdbc:mysql://localhost/catalog" />
      <set-property property="username" value="datal" />
      <set-property property="password" value="datal" />
    </data-source>
  </data-sources>

but when it run give:

javax.servlet.ServletException: Servlet.init() for servlet action threw exception

    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:963)

    at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823)

    at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3421)

    at org.apache.catalina.core.StandardContext.start(StandardContext.java:3609)

    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:821)

    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.addChild(StandardHostDeployer.java:700)

    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.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:252)

    at org.apache.commons.digester.SetNextRule.end(SetNextRule.java:256)

    at org.apache.commons.digester.Rule.end(Rule.java:276)

    at org.apache.commons.digester.Digester.endElement(Digester.java:1058)

    at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1683)

    at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:634)

    at org.apache.crimson.parser.Parser2.parse(Parser2.java:333)

    at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:448)

    at org.apache.commons.digester.Digester.parse(Digester.java:1567)

    at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:385)

    at org.apache.catalina.core.StandardHost.install(StandardHost.java:803)

    at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:442)

    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:399)

    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(LifecycleSupport.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)

Please, help me!
Thanks
Andrea


__________________________________________________________________
New! Unlimited Netscape Internet Service.
Only $9.95 a month -- Sign up today at http://isp.netscape.com/register
Act now to get a personalized email address!

Netscape. Just the Net You Need.

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

RE: dbcp and mysql

Posted by Matthias Wessendorf <ma...@matthias-wessendorf.de>.
hi

do you have also
pool.jar in /WEB-INF/lib

http://jakarta.apache.org/commons/pool/

it was time ago problem in my case.

greetings, matthias

-----Original Message-----
From: PlrAndrea@netscape.net [mailto:PlrAndrea@netscape.net] 
Sent: Sunday, January 25, 2004 8:32 PM
To: struts-user@jakarta.apache.org
Subject: dbcp and mysql


I have:

Struts 1.1
Tomcat 4.1
mysql-connector-java-3.0.10-stable
last version of commons-dbcp

and

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD
Struts Configuration 1.1//EN"
"http://jakarta.apache.org/struts/dtds/struts-config_1_1.dtd">
<struts-config>
  <data-sources>
    <data-source key="dataSource"
type="org.apache.commons.dbcp.BasicDataSource">
      <set-property property="driverClassName"
value="com.mysql.jdbc.Driver" />
      <set-property property="url"
value="jdbc:mysql://localhost/catalog" />
      <set-property property="username" value="datal" />
      <set-property property="password" value="datal" />
    </data-source>
  </data-sources>

but when it run give:

javax.servlet.ServletException: Servlet.init() for servlet action threw
exception

    at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.jav
a:963)

    at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823)

    at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.j
ava:3421)

    at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3609
)

    at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.ja
va:821)

    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.addChild(StandardHostDeplo
yer.java:700)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)

    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)

    at java.lang.reflect.Method.invoke(Method.java:324)

    at
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:2
52)

    at org.apache.commons.digester.SetNextRule.end(SetNextRule.java:256)

    at org.apache.commons.digester.Rule.end(Rule.java:276)

    at
org.apache.commons.digester.Digester.endElement(Digester.java:1058)

    at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1683)

    at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:634)

    at org.apache.crimson.parser.Parser2.parse(Parser2.java:333)

    at
org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:448)

    at org.apache.commons.digester.Digester.parse(Digester.java:1567)

    at
org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeploy
er.java:385)

    at
org.apache.catalina.core.StandardHost.install(StandardHost.java:803)

    at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java
:442)

    at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:399)

    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:718)

    at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:35
8)

    at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSu
pport.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.jav
a:39)

    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)

    at java.lang.reflect.Method.invoke(Method.java:324)

    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)

Please, help me!
Thanks
Andrea


__________________________________________________________________
New! Unlimited Netscape Internet Service.
Only $9.95 a month -- Sign up today at http://isp.netscape.com/register
Act now to get a personalized email address!

Netscape. Just the Net You Need.

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


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