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