Hi Atishay, added your suggestion to the server.xml. While it is not the fix, I do have a different error listing. Is this a clue to you?
Eric current last listing of stack trace... Caused by: java.lang.NullPointerException at com.informix.jdbc.IfxDriver.checkURL(IfxDriver.java:473) at com.informix.jdbc.IfxDriver.acceptsURL(IfxDriver.java:297) at java.sql.DriverManager.getDriver(DriverManager.java:232) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773) ... 28 more original last listing of stack trace... java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDriver(DriverManager.java:243) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773) On Thu, 7 Oct 2004 19:17:14 +0530, Atishay Kumar <[EMAIL PROTECTED]> wrote: > On Wed, 6 Oct 2004 14:37:58 -0700, Eric Wulff <[EMAIL PROTECTED]> wrote: > > 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"> > > <Resource name="jdbc/test_connection" auth="Container" > type="javax.sql.DataSource"/> > is missing > > > <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: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > -- > :) > Atishay Kumar > Btech, SEM VII > DA-IICT > Gandhinagar - 382009 > India > ph: +91 9825383948 > /**************************************************************************** > * Learn the rules as you would need them to break them properly * > ****************************************************************************/ > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
