Conditional Sequence Generator Selection [message #948199] |
Wed, 17 October 2012 21:18 |
Scott Dudley Messages: 21 Registered: October 2012 |
Junior Member |
|
|
I'm still a JPA neophyte but starting to get the hang of things.
Attempting to integrate JPA with a legacy RDBMS supporting both SQL Server and Oracle. For Oracle, we use sequences and for SQL, a table.
I need to be able to conditionally use one of two generators based on database type:
Oracle
@Id
@GeneratedValue(generator="generator")
@SequenceGenerator(name="generator", sequenceName="PBX_SEQ", allocationSize=1)
@Column(name="PBX_ID")
protected long pbxId;
SQL Server
@Id
@GeneratedValue(generator="generator")
@TableGenerator(name="generator", table="SEQTAB", pkColumnName="TABLENAM", valueColumnName="ID", pkColumnValue="PBX", allocationSize=1)
@Column(name="PBX_ID")
protected long pbxId;
How best would one approach this challenge?
Thanks.
|
|
|
|
Powered by
FUDForum. Page generated in 0.03293 seconds