Hi

I'm about to make an upgrade of my old Oracle 8 jsp server to a tomcat
server and would like to connect to the database using JNDI.

Normaly I would do something like this:

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn =
DriverManager.getConnection("jdbc:oracle:thin:@(protected)
sr","pass");

Now I have set up the JNDI in tomcat and get the connection like this:

Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/myoracle");
Connection conn = ds.getConnection();

Everything works fine, except when I uses Oracle
(oracle.jdbc.driver.OracleDriver) specific functions like this:

// CallableStatement cstmt
rs = cstmt.getCursor(1);

I figure out that what I worked with wasn't oracles classes, but a
regular JDBC classes (java.sql). I also tried this:

rs = ((OracleCallableStatement) cstmt).getCursor(1);


Does anyone have an Idea how to fix this?



Think this is the rows in server.xml. (Used the admin interface to set
it up)


      <Resource auth="Container" description="DB Connection"
name="jdbc/DEVELOP" scope="Shareable" type="javax.sql.DataSource"/>
      <Resource auth="Container" name="jdbc/myoracle"
scope="Shareable" type="javax.sql.DataSource"/>
      <Resource auth="Container" description="DB Connection"
name="DEVELOP" scope="Shareable" type="javax.sql.DataSource"/>
      <ResourceParams name="jdbc/myoracle">
       <parameter>
        <name>url</name>
        <value>jdbc:oracle:thin:@(protected)>
       </parameter>
       <parameter>
        <name>validationQuery</name>
        <value>select count(*) from usr.table</value>
       </parameter>
       <parameter>
        <name>maxIdle</name>
        <value>10</value>
       </parameter>
       <parameter>
        <name>maxActive</name>
        <value>20</value>
       </parameter>
       <parameter>
        <name>driverClassName</name>
        <value>oracle.jdbc.driver.OracleDriver</value>
       </parameter>
       <parameter>
        <name>maxWait</name>
        <value>-1</value>
       </parameter>
       <parameter>
        <name>username</name>
        <value>usr</value>
       </parameter>
       <parameter>
        <name>factory</name>

<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
       </parameter>
       <parameter>
        <name>password</name>
        <value>pwd</value>
       </parameter>
      </ResourceParams>

===========================================================================
To unsubscribe: mailto listserv@(protected)".
For digest: mailto listserv@(protected)".

Some relevant archives, FAQs and Forums on JSPs can be found at:

http://java.sun.com/products/jsp
http://archives.java.sun.com/jsp-interest.html
http://forums.java.sun.com
http://www.jspinsider.com