adding a Datasource to tomcat jndi

[shawn peter]

here is i got error

Jun 23, 2009 2:36:09 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent   
INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\software\virclipse-2.0\jre\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\software\virclipse-2.0\jre\bin\client;C:\software\virclipse-2.0\jre\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Windows Imaging\;C:\java\j2sdk1.4.2_13\bin;C:\Program Files\Apache Software Foundation\Tomcat 5.5\bin;.;C:\Program Files\CVSNT\;.   
Jun 23, 2009 2:36:09 PM org.apache.coyote.http11.Http11BaseProtocol init   
INFO: Initializing Coyote HTTP/1.1 on http-8080  
Jun 23, 2009 2:36:09 PM org.apache.catalina.startup.Catalina load   
INFO: Initialization processed in 1078 ms   
Jun 23, 2009 2:36:09 PM org.apache.catalina.core.StandardService start   
INFO: Starting service Catalina   
Jun 23, 2009 2:36:09 PM org.apache.catalina.core.StandardEngine start   
INFO: Starting Servlet Engine: Apache Tomcat/5.5.17  
Jun 23, 2009 2:36:09 PM org.apache.catalina.core.StandardHost start   
INFO: XML validation disabled   
Jun 23, 2009 2:36:10 PM org.apache.coyote.http11.Http11BaseProtocol start   
INFO: Starting Coyote HTTP/1.1 on http-8080  
Jun 23, 2009 2:36:10 PM org.apache.jk.common.ChannelSocket init   
INFO: JK: ajp13 listening on /0.0.0.0:8009  
Jun 23, 2009 2:36:10 PM org.apache.jk.server.JkMain start   
INFO: Jk running ID=0 time=0/31  config=null  
Jun 23, 2009 2:36:10 PM org.apache.catalina.storeconfig.StoreLoader load   
INFO: Find registry server-registry.xml at classpath resource   
Jun 23, 2009 2:36:11 PM org.apache.catalina.startup.Catalina start   
INFO: Server startup in 1516 ms   
javax.naming.NameNotFoundException: Name UserDatabase is not bound in this Context   
    at org.apache.naming.NamingContext.lookup(NamingContext.java:769)   
    at org.apache.naming.NamingContext.lookup(NamingContext.java:152)   
    at com.microdeveloper.db.jndi.ConnectionPool.init(ConnectionPool.java:23)   
    at org.apache.jsp.index_jsp._jspService(index_jsp.java:48)   
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)   
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)   
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)   
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)   
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)   
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)   
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)   
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)   
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)   
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)   
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)   
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)   
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)   
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)   
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)   
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)   
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)   
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)   
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)   
    at java.lang.Thread.run(Unknown Source) 

here is my context.xml in tomcat/conf

<?xml version="1.0" encoding="ISO-8859-1"?>   
<!-- The contents of this file will be loaded for each web application -->   
<Context>   
  
    <!-- Default set of monitored resources -->   
    <WatchedResource>WEB-INF/web.xml</WatchedResource>   
       
    <!-- Uncomment this to disable session persistence across Tomcat restarts -->   
  
    <Manager pathname="" />   
<ResourceLink global="jdbc/R1100" name="jdbc/R1100" type="oracle.jdbc.pool.OracleDataSource"/>   
<ResourceLink global="UserDatabase" name="UserDatabase" type="org.apache.catalina.UserDatabase"/>   
  
</Context>  

here is my server.xml

<GlobalNamingResources>   
  
    <!-- Test entry for demonstration purposes -->   
    <Environment name="simpleValue" type="java.lang.Integer" value="30"/>   
  
    <!-- Editable user database that can also be used by   
         UserDatabaseRealm to authenticate users -->   
    <Resource name="UserDatabase" auth="Container"  
              type="org.apache.catalina.UserDatabase"  
       description="User database that can be updated and saved"  
           factory="org.apache.catalina.users.MemoryUserDatabaseFactory"  
          pathname="conf/tomcat-users.xml" />   
  
    <Resource name="jdbc/R1100" auth="Container"  
    type="oracle.jdbc.pool.OracleDataSource"    
    driverClassName="oracle.jdbc.driver.OracleDriver"    
    factory="oracle.jdbc.pool.OracleDataSourceFactory"    
    url="jdbc:oracle:thin:@172.28.4.232:1521:ORA920"    
    user="r1100_dev_usr" password="r1100_dev_usr"    
    maxActive="20" maxIdle="10" maxWait="-1" />    
  
  
  </GlobalNamingResources> 

here is my application code

package com.microdeveloper.db.jndi;   
import oracle.jdbc.pool.OracleDataSource;   
  
import javax.naming.Context;   
import javax.naming.InitialContext;   
import java.io.Serializable;   
import java.sql.Connection;   
import java.sql.SQLException;   
import java.sql.ResultSet;   
import java.sql.Statement;   
import java.util.Properties;   
  
public class ConnectionPool implements Serializable {   
   String message = "Not Connected";   
   public void init() {   
          
   Connection conn = null;   
   ResultSet rst = null;   
   Statement stmt = null;   
   try {   
      Context initContext = new InitialContext();   
      Context envContext = (Context) initContext.lookup("java:/comp/env");   
      OracleDataSource ds = (OracleDataSource) envContext.lookup("UserDatabase");   
            if (envContext == null) throw new Exception("Error: No Context");   
     if (ds == null) throw new Exception("Error: No DataSource");   
     if (ds != null) conn = ds.getConnection();     if (conn != null) {   
        message = "Got Connection " + conn.toString() + ", ";   
        stmt = conn.createStatement();   
        rst = stmt.executeQuery("SELECT 'Success obtaining connection' FROM DUAL");   
     }   
     if (rst.next()) message = rst.getString(1);   
  
   rst.close();   
   rst = null;   
   stmt.close();   
   stmt = null;   
   conn.close(); // Return to connection pool   
   conn = null; // Make sure we don't close it twice    
   }    
   catch (Exception e) {   
   e.printStackTrace();   
 } finally {   
   // Always make sure result sets and statements are closed,   
   // and the connection is returned to the pool   
   if (rst != null) {   
      try {   
         rst.close();   
      } catch (SQLException e) {;}   
      rst = null;   
   }   
  
   if (stmt != null) {   
      try {   
         stmt.close();   
      } catch (SQLException e) {;}   
      stmt = null;   
   }   
  
   if (conn != null) {   
      try {   
         conn.close();   
      } catch (SQLException e) {;}   
      conn = null;   
   }   
 }   
}   
   public String getMessage() {return message;}} 

[Tim Holloway]

You should only put the datasource in server.xml if you intend to make it available to multiple webapps as a common definition. Otherwise, set up a context xml file in CATALINA_HOME/conf/Catalina/localhost for the specific webapp that uses it. Alternatively, you can create a META-INF/context.xml file and store it in your WAR.

Here's one I have embedded in an application Context:

    <Resource name="jdbc/myDS" auth="Container"
        type="javax.sql.DataSource" maxActive="100" maxIdle="30"
        maxWait="10000" username="dbuser" password="secret"
        driverClassName="org.postgresql.Driver"
        url="jdbc:postgresql://database.mousetech.com/mydatabase"
    />

I have a web.xml entry to go with it - and that may be what you're missing.

    <resource-ref id="datasource">
        <description>DB Connection</description>
        <res-ref-name>jdbc/myDS</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>

I then use the JDNI key java:/comp/env/jdbc/myDS to locate it.

[shawn peter]

here i change my project as below.now my classes are like these.

web.xml file in my application.

<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
	<display-name>
	MyJnDI</display-name>
	<welcome-file-list>
		<welcome-file>index.html</welcome-file>
		<welcome-file>index.htm</welcome-file>
		<welcome-file>index.jsp</welcome-file>
		<welcome-file>default.html</welcome-file>
		<welcome-file>default.htm</welcome-file>
		<welcome-file>default.jsp</welcome-file>
	</welcome-file-list>
	
	<resource-ref>
   <description>Dtasource</description>
   <res-ref-name>UserDatabase</res-ref-name>
   <res-type>oracle.jdbc.pool.OracleDataSource</res-type>
   <res-auth>Container</res-auth>
</resource-ref>
	
</web-app>

Server.xml file at tomcat/conf

  <Resource name="UserDatabase" auth="Container"
              type="org.apache.catalina.UserDatabase"
       description="User database that can be updated and saved"
           factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
          pathname="conf/tomcat-users.xml" />

	<Resource name="UserDatabase" auth="Container"
	type="oracle.jdbc.pool.OracleDataSource" 
	driverClassName="oracle.jdbc.driver.OracleDriver" 
	factory="oracle.jdbc.pool.OracleDataSourceFactory" 
	url="jdbc:oracle:thin://172.28.4.232:1521:ORA920" 
	user="r1100_dev_usr" password="r1100_dev_usr" 
	maxActive="20" maxIdle="10" maxWait="-1" /> 


  </GlobalNamingResources>

context.xml at tomcat/conf

<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- The contents of this file will be loaded for each web application -->
<Context>

    <!-- Default set of monitored resources -->
    <WatchedResource>WEB-INF/web.xml</WatchedResource>
	
    <!-- Uncomment this to disable session persistence across Tomcat restarts -->

    <Manager pathname="" />
<ResourceLink global="UserDatabase" name="UserDatabase" type="oracle.jdbc.pool.OracleDataSource"/>
<ResourceLink global="UserDatabase" name="UserDatabase" type="org.apache.catalina.UserDatabase"/>

</Context>

The error i got

Jun 23, 2009 5:52:34 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\software\virclipse-2.0\jre\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\software\virclipse-2.0\jre\bin\client;C:\software\virclipse-2.0\jre\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Windows Imaging\;C:\java\j2sdk1.4.2_13\bin;C:\Program Files\Apache Software Foundation\Tomcat 5.5\bin;.;C:\Program Files\CVSNT\;.
Jun 23, 2009 5:52:34 PM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Jun 23, 2009 5:52:34 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 937 ms
Jun 23, 2009 5:52:34 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jun 23, 2009 5:52:34 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.17
Jun 23, 2009 5:52:34 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Jun 23, 2009 5:52:35 PM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Jun 23, 2009 5:52:35 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Jun 23, 2009 5:52:35 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/31  config=null
Jun 23, 2009 5:52:35 PM org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
Jun 23, 2009 5:52:35 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 1032 ms
javax.naming.NamingException: Cannot create resource instance
	at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:142)
	at javax.naming.spi.NamingManager.getObjectInstance(Unknown Source)
	at org.apache.naming.NamingContext.lookup(NamingContext.java:792)
	at org.apache.naming.NamingContext.lookup(NamingContext.java:152)
	at com.microdeveloper.db.jndi.ConnectionPool.init(ConnectionPool.java:23)
	at org.apache.jsp.welcome_jsp._jspService(welcome_jsp.java:48)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Unknown Source)

[Tim Holloway]

You did not specify a context path or docBase in your Context xml file. Without them, there's no way for the server to match a specific webapp with a specific context definition.

[shawn peter]

can you please tell me the what should i include in context file.

[Tim Holloway]

<Context path="/myapp"
    docBase="/home/timh/workspace/myapp/target/myapp"
>

This will make the web application "myapp" be addressable by the URL http://myserver/myapp and use the exploded WAR directory /home/timh/workspace/myapp/target/myapp