You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Eddie Liang <el...@edge.com> on 2002/12/04 17:46:18 UTC
JNDI datasource can not create
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