Michele,
I tried your suggestion and added
Code:
<property name="hibernate.connection.shutdown">true</property>
to my hibernate.cfg.xml file.
The complete file now looks like:
Code:
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- Database connection settings -->
<property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
<property name="connection.url">jdbc:hsqldb:data/tutorial</property>
<property name="connection.username">sa</property>
<property name="connection.password"></property>
<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>
<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>
<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>
<!-- Drop and re-create the database schema on startup -->
<property name="hbm2ddl.auto">create</property>
<property name="hibernate.connection.shutdown">true</property>
<mapping resource="Event.hbm.xml"/>
</session-factory>
</hibernate-configuration>
however, the tutorial still drops and recreates the tables each time.
My main (inside the EventManager class) is:
Code:
public static void main(String[] args) {
EventManager mgr = new EventManager();
if (args[0].equals("store")) {
mgr.createAndStoreEvent("My Event", new Date());
}
else if (args[0].equals("list")) {
List events = mgr.listEvents();
for (int i = 0; i < events.size(); i++) {
Event theEvent = (Event) events.get(i);
System.out.println("Event: " + theEvent.getTitle() +
" Time: " + theEvent.getDate());
}
}
HibernateUtil.sessionFactory.close();
}
However, just as an aside, if I change the main and replace all the argument based processing with:
Code:
mgr.createAndStoreEvent("My Event",new Date());
mgr.createAndStoreEvent("Event1",new Date());
mgr.createAndStoreEvent("Event2",new Date());
mgr.createAndStoreEvent("Event3",new Date());
List events = mgr.listEvents();
for (int j=0; j<events.size(); j++) {
Event theEvent = (Event)events.get(j);
System.out.println("Event: "+theEvent.getTitle()+
" Time: "+theEvent.getDate());
}
that works correctly (e.g. multiple events are added to the table & the list at the end shows all of them).
so clearly hibernate and hsqldb are working, the problem is simply getting hsqldb to remember tables/data between runs.
Any advice on how to do that would be appreciated.
Thanks,
Steve
Login
FAQ
Search
