i am using Table generator for sequence generation in mysql db. i want to start my orderid with 14326 and should increment each time by 3 . once i insert a row into order table its showing 42978(14326*3).and gen value of my_sequence_generator table increments by 1 only. is it an expected behaviour or some error.
tell me a solution if i am wrong any where @TableGenerator( name="orderKeysGen", table="my_sequence_generator", pkColumnName="GEN_KEY", valueColumnName="GEN_VALUE", pkColumnValue="orderId", initialValue=14326, allocationSize=3 ) @Id @GeneratedValue(strategy=GenerationType.TABLE, generator="orderKeysGen") jimmy View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3999793#3999793 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3999793 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user