hi!
I'm having awful problems getting the Hibernate 3.2 example (bundled with Hibernate 3.2) Event / Person working... I've got it working with mysql connecting to localhost.. but i can't for the life of me get it working using a hsqldb or derby database.. it successfully inserts the row into the database, but the database is never created... calling the example with list causes a query to be run on a database that's just been created (????)
i can't tell if this is a problem with Hibernate, or with HSQL.. here is my hibernate.cfg.xml
Quote:
<?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:./hsqldb</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>
<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>
<!-- Disable the second-level cache -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</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>
<mapping resource="events/Event.hbm.xml"/>
<mapping resource="events/Person.hbm.xml"/>
</session-factory>
</hibernate-configuration>
The example i'm trying is straight from the Hibernate3.2 doc/tutorial/src
directory. Please help! I want to make Hibernate create a database in the current directory but it just doesn't seem to want to do that.
Thanks in advance
James Gardner
jgardner@elink.net.au