cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "warrell harries" <>
Subject Re: modular database action
Date Tue, 12 Feb 2008 20:11:21 GMT
I recommend you look at the sqltransformer component. Try the examples
and you should find this is the most generic approach

On 11/02/2008, Al Brown <> wrote:
> I'm trying to figure out how to use a mysql database in an cocoon action.
> I'm using cocoon 2.1.10
> I have a mysql database and forms for all the attributes of all the
> tables. When the form action returns the new values for
> all the attributes in a table what is the recommended way to get a basic
> sql update to happen.
> I found the modulardatabaseAction wiki document and I can see how I can
> make a descriptor file that describes a table but
> 1) where does this file go.
> 2) how does the sql update command get created?
> I guess I can just put jdbc command in a java class and use the
> <map:act> to call the class but it looks likes a
> lot of good folks have already solved this problem but the solution is
> not obvious to me. I found the ModularDatabaseActions wiki pages
> but I have not found a how-to or tutorial and where all the pieced go.
> I have seen the database connection stuff and the pooling stuff so it
> seems like I should not create another mysql connection in my java code
> but I do not know how to get at and use the connection in cocoon.
>  I can query my database using the sql transform and that works great.
> Now I need to get data back into the tables.
> Al
> --
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> For additional commands, e-mail:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message