You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cocoon.apache.org by bu...@apache.org on 2002/02/05 12:54:43 UTC

DO NOT REPLY [Bug 6242] New: - SQL Transformer Infinite Loop

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: cocoon-dev@xml.apache.org
        ReportedBy: joao_g_fonseca@yahoo.com


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: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org