Re: [OT] Updating CachedRowSet

[V. Cekvenich]

http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/basicportal/basicportal_07/src/basicWebLib/org/commons/DAO/BasicDAOImpl.java

Above has a working DAO implementation that uses RowSet.
The idea is that you can have many implementations using DAO.
(So, next to it is same DAO that uses SQL-Commons. I only use light weight DAO becuase they have higher performance and mostly zero copy beans).

After you review above, follow up.

.v

Jerry Jalenak 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]>