Toplink is a popular commercial-level package for transparent object persistence. Something else a coworker pointed out to me recently was the CachedRowSet object from Sun. I believe it's still in beta, but take a look...some very neat features implemented in it that might address what you're looking for.
While I'm posting, for those that reply...can you make mention on performance of the object persistance packages you've worked with? I'm curious to see how performance varies across the various packages. ----- Original Message ----- From: "Robert Taylor" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, December 12, 2001 7:21 AM Subject: RE: Dynamic SQL query library > Might want to have a look at JDO or the database package provided by > Expresso. > > JDO: > http://jcp.org/aboutJava/communityprocess/review/jsr012/index.html > http://castor.exolab.org/index.html > > Expresso: > http://www.jcorporate.com/econtent/Content.do?state=template&template=2&reso > urce=636&db=default > http://www.jcorporate.com/html/products/expresso/dbpooling.html > > HTH, > > robert > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul > > Dlug > > Sent: Wednesday, December 12, 2001 10:04 AM > > To: [EMAIL PROTECTED] > > Subject: Dynamic SQL query library > > > > > > This is somewhat offtopic but definitely related to web development and > > I'm sure someone on this list has run up against this issue before. > > > > I'm looking for a java library to generate dynamic SQL. Basically I want > > the ability to do something like: > > Query q = new Query(); > > q.type(SELECT); > > q.add("table1", "username", EQUALS, "john"); > > q.add("table1", "added_date", LESS_THAN, new java.util.Date()); > > Statement st = conn.createStatement(); > > st.executeQuery(q.toString()); > > > > Or something just as easy to use as this, basically generating queries > > without being locked into creating SQL statements by hand since they > > could change at any time. I came across the org.apache.turbine.util.db > > library from Turbine which seems to have what I'm looking for, but it's > > too tightly coupled with Turbine. Ideally I need a library that is > > general enough to use in any environment (why isn't there a Jakarta > > Commons SQL Utils??), or something that can work hand in hand with > > struts. Any advice greatly appreciated. > > > > -- > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
