Marc Thanks..! Do you know if the global link is necessary...or what it does?
Brent -----Original Message----- From: Marc Dugger [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 12:56 PM To: [EMAIL PROTECTED]; 'Tomcat Users List' Subject: RE: jndi + dbcp [SOLUTION] I had defined the resource at the global level, but failed to link it to the context. before: <Context path="/workbench" docBase="C:\Code\loanauditor\src\webapp\workbench" workDir="C:\Code\loanauditor\src\webapp\workbench\WEB-INF\work" reloadable="true" debug="0" /> after: <Context path="/workbench" docBase="C:\Code\loanauditor\src\webapp\workbench" workDir="C:\Code\loanauditor\src\webapp\workbench\WEB-INF\work" reloadable="true" debug="0"> <ResourceLink name="jdbc/loanauditor" global="LoanAuditorDB" type="javax.sql.DataSource"/> </Context> > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, November 17, 2003 2:29 PM > To: 'Tomcat Users List'; [EMAIL PROTECTED] > Subject: RE: jndi + dbcp [SOLUTION] > > > Hey Mark, > > Can you post your context solution...I am not sure about the > ResourceLink > > Thanks Brent > > > > -----Original Message----- > From: Marc Dugger [mailto:[EMAIL PROTECTED] > Sent: Monday, November 17, 2003 12:26 PM > To: Tomcat Users List > Subject: RE: jndi + dbcp [SOLUTION] > > > missing <ResourceLink .../> inside <Context ../> > > > -----Original Message----- > > From: Marc Dugger [mailto:[EMAIL PROTECTED] > > Sent: Monday, November 17, 2003 12:56 PM > > To: [EMAIL PROTECTED] > > Subject: jndi + dbcp > > > > > > My resource parameters are not being passed correctly to a JDBC > > resource factory causing this stack trace: > > > > 2003-11-17 12:42:59,281 [main] FATAL > > com.socotech.loanauditor.dao.TorqueDomainTypeDAO - Cannot create > > JDBC driver of class '' for connect URL 'null' > > org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC > > driver > of > > class '' for connect URL 'null', cause: > > java.sql.SQLException: No suitable driver > > at java.sql.DriverManager.getDriver(DriverManager.java:243) > > at > > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicData > > Source.jav > > a:743) > > at > > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSou > > rce.java:5 > > 18) > > at org.apache.torque.Torque.getConnection(Torque.java:890) > > at > > org.apache.torque.util.Transaction.beginOptional(Transaction.java:114) > > at > org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1328) > > at > > com.socotech.loanauditor.or.torque.BaseTimeIntervalImplPeer.doSele > > ctVillageR > > ecords(BaseTimeIntervalImplPeer.java:375) > > at > > com.socotech.loanauditor.or.torque.BaseTimeIntervalImplPeer.doSele > > ctVillageR > > ecords(BaseTimeIntervalImplPeer.java:342) > > at > > com.socotech.loanauditor.or.torque.BaseTimeIntervalImplPeer.doSele > > ct(BaseTim > > eIntervalImplPeer.java:311) > > at > > com.socotech.loanauditor.dao.TorqueDomainTypeDAO.getTimeIntervals( > > TorqueDoma > > inTypeDAO.java:36) > > at > > com.socotech.loanauditor.web.listener.DomainTypeLoader.contextInit > > ialized(Do > > mainTypeLoader.java:32) > > at > > org.apache.catalina.core.StandardContext.listenerStart(StandardCon > > text.java: > > 3271) > > at > > > org.apache.catalina.core.StandardContext.start(StandardContext.java:36 > 13 > ) > > at > > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) > > at > > org.apache.catalina.core.StandardHost.start(StandardHost.java:754) > > at > > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) > > at > > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363) > > at > > > org.apache.catalina.core.StandardService.start(StandardService.java:49 > 7) > > at > > > org.apache.catalina.core.StandardServer.start(StandardServer.java:2190 > ) > > at > org.apache.catalina.startup.Catalina.start(Catalina.java:512) > > at > org.apache.catalina.startup.Catalina.execute(Catalina.java:400) > > at > org.apache.catalina.startup.Catalina.process(Catalina.java:180) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorIm > > pl.java:39 > > ) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAc > > cessorImpl > > .java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at > org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203) > > > > my server.xml: > > > > <GlobalNamingResources> > > <Resource name="jdbc/loanauditor" auth="Container" > > type="javax.sql.DataSource" /> > > <ResourceParams name="jdbc/loanauditor"> > > <parameter> > > <name>factory</name> > > > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > > </parameter> > > <parameter> > > <name>maxActive</name> > > <value>100</value> > > </parameter> > > <parameter> > > <name>maxIdle</name> > > <value>30</value> > > </parameter> > > <parameter> > > <name>maxWait</name> > > <value>10000</value> > > </parameter> > > <parameter> > > <name>username</name> > > <value>marc</value> > > </parameter> > > <parameter> > > <name>password</name> > > <value>[PASSWORD]</value> > > </parameter> > > <parameter> > > <name>driverClassName</name> > > <value>com.mysql.jdbc.Driver</value> > > </parameter> > > <parameter> > > <name>url</name> > > > > > <value>jdbc:mysql://localhost:3306/loanauditor?autoReconnect=true</val > ue > > > > </parameter> > > </ResourceParams> > > > > I've got JDBC driver, commons-dbcp, commons-pool, and > > commons-collections in Tomcat's common/lib. Thanks in advance for > > any > > > insight! > > > > > > -------------------------------------------------------------------- > > - > > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
