Hi all, and thanks for your support. I am using Tomcat 5.0.28, this is the latest version, so I really don't know if this is a real bug.
Like I early wrote, I try to cut and paste the configured database resource from the <GlobalNamingResources> element to every context in which I need that database resource, and it just work fine, but I guess this is not the best way to do it, because I have a considerable amount of context and virtual host, I have the database .jar inside WEB-INF\lib inside my applications. Why this works when I copy the resource to every context, and doesn't work as a global resource when I link it through the ResourceLink element, like this: <ResourceLink name="jdbc/app" global="jdbc/app" type="javax.sql.DataSource"/> inside every context element I need... Thanks to all... Regards Jonathan On Thu, 16 Sep 2004 18:35:51 +0530, Antony Paul <[EMAIL PROTECTED]> wrote: > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]