Hmm, I think that's implementation dependent. For example, the Oracle CachedRowSet implementation doesn't support updating joined tables. See:
http://otn.oracle.com/docs/products/ias/doc_library/90200doc_otn/web.902/a90211/rowset.htm#628357 I don't know for sure, but I'll wager the RI doesn't, either... John --- Jerry Jalenak <[EMAIL PROTECTED]> wrote: > > My initial SQL SELECT statement that creates my > ResultSet pulls data from several tables. I wasn't > sure if the RowSetWriter implementation would be > able to accommodate this scenario, so I've started > using the CachedRowSet object as a means of passing > data from DAO to business logic and back. I had to > kill the writer in order to use the 'acceptChanges()' > method. Does the default RowSetWriter handle > updating multiple tables? > > Jerry > > > -----Original Message----- > > From: John Bigboote [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, November 26, 2002 2:23 PM > > To: Struts Users Mailing List > > Subject: Re: [OT] Updating CachedRowSet > > > > > > > > --- Jerry Jalenak <[EMAIL PROTECTED]> > wrote: > > > > > [...snip...] > > > > > > > > > crs.updateString("userInfo", userInfo); > > > crs.updateRow(); > > > crs.setWriter(null); // kill default writer > > > crs.acceptChanges(); > > > > > > > Why are you setting the writer to null? It's the > > RowSetWriter that propagates changes back to the > > database... > > > > John > > > > > > __________________________________________________ > > Do you Yahoo!? > > Yahoo! Mail Plus - Powerful. Affordable. Sign up > now. > > http://mailplus.yahoo.com > > > > -- > > To unsubscribe, e-mail: > > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > > This transmission (and any information attached to > it) may be confidential and is intended solely for > the use of the individual or entity to which it is > addressed. If you are not the intended recipient or > the person responsible for delivering the > transmission to the intended recipient, be advised > that you have received this transmission in error > and that any use, dissemination, forwarding, > printing, or copying of this information is strictly > prohibited. If you have received this transmission > in error, please immediately notify LabOne at the > following email address: > [EMAIL PROTECTED] > > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>