Integration

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.