Hi,
Any hints anyone? Joel Sather gave me a couple of replies, but I haven't
been able to proceed.
Thanks,
manav.
> ----- Original Message -----
> From: "Manavendra Gupta" <[EMAIL PROTECTED]>
> To: "Tomcat Users List" <[EMAIL PROTECTED]>
> Sent: Monday, November 18, 2002 8:59 PM
> Subject: Oracle thin client DataSource configuration with tomcat
>
>
> > Hi,
> >
> > I'm sure the gurus have discussed this issue a number of times and
> probably
> > found a solution too, but after reading all the documents i found, i
came
> to
> > a naught.
> >
> > Its the same problem: server.xml and web.xml seem to have been
configured
> > properly, yet when i try to obtain a datasource i get nothing.
> >
> > Here's the scenario:
> > setup: tomcat 4.0.3 LE, jdk1.4, RHL 7.3
> >
> > server.xml
> > <!-- RTI Billing Context -->
> > <Context path="/rti" docBase="rti" debug="0"
> > reloadable="true" crossContext="true">
> > <Logger
> className="org.apache.catalina.logger.FileLogger"
> > prefix="rti_log." suffix=".txt"
> > timestamp="true"/>
> > <Resource name="jdbc/RtiDB" auth="Container"
> > type="javax.sql.DataSource"/>
> > <ResourceParams name="jdbc/RtiDB">
> > <parameter>
> > <name>user</name>
> > <value>rti</value>
> > </parameter>
> > <parameter>
> > <name>password</name>
> > <value>rti</value>
> > </parameter>
> > <parameter>
> > <name>driverClassName</name>
> > <value>oracle.driver.OracleDriver</value>
> > </parameter>
> > <parameter>
> > <name>URL</name>
> >
> > <value>jdbc:odbc:thin:@rti:1521:rti?user=rti;password=rti</value>
> > </parameter>
> > <parameter>
> > <name>maxActive</name>
> > <value>20</value>
> > </parameter>
> > <parameter>
> > <name>maxIdle</name>
> > <value>10</value>
> > </parameter>
> > <parameter>
> > <name>maxWait</name>
> > <value>-1</value>
> > </parameter>
> > </ResourceParams>
> > </Context>
> >
> > web.xml
> > <!-- Resource references -->
> > <resource-ref>
> > <description>DB Connection</description>
> > <res-ref-name>jdbc/RtiDB</res-ref-name>
> > <res-type>javax.sql.DataSource</res-type>
> > <res-auth>Container</res-auth>
> > </resource-ref>
> >
> > DBTest.jsp
> > <%
> > String foo = "Not Connected";
> > String bar = "";
> >
> > javax.naming.Context ctx = new javax.naming.InitialContext();
> > javax.naming.Context envCtx = (javax.naming.Context)
> > ctx.lookup("java:comp/env");
> > if(ctx == null )
> > throw new Exception("Boom - No Context");
> >
> > javax.sql.DataSource ds =
> > (javax.sql.DataSource)envCtx.lookup("jdbc/RtiDB");
> >
> > if (ds != null) {
> > java.sql.Connection conn = ds.getConnection();
> > out.println("got a connection");
> > }
> > out.println("no luck yet");
> > %>
> >
> > And I never get the message "got a connection". Any clues?
> >
> > Btw, I have not touched the "Realm" - I don't understand what that is
> meant
> > for. Not yet.
> >
> > TIA,
> > Manav.
> >
> >
> > --
> > 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]>
