try-hibernate

CI Status

Goal

Try features of Hibernate without install database.

Hibernate version

• 4.3.5.Final

Usage:

• Step 1: Clone the project
• Step 2: Load to your favorite Java IDE with Gralde support.
• Step 3. Check unit test of this Project. One ut case is just one complete Hibernate usage example.

Cases

• HQL multiple count:

TODO

• Add CI. Or the project is rubbish.
• Refactor: for every test (java), one database, data, one hibernate config, one domain model. One session.
• Stick to HSQL and learn HSQL. It is better choice for this project. More details check HSQL chapter.
• Easy to prepare table, data, bean.

Some tips when you run into some problems

• Every test method tagged with annotation @Test has its own in-memory database, hibernate config.

• Hibernate config seems not update. Try to run gradle processTestResources to update the hibernate.cfg.xml.

HSQL

Reference:

• http://stackoverflow.com/questions/4990864/best-sql-browser-for-hsqldb
• http://stackoverflow.com/questions/591518/how-to-see-all-the-tables-in-an-hsqldb-database/19646240#19646240
• http://hsqldb.org/doc/2.0/util-guide/sqltool-chapt.html#N1067A

Database

• Use HyerpSql (hsql): http://hsqldb.org/ (Reason: Hibernate support it.)

Usage:

• Check the Unit Test to see the demo of how to use Hibernate.
• Load the project into IntelliJ and debug the unit test.
• Before running single case, you'd better run cleanMockData to clean database.

Some tips when you run into some errors.

• Suggest use gradle task 'gradle cleanMockData' to remove database before you test.

Issues

• The cases are not independent. All of them are using the same database. So Only run one test case every time and run cleanMockData before.

Helpful links

• Why test hang? https://stackoverflow.com/questions/14001558/maven-hangs-while-running-test-case-eclipselink-hsqldb