Chits,
you can take a look at the SQLTransformer source code, which is included in
Cocoon.
Regarding the datasource, here it is (you should place it in cocoon.xconf):
<datasources>
<jdbc name="noria-dev">
<pool-controller min="5" max="10" oradb="true"/>
<dburl>jdbc:oracle:thin:@localhost:1521:sid</dburl>
<user>user</user>
<password>password</password>
</jdbc>
</datasources>
I hope this can help...
---------------------------------------------
Luca Morandini
GIS Consultant
[EMAIL PROTECTED]
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
> -----Original Message-----
> From: Chitharanjan Das [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 07, 2002 6:35 AM
> To: [EMAIL PROTECTED]
> Subject: FW:
>
>
>
> Hello All,
> I am planning to provide the user authentication procedure via
> an Action.
> How do I access the datasource from JAVA code, to obtain a
> connection?
>
> Please include datasource example for oracle and sample code in
> JAVA to access the named datasource.
>
>
> Regds,
> Chiths
>
>
>
> ---------------------------------------------------------------------
> 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]>
