incremental database tables question of id's

Mike's Avatar

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

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

    Musaddique's Avatar

    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

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

    Technical Support's Avatar

    Hello Mike ,

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

    Thank you,

    Technical Support Team

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

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac