Had you tried it with inside Context element. If it doesn't work it means the JDBC driver is not found when Tomcat starts up. You have to put JDBC jar in CATALINA_HOME\common\lib. It can be placed in WEB-INF\lib if you place dbcp.jar too there.
rgds Antony Paul ----- Original Message ----- From: "Shapira, Yoav" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]>; "Jonathan Rengifo" <[EMAIL PROTECTED]> Sent: Thursday, September 16, 2004 6:02 PM Subject: RE: Problem configuring a global resource to be linked from Context elements .... Hi, Maybe there really is a bug in the Tomcat release you're using: which one are you trying? Yoav Shapira Millennium Research Informatics >-----Original Message----- >From: Jonathan Rengifo [mailto:[EMAIL PROTECTED] >Sent: Wednesday, September 15, 2004 9:08 PM >To: Tomcat User List >Subject: Problem configuring a global resource to be linked from Context >elements .... > >Hi all.... > > >This is the third time I've write a message to the list asking for the >same issue, but didn't solve it, I am starting to think about this is >a really bug in Tomcat 5. My question is ... Why when I configure a >Resource inside the GlobalNamingResources element just to ResourceLink >it inside the context it just doesn't work, throwing an exception like >this ... > >org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver >class 'oracle.jdbc.driver.OracleDriver' > >This means to me that the oracle driver I am using is could no be >found, but then, why when I cut the Resource and paste it inside every >Context I use it just work fine???... > >Please help.... How do I configure this global resource?? > >Here is how I am setting this up... > ><GlobalNamingResources> > ><Resource name="jdbc/app" auth="Container" scope="Shareable" >type="javax.sql.DataSource"/> > <ResourceParams name="jdbc/app"> > <parameter> > <name>factory</name> > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > </parameter> > <parameter> > <name>url</name> > <value>jdbc:oracle:thin:@myDatabaseServer:port:user</value> > </parameter> > <parameter> > <name>password</name> > <value>myPassword</value> > </parameter> > <parameter> > <name>maxActive</name> > <value>20</value> > </parameter> > <parameter> > <name>maxWait</name> > <value>-1</value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>oracle.jdbc.driver.OracleDriver</value> > </parameter> > <parameter> > <name>username</name> > <value>myUser</value> > </parameter> > <parameter> > <name>maxIdle</name> > <value>10</value> > </parameter> > </ResourceParams> ></GlobalNamingResources> > > >Thanks .. > >Jonathan > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. --------------------------------------------------------------------- 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]
