cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Oskar Werewka <...@poczta.onet.pl>
Subject Re: use connection pool in esql
Date Wed, 06 Jun 2001 19:01:20 GMT

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



-- 

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


Mime
View raw message