You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by "Renda, Michael" <mi...@info-resonance.com> on 2003/09/24 01:52:44 UTC
Configuring a JDBC Data Source
I'm trying to configure a JDBC Data Source for a Tomcat 4.1.27
installation. I used the Admin tool which wrote the following entry to
my server.xml file:
<GlobalNamingResources>
<Resource name="jdbc/connection" scope="Shareable"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/connection">
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>password</name>
<value>secret</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver:192.168.0.2:1433</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
</ResourceParams>
</GlobalNamingResources>
I have placed the jar files for the sql/server jdbc driver in the
common/lib directory.
Now Tomcat won't start up. I have the following message in my log:
INFO: Initializing Coyote HTTP/1.1 on port 8080
Exception during startup processing
java.lang.reflect.InvocationTargetException
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)
Caused by: java.lang.NoClassDefFoundError:
org/apache/commons/pool/impl/GenericObjectPool
at
org.apache.commons.dbcp.BasicDataSourceFactory.getObjectInstance(BasicDa
taSourceFactory.java:121)
at
org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFact
ory.java:186)
at
javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:301)
at
org.apache.naming.NamingContext.lookup(NamingContext.java:834)
at
org.apache.naming.NamingContext.lookup(NamingContext.java:194)
at
org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans
(GlobalResourcesLifecycleListener.java:214)
at
org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans
(GlobalResourcesLifecycleListener.java:220)
at
org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans
(GlobalResourcesLifecycleListener.java:181)
at
org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.lifecycleEve
nt(GlobalResourcesLifecycleListener.java:149)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSu
pport.java:166)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:2183)
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)
... 5 more
Can anyone tell me what I'm doing wrong here?
Thanks,
Mike Renda
Re: Configuring a JDBC Data Source
Posted by Adam Hardy <ah...@cyberspaceroad.com>.
sounds like you need the commons-dbcp and commons-pool jar files as well.
Adam
On 09/24/2003 01:52 AM Renda, Michael wrote:
> I'm trying to configure a JDBC Data Source for a Tomcat 4.1.27
> installation. I used the Admin tool which wrote the following entry to
> my server.xml file:
>
> <GlobalNamingResources>
> <Resource name="jdbc/connection" scope="Shareable"
> type="javax.sql.DataSource"/>
> <ResourceParams name="jdbc/connection">
> <parameter>
> <name>maxWait</name>
> <value>5000</value>
> </parameter>
> <parameter>
> <name>maxActive</name>
> <value>4</value>
> </parameter>
> <parameter>
> <name>password</name>
> <value>secret</value>
> </parameter>
> <parameter>
> <name>url</name>
> <value>jdbc:microsoft:sqlserver:192.168.0.2:1433</value>
> </parameter>
> <parameter>
> <name>driverClassName</name>
> <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
> </parameter>
> <parameter>
> <name>maxIdle</name>
> <value>2</value>
> </parameter>
> <parameter>
> <name>username</name>
> <value>sa</value>
> </parameter>
> </ResourceParams>
> </GlobalNamingResources>
>
> I have placed the jar files for the sql/server jdbc driver in the
> common/lib directory.
>
> Now Tomcat won't start up. I have the following message in my log:
>
> INFO: Initializing Coyote HTTP/1.1 on port 8080
> Exception during startup processing
> java.lang.reflect.InvocationTargetException
> 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)
> Caused by: java.lang.NoClassDefFoundError:
> org/apache/commons/pool/impl/GenericObjectPool
> at
> org.apache.commons.dbcp.BasicDataSourceFactory.getObjectInstance(BasicDa
> taSourceFactory.java:121)
> at
> org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFact
> ory.java:186)
> at
> javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:301)
> at
> org.apache.naming.NamingContext.lookup(NamingContext.java:834)
> at
> org.apache.naming.NamingContext.lookup(NamingContext.java:194)
> at
> org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans
> (GlobalResourcesLifecycleListener.java:214)
> at
> org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans
> (GlobalResourcesLifecycleListener.java:220)
> at
> org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans
> (GlobalResourcesLifecycleListener.java:181)
> at
> org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.lifecycleEve
> nt(GlobalResourcesLifecycleListener.java:149)
> at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSu
> pport.java:166)
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:2183)
> 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)
> ... 5 more
>
> Can anyone tell me what I'm doing wrong here?
>
> Thanks,
>
> Mike Renda
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
--
struts 1.1 + tomcat 4.1.27 + java 1.4.2
Linux 2.4.20 RH9
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: Configuring a JDBC Data Source
Posted by Adam Hardy <ah...@cyberspaceroad.com>.
sounds like you need the commons-dbcp and commons-pool jar files as well.
Adam
On 09/24/2003 01:52 AM Renda, Michael wrote:
> I'm trying to configure a JDBC Data Source for a Tomcat 4.1.27
> installation. I used the Admin tool which wrote the following entry to
> my server.xml file:
>
> <GlobalNamingResources>
> <Resource name="jdbc/connection" scope="Shareable"
> type="javax.sql.DataSource"/>
> <ResourceParams name="jdbc/connection">
> <parameter>
> <name>maxWait</name>
> <value>5000</value>
> </parameter>
> <parameter>
> <name>maxActive</name>
> <value>4</value>
> </parameter>
> <parameter>
> <name>password</name>
> <value>secret</value>
> </parameter>
> <parameter>
> <name>url</name>
> <value>jdbc:microsoft:sqlserver:192.168.0.2:1433</value>
> </parameter>
> <parameter>
> <name>driverClassName</name>
> <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
> </parameter>
> <parameter>
> <name>maxIdle</name>
> <value>2</value>
> </parameter>
> <parameter>
> <name>username</name>
> <value>sa</value>
> </parameter>
> </ResourceParams>
> </GlobalNamingResources>
>
> I have placed the jar files for the sql/server jdbc driver in the
> common/lib directory.
>
> Now Tomcat won't start up. I have the following message in my log:
>
> INFO: Initializing Coyote HTTP/1.1 on port 8080
> Exception during startup processing
> java.lang.reflect.InvocationTargetException
> 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)
> Caused by: java.lang.NoClassDefFoundError:
> org/apache/commons/pool/impl/GenericObjectPool
> at
> org.apache.commons.dbcp.BasicDataSourceFactory.getObjectInstance(BasicDa
> taSourceFactory.java:121)
> at
> org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFact
> ory.java:186)
> at
> javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:301)
> at
> org.apache.naming.NamingContext.lookup(NamingContext.java:834)
> at
> org.apache.naming.NamingContext.lookup(NamingContext.java:194)
> at
> org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans
> (GlobalResourcesLifecycleListener.java:214)
> at
> org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans
> (GlobalResourcesLifecycleListener.java:220)
> at
> org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans
> (GlobalResourcesLifecycleListener.java:181)
> at
> org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.lifecycleEve
> nt(GlobalResourcesLifecycleListener.java:149)
> at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSu
> pport.java:166)
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:2183)
> 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)
> ... 5 more
>
> Can anyone tell me what I'm doing wrong here?
>
> Thanks,
>
> Mike Renda
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
--
struts 1.1 + tomcat 4.1.27 + java 1.4.2
Linux 2.4.20 RH9