Home → Questions →

incremental database tables question of id's

• Edit

Mike

11 Jun, 2014 08:18 AM

Can someone explain why some id's of table 'item' and 'item type' increment by 1 and others skipping id's the next 100 number?? I can't to seem to find a locigal explaination why this happens. In the example (screenshot) you can see the item tabel where this is happening, it's definitely not linked to the item_type.

Does someone know?
Thanks

• jbilling.png 101 KB

1. 1 Posted by Musaddique on 14 Nov, 2014 06:12 AM

   

   it is hibernate feature for increment numbers. take a look at jbilling_seq table

   and code in DTO is like this
   @Entity
   @TableGenerator(
           name="customer_GEN",
           table="jbilling_seqs",
           pkColumnName = "name",
           valueColumnName = "next_id",
           pkColumnValue="customer",
           allocationSize = 100
   )

   allocation size=100

   thanks
   Musaddique

   • Edit

2. Support Staff 2 Posted by Technical Suppo... on 08 Jan, 2015 05:51 AM

   

   Hello Mike ,

   Please let us know with new issue , if you need further assistance on it.

   Thank you,

   Technical Support Team

   • Edit

3. Technical Support closed this discussion on 08 Jan, 2015 05:51 AM.