If you want the capaiblity to execute complex SQL and not be limited on your schema, look at eQ! (www.browsersoft.com/eQ). In other words, it doesn't hide the SQL from you or generate it on the fly, as you specifiy it yourself. It support dynamic SQL, prepared statements and stored procedures.

It is more than an O/R tool, but persistence is a big part of it. You can even setup relationships between objects that you wouldn't normally do so, for query purposes. An example would be if you want to see all the customers that ordered certain products. You wouldn't normally have a relationship between the "product" object and the "customer", but you can do this with eQ!, and it is all configured, not hard coded.

For connections, you can either use the built in pooling (actually Avalon's Excalibur pooling) or go to a JNDI DataSource pooled by your app server (or whereever it may be).

There is even a free demo app that uses Struts for the web part so you can see how it fits in with struts apps.

The next major release, due in about a couple of months, will be even more powerful and support DynaBeans in the persistence layer.

- Robert McIntosh

Mark Chaimungkalanont wrote:

Howdy all,

This is not about struts really... But I figured it could be relevant for
some people. If you know a better forum for relatively unbiased opinion,
please tell me & I'll take it there!

Just looking into O/R mappers and have looked at (Briefly):

Hibernate 2.0 beta 2
Castor 0.9.4.2
OJB 0.9.8

Does anyone know which is better for what? Which is the most "robust" and
mature development? Have any recommendations of any other ones? Had some
success/problems? Hibernate SOUNDS impressive and looks quite professional
but I haven't used any of them...

Again, sorry for spamming the struts mailing list and will take it
elsewhere if it bothers people.

Cheers

MC


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to