MySQL and Cocoon

From: Nesto (nesto11_at_libero.it)
Date: 01/19/04 

Date: Mon, 19 Jan 2004 12:44:29 +0100

Hi all!

I want to write some code that connects to a database from the Apache
Cocoon servlet, to check authentication data.
I have the user information (in this case username/password and other
info) in a remote MySQL database, for which I have already set a
connection pool in Cocoon (2.1.3).

One possible soution is to writing an action (a cocoon object that
permits the execution of java code) that checks the user parameters
(username/password) provided through a web form, with those stored in
the database. Here the problem, for me, is to write java code that reuse
the connection pool set for other purposes. I have no idea...
How can I retrieve the pool and perform the database queries/update/... ??

Please give some hint, or better (If you can) some code example.

Thank you a lot, and... sorry for my english ;-)

Bye,
Nesto

PS for Cocoon users: I can't use esql, logicsheets at this level, just
Java code inside an action.