users@glassfish.java.net

Help with JPA sequence with oracle 9i

From: Cheng Fang <Cheng.Fang_at_Sun.COM>
Date: Mon, 15 Oct 2007 09:29:50 -0400

Hi,

A user asked this question on glassfish Chinese forum:
http://gceclub.sun.com.cn/NASApp/sme/jive/thread.jsp?forum=22&thread=46801

The user is using PE 9 and Oracle 9i. All entities are using sequence.
When adding entries from session beans, the server generates Id that has
already been used.

For example, when user A inserted a row with Id 80, and later user B
could insert another row with Id 76. What could be going wrong?
Appreciate your help.

-cheng