Hello,
  I got a problem setting up my jdbc connection pool as described in 
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-resources-howto.html
<http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-resources-howto.html>
.
I use Oracle jdbc driver ojdbc14.jar and tomcat 4.0.4
My server.xml:
<Context path="/ROOT" docBase="ROOT" debug="4" reloadable="true">
          <Logger className="org.apache.catalina.logger.FileLogger"
                prefix="Imedgedb_log." suffix=".txt" timestamp="true" />
                <Resource name="jdbc/ImedgeDB" auth="CONTAINER" 
                type="javax.sql.DataSource" />  
            <ResourceParams name="jdbc/ImedgeDB">
                <parameter> <name>user</name> <value>i11dbs</value>
</parameter>
                <parameter><name>password</name><value>i11db5</value>
</parameter>
                <parameter> <name>driverClassName</name>
                <value>oracle.jdbc.driver.OracleDriver</value> </parameter>
                <parameter><name>url</name>
        
<value>jdbc:oracle:thin:@sunlab2:1521:chcity</value></parameter>
            </ResourceParams>
        </Context>

web.xml:

<resource-ref>
                <description>Imedge ph 3 Database for Admin
Applications</description>
                <res-ref-name>jdbc/ImedgeDB</res-ref-name>
                <res-type>javax.sql.DataSource</res-type>
                <res-auth>Container</res-auth>
        </resource-ref>

My JSP page is

  Context initCtx = new InitialContext();
        Context envCtx = (Context) initCtx.lookup("java:comp/env");
        DataSource ds = (DataSource)envCtx.lookup("jdbc/ImedgeDB");

which results in the following error message when I execute 
envCtx.lookup("jdbc/ImedgeDB"):

javax.servlet.ServletException: Exception creating DataSource:
tyrex/jdbc/xa/EnabledDataSource
        at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java:471)
        at org.apache.jsp.testfam$jsp._jspService(testfam$jsp.java:136)

javax.naming.NamingException: Exception creating DataSource:
tyrex/jdbc/xa/EnabledDataSource
        at
org.apache.naming.factory.TyrexDataSourceFactory.getObjectInstance(TyrexData
SourceFactory.java:233)
        at
org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.
java:165)
        at
javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:301)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:835)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:181)


Does anyone can help? 

Thank you

Eddie Liang
Database Architect
Phone: 630-297-1229


Reply via email to