ERROR - Table not found in statement [select max(uid) from EVENTS]

[Sushma Sharma]

Hi,
I am trying to learn Hibernate and I am using an online tutorial(http://www.gloegl.de/8.html) for that. I am using HSQLDB for database. When I try to run my application, I am getting the following error

 
INFO  - Hibernate 3.1 beta 1
INFO  - loaded properties from resource hibernate.properties: {hibernate.connection.driver
_class=org.hsqldb.jdbcDriver, hibernate.cglib.use_reflection_optimizer=true, hibernate.max
_fetch_depth=1, hibernate.dialect=org.hibernate.dialect.HSQLDialect, hibernate.jdbc.use_st
reams_for_binary=true, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hib
ernate.proxool.pool_alias=pool1, hibernate.connection.username=sa, hibernate.cache.region_
prefix=hibernate.test, hibernate.connection.url=jdbc:hsqldb:., hibernate.connection.passwo
rd=****, hibernate.jdbc.batch_versioned_data=true, hibernate.connection.pool_size=1}
INFO  - using java.io streams to persist binary types
INFO  - using CGLIB reflection optimizer
INFO  - using JDK 1.4 java.sql.Timestamp handling
INFO  - configuring from resource: /hibernate.cfg.xml
INFO  - Configuration resource: /hibernate.cfg.xml
INFO  - Reading mappings from resource: hibernate\event\Event.hbm.xml
INFO  - Mapping class: hibernate.event.Event -> EVENTS
INFO  - Configured SessionFactory: null
INFO  - processing extends queue
INFO  - processing collection mappings
INFO  - processing association property references
INFO  - processing foreign key constraints
INFO  - Using Hibernate built-in connection pool (not for production use!)
INFO  - Hibernate connection pool size: 1
INFO  - autocommit mode: false
INFO  - using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb :mrgreen: ata/test
INFO  - connection properties: {user=sa, password=****}
INFO  - RDBMS: HSQL Database Engine, version: 1.8.0
INFO  - JDBC driver: HSQL Database Engine Driver, version: 1.8.0
INFO  - Using dialect: org.hibernate.dialect.HSQLDialect
INFO  - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
INFO  - No TransactionManagerLookup configured (in JTA environment, use of read-write or t
ransactional second-level cache is not recommended)
INFO  - Automatic flush during beforeCompletion(): disabled
INFO  - Automatic session close at end of transaction: disabled
INFO  - JDBC batch size: 15
INFO  - JDBC batch updates for versioned data: enabled
INFO  - Scrollable result sets: enabled
INFO  - JDBC3 getGeneratedKeys(): disabled
INFO  - Connection release mode: null
INFO  - Maximum outer join fetch depth: 1
INFO  - Default batch fetch size: 1
INFO  - Generate SQL with comments: disabled
INFO  - Order SQL updates by primary key: disabled
INFO  - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
INFO  - Using ASTQueryTranslatorFactory
INFO  - Query language substitutions: {no='N', true=1, yes='Y', false=0}
INFO  - Second-level cache: enabled
INFO  - Query cache: disabled
INFO  - Cache provider: org.hibernate.cache.HashtableCacheProvider
INFO  - Optimize cache for minimal puts: disabled
INFO  - Cache region prefix: hibernate.test
INFO  - Structured second-level cache entries: disabled
INFO  - Echoing all SQL to stdout
INFO  - Statistics: disabled
INFO  - Deleted entity synthetic identifier rollback: disabled
INFO  - Default entity-mode: pojo
INFO  - building session factory
INFO  - Not binding factory to JNDI, no JNDI name configured
INFO  - Running hbm2ddl schema update
INFO  - fetching database metadata
ERROR - could not get database metadata
java.sql.SQLException: Table not found in statement [select sequence_name from system_sequ
ences]
        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:132)
        at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:297)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1033)
        at hibernate.event.HibernateUtil.<clinit>(HibernateUtil.java:13)
        at hibernate.event.EventManager.store(EventManager.java:28)
        at hibernate.event.EventManager.main(EventManager.java:13)
ERROR - could not complete schema update
java.sql.SQLException: Table not found in statement [select sequence_name from system_sequ
ences]
        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:132)
        at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:297)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1033)
        at hibernate.event.HibernateUtil.<clinit>(HibernateUtil.java:13)
        at hibernate.event.EventManager.store(EventManager.java:28)
        at hibernate.event.EventManager.main(EventManager.java:13)
INFO  - cleaning up connection pool: jdbc:hsqldb :mrgreen: ata/test
INFO  - Checking 0 named queries
WARN  - SQL Error: -22, SQLState: S0002
ERROR - Table not found in statement [select max(uid) from EVENTS]
org.hibernate.exception.SQLGrammarException: could not fetch initial value
        at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43
)
        at org.hibernate.id.IncrementGenerator.getNext(IncrementGenerator.java:107)
        at org.hibernate.id.IncrementGenerator.generate(IncrementGenerator.java:45)
        at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractS
aveEventListener.java:91)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrReq
uestedId(DefaultSaveOrUpdateEventListener.java:186)
        at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId
(DefaultSaveEventListener.java:33)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(Defa
ultSaveOrUpdateEventListener.java:175)
        at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSav
eEventListener.java:27)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(Default
SaveOrUpdateEventListener.java:71)
        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:486)
        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:481)
        at hibernate.event.EventManager.store(EventManager.java:35)
        at hibernate.event.EventManager.main(EventManager.java:13)
Caused by: java.sql.SQLException: Table not found in statement [select max(uid) from EVENT
S]
        at org.hsqldb.jdbc.Util.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
        at org.hibernate.id.IncrementGenerator.getNext(IncrementGenerator.java:86)
        ... 11 more
 

I haven't created any tables in HSDBQL and I don't know to do that. I have does everything as apecified in the tutorial.
please help....

Sushma