First, setup cocoon.properties (I'm creating a new pool called 'mypool'
which connects to a postgresql database called mydb).
processor.xsp.pool.database.mypool.driver=org.postgresql.Driver
processor.xsp.pool.database.mypool.url=jdbc:postgresql://localhost/mydb
processor.xsp.pool.database.mypool.username=myid
processor.xsp.pool.database.mypool.password=mypassword
processor.xsp.pool.database.mypool.maxConnections=3
processor.xsp.pool.database.mypool.expiryTime=3600000
(There may be more stuff needed to setup depending on your database)
Now, just replace the following lines:
<esql:driver>org.postgresql.Driver</esql:driver>
<esql:dburl>jdbc:postgresql://localhost/test</esql:dburl>
<esql:username>test</esql:username>
<esql:password>test</esql:password>
with:
<esql:pool>mypool</esql:pool>
Gary A. Clark
Systems Programmer
Software Services Group
JELD-WEN Information Systems
> -----Original Message-----
> From: Oskar Werewka [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, June 06, 2001 9:53 AM
> To: [EMAIL PROTECTED]
> Subject: Turbine without ESQL
>
>
> Can somebody just send me a fragment
> of code, which gets connections from
> Turbine pool?
>
> COCOON 1.8.2
>
> It will be very niece for me ;)
>
> Thanks,
> Oskar Werewka
>
>
>
> --
>
> 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]>
---------------------------------------------------------------------
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]>