We had a very bad experience with CachedRowSet, in fact we had to take it out of our code after it had gone into production. CachedRowSet it in beta and there is no good documentation for it. It handles long data type (of Oracle) very poorly and is quite unstable. It promises a lot of funky features but falls very short of achieving them. I do not think it is a good idea to use it in a production environment.
-----Original Message----- From: Rajeev Singh [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 15, 2001 1:17 AM To: 'Struts Users Mailing List' Subject: RE: Dynamic SQL query library I agree to Vic on this , I had been using it for past an year or so, though its still in beta but its very handy in handling huge chunks of data which need to be scrollable in JSP's as it can be used as a bean and also as Entity bean as it is a persistent and connected data object too. I am still waiting for its final release as I have found data missing in it on some occasions so I can term it as inconsistent. May be final release takes care of it. -----Original Message----- From: Struts Newsgroup [mailto:@[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 2:55 AM To: [EMAIL PROTECTED] Subject: Re: Dynamic SQL query library 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]> -- 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]>
