> On 2002.01.16 23:44:26 -0500 Bill Pfeiffer wrote: > > I will probably go ahead and check uniqueness on the setter of the field, > > but I don't like it and here's why. Oracle has gone a long way to ensure > > that users have a consistant view of the database, my dinky check in my > > setter to see if a value is there yet lacks ANY robustness.
just wondering, is it possible to write something in pl/sql that will do something similar to select for update? then perhaps, you could call this stored procedure, in the set method, and the stored procedure does two things - a) checks to see if the value exists in the table, and tells you if it does, and b) assuming the value doesn't exist, reserves it for future use. whilst that'd completely throw away any portability, it would hopefully maintain the robustness you're after.... thoughts? cheers dim _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
