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:christian.bruckh...@gmx.de] 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: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 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org