[jboss-user] [EJB 3.0] - @TableGenerator unexpected behaviour(MYSQL, EJB3, JBOSS)

[jimmymani]

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