Not totally sure if this matters, maybe it doesn't, but I notice this line on
the error:
Failed to resolved external DataSource at "java :comp/env/jdbc/TestDB".
I have a similar reference, while using Oracle, but reference as
Context envCtx = (Context) initCtx.lookup("java:comp/env"); <------------
no space.....yours has a space.
Maybe the space would cause an error?
-----Original Message-----
From: Christian Bruckhoff [mailto:[email protected]]
Sent: Friday, July 09, 2010 2:02 AM
To: Tomcat Users List
Subject: Re: Connecting Tomcat to a database
Hi.
Am 08.07.2010 23:36, schrieb Caldarale, Charles R:
>> From: Christian Bruckhoff [mailto:[email protected]]
>> 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: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
