hsqldb table data not loading in in-process mode

Question

I am using hibernate and HSQLDB. HSQLDB works in in-process mode.

The database query:

    session.createQuery("from Doctor").list();

returns an empty list. But, in reality, the database tables are not empty and all database files are in project package

hibernate configuration:

<hibernate-configuration>
  <session-factory>
    <property name="hibernate.connection.driver_class">org.hsqldb.jdbcDriver</property>
    <!-- In-Process database connection-->
    <property name="hibernate.connection.url">jdbc:hsqldb:file:demodb;shutdown=true</property>
    <property name="hibernate.connection.username">user1</property>
    <property name="hibernate.connection.password">user1</property>
    <property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>
    <property name="show_sql">true</property>
    <property name="hbm2ddl.auto">update</property>
    <mapping class="com.mycom.entity.Doctor"></mapping>
  </session-factory>
</hibernate-configuration>

How do I solve this problem?

score 0 · Accepted Answer · answered Nov 22 '19 at 13:36

0

Your JDBC URL opens the database in the directory where the Java VM was started. You need to use either an absolute path to the database or a path that contains a placeholder for the user.home directory if you put the files there.

See: http://hsqldb.org/doc/2.0/guide/dbproperties-chapt.html#dpc_variables_url

answered Nov 22 '19 at 13:36

fredt

24,044
3
40
61

All database files in procject package – Gdd gffg Nov 22 '19 at 14:19
Check where the Java VM is is started. It may not be the same place as your files. – fredt Nov 23 '19 at 00:38
yes, indeed, the absolute path to the database file (demodb without extension) works – Gdd gffg Nov 26 '19 at 14:37

hsqldb table data not loading in in-process mode

1 Answers1