users@glassfish.java.net

I am using JPA and I am using _at_GeneratedValue(strategy = GenerationType.AUTO) but it does not increment correctly

From: Sarah kho <sarah.kho_at_gmail.com>
Date: Fri, 31 Jul 2009 20:30:01 +0430

Hi
Thank you for reading my post.
I am using JPA and I am using the follwing notation for my key field.
  @Id
  @GeneratedValue(strategy = GenerationType.AUTO)
  private Long id;

problem is that records in the database do not have correctly sequenced ID
values. for exaple the first record is 3 and the second record is 53, is
there any way that I can fix it?
My database is MySQL and I am using Toplink Essential.
Thanks.