tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roberto Bouza <rbo...@efcholdings.com>
Subject RE: Tomcat 4.1, DBCP and Oracle
Date Mon, 09 Dec 2002 18:05:17 GMT

 No only rename the .zip to .jar

Quoting "Campano, Troy" <Troy.Campano@LibertyMutual.com>:

> Damn, I'm still getting the same error after I re-did my configuration like
> yours.
> java.sql.SQLException: Cannot load JDBC driver class 'null'
> 
> When you put your JAR into /common/lib/ did Tomcat automatically recognize it
> when you rebooted the server?
> Mine didn't, though it did in Tomcat 4.0.x.
> I wonder if that had something to do with it.
> 
> Did all you do was rename classes12.zip to classes12.jar?
> Did you have to do any repackaging?
> 
> thank you!
> 
> ~ t r o y ~
> 
> -----Original Message-----
> From: Thomas Achleitner [ <mailto:tachleitner@ftisoft.at>
> mailto:tachleitner@ftisoft.at]
> Sent: Monday, December 09, 2002 11:38 AM
> To: Tomcat Users List
> Subject: RE: Tomcat 4.1, DBCP and Oracle
> 
> 
> Here are the relevant snapshots of the code (classes12.jar in common/lib):
> server.xml:
> <Resource name="jdbc/OracleDS" auth="Container"
> type="oracle.jdbc.pool.OracleConnectionCacheImpl"/>
> <ResourceParams name="jdbc/OracleDS">
>
<parameter><name>factory</name><value>oracle.jdbc.pool.OracleDataSourceFactory</value></parameter>
> <parameter><name>userName</name><value>scott</value></parameter>
> <parameter><name>password</name><value>tiger</value></parameter>
>
<parameter><name>driverClassName</name><value>oracle.jdbc.OracleDriver</value></parameter>
>
<parameter><name>url</name><value>jdbc:oracle:thin:@testdb:1525:ORA5</value></parameter>
> </ResourceParams>
> 
> web.xml:
> <resource-ref>
>   <description>Resource reference to a factory for java.sql.Connection
>   instances that may be used for talking to a particular
>   database that is configured in the server.xml file.</description>
>   <res-ref-name>jdbc/OracleDS</res-ref-name>
>   <res-type>javax.sql.DataSource</res-type>
>   <res-auth>Container</res-auth>
> </resource-ref>
> 
> Source code that obtains connection:
> initCtx = new InitialContext();
> envCtx = (Context) initCtx.lookup("java:comp/env");
> dataSource = (DataSource) envCtx.lookup("jdbc/OracleDS");
> con = dataSource.getConnection();
> 
> hope that helps !
> thomas
> 
> -----Original Message-----
> From: Campano, Troy [ <mailto:Troy.Campano@LibertyMutual.com>
> mailto:Troy.Campano@LibertyMutual.com]
> Sent: Monday, December 09, 2002 5:26 PM
> To: Tomcat Users List
> Subject: RE: Tomcat 4.1, DBCP and Oracle
> 
> 
> Woa...
> 
> Could you send me a copy of your server.xml, web.xml, and how you create the
> connection in your Servlet/JSP?
> 
> That would be greatly appreciated.
> 
> 
> thank you very much!
> 
> ~ t r o y ~
> 
> -----Original Message-----
> From: Thomas Achleitner [ <mailto:tachleitner@ftisoft.at>
> mailto:tachleitner@ftisoft.at]
> Sent: Monday, December 09, 2002 11:24 AM
> To: Tomcat Users List
> Subject: RE: Tomcat 4.1, DBCP and Oracle
> 
> 
> hi!
> tomcat 4.1.12
> classes12.jar
> 
> thomas
> 
> -----Original Message-----
> From: Campano, Troy [ <mailto:Troy.Campano@LibertyMutual.com>
> mailto:Troy.Campano@LibertyMutual.com]
> Sent: Monday, December 09, 2002 5:22 PM
> To: Tomcat Users List
> Subject: RE: Tomcat 4.1, DBCP and Oracle
> 
> 
> Hi Thomas...
> 
> What version of Tomcat are you using?
> Are you using classes12.jar (zip)?
> 
> thanks!
> 
> ~ t r o y ~
> 
> 
> -----Original Message-----
> From: Thomas Achleitner [ <mailto:tachleitner@ftisoft.at>
> mailto:tachleitner@ftisoft.at]
> Sent: Monday, December 09, 2002 11:15 AM
> To: Tomcat Users List
> Subject: RE: Tomcat 4.1, DBCP and Oracle
> 
> 
> hi troy!
> 
> You can take oracle.jdbc.OracleDriver as well (the oracle forum told me that
> oracle.jdbc.driver.OracleDriver is only kept for backwards compatibility). If
> I remove following parameters then it works fine with my application:
>     <parameter>
>       <name>maxLimit</name>
>       <value>10</value>
>     </parameter>
>     <parameter>
>       <name>minLimit</name>
>       <value>5</value>
>     </parameter>
>     <parameter>
>       <name>cacheScheme</name>
>       <value>1</value>
>     </parameter>
> 
> I think you should have a look at the docu for those parameters. I just have
> no idea why they don't work. The parameter user should be changed to userName
> as well (casesensitive).
> 
> thomas
> 
> -----Original Message-----
> From: Campano, Troy [ <mailto:Troy.Campano@LibertyMutual.com>
> mailto:Troy.Campano@LibertyMutual.com]
> Sent: Monday, December 09, 2002 4:53 PM
> To: Tomcat Users List
> Subject: RE: Tomcat 4.1, DBCP and Oracle
> 
> 
> Hello Thomas,
> I take it you mean oracle.jdbc.driver.OracleDriver.
> I added it, bounced the server, and still the same dreadful error:
> 
> java.sql.SQLException: Cannot load JDBC driver class 'null'
> 
> 
> thank you for your help though!
> 
> ~ t r o y ~
> 
> 
> -----Original Message-----
> From: Thomas Achleitner [ <mailto:tachleitner@ftisoft.at>
> mailto:tachleitner@ftisoft.at]
> Sent: Monday, December 09, 2002 10:44 AM
> To: Tomcat Users List
> Subject: RE: Tomcat 4.1, DBCP and Oracle
> 
> 
> Hi!
> I think paraemter driverClassName is missing. Try:
>
<parameter><name>driverClassName</name><value>oracle.jdbc.OracleDriver</value></parameter>
> 
> hope this helps!
> 
> thomas
> 
> -----Original Message-----
> From: Campano, Troy [ <mailto:Troy.Campano@LibertyMutual.com>
> mailto:Troy.Campano@LibertyMutual.com]
> Sent: Monday, December 09, 2002 4:36 PM
> To: Balzarotti Paolo; Tomcat Users List
> Subject: RE: Tomcat 4.1, DBCP and Oracle
> 
> 
> Nope...no luck.
> Same error:
> java.sql.SQLException: Cannot load JDBC driver class 'null'
> 
> My server.xml looks like this now:
> 
> <Context path="/inventoryServer" docBase="inventoryServer" debug="5"
> reloadable="false" crossContext="false">
>   <Resource name="jdbc/inventoryPool"
> type="oracle.jdbc.pool.OracleConnectionCacheImpl"/>
>   <ResourceParams name="jdbc/inventoryPool">
>     <parameter>
>       <name>factory</name>
>       <value>oracle.jdbc.pool.OracleDataSourceFactory</value>
>     </parameter>
>     <parameter>
>       <name>url</name>
>       <value>jdbc:oracle:thin:@myNode:1521:myIstance</value>
>     </parameter>
>     <parameter>
>       <name>user</name>
>       <value>myUser</value>
>     </parameter>
>     <parameter>
>       <name>password</name>
>       <value>myPass</value>
>     </parameter>
>     <parameter>
>       <name>maxLimit</name>
>       <value>10</value>
>     </parameter>
>     <parameter>
>       <name>minLimit</name>
>       <value>5</value>
>     </parameter>
>     <parameter>
>       <name>cacheScheme</name>
>       <value>1</value>
>     </parameter>
>   </ResourceParams>
> </Context>
> 
> 
> 
> Any ideas?
> 
> ~ t r o y ~
> 
> -----Original Message-----
> From: Balzarotti Paolo [ <mailto:Paolo.Balzarotti@rasnet.it>
> mailto:Paolo.Balzarotti@rasnet.it]
> Sent: Monday, December 09, 2002 10:11 AM
> To: Campano, Troy
> Subject: R: Tomcat 4.1, DBCP and Oracle
> 
> 
> No,
> they suggest to use an oracle.jdbc.pool.OracleConnectionCacheImpl
> and an oracle.jdbc.pool.OracleDataSourceFactory
> look in chapter 5
> It's an old post, I don't know its validity 8-?
> 
> ---------------------------------------------
> 
> 
>  Oracle JDBC DataSource Example
> This example shows how to configure Tomcat to use Oracle's JDBC connection
> cache data source.
> 
> First ensure the Oracle JDBC driver is installed correctly. The Oracle
> drivers can typically be located in the $ORACLE_HOME/jdbc/lib directory:
> 
> The Oracle JDBC driver must be added to the $CATALINA_HOME/common/lib
> directory, so that it can be loaded as a JNDI Resource.
> Ensure the driver file(s) has a .jar extension, so that it can be
> automatically loaded by Tomcat's class loader.
> Add a Tomcat Resource and ResourceParams element to the web application's
> Context in the $CATALINA_HOME/conf/server.xml file:
> 
> <Context ...> ... <Resource name="jdbc/EmployeeDB"
> type="oracle.jdbc.pool.OracleConnectionCacheImpl"/> <ResourceParams
> name="jdbc/EmployeeDB"> <parameter> <name>factory</name>
> <value>oracle.jdbc.pool.OracleDataSourceFactory</value> </parameter>
> <parameter> <name>url</name>
> <value>jdbc:oracle:thin:@localhost:1521:EmployeeDB</value> </parameter>
> <parameter> <name>user</name> <value>dbusername</value>
</parameter>
> <parameter> <name>password</name> <value>dbpassword</value>
</parameter>
> <parameter> <name>maxLimit</name> <value>10</value> </parameter>
<parameter>
> <name>minLimit</name> <value>5</value> </parameter> <parameter>
> <name>cacheScheme</name> <value>1</value> </parameter>
</ResourceParams> ...
> </Context>
> The configuration properties for Oracle's connection cache data source
> resource factory (oracle.jdbc.pool.OracleDataSourceFactory) are as follows:
> 
> cacheScheme - The connection caching scheme: 1 - Dynamic Scheme; creates
> connections as required beyond maxLimit, but will close additional
> connections beyond maxLimit when they become available. 2 - Fixed Return Null
> Scheme; returns null when no spare connections are available. 3 - Fixed Wait
> Scheme; blocks waiting until a spare connection becomes available. database
> login password. The default value is Dynamic Scheme.
> maxLimit - The maximum number of connections in the pool. The default value
> is 10.
> minLimit - The minimum number of connections in the pool. The default value
> is 0.
> password - The database login password.
> url - The JDBC connection URL.
> user - The database login username.
> Add a corresponding resource-env-ref element in the web application's web.xml
> file:
> 
> <resource-env-ref> <resource-env-ref-name> jdbc/EmployerDB
> </resource-env-ref-name> <resource-env-ref-type>
> oracle.jdbc.pool.OracleConnectionCacheImpl </resource-env-ref-type>
> <resource-env-ref>
> Note the OracleConnectionCacheImpl class implements the javax.sql.DataSource
> interface, and should be used like a regular data source.
> 
> > -----Messaggio originale-----
> > Da: Campano, Troy [ <mailto:Troy.Campano@LibertyMutual.com>
> mailto:Troy.Campano@LibertyMutual.com]
> > Inviato: lunedì 9 dicembre 2002 16.08
> > A: Balzarotti Paolo
> > Oggetto: RE: Tomcat 4.1, DBCP and Oracle
> >
> >
> > Is that the same thing as this?
> >
> >  <http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasourc>
> http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasourc
> > e-examples-howto.html
> >
> >
> > -----Original Message-----
> > From: Balzarotti Paolo [ <mailto:Paolo.Balzarotti@rasnet.it>
> mailto:Paolo.Balzarotti@rasnet.it]
> > Sent: Monday, December 09, 2002 10:02 AM
> > To: Campano, Troy
> > Subject: R: Tomcat 4.1, DBCP and Oracle
> >
> >
> > Hello Troy,
> > look at this
> >  <http://www.mail-archive.com/tomcat-dev@jakarta.apache.org/msg2>
> http://www.mail-archive.com/tomcat-dev@jakarta.apache.org/msg2
> > 7217.html
> >
> > > -----Messaggio originale-----
> > > Da: Campano, Troy [ <mailto:Troy.Campano@LibertyMutual.com>
> mailto:Troy.Campano@LibertyMutual.com]
> > > Inviato: lunedì 9 dicembre 2002 15.30
> > > A: Balzarotti Paolo
> > > Oggetto: RE: Tomcat 4.1, DBCP and Oracle
> > >
> > >
> > > Hi Paolo,
> > > No, nothing has worked yet...unfortunately.
> > >
> > > ~ T r o y ~
> > >
> > > -----Original Message-----
> > > From: Balzarotti Paolo [ <mailto:Paolo.Balzarotti@rasnet.it>
> mailto:Paolo.Balzarotti@rasnet.it]
> > > Sent: Monday, December 09, 2002 5:56 AM
> > > To: Campano, Troy
> > > Subject: Tomcat 4.1, DBCP and Oracle
> > >
> > >
> > > Hello Troy,
> > > have you solved your problem with Tomcat?
> > > I've a similar problem: right configuration (I hope!), but when I
> > > launch the test page like the one in the tomcat-docs I see the
> > > system out until
> > >  System.out.println("**** init 4.1 " + ds.toString());          
> > > reported in the listing and the browser goes in guru meditation
> > > ...ahummmmmmmmm...    
> > >
> > > public void init() {
> > >         try{         
> > >             System.out.println("**** init 1");
> > >             Context initContext  = new InitialContext();
> > >             Context envContext  =
> > > (Context)initContext.lookup("java:/comp/env");           
> > >             System.out.println("**** init 2");
> > >            
> > >             if(initContext  == null ){
> > >                 System.out.println("**** init 2.1");
> > >                 throw new Exception("Boom - No Context");  
> >         
> > >             }
> > >             System.out.println("**** init 3");
> > >             DataSource ds =
> > > (DataSource)envContext.lookup("jdbc/unifondiDS");         
> > >     
> > >             System.out.println("**** init 4");
> > >             if (ds != null) {
> > >                 System.out.println("**** init 4.1");
> > >                 System.out.println("**** init 4.1 " +
> > ds.getClass());
> > >                 System.out.println("**** init 4.1 " +
> > ds.toString());
> > >
> > >                 Connection conn = ds.getConnection();
> > >                 System.out.println("**** init 4.2");
> > >                 if(conn != null)  {
> > >                     System.out.println("**** init 4.2.1");
> > >                     foo = "Got Connection "+conn.toString();
> > >                     Statement stmt = conn.createStatement();
> > >                     System.out.println("**** init 4.2.2");
> > >                     ResultSet rst =
> > >                     stmt.executeQuery(
> > >                     "select * from anintric where COGNOME  =
> > > 'PIPPO'");
> > >                     System.out.println("**** init 4.2.3");
> > >                     if(rst.next()) {
> > >                         System.out.println("**** init 4.2.3.1");
> > >                         foo=rst.getString(2);
> > >                         bar=rst.getInt(3);
> > >                     }
> > >                     System.out.println("**** init 4.2.4");
> > >                     conn.close();
> > >                 }
> > >             }
> > >         }catch(Exception e) {
> > >             e.printStackTrace();
> > >         }
> > >     }
> > >
> >
> 
> --
> To unsubscribe, e-mail:   <
> <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: <
> <mailto:tomcat-user-help@jakarta.apache.org>
> mailto:tomcat-user-help@jakarta.apache.org>
> 
> 
> --
> To unsubscribe, e-mail:   <
> <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: <
> <mailto:tomcat-user-help@jakarta.apache.org>
> mailto:tomcat-user-help@jakarta.apache.org>
> 
> --
> To unsubscribe, e-mail:   <
> <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: <
> <mailto:tomcat-user-help@jakarta.apache.org>
> mailto:tomcat-user-help@jakarta.apache.org>
> 
> 
> --
> To unsubscribe, e-mail:   <
> <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: <
> <mailto:tomcat-user-help@jakarta.apache.org>
> mailto:tomcat-user-help@jakarta.apache.org>
> 
> --
> To unsubscribe, e-mail:   <
> <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: <
> <mailto:tomcat-user-help@jakarta.apache.org>
> mailto:tomcat-user-help@jakarta.apache.org>
> 
> 
> --
> To unsubscribe, e-mail:   <
> <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: <
> <mailto:tomcat-user-help@jakarta.apache.org>
> mailto:tomcat-user-help@jakarta.apache.org>
> 
> --
> To unsubscribe, e-mail:   <
> <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: <
> <mailto:tomcat-user-help@jakarta.apache.org>
> mailto:tomcat-user-help@jakarta.apache.org>
> 
> 
> --
> To unsubscribe, e-mail:   <
> <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: <
> <mailto:tomcat-user-help@jakarta.apache.org>
> mailto:tomcat-user-help@jakarta.apache.org>
> 
> 
> 


-- 
=             Roberto Bouza Fraga               =
===================================
      Research & Development Engineer
       Ella Cisneros Fontanals Holdings
 Ph: (305)-860-0116 / Fax:(305)-860-9401
===================================
       e-Mail:rbouza@efcholdings.com

--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>


Mime
View raw message