Thanks for the info. It at least helps me understand where other cocoon users are
coming from. I
use OJB on a struts project and it works great for that app where I'm doing a lot of
database
writing from form entries, etc. However, I never like OJB for query intensive
apps.... which is
exactly what I'm using Cocoon for. This app will do little-to-no writing to the
database but I
will need to be unrestricted in my SQL query capabilities.
As for parameter binding, yeah, it's not absolutely essential, and there are
workarounds. I see
it kind of as if I was looking at luxury cars.... If someone told me the car didn't
have a most
basic feature like power windows, I'd just assume that it's probably missing a lot of
other
things.
And that's why Cocoon worries me.. I still think it's great, but I'm a little
concerned about
what's around the corner as I get more and more involved in it.
--- Steve Schwarz <[EMAIL PROTECTED]> wrote:
> Terry
> 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]
>
>
__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
