All geek questions in one place

Getting my webapp for agnostic database with Hibernate

So, the final creep coverage area has appeared the other day: since we use Hibernate, can we make our webapp work with both Oracle and MySQL, interchangably?

I thought it would be a simple case of changing hibernate.cfg.xml, so that instead of explaining the parameters specific to MySQL, it would refer to the JNDI data source, allowing the application to create regardless of the database that we plan to deploy, Then switch to another database would simply mean changing the individual data source configuration in JBoss, Jetty, WebLogic, etc. Is it realistic?

Well, I got to the Jetty installation, but what is turning me off right now is an error due to the fact that hibernate.dialect was not installed in the hibernate.cfg.xml file. But if I installed a dialect there, then my application will still be built in MySQL or Oracle, but this is not quite what I want.

Either I'm trying to do the impossible, or I missed something fundamentally obvious ... did anyone have a similar problem (and subsequent solution / workaround)?

+3
source share
3 answers

But no. A dialect is just a configuration item. I am sure that the application should be RECONFIGURED for another database.

SQL (.. SQL) . .

: SQL Server .

+3

( ), Hibernate JNDI (, , , URL- db, db ), - ( , , MySQL, Oracle ..), Hibernate. SQL Dialects. , ( , , id), .

0

. / factory JNDI. connection.getMetaData().getDatabaseProductName() - JDBC, , , , . hibernateConfiguration.setProperty(Environment.DIALECT, deducedDialect)

, SQL Server, Oracle, MySQL, DB2 Informix. , . , (), .

0

Source: https://habr.com/ru/post/1736087/

More articles:


All Articles