Did you restart your servlet server (Tomcat in my case)? The change won't
take effect until you do. If you did, look in the log files of your servlet
server and see if you can find out why the connection failed.
Gary A. Clark
Systems Programmer
Software Services Group
JELD-WEN Information Systems
> -----Original Message-----
> From: Fang Huang [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, June 06, 2001 11:32 AM
> To: [EMAIL PROTECTED]
> Subject: use connection pool in esql
>
> 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.ed
> u: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]>
---------------------------------------------------------------------
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]>
