So what happens when the following occurs:
>Inside the ejbCreate() method, we added code to
>* get a Connection from DriverManager
>* from the Connection, get a PreparedStatement with the SQL to grab
>the next sequence number from the db
> ("SELECT customer_seq.nextval FROM dual")
====== ROW INSERTED FROM ANOTHER TRANSACTION HERE ==========
>* execute the prepared statement query
>* grab the sequence number out of the result set.
>* close the Connection
If this happens then your create method will return the wrong primary key
to the client won't it?
Floyd
---------------------------------
Senior Architect
The Middleware Company
http://www.middleware-company.com
[EMAIL PROTECTED]
416-889-6115
Need help with EJB / J2EE? Ask about our on-site training and consulting
services.
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
