Re: DBCP Please Help Get Working Properly

David Smith Mon, 11 Apr 2005 06:19:10 -0700

Ok, define 'no results'. In reality, the naming import isn't the only thing that changed. Your web.xml file *looks* like 2.3 spec from what I can see and you are using JSP 2.x spec syntax in your jsp. If you want the JSP 2.x spec features, you need to declare your web.xml file for servlet 2.4 spec. This should be up at the top of your web.xml (pasted from the specification for servlet 2.4):

<?xml version="1.0" encoding="ISO-8859-1"?>

<web-app 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”;
version=”2.4”>

Then just put all your servlet-mappings, etc., ... after that. The taglib declarations need to be inside a <jsp-config> element for the 2.4 spec web.xml file too. That's how I'm guessing you have a 2.3 spec web.xml file. The full spec can be found at http://www.jcp.org/en/jsr/detail?id=154

--David

Scott Purcell wrote:

Hello,
I am trying to use the DBCP features of Tomcat 5.5.7. I created a webapp named 
"testDB" and put it under $CATALINA_HOME/webapps/testDB. Then I created a 
testDB.xml file under $CATALINA_HOME/conf/Catalina/localhost/testDB.xml.
// here it is
<Context path="/testDB" docBase="testDB"
       debug="5" reloadable="true" crossContext="true">
 <Resource name="jdbc/testDB" auth="Container" type="javax.sql.DataSource"
              maxActive="100" maxIdle="30" maxWait="10000"
              username="javauser" password="javadude" 
driverClassName="com.mysql.jdbc.Driver"
              url="jdbc:mysql://localhost:3306/fritest?autoReconnect=true"/>
</Context>
I have been following the notes from: http://localhost/tomcat-docs/jndi-datasource-examples-howto.html
I made sure I completed the rest of the tasks.
WEB-INF has the two tag locations, and the resource ref.
eg:
   <taglib>
   <taglib-uri>/WEB-INF/sql.tld</taglib-uri>
   <taglib-location>/WEB-INF/sql.tld</taglib-location>
   </taglib>
   <taglib>
   <taglib-uri>/WEB-INF/c.tld</taglib-uri>
   <taglib-location>/WEB-INF/c.tld</taglib-location>
   </taglib>
 <resource-ref>
     <description>DB Connection</description>
     <res-ref-name>jdbc/testDB</res-ref-name>
     <res-type>javax.sql.DataSource</res-type>
     <res-auth>Container</res-auth>
 </resource-ref>
I finally hit my jsp page which is this:
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql"; prefix="sql" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core"; prefix="c" %>
<sql:query var="rs" dataSource="jdbc/testDB">
select id, foo, bar from testdata
</sql:query>
<html>
 <head>
   <title>DB Test</title>
 </head>
 <body>
<h2>Results</h2> <c:forEach var="row" items="${rs.rows}"> Foo ${row.foo}<br/> Bar ${row.bar}<br/> </c:forEach>
 </body>
</html>
And I get no results:
Now I am pretty sure I have all configured. Because if I use a fallback (Tomcat 
4.1) code piece I had, I get results using the same settings:
package foo;
import javax.naming.*;
import javax.sql.*;
import java.sql.*;
public class DBTest {
String foo = "Not Connected"; int bar = -1; public void init() { try{ Context ctx = new InitialContext(); if(ctx == null ) throw new Exception("Boom - No Context");

DataSource ds = (DataSource)ctx.lookup( "java:comp/env/jdbc/testDB");

if (ds != null) { Connection conn = ds.getConnection(); if(conn != null) { foo = "Got Connection "+conn.toString(); Statement stmt = conn.createStatement(); ResultSet rst = stmt.executeQuery( "select id, foo, bar from testdata"); while(rst.next()) { System.out.println("next ...."); foo=rst.getString(2); bar=rst.getInt(3); } conn.close(); } } }catch(Exception e) { e.printStackTrace(); } }
public String getFoo() { return foo; }
public int getBar() { return bar;}
}
And using the above class works all day.
The only difference I see is that the class using a "naming" import and the jsp 
does not. Can anyone help.
Thanks,
Scott
-----Original Message-----
From: David Smith [mailto:[EMAIL PROTECTED]
Sent: Friday, April 08, 2005 1:14 PM
To: Tomcat Users List
Subject: Re: Add Context Path, Tomcat 5.5.7
Hi.
Take a look at this for where to put <Context> elements:
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/config/context.html
This is new with Tomcat 5.0 and is continued in Tomcat 5.5
--David
Scott Purcell wrote:
Hello,
I am following the information here to add DBCP to my application.
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples-howto.html
I am reading to add the <Context path="/DBTest ... from the above docs." The 
instructions say to ".
Configure the JNDI DataSource in Tomcat by adding a declaration for your 
resource to $CATALINA_HOME/conf/server.xml.
Add this in between the </Context> tag of the examples context and the </Host> 
tag closing the localhost definition.
So cool, I opened up the server.xml, but do not see any existing context or 
host tags in it. Here is my server.xml file. Does anyone know where I put the 
Context for the DBCP stuff? Thanks,
'


<Server port="8005" shutdown="SHUTDOWN">
 <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener" /> <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" /> <Listener className="org.apache.catalina.storeconfig.StoreConfigLifecycleListener"/>

<GlobalNamingResources>
  
  <Environment name="simpleValue" type="java.lang.Integer" value="30"/>
  
  <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" />
</GlobalNamingResources>


<Service name="Catalina">
  
  
  <Connector
port="80"               maxThreads="150" minSpareThreads="25" 
maxSpareThreads="75"
             enableLookups="false" redirectPort="8443" acceptCount="100"
             connectionTimeout="20000" disableUploadTimeout="true" />
  


 

 <Connector port="8009" enableLookups="false" redirectPort="8443" protocol="AJP/1.3" />

  
  
  <Engine name="Catalina" defaultHost="localhost">
    
    
    
    
    <Realm className="org.apache.catalina.realm.UserDatabaseRealm"
           resourceName="UserDatabase"/>
    
    
    
    
    
    
    
    <Host name="localhost" appBase="webapps"
     unpackWARs="true" autoDeploy="true"
     xmlValidation="false" xmlNamespaceAware="false">
        
      
      
      
      
      
      
    </Host>
  </Engine>
</Service>
</Server>
Scott K Purcell | Developer | VERTIS | 555 Washington Ave. 4th Floor | St. Louis, MO 63101 | 314.588.0720 Ext:1320 | [EMAIL PROTECTED] | http://www.vertisinc.com <http://www.vertisinc.com/>

Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: DBCP Please Help Get Working Properly

Reply via email to