DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=31304>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=31304

NoClassDefFoundError: org/apache/commons/collections/CursorableLinkedList





------- Additional Comments From [EMAIL PROTECTED]  2004-09-21 00:01 -------
Yoav,

All that was added was the mysql-connector JAR to common/lib and a session
counting listener to common/classes. Both WEB-INF/lib and WEB-INF/classes are empty.

--- # jar tf common/lib/commons-collections-3.1.jar ---

org/apache/commons/collections/CursorableLinkedList$Listable.class
org/apache/commons/collections/CursorableLinkedList$ListIter.class
org/apache/commons/collections/CursorableLinkedList$Cursor.class
org/apache/commons/collections/CursorableLinkedList.class

So yes it exists in mine as well. To be expected really since I haven't modified
anything.

--- context config ---

  <Resource auth="container" name="jdbc/test" type="javax.sql.DataSource"/>
  <ResourceParams name="jdbc/test">
    <parameter>
      <name>url</name>
      <value>jdbc:mysql://dev:3306/test?autoReconnect=true</value>
    </parameter>
    <parameter>
      <name>validationQuery</name>
      <value>select id, foo, bar from testdata</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>5</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>100</value>
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>com.mysql.jdbc.Driver</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>10000</value>
    </parameter>
    <parameter>
      <name>removeAbandoned</name>
      <value>true</value>
    </parameter>
    <parameter>
      <name>factory</name>
      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>test</value>
    </parameter>
    <parameter>
      <name>logAbandoned</name>
      <value>true</value>
    </parameter>
    <parameter>
      <name>removeAbandonedTimeout</name>
      <value>60</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>test</value>
    </parameter>
  </ResourceParams>

--- WEB-INF/web.xml ---

<resource-ref>
  <description>
    DB Connection Pool
  </description>
  <res-ref-name>
    jdbc/test
  </res-ref-name>
  <res-type>
    javax.sql.DataSource
  </res-type>
  <res-auth>
    Container
  </res-auth>
</resource-ref>

--- test JSP ---

<%@ page import="java.sql.*,
                 javax.naming.Context,
                 javax.naming.InitialContext,
                 javax.sql.DataSource"%>
<%
  Context initContext = new InitialContext();
  Context envContext  = (Context)initContext.lookup("java:/comp/env");
  DataSource ds = (DataSource)envContext.lookup("jdbc/test");
  Statement stmt = null;
  ResultSet rs = null;
  Connection conn = null;
  if (ds != null) {
  try {
    conn = ds.getConnection();
    stmt = conn.createStatement();
    rs = stmt.executeQuery("select id, foo, bar from testdata");
    while (rs.next()) {
       %>id: <%= rs.getInt("id") %>, foo: <%= rs.getString("foo") %>, bar: <%=
rs.getInt("bar") %><br/><%
    }
    rs.close();
    rs = null;
    stmt.close();
    stmt = null;
    conn.close();
    conn = null;
  } catch (SQLException e) { ; } finally {
    if (rs != null) {
      try { rs.close(); } catch (SQLException e) { ; }
      rs = null;
    }
    if (stmt != null) {
      try { stmt.close(); } catch (SQLException e) { ; }
      stmt = null;
    }
    if (conn != null) {
      try { conn.close(); } catch (SQLException e) { ; }
      conn = null;
    }
  }
  } else {
      %> DataSource is null <%
  }
%>

I also have a page that performs the same function but by going directly using
the same settings i.e. Class.forName ... etc ...

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

Reply via email to