Subject: Re: Dynamic SQL query library From: Vic Cekvenich <[EMAIL PROTECTED]> === While not politically correct.... I too use a CachedRowSet, by setting a property in my FromBean of rowset to accomplish this. For more see http://developer.java.sun.com/developer/earlyAccess/crs Vic
John M. Corro wrote: > 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]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
