I need to develop an application with hibernate using MySQL and this must be deployed in production with an oracle DB.
But I know that not everything will work as i would expect then, one of those things is ID generation.
if I would use the following hibernate annotations to make it work in MySQL:
Code:
@Id
@GeneratedValue(strategy=GenerationType.AUTO)
private Long id;
would that also work in oracle? because if I would use SequenceGenerators then I would have problems with MySQL.
The goal of this is to use Hibernate in such a way that it absolutely doesn't matter which database it uses.