It's not a secret anymore!
The moose likes Object Relational Mapping and the fly likes Reset AUTO INCREMENTS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Reset AUTO INCREMENTS" Watch "Reset AUTO INCREMENTS" New topic


masse Satriana

Joined: Sep 21, 2008
Posts: 8
Hi All,
Does JPA has feature in GeneratedType identity to reset auto-increment ?
For example I have one entity called customers. It contains 10 record.
then I delete record 9th and 10th.
When I insert new Record on customer table, the record should start on record 9 not 11.
In sql query we always using " alter table customer AUTO_INCREMENT=1; "
Any clues in JPA?so it will done automatically everytime I delete and insert operation.

Masse Satriana

A warm family is worthy enough than hard working.
I agree. Here's the link:
subject: Reset AUTO INCREMENTS
It's not a secret anymore!