Surely there must be somebody out there who has connection pooling working with DBCP and Oracle.....
Please! :) -----Original Message----- From: James hughes [mailto:[EMAIL PROTECTED]] Sent: 14 October 2002 14:55 To: Tomcat Users List Subject: RE: JNDI Datasource is null I changed the values, but still the Datasource is null :( I find it strange that the JNDI name exists with no object - that is, I dont get a NameNotFoundException. -----Original Message----- From: Jacob Kjome [mailto:[EMAIL PROTECTED]] Sent: 14 October 2002 14:53 To: Tomcat Users List Subject: Re: JNDI Datasource is null 2 things are possible culprits.... The syntax for JNDI datasources changed slightly after moving from Tyrex as the default provider to DBCP. Specifically, "user" should be "username". The other thing is the <Resource scope="Sharable">. That might be right, but I've never used it. I use "Container" for that value. Jake At 02:07 PM 10/14/2002 +0100, you wrote: >Hi there, > >I am using Oracle 9i, DBCP and Tomcat 4.1.12. I am trying to configure a >JNDI datasource that implements connection pooling. I have been following >the instructions in the JNDI how to, specifically the section for Oracle. > >My problem is that the JNDI Datasource is null when I try to get it from the >context. I cant see any exceptions being thrown anywhere. > >Can anyone tell me what I have missed? > >My server.xml is as follows (this entry is in the HOST tag, after the >/examples context): > > <Context className="org.apache.catalina.core.StandardContext" > cachingAllowed="true" > charsetMapperClass="org.apache.catalina.util.CharsetMapper" > > cookies="true" > crossContext="true" > debug="5" docBase="TestDB" > >mapperClass="org.apache.catalina.core.StandardContextMapper" > path="/TestDB" privileged="false" > reloadable="true" swallowOutput="false" > useNaming="true" > wrapperClass="org.apache.catalina.core.StandardWrapper"> > <Logger className="org.apache.catalina.logger.FileLogger" > debug="0" directory="logs" > prefix="localhost_DBTest_log." > suffix=".txt" timestamp="true" verbosity="1"/> > <Resource auth="container" name="jdbc/myoracle" scope="Shareable" >type="java.sql.DataSource"/> > <ResourceParams name="jdbc/myoracle"> > <parameter> > <name>factory</name> > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > </parameter> > <parameter> > <name>url</name> > <value>jdbc:oracle:thin:@127.0.0.1:1521:RHODES</value> > </parameter> > <parameter> > <name>password</name> > <value>tiger</value> > </parameter> > <parameter> > <name>maxActive</name> > <value>20</value> > </parameter> > <parameter> > <name>maxWait</name> > <value>10</value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>oracle.jdbc.driver.OracleDriver</value> > </parameter> > <parameter> > <name>user</name> > <value>scott</value> > </parameter> > <parameter> > <name>maxIdle</name> > <value>10</value> > </parameter> > </ResourceParams> > </Context> > > >And web.xml is as follows: > > <resource-ref> > <description>Oracle Datasource example</description> > <res-ref-name>jdbc/myoracle</res-ref-name> > <res-type>javax.sql.DataSource</res-type> > <res-auth>Container</res-auth> > </resource-ref> > > > >I have a class as follows: > >package foo; > >import javax.naming.*; >import javax.sql.*; >import java.sql.*; > >public class DBTest >{ > String foo = "Not Connected"; > int bar = -1; > > public void init() > { > try > { > Context ctx = new InitialContext(); > if(ctx == null ) > { > throw new Exception("Boom - No Context"); > } > > Context envContext = >(Context)ctx.lookup("java:/comp/env"); > DataSource ds = >(DataSource)envContext.lookup("jdbc/myoracle"); > > if (ds != null) > { > Connection conn = ds.getConnection(); > > if(conn != null) > { > foo = "Got Connection >"+conn.toString(); > Statement stmt = >conn.createStatement(); > ResultSet rst = >stmt.executeQuery("select id, foo, bar from testdata"); > > if(rst.next()) > { > foo = rst.getString(2); > bar = rst.getInt(3); > } > > conn.close(); > } > } > else > { > System.out.println("DS was null!"); > } > } > catch(Exception e) > { > e.printStackTrace(); > } > } > > public String getFoo() { return foo; } > public int getBar() { return bar;} >} > > > >And finally, a JSP as follows: > ><% foo.DBTest tst = new foo.DBTest(); tst.init(); %> > >Results > > > >Foo <%= tst.getFoo() %> Bar <%= tst.getBar() %> > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
