As I pointed out earlier liquibase is a stable and nice migration tool for SQL databases in the Java land. The problem I had is that I couldn’t get it working with hibernate while using annotations.
Now just for my personal memory here are the steps to get it working. Download liquibase 1.9.5 (couldn’t get it working with 2.0.0 :-() and put the following libs in the liquibase/lib folder:
dom4j-1.6.1.jar h2-1.2.137.jar #or your prefered jdbc database driver hibernate-annotations-3.5.1-Final.jar hibernate-commons-annotations-3.2.0.Final.jar hibernate-core-3.5.1-Final.jar hibernate-jpa-2.0-api-1.0.0.Final.jar slf4j-api-1.6.0.jar
You will need to put the 4 hibernate jars into the classpath parameter, too. To do a diff and update the changelog file via the command line do the following:
liquibase --logLevel=FINE \ --driver=org.h2.Driver \ --classpath=$CP \ --url=jdbc:h2:~/.myapp/h2db \ --username=sa \ --password=tmp \ --changeLogFile=src/main/resources/dbchangelog.xml \ diffChangeLog \ --baseUrl=hibernate:src/main/resources/hibernate.cfg.xml
This means you compare the ‘old’ database with the new hibernate config. If you have problems while set-up you can look directly into the source file.
BTW: here is the pom snippet for the hibernate deps:
<dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-core</artifactId> <version>3.5.1-Final</version> </dependency> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-annotations</artifactId> <version>3.5.1-Final</version> </dependency>
Pingback: Blog bookmarks 06/23/2010 « My Diigo bookmarks
Hi, I am using hibernate 4 in my app. do you have Liquibase jar for hibernate 4
sorry, no idea. Why not ask for help on the liquibase mailing list??