What is the best way to launch HSQLDB for unit testing, when working with spring, maven and hibernate?

hibernate spring maven-2 junit hsqldb
tom eustace picture tom eustace · Jun 16, 2010 · Viewed 16.3k times · Source

In my project I can successfully test database code. I'm using Spring, Hibernate, HSQLDB, JUnit and Maven.

The catch is that currently I have to launch HSQLDB manually prior to running the tests. What is the best way to automate the launching of HSQLDB with the technologies being used?

Answer

Juha Syrjälä picture Juha Syrjälä · Jun 16, 2010

I am assuming that with hsql you are referring to HSQLDB.

Configure your database url for JDBC drivers (for hibernate etc) to embedded memory based version of HSQLDB:

jdbc:hsqldb:mem:myunittests

Then a inprocess version of HSQLDB automatically starts that stores stuff to memory. No need to start any external servers.

Related questions

Hibernate ManyToOne with FetchType.LAZY not fetching lazy

I am using Hibernate with spring. I have a model-class like this. @Entity @Table(name = "forumtopic") public final class Forumtopic extends AbstractUserTracking implements java.io.Serializable { /**SNIP **/ private Forumcategory forumcategory; @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "FkForumcategoryId", nullable = false) public …

Read More
How to solve the “failed to lazily initialize a collection of role” Hibernate exception

I have this problem: org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: mvc3.model.Topic.comments, no session or session was closed Here is the model: @Entity @Table(name = "T_TOPIC") public class Topic { @Id @GeneratedValue(strategy=…

Read More
Error creating bean with name 'entityManagerFactory' defined in class path resource : Invocation of init method failed

When I compile my spring project, I got the following error. Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaAutoConfiguration.class]: Invocation of init method failed I am using STS Eclipse …

Read More