I asked the question twice on this list and received no responses. I assume this
means noone has been successful doing this correctly. Since I couldn't wait any
longer, I wrote a temporary solution that reads the properties directly and
allocates connections explicitly using the DriverManager.
Here's the code I ended up using to retrieve the DataSource properties. You can
use it as a temporary solution until someone responds to the correct way to
successfully instantiate the Oracle DataSource. I didn't include the
DBServletDataSourceSpec class here since it is not important to understanding
the implementation workaround.
private Vector ReadJNDIDataSources (HttpServlet theDBServletLogger)
throws Exception
{
Vector theResult = null;
String theJNDIName = "";
String theClassName = "";
String theUserID = "";
String thePassword = "";
String theDriverName = "";
String theDriverClassName = "";
NamingEnumeration theNamingEnumeration = null;
Reference theReference = null;
RefAddr theRefAddr = null;
Binding theBinding = null;
String theResourceClassName = "";
DBServletDataSourceSpec theDBServletDataSourceSpec = null;
String theURLConnectString = "";
theResult = new Vector ();
if (fInitialContext == null)
{
fInitialContext = new InitialContext ();
}
if (fComponentContext == null)
{
fComponentContext = (Context) fInitialContext.lookup
("java:comp/env");
}
theNamingEnumeration = fComponentContext.listBindings ("jdbc");
theReference = null;
if (theDBServletLogger != null)
{
theDBServletLogger.log ("DEBUG: Initializing Data Sources...");
}
while (theNamingEnumeration.hasMore ())
{
theBinding = (Binding) theNamingEnumeration.next ();
theJNDIName = theBinding.getName ();
theClassName = theBinding.getClassName ();
theReference = (Reference) theBinding.getObject ();
theResourceClassName = (String) theReference.getClassName ();
if (theDBServletLogger != null)
{
theDBServletLogger.log ("DEBUG: Adding DataSource...");
theDBServletLogger.log ("DEBUG: Name: " + theJNDIName);
theDBServletLogger.log ("DEBUG: Type: " + theClassName);
theDBServletLogger.log ("DEBUG: Value: " + theReference);
theDBServletLogger.log ("DEBUG: ResourceClassName: " +
theResourceClassName);
theDBServletLogger.log ("");
}
if (theResourceClassName.equals ("javax.sql.DataSource"))
{
theRefAddr = (RefAddr) theReference.get ("user");
theUserID = (String) theRefAddr.getContent ();
theRefAddr = (RefAddr) theReference.get ("password");
thePassword = (String) theRefAddr.getContent ();
theRefAddr = (RefAddr) theReference.get ("driverName");
theDriverName = (String) theRefAddr.getContent ();
theRefAddr = (RefAddr) theReference.get ("driverClassName");
theDriverClassName = (String) theRefAddr.getContent ();
if (theDBServletLogger != null)
{
theDBServletLogger.log ("DEBUG: theUserID: " + theUserID);
theDBServletLogger.log ("DEBUG: thePassword: " +
thePassword);
theDBServletLogger.log ("DEBUG: theDriverName: " +
theDriverName);
theDBServletLogger.log ("DEBUG: theDriverClassName: " +
theDriverClassName);
}
theURLConnectString = theDriverName;
theDBServletDataSourceSpec = new DBServletDataSourceSpec
(theJNDIName
, theDriverClassName,
theURLConnectString, theUserID, thePassword);
theResult.addElement (theDBServletDataSourceSpec);
}
}
return (theResult);
} // DBServletDataSourceReader::ReadJNDIDataSources:
____________________Reply Separator____________________
Subject: RE: tomcat 4 datasource Oracle help
Author: [EMAIL PROTECTED]
Date: 8/22/2001 5:48 AM
Pleae let me know how it goes for you as that is my goal for tomcat. However,
currently I am struggling with mod_jk
Pete
[EMAIL PROTECTED]
[EMAIL PROTECTED] (Jonathan Pierce) wrote:
>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></parame
t
>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></paramete
r
>>
> ...
>
>
>____________________Reply Separator____________________
>Subject: RE: tomcat 4 datasource casting
>Author: [EMAIL PROTECTED]
>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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Craig R.
>> McClanahan
>> Sent: Monday, August 20, 2001 6:16 PM
>> To: [EMAIL PROTECTED]
>> 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 [EMAIL PROTECTED] 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
>> >
>>
>>
>
>
__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas. Experience
the convenience of buying online with Shop@Netscape!
http://shopnow.netscape.com/
Get your own FREE, personal Netscape Mail account today at
http://webmail.netscape.com/
