File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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!