DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=6242>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=6242 SQL Transformer Infinite Loop Summary: SQL Transformer Infinite Loop Product: Cocoon 2 Version: 2.0 Platform: All OS/Version: Other Status: NEW Severity: Normal Priority: Other Component: general components AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] The SQL Transformer, when trying to acquire a DB connection starts an infinite loop if the DB is not available. An excerpt of my log: DEBUG (2002-02-01) 12:04.43:612 [cocoon ] (/ptprime/np/sql/er_message/list.html) HttpProcessor[20000] [1]/SQLTransformer$Query: SQLTransformer$Query: could not acquire a Connection -- waiting 0 ms to try again. WARN (2002-02-01) 12:04.43:613 [cocoon ] (/ptprime/np/sql/er_message/list.html) HttpProcessor[20000][1]/JdbcDataSource: Could not return Connection java.lang.IllegalStateException: There are no connections in the pool, check your settings. at org.apache.avalon.excalibur.datasource.JdbcConnectionPool.get (Unknown Source) at org.apache.avalon.excalibur.datasource.JdbcDataSource.getConnection (Unknown Source) at org.apache.cocoon.transformation.SQLTransformer$Query.getConnection (SQLTransformer.java, Compiled Code) at org.apache.cocoon.transformation.SQLTransformer$Query.execute (SQLTransformer.java, In SQLTransformer.java: long waittime = 5000 * (long) Math.random(); waittime will always be 0! "(long) Math.random" is converted to 0 before being multiplied by 5000. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
