cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Fang Huang <fhua...@csee.umbc.edu>
Subject RE: use connection pool in esql
Date Wed, 06 Jun 2001 20:03:29 GMT
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:fhuang2@csee.umbc.edu]
> > Sent:	Wednesday, June 06, 2001 11:32 AM
> > To:	cocoon-users@xml.apache.org
> > 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: <cocoon-users-unsubscribe@xml.apache.org>
> > For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
> 
> ---------------------------------------------------------------------
> 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>
> 
> 




---------------------------------------------------------------------
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