tomcat 4 datasource Oracle help

[Jonathan Pierce <Jo...@seagram.com>]

I must still be missing something here. Please help. I'm still not able to get
an Oracle datasource using JNDI lookup to work. 

The lookup is returning null. Has anyone been successful looking up an Oracle
datasource resource using Tomcat 4.0b7?

I've placed the following jars in /common/lib

jdbc2_0-stdext.jar
tyrex-0.9.7.0.jar
classes12.jar (Oracle driver classes renamed from classes12.zip)

// My lookup code is:

theInitialContext = new InitialContext ();
DataSource theDataSource = (DataSource) theInitialContext.lookup
("java:comp/env/jdbc/oradb7");
out.println ("theDataSource:" + theDataSource);

I've configured server.xml as follows:

<Context path="/frn" docBase="frn" debug="0"
                 reloadable="true">
...
          <Resource name="jdbc/oradb7" auth="SERVLET"
                    type="javax.sql.DataSource" />
          <ResourceParams name="jdbc/oradb7">
            <parameter><name>user</name><value>testuser</value></parameter>
            <parameter><name>password</name><value>testpassword</value></paramet
er>
            <parameter><name>driverClassName</name>
              <value>oracle.jdbc.driver.OracleDriver</value></parameter>
            <parameter><name>driverName</name>
              <value>jdbc:oracle:thin:@localhost:1521:ORADB7</value></parameter>
          </ResourceParams>

I've configured my apps web.xml file as follows:

<web-app>
...

    <resource-ref>
        <description>Development</description>
        <res-ref-name>jdbc/oradb7</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
        <res-sharing-scope>Sharable</res-sharing-scope>
    </resource-ref>

I also tried adding a factory parameter but I'm not sure if the value is
correct. The class oracle.jdbc.pool.OracleDataSourceFactory exists in the
classes.12.jar but I'm not sure if it is what I should be using as the factory
class.

          <Context path="/frn" docBase="frn" debug="0"
                 reloadable="true">
    ...
          <Resource name="jdbc/oradb7" auth="SERVLET"
                    type="javax.sql.DataSource" />
          <ResourceParams name="jdbc/oradb7">
      <parameter><name>factory</name>
              <value>oracle.jdbc.pool.OracleDataSourceFactory</value></parameter
>
    ...


____________________Reply Separator____________________
Subject:    RE: tomcat 4 datasource casting
Author: tomcat-user@jakarta.apache.org
Date:       8/20/2001 6:42 PM

...and the second example for my "class-not-found" document presents itself
=)

Thanks guys!

- r

> -----Original Message-----
> From: craigmcc@sfu.ca [mailto:craigmcc@sfu.ca]On Behalf Of Craig R.
> McClanahan
> Sent: Monday, August 20, 2001 6:16 PM
> To: tomcat-user@jakarta.apache.org
> Subject: Re: tomcat 4 datasource casting
>
>
> Where do you have the jdbc2_0-stdext.jar file?  I'm betting that it needs
> to be in $CATALINA_HOME/common/lib only for this to work -- because JAR
> files here are on the class loading path for both Catalina internal
> classes and web application classes.
>
> Craig
>
>
> On Mon, 20 Aug 2001 VASQUEZ_JASON@LILLY.COM wrote:
>
> > Hello all,
> >
> > I read the great message Craig McClanahan posted in the archives  (from
> > Aug 4) about how to setup and use a tomcat 4 datasource.  All
> has seemed
> > to go pretty well, but I'm having a funny problem, which I'm
> not sure is a
> > Tyrex problem, a Tomcat 4 problem or a Java education problem
> on my part
> > :).  (I'm using Tomcat 4 beta 7)
> >
> > When I try to get a DataSource from JNDI, I can retrieve a
> reference just
> > fine.  The problem is that I am having trouble casting it to a
> > javax.sql.DataSource.  It returns an instance of
> > tyrex.jdbc.xa.EnabledDataSource.  If I try to cast to
> > javax.sql.DataSource, I get a ClassCastException from the server.  I
> > looked up this class in the Tyrex API docs, and it does in fact
> implement
> > javax.sql.DataSource -- I think I should be able to cast to it
> because of
> > that.  If I work with the tyrex implementation directly, all is
> ok (i.e.,
> > calling tyrex.jdbc.xa.EnabledDataSource.getConnection()), but I
> obviously
> > won't want to care about the particular implementation in this case.
> >
> > If it helps, here is the code I'm trying to use:
> >
> > --------------------------
> > ctx = new InitialContext();
> > ds = (DataSource)ctx.lookup("java:comp/env/jdbc/lis_ds");
> > --------------------------
> >
> > That failed, so I added this for debugging:
> >
> > --------------------------
> > Object o = ctx.lookup("java:comp/env/jdbc/lis_ds");
> > if (o == null) {
> >    System.out.println("looked up a null object");
> > } else {
> >    System.out.println("o is of type: " + o.getClass().getName()); //<--
> > prints "tyrex.jdbc.xa.EnabledDataSource"
> > }
> > --------------------------
> >
> > The exceptions I get are like this:
> >
> > --------------------------
> > java.lang.ClassCastException: tyrex.jdbc.xa.EnabledDataSource
> >         at report.ReportPrefs.setDateDefaults(ReportPrefs.java:52)
> >         at report.ReportPrefs.<init>(ReportPrefs.java:16)
> >         at java.lang.Class.newInstance0(Native Method)
> >         at java.lang.Class.newInstance(Class.java:237)
> >         at java.beans.Beans.instantiate(Beans.java:207)
> >         at java.beans.Beans.instantiate(Beans.java:51)
> > ........
> > --------------------------
> >
> > Any ideas?
> >
> > Thanks,
> > Jason Vasquez
> >
>
>