Hi.
Am 08.07.2010 23:36, schrieb Caldarale, Charles R:
From: Christian Bruckhoff [mailto:christian.bruckh...@gmx.de]
Subject: Re: Connecting Tomcat to a database
Sorry was in a haste, forgot much more than this. :-/
- Tomcat 7.0.0
- Java 1.6 Update 20
- Windows XP SP3
- Wanted to use DB for Apache ODE 2.0 Beta
That's how it was shown here: http://ode.apache.org/war-deployment.html
Most unfortunate that they're suggesting very, very out of date practices. Put the
MySQL JDBC driver in Tomcat's lib directory, not common/lib (that was changed quite
some time ago). Place the following<Context> element in
webapps/ode/META-INF/context.xml:
<Context reloadable="true" crossContext="true">
<Resource name="jdbc/ODEDB" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="root" password="" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/ode?autoReconnect=true"/>
</Context>
I did and modified it to my database:
----------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<Context reloadable="true" crossContext="true">
<Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="test_dab" password="moep"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://mysqlhost.uni-koblenz.de:3306/TestDB?autoReconnect=true"/>
</Context>
----------------------------------------
I also edited ode-axis2.properties to
----------------------------------------
ode-axis2.db.mode=EXTERNAL
ode-axis2.db.ext.dataSource=java:comp/env/jdbc/TestDB
----------------------------------------
after this, I get the this error log:
----------------------------------------
09.07.2010 08:59:04 org.apache.catalina.core.AprLifecycleListener init
INFO: Loaded APR based Apache Tomcat Native library 1.1.20.
09.07.2010 08:59:04 org.apache.catalina.core.AprLifecycleListener init
INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters
[false], ra
ndom [true].
09.07.2010 08:59:05 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1235 ms
09.07.2010 08:59:05 org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
09.07.2010 08:59:05 org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.0
09.07.2010 08:59:05 org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive ode.war
DEBUG - GeronimoLog.debug(66) | Loading properties
DEBUG - GeronimoLog.debug(66) | Initializing transaction manager
DEBUG - GeronimoLog.debug(66) | Initializing transaction manager using
org.apach
e.ode.il.EmbeddedGeronimoFactory
DEBUG - GeronimoLog.debug(66) | Creating data source.
ERROR - GeronimoLog.error(108) | Failed to resolved external DataSource
at "java
:comp/env/jdbc/TestDB".
javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
at org.apache.naming.NamingContext.lookup(NamingContext.java:774)
at org.apache.naming.NamingContext.lookup(NamingContext.java:144)
at org.apache.naming.NamingContext.lookup(NamingContext.java:785)
at org.apache.naming.NamingContext.lookup(NamingContext.java:144)
at org.apache.naming.NamingContext.lookup(NamingContext.java:785)
at org.apache.naming.NamingContext.lookup(NamingContext.java:157)
at
org.apache.naming.SelectorContext.lookup(SelectorContext.java:156)
at javax.naming.InitialContext.lookup(InitialContext.java:392)
at
org.apache.ode.il.dbutil.Database.lookupInJndi(Database.java:244)
at
org.apache.ode.il.dbutil.Database.initExternalDb(Database.java:159)
at
org.apache.ode.il.dbutil.Database.initDataSource(Database.java:144)
at org.apache.ode.il.dbutil.Database.start(Database.java:99)
at
org.apache.ode.axis2.ODEServer.initDataSource(ODEServer.java:218)
at org.apache.ode.axis2.ODEServer.init(ODEServer.java:157)
at org.apache.ode.axis2.ODEServer.init(ODEServer.java:116)
at
org.apache.ode.axis2.hooks.ODEAxisServlet.init(ODEAxisServlet.java:53
)
at
org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.
java:1164)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.
java:1118)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:10
05)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex
t.java:4529)
at
org.apache.catalina.core.StandardContext.startInternal(StandardContex
t.java:4800)
at
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:138)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:785)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:76
3)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:558)
at
org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:987)
at
org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778
)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:540
)
at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1390)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:355)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:119)
at
org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBa
se.java:89)
at
org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:31
2)
at
org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:29
2)
at
org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.ja
va:998)
at
org.apache.catalina.core.StandardHost.startInternal(StandardHost.java
:772)
at
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:138)
at
org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.ja
va:990)
at
org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.
java:275)
at
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:138)
at
org.apache.catalina.core.StandardService.startInternal(StandardServic
e.java:424)
at
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:138)
at
org.apache.catalina.core.StandardServer.startInternal(StandardServer.
java:648)
at
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:138)
at org.apache.catalina.startup.Catalina.start(Catalina.java:576)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:415)
ERROR - GeronimoLog.error(108) | Error starting database connections,
check the
database configuration!
org.apache.ode.il.dbutil.DatabaseConfigException: Failed to resolved
external Da
taSource at "java:comp/env/jdbc/TestDB".
at
org.apache.ode.il.dbutil.Database.initExternalDb(Database.java:164)
at
org.apache.ode.il.dbutil.Database.initDataSource(Database.java:144)
at org.apache.ode.il.dbutil.Database.start(Database.java:99)
at
org.apache.ode.axis2.ODEServer.initDataSource(ODEServer.java:218)
at org.apache.ode.axis2.ODEServer.init(ODEServer.java:157)
at org.apache.ode.axis2.ODEServer.init(ODEServer.java:116)
at
org.apache.ode.axis2.hooks.ODEAxisServlet.init(ODEAxisServlet.java:53
)
at
org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.
java:1164)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.
java:1118)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:10
05)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex
t.java:4529)
at
org.apache.catalina.core.StandardContext.startInternal(StandardContex
t.java:4800)
at
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:138)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:785)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:76
3)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:558)
at
org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:987)
at
org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778
)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:540
)
at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1390)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:355)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:119)
at
org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBa
se.java:89)
at
org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:31
2)
at
org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:29
2)
at
org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.ja
va:998)
at
org.apache.catalina.core.StandardHost.startInternal(StandardHost.java
:772)
at
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:138)
at
org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.ja
va:990)
at
org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.
java:275)
at
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:138)
at
org.apache.catalina.core.StandardService.startInternal(StandardServic
e.java:424)
at
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:138)
at
org.apache.catalina.core.StandardServer.startInternal(StandardServer.
java:648)
at
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:138)
at org.apache.catalina.startup.Catalina.start(Catalina.java:576)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:415)
Caused by: javax.naming.NameNotFoundException: Name jdbc is not bound in
this Co
ntext
at org.apache.naming.NamingContext.lookup(NamingContext.java:774)
at org.apache.naming.NamingContext.lookup(NamingContext.java:144)
at org.apache.naming.NamingContext.lookup(NamingContext.java:785)
at org.apache.naming.NamingContext.lookup(NamingContext.java:144)
at org.apache.naming.NamingContext.lookup(NamingContext.java:785)
at org.apache.naming.NamingContext.lookup(NamingContext.java:157)
at
org.apache.naming.SelectorContext.lookup(SelectorContext.java:156)
at javax.naming.InitialContext.lookup(InitialContext.java:392)
at
org.apache.ode.il.dbutil.Database.lookupInJndi(Database.java:244)
at
org.apache.ode.il.dbutil.Database.initExternalDb(Database.java:159)
... 41 more
09.07.2010 08:59:11 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory docs
09.07.2010 08:59:11 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory examples
09.07.2010 08:59:12 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory host-manager
09.07.2010 08:59:12 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory manager
09.07.2010 08:59:12 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory ROOT
09.07.2010 08:59:12 org.apache.coyote.http11.Http11AprProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
09.07.2010 08:59:12 org.apache.coyote.http11.Http11AprProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
09.07.2010 08:59:12 org.apache.coyote.ajp.AjpAprProtocol init
INFO: Initializing Coyote AJP/1.3 on ajp-8009
09.07.2010 08:59:12 org.apache.coyote.ajp.AjpAprProtocol start
INFO: Starting Coyote AJP/1.3 on ajp-8009
09.07.2010 08:59:12 org.apache.catalina.startup.Catalina start
INFO: Server startup in 7072 ms
----------------------------------------
Any idea, what's wrong?
Greetings
Christian
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
