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]
