A TableGenerator and referencing @GeneratedValue incantation like this:
Code:
@Entity(name = "PostalAddress")
@Table(name = "PostalAddress")
@TableGenerator(
name = "PostalAddressEntityIDGenerator",
table = "JPAGenerators",
pkColumnName = "generatorName",
pkColumnValue = "PostalAddressEntityIDGenerator",
valueColumnName = "generatorValue",
allocationSize = 1
)
public class PostalAddressEntity {
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.TABLE, generator = "PostalAddressEntityIDGenerator")
@Id
private long id;
/* etc. */
}
...produces SQL like this (for getting the next ID):
Code:
select generatorValue from JPAGenerators.JPAGenerators.JPAGenerators where generatorName = 'PostalAddressEntityIDGenerator' for update
Why is this being repeated three times?
This is Hibernate 3.5.2-Final.
Best,
Laird