• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

using Oracle Sequences

 
blr sam
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
I am using auto-key generation for CMP with Oracle in EJB2.0 on WL 6.1.
Everything works fine if i am start off with a blank table and start inserting/updating records.
If i already have some records in the table, when i try to insert some records using the sequence, Oracle throws a exception which is shown by the bean. When i check in Oracle, whats the last_number used, its the latest. Why does weblogic start using the sequence always from 1?
They only as of now is keep calling create - so that WL reaches that number....
Anybody knows what can be done here???
Cheers,
Sham
 
blr sam
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
The current valus of the sequence in Oracle was itself reset to 1. When this was corrected
everything just worked.
Now i am having problems with date... : :roll:
Thanks anyway
Sham
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic