Hi, I have a question regarding the usage of Hibernate with different databases (MSSQL Server and MySQL) in the same application:

I started with Hibernate in Netbeans 8.2 and created a hibernate config for my MSSQL Server database, hibernate reverse-engineering file and let netbeans created the Hibernate Mapping files and POJOs from database.

Now I would like to use also a Mysql datbase with the same table-names, etc...

I tried just to change the

hibernate.connection.driver_class
hibernate.connection.url
hibernate.dialect

- properties and use the same mappings as already created for MSSQL, but this obviously does not work. I observed that e.g. in MSSQL a 'schema' has a different meaning as in Mysql.

Is there a way to use the same POJOs and mapping files for different databases? I thought that that's one of the reasons to use hibernate...

Or do I have to generate POJOs and hbm.xml - files for the different databases and instantiate them in my application depending on which db to use e.g. via factory pattern?

Regards

Klaus

Sure thing. You can have the entities as annotated for SQL Server, and provide an orm.xml which overrides annotations for the troubling mappings.

Read this article for more details.