Dear friends,
I tried to test Hibernate 3.0 via a simple example. But I met strange problems.
In my Main.java, I put
---
Configuration cfg = new Configuration();
cfg.addClass(hb.Keyword.class);
cfg.addClass(hb.KeySet.class);
cfg.configure("/hibernate.cfg.xml");
SessionFactory sessions = cfg.buildSessionFactory();
Session session = sessions.openSession();
----
Then whatever the content of "hibernate.cfg.xml", there is no parsing error. In log file, it is always,
09:18:56,328 ERROR SchemaUpdate:129 - could not get database metadata
It seems the configuration file is nerver really parsed.
What king of missing details could cause this?
Thanks.
Pengyou
PS:
09:35:31,859 ERROR SchemaUpdate:129 - could not get database metadata
java.sql.SQLException: Table not found in statement [select sequence_name from system_sequences]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:113)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:39)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:124)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:265)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1005)
at Main.main(Main.java:29)
09:35:31,859 ERROR SchemaUpdate:158 - could not complete schema update
java.sql.SQLException: Table not found in statement [select sequence_name from system_sequences]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:113)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:39)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:124)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:265)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1005)
at Main.main(Main.java:29)
hibernate.cfg.xml contents:
<?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>
<property name="hibernate.connection.driver_class">org.hsqldb.jdbcDriver</property>
<property name="hibernate.connection.url">jdbc:hsqldb:db/test</property>
<property name="hibernate.connection.username">sa</property>
<property name="hibernate.connection.password"></property>
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>
<property name="show_sql">true</property>
<property name="transaction.factory_class">
org.hibernate.transaction.JDBCTransactionFactory
</property>
<property name="hibernate.cache.provider_class">
org.hibernate.cache.HashtableCacheProvider
</property>
<property name="hibernate.hbm2ddl.auto">update</property>
<mapping resource="hb/KeySet.hbm.xml"/>
<mapping resource="hb/Keyword.hbm.xml"/>
</session-factory>
</hibernate-configuration>