On 09/07/2010 08:01, Christian Bruckhoff wrote: > 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:
For future ref: https://issues.apache.org/jira/browse/ODE-871 p >> <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 >
signature.asc
Description: OpenPGP digital signature