Hibernate version:
3.2
Code between sessionFactory.openSession() and session.close():
using spring for sessionfactory
Name and version of the database you are using:
MySQL 5.2 --- MS-SQL 2005
I need to deploy the same application at multiple servers ... some servers are having MySQL at backend and some are having MS-SQL at their backend.
The problem is that for every deployment i have to change in applicationContext.xml (spring based file using for hibernate). Is there any way that i can use conditional hbm binding for JAVA OBJECT and DB TABLES. I am having dialect, username, password settings in .properties file i need to know that whether that property file will help me to bind corresponding hbm depending upon backend DB?
Since the table names are different in MySQL and MS-SQL and so are column names. for MySQL i am having mysql-emplyee.hbm.xml and for ms-sql i am having mssql-employee.hbm.xml.
|