Try the "select ... for update" oracle statement, followed by your insert.
Bart Cassady
Database Analyst
Associated Engineering Group Ltd.
[EMAIL PROTECTED]
>>> Rajeev Muralidharan <[EMAIL PROTECTED]> 05/25 10:01 AM >>>
Hello,
I have a servlet which does an insert into an oracle database using a JDBC
connection. It works fine but fails(data integrity) for unique values on a
column because of the fact that two or more clients try to do an insert at the
same time. I know that there is something that can be done with threading which
will make sure that the requests fall in a queue and will not try data
manipulation at the same time. Can somebody give me more clues or be more
specific about what I need to do with regard to this issue?
Thanks for your time and kind attention.
Rajeev
'Be the change that you want to see in the world - M.K.Gandhi'
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
