Return-Path: 
 <tomcat-user-return-112086-apmail-jakarta-tomcat-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org
Received: (qmail 25980 invoked from network); 6 Oct 2004 21:52:03 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 6 Oct 2004 21:52:03 -0000
Received: (qmail 5390 invoked by uid 500); 6 Oct 2004 21:51:34 -0000
Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org
Received: (qmail 5311 invoked by uid 500); 6 Oct 2004 21:51:33 -0000
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:tomcat-user-subscribe@jakarta.apache.org>
List-Help: <mailto:tomcat-user-help@jakarta.apache.org>
List-Post: <mailto:tomcat-user@jakarta.apache.org>
List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org>
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 5298 invoked by uid 99); 6 Oct 2004 21:51:33 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=NO_REAL_NAME
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from [202.37.93.67] (HELO HONDANET.HONDA.CO.NZ) (202.37.93.67)
  by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 06 Oct 2004 14:51:30 -0700
Subject: Re: connection pooling
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
X-Mailer: Lotus Notes Release 5.0.8  June 18, 2001
Message-ID: <OF259E4907.6E2D11E6-ONCC256F25.0077C7CD@HONDA.CO.NZ>
From: jthompson@honda.co.nz
Date: Thu, 7 Oct 2004 10:49:15 +1300
X-MIMETrack: Serialize by Router on HONDA01/XB/HONDA(Release 6.0.2CF1|June 9,
 2003) at
 10/07/2004 10:49:19
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N






Please ignore my last post - it's wrong.
(Answered before verifying).

John Thompson


|---------+---------------------------->
|         |           Eric Wulff       |
|         |           <ewulff@gmail.com|
|         |           >                |
|         |                            |
|         |           07/10/2004 10:37 |
|         |           AM               |
|         |           Please respond to|
|         |           "Tomcat Users    |
|         |           List"            |
|         |                            |
|---------+---------------------------->
  >--------------------------------------------------------------------------------------------------------------|
  |                                                                                                              |
  |       To:       tomcat-user@jakarta.apache.org                                                               |
  |       cc:                                                                                                    |
  |       Subject:  connection pooling                                                                           |
  >--------------------------------------------------------------------------------------------------------------|




I have gone over some of the tomcat docs and googled errors
but there is SO much information covering JNDI, connection pooling,
and Datasources.  Can someone review the info below and consult or
point me in the right direction?  Although I feel I'm missing
something obvious, I can't find out what's wrong with my set-up.

thx
Eric

System:
Tomcat 5 on Fedora Core 2 connecting to a db on an Informix Dynamic
Server 9.4 on Windows Server

-I am able to connect to my db via typical JDBC
DriverManager.getConnection().  This leads me to believe that my
informix jdbc driver is in the correct place...
CATALINA_HOME/common/lib
-I have a Context set up in my server.xml per examples in a text
tutorial I'm referencing

Below listed...
-errors
-web.xml
-server.xml <Context> (minus connection actual values)
-.java

exception/errors:
-Exception: org.apache.commons.dbcp.SQLNestedException: Cannot create
JDBC driver of class '' for connect URL 'null'
SQL state: null
Error code: 0

-stack trace reveals this, but I can't see why since I have the driver
in the correct directory...
java.sql.SQLException: No suitable driver at
java.sql.DriverManager.getDriver(DriverManager.java:243) at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)


web.xml:
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app
    PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
    "http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
 <servlet>
  <servlet-name>Test Connection Pooling</servlet-name>
  <servlet-class>TestConnectionPooling</servlet-class>
 </servlet>

 <servlet-mapping>
  <servlet-name>Test Connection Pooling</servlet-name>
  <url-pattern>/testConnectionPooling</url-pattern>
 </servlet-mapping>

 <resource-ref>
   <res-ref-name>jdbc/test_connect</res-ref-name>
   <res-type>javax.sql.DataSource</res-type>
   <res-auth>Container</res-auth>
 </resource-ref>
</web-app>


server.xml <Context>:
  <Context path="/testConnectionPooling"
docBase="testConnectionPooling" debug="0" reloadable="true">
    <ResourceParams name="jdbc/test_connect">
      <parameter>
        <name>username</name>
        <value>informix</value>
      </parameter>
      <parameter>
        <name>password</name>
        <value>informix</value>
      </parameter>
      <parameter>
        <name>driverClassName</name>
        <value>com.informix.jdbc.IfxDriver</value>
      </parameter>
      <parameter>
        <name>url</name>
<value>jdbc:informix-sqli://url:port/dbName:INFORMIXSERVER=serverName</value>
      </parameter>
    </ResourceParams>
  </Context>


.java:
import java.io.*;
import java.sql.*;
// -Must import javax.naming use JNDI which is required to implement data
//   resource references and hence connection pooling.
import javax.naming.*;
import javax.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;

public class TestConnectionPooling extends HttpServlet {
 private DataSource dataSource;

 public void init(ServletConfig config) throws ServletException {
  try {
   Context init = new InitialContext();
   // don't know what the 'java:comp/env' refers to
   Context ctx = (Context) init.lookup("java:comp/env");
   // I know "jdbc/conversion must match the web.xml res-ref-name of
the web.xml but don't know what the path really refers to
   dataSource = (DataSource) ctx.lookup("jdbc/test_connect");
  } catch (NamingException ex) {
   throw new ServletException("Cannot retrieve
java:comp/env/jdbc/test_connect",ex);
  }
 }

 public void doGet(HttpServletRequest request, HttpServletResponse
 response)
 throws ServletException, IOException {
  response.setContentType("text/html");
  PrintWriter out = response.getWriter();
  Connection connection = null;
  out.println ("<HTML><HEAD><TITLE>Test Connection
Pooling</TITLE></HEAD><BODY>");
  out.println("<H1>Customer Name Query</H1>");

  try {
   synchronized(dataSource) {
       connection = dataSource.getConnection();
   }
   out.println("<br>");
   out.println("<strong>Loaded informix driver successfully via
server.xml.</strong>" +
      "Now attempting db connection.");
   out.println("<br>");
   PreparedStatement pstmt = connection.prepareStatement("SELECT blah
FROM blah blah");
   ResultSet results = pstmt.executeQuery();
   if (!results.next()) {
    throw new SQLException("No data returned for some reason");
   }
   out.println("<br>");
   while(results.next()) {
    out.println("<tr><td>" + results.getString("blah") + "</td></tr>");
   }
        } catch (Exception ex) {
   out.println("<br>");
   out.println("Exception: " + ex);
   if(ex instanceof SQLException) {
    SQLException sqlex = (SQLException) ex;
    out.println("<br>");
    out.println("SQL state: "+sqlex.getSQLState()+"<BR>");
    out.println("<br>");
    out.println("Error code: "+sqlex.getErrorCode()+"<BR>");
    out.println("<br><br>");
    sqlex.printStackTrace(out);
    out.println("<br><br>");
   }
        }
        finally {
            try { connection.close(); } catch (Exception ex) {}
        }
  out.println ("</BODY></HTML>");
    }
}

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org