It appears to me that if I let Hibernate manage the JDBC connection to HSQL I can't get HSQL running in IN-PROCESS (Standalone) MODE. According to the HSQL Doc, to do this you need to:

Connection c = DriverManager.getConnection ("jdbc:hsqldb:testdb", "sa", "");

Which I guess Hibernate is not doing, so that as a result I felt I had to call JDBC directly for a Connection and supply that to Hibernate, which according to the Hibernate Doc is far less preferred than letting Hibernate do all the JDBC handling.

Is my analysis correct? Is there a way to tell Hibernate to open the HSQL database in In Process mode?

Thanks

works for me....

Thanks.... Now...