I restarted tomcat, and it works now. But there is an exception
java.lang.Exception: The logfile= property and the turbine.logs= property
in the TurbineResources.properties file are null
or could not be found.
Where is the TurbineResources.properties file?
Fang
On Wed, 6 Jun 2001, Gary Clark wrote:
> 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]>
>
>
---------------------------------------------------------------------
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]>
