hsqldb « Connection « JPA Q&A

1. Using HSQL in-memory database as JPA datasource    stackoverflow.com

I have an in-memory data source:

java.sql.Connection c = DriverManager.getConnection("jdbc:hsqldb:mem:testdb", "sa", "");            
emf = Persistence.createEntityManagerFactory("manager");

2. Connections could not be acquired from th e underlying database! -- HSQL DB    stackoverflow.com

I am trying to learn Hibernate from Java Persistence with hibernate by Gavin King. I just downloaded the examples given in the book from this location http://downloads.jboss.org/hibernate/caveatemptor/jpwh-gettingstarted-070401.zip I started my HSQL ...

3. hibernate.connection.datasource for HSQLDB    stackoverflow.com

The configuration of my hibernate.properties is :

database.driver=org.hsqldb.jdbcDriver
database.url=jdbc:hsqldb:file:${ems.home}/db/ems
database.username=sa
database.password=
hibernate.dialect=org.hibernate.dialect.HSQLDialect
hibernate.show_sql=false