I have the same configuration, and it is working?
Did you restart cocoon after hanging cocoon.properties?
>Hi, I was trying to use connection pool in esql, but I still got error:
>java.lang.RuntimeException: Could not open pooled connection: mypool
>
>In cocoon.properties, I add mypool definition as follows:
>processor.xsp.pool.database.mypool.driver=oracle.jdbc.driver.OracleDriver
>processor.xsp.pool.database.mypool.url=jdbc:oracle:thin:@oracle.gl.umbc.edu:1521:GL
>processor.xsp.pool.database.mypool.username=user
>processor.xsp.pool.database.mypool.password=user
>processor.xsp.pool.database.mypool.maxConnections=3
>processor.xsp.pool.database.mypool.expiryTime=3600000
>
>And in my xsp file, I use:
><esql:connection>
> <esql:pool>mypool</esql:pool>
> <esql:execute-query>
> ...
>
>I can get the correct results when I use
><esql:connection>
> <esql:driver>oracle.jdbc.driver.OracleDriver</esql:driver>
> <esql:dburl>jdbc:oracle:thin:@oracle.gl.umbc.edu:1521:GL</esql:dburl>
> <esql:username>user</esql:username>
> <esql:password>user</esql:password>
> <esql:execute-query>
>
>What's wrong with the connection pool? Thanks.
>
>Fang
>
>
>---------------------------------------------------------------------
>Please check that your question has not already been answered in the
>FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
>
>To unsubscribe, e-mail: <[EMAIL PROTECTED]>
>For additional commands, e-mail: <[EMAIL PROTECTED]>
--
Kamera wideo Sony, 5000 zl
wygraj w konkursie eMarketu i Onet.pl [ http://konkursy.onet.pl/emarket ]
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>