Thanks guys, its all working now....

ejbFindByPrimaryKey only retrieves rows that have obsolete_indicator != "Y",
and ejbRemove() sets obsolete_indicator = "Y".


Many thanks!


-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Karl Koster
Sent: 19 September 2001 16:51
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] EJB Entity design question: Can ejbRemove() be
used to modify a row in the DB?


Adam,

Even better, if you are using BMP and we are talking about an SQL storage
facility, construct your SQL to only fetch rows with the
"obsolete_indicator" column not equal to "Y" or null. This will reduce the
amount of network communication that occurs, especially if you are dealing
with wide rows, since the ResultSet will be null if no data is returned.

Karl.

<< Snip >>


_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to