I started using SQLTransformer and for a lot of things it works great. It doesn't do parameter substitution (AFAIK) so my queries/inserts/updates are built dynamically and build the query explicitly. I'm sure there are still a lot of Cocoon apps deployed and currently being built using this stable technology.
Most of my code has been converted to use OJB so my object model is independent (mostly) from the database code used to persist the model. Other developers are using Hibernate or Castor. Since these are ubiquitous techologies at this point you won't see too much discussion about them unless someone has problems. Using an ORM (and many would argue together with CForms and flow) is the way to go especially if your object model already exists or is expected to be reused in another context.
The beauty of Cocoon is its ability to provide integration with all of these persistence mechanisms.
Hope this helps, Steve
Thanks for the tip. I started with SqlTransformer because I *thought* that it was the
new/improved/suggested way of doing things with sql.
I'm starting to get the impression db support is low priority here. I guess that's fine... I
guess I just could've figured it out sooner :)
--- "Anderson J. Vitous" <[EMAIL PROTECTED]> wrote:
> I've not done anything using SqlTransformer, but parameter binding can
> be done with ESQL in XSPs, in which your query becomes something like
>
> <esql:query>
> select * from foo
> where foo_date <
> <esql:parameter><xsp:expr>datevar</xsp:expr></esql:parameter>
> </esql:query>
>
> That being said, I've had trouble doing this with date values but
> instead of looking for a 'proper' solution just did format conversion
> and passed strings...
>
> HTH,
> Anderson
>
> On 7/6/2004 1:05 PM, Terry Brick wrote:
>
> > Anyone?
> > Am I the only one attempting serious database back-end work with cocoon?
> >
> > --- Terry Brick <[EMAIL PROTECTED]> wrote:
> >
> >>Looking through the doc and the source code, I don't see that it's possible to use standard
> JDBC
> >>query parameter binding. I would've expected to be able to do something like this...
> >>
> >><query>
> >>select * from foo where foo_date < ?
> >><param type="date" value="${datevar}"/>
> >></query>
> >>
> >>.... or something along those lines.
> >>
> >>Is something like this possible? If not, I would conside the SqlTransformer thing not ready
> for
> >>prime time.... what would be the suggested approach (besides implementing an entirely custom
> >>approach, which I AM leaning toward at this point)?
> >>
_________________________________________________________________
MSN Toolbar provides one-click access to Hotmail from any Web page – FREE download! http://toolbar.msn.click-url.com/go/onm00200413ave/direct/01/
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
