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
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
