Mighty Tornado wrote: > I added the same entry to context.xml under $CATALINA/conf and it did work. > Could there be something else wrong?
Did you remove it before trying to add it here? p > On Mon, Apr 6, 2009 at 12:30 PM, Pid <p...@pidster.com> wrote: > >> Mighty Tornado wrote: >>> JVM: 1.5.0_16Tomcat: 6.0.16 2 >>> OS: Mac OS X Leopard >>> >>> Hi, >>> >>> I defined the following context.xml under META-INF: >>> >>> <?xml version="1.0" encoding="UTF-8"?> >>> >>> <Context path="/Household" docBase="Household" debug="5" >> reloadable="true" >>> crossContext="true"> >>> >>> <Resource >>> >>> auth="Container" >>> >>> description="DB Connection" >>> >>> name="jdbc/vhousehold" >>> >>> type="javax.sql.DataSource" >>> >>> password="vhousehold" >>> >>> driverClassName="com.mysql.jdbc.Driver" >>> >>> maxIdle="2" >>> >>> maxWait="5000" >>> >>> validationQuery="/* PING */ SELECT 1;" >>> >>> username="vhousehold" >>> >>> url="jdbc:mysql://localhost:3306/vhousehold" >>> >>> maxActive="4"/> >>> >>> </Context> >>> >>> >>> In web.xml I have the following: >>> >>> >>> <resource-ref> >>> >>> <description>Connection Pool</description> >>> >>> <res-ref-name>jdbc/vhousehold</res-ref-name> >>> >>> <res-type>javax.sql.Datasource</res-type> >>> >>> <res-auth>Container</res-auth> >>> >>> </resource-ref> >>> >>> >>> I try to get this data source in my application using the following code: >>> >>> >>> DataSource ds = (DataSource)initContext.lookup( >>> "java:/comp/env/jdbc/vhousehold"); >>> >>> >>> and it fails. This is the exception I get: >>> >>> javax.naming.NamingException: Cannot create resource instance >>> >>> at >>> >> org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:143) >>> at >>> javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304) >>> >>> at org.apache.naming.NamingContext.lookup(NamingContext.java:793) >>> >>> at org.apache.naming.NamingContext.lookup(NamingContext.java:140) >>> >>> at org.apache.naming.NamingContext.lookup(NamingContext.java:781) >>> >>> at org.apache.naming.NamingContext.lookup(NamingContext.java:140) >>> >>> at org.apache.naming.NamingContext.lookup(NamingContext.java:781) >>> >>> at org.apache.naming.NamingContext.lookup(NamingContext.java:153) >>> >>> at >>> org.apache.naming.SelectorContext.lookup(SelectorContext.java:137) >>> >>> at javax.naming.InitialContext.lookup(InitialContext.java:351) >>> >>> at >>> com.vhousehold.dao.RandomPhraseDAO.getPhrases(RandomPhraseDAO.java:60) >>> >>> at >>> >> com.vhousehold.model.RandomPhraseModel.getRandomPhrase(RandomPhraseModel.java:19) >>> at >> com.vhousehold.servlet.VHController.doPost(VHController.java:52) >>> at >> com.vhousehold.servlet.VHController.doGet(VHController.java:35) >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) >>> >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >>> >>> at >>> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) >>> at >>> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >>> at >>> >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) >>> at >>> >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) >>> at >>> >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) >>> at >>> >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) >>> at >>> >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) >>> at >>> >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) >>> at >>> >> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) >>> at >>> >> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) >>> at >>> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) >>> >>> at java.lang.Thread.run(Thread.java:613) >>> >>> >>> Any suggestions as to what I am doing wrong? >> You've added the path and docBase attributes to your >> META-INF/context.xml. Don't do that. >> >> Are the credentials you're using for the database correct? >> >> p >> >> >>> Thanks. >>> >> >> --------------------------------------------------------------------- >> 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
