Database independency using Hibernate

Question

I am using Hibernate for ORM in my Java application. I want to write custom queries combining multiple tables and using DB functions like sum(salary). I also want to support multiple databases without writing the SQLs again and again for each database. The approach currently followed is having Stored Procedures specific to each DB (Oracle, MySQL etc) and whichever we want to support, we change the configuration file in the application. What I am looking for is a solution very generic so that I need not write Stored Procedures or SQLs for every new functionality.

GreyBeardedGeek · Accepted Answer · 2013-06-18 11:26:01Z

1

If you really want to keep it portable, you'll need to do it all with HQL.

There's no reason that you couldn't do multi-table joins and aggregate functions in HQL, you just need to limit yourself to the ones it supports.

Once you start doing database-vendor specific things, you are no longer database independent, by definition.

answered Jun 18, 2013 at 11:26

GreyBeardedGeek

30.3k2 gold badges51 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Suresh Atta · Accepted Answer · 2013-06-18 11:20:19Z

1

A perfect suite is HIbernate Criterias

Hibernate provides alternate ways of manipulating objects and in turn data available in RDBMS tables. One of the methods is Criteria API which allows you to build up a criteria query object programmatically where you can apply filtration rules and logical conditions.

http://www.tutorialspoint.com/hibernate/hibernate_criteria_queries.htm

answered Jun 18, 2013 at 11:20

Suresh Atta

122k38 gold badges206 silver badges315 bronze badges

Collectives™ on Stack Overflow

Database independency using Hibernate

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related