Hi, Yoav. I have not yet solved my Tomcat 5.0.27 CP configuration problem.
Yesterday, you said that the Tomcat log should not show it looked for MySQL driver when I am trying to connect to the Oracle 9i driver. It turned out that there is "another application" in the webapps looking for the MySQL driver. My current application does not look for the MySQL driver. A nice person really look into my configuration and my code and he said he does not see any obvious mistakes that other people have made. He is still helping digging into my CP configuration connection to the Oracle 9i. --- "Shapira, Yoav" <[EMAIL PROTECTED]> wrote: > > 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] > > __________________________________ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
