How to use Hibernate with MySQL and PostgreSQL in same time

teutates · **Joined:** Tue Jul 26, 2011 2:17 am **Posts:** 2

Hello !

We have a project to develop working with MySQL or PostgreSQL.
For the moment, if I change my database, I've to change the mapping. For exemple "id" in MySQL are auto-increments, and in hibernate I've to set a sequence.

I would like to know if there is a solution to write only one mapping compatible with MySQL and PostgreSQL ?

Thanks for your response !

Teutates.

nillehammer · **Joined:** Mon Jan 31, 2011 3:23 pm **Posts:** 5

As for the id-Problem, have you tried javax.persistence.GenerationType.AUTO? This makes hibernate choose the correct stategy for obtaining db-level ids.

teutates · **Joined:** Tue Jul 26, 2011 2:17 am **Posts:** 2

Hi ! Thank you for your response !

I've tried but for Id it's the same error. In fact, the real problem is with sequence, Hibernate choose "hibernate_sequence".
If I create this sequence it will be the same for all tables of the database.
If I specifiy the sequence, I've to edit the mapping if I want to use Mysql
This is my problem ...

Maybe, I've not well understanding your tips, I've test :

Code:

   @Id
   @GeneratedValue(strategy=GenerationType.AUTO)
   @Column(name = "id_user")
   public Long getId() {
      return id;
   }

Right ?

Byebye