Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.0

Hi,

I am a new user following the roap map for new users. downloaded hibernate 3.0 and hypersonic sql db for my database. I am getting this error:

Buildfile: build.xml
[taskdef] Could not load definitions from resource checkstyletask.properties. It could not be found.
[taskdef] Could not load definitions from resource clovertasks. It could not be found.

eg:
[echo] remember to place your JDBC driver in the lib directory
[java] 11:00:04,484 INFO Environment:464 - Hibernate 3.0.5
[java] 11:00:04,500 INFO Environment:482 - loaded properties from resource hibernate.properties: {hibernate.connection.driver_cla
ss=org.hsqldb.jdbcDriver, hibernate.cglib.use_reflection_optimizer=true, hibernate.cache.provider_class=org.hibernate.cache.HashtableCa
cheProvider, hibernate.max_fetch_depth=1, hibernate.dialect=org.hibernate.dialect.HSQLDialect, hibernate.jdbc.use_streams_for_binary=tr
ue, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hibernate.proxool.pool_alias=pool1, hibernate.connection.username=s
a, hibernate.cache.region_prefix=hibernate.test, hibernate.connection.url=jdbc:hsqldb:testdb/demo, hibernate.connection.password=****,
hibernate.jdbc.batch_versioned_data=true, hibernate.connection.pool_size=1}
[java] 11:00:04,515 INFO Environment:509 - using java.io streams to persist binary types
[java] 11:00:04,515 INFO Environment:510 - using CGLIB reflection optimizer
[java] 11:00:04,515 INFO Environment:521 - JVM does not support Statement.getGeneratedKeys()
[java] 11:00:04,531 INFO Environment:532 - JVM does not support LinkedHasMap, LinkedHashSet - ordered maps and sets disabled
[java] 11:00:04,531 INFO Environment:535 - using workaround for JVM bug in java.sql.Timestamp
[java] 11:00:04,531 INFO Environment:543 - using pre JDK 1.4 java.sql.Timestamp handling
[java] 11:00:04,671 INFO Configuration:464 - Mapping resource: org/hibernate/auction/AuctionItem.hbm.xml
[java] 11:00:05,500 INFO HbmBinder:260 - Mapping class: org.hibernate.auction.AuctionItem -> AuctionItem
[java] 11:00:05,687 INFO Configuration:464 - Mapping resource: org/hibernate/auction/Bid.hbm.xml
[java] 11:00:05,781 INFO HbmBinder:260 - Mapping class: org.hibernate.auction.Bid -> Bid
[java] 11:00:05,843 INFO HbmBinder:737 - Mapping subclass: org.hibernate.auction.BuyNow -> Bid
[java] 11:00:05,843 INFO Configuration:464 - Mapping resource: org/hibernate/auction/User.hbm.xml
[java] 11:00:05,906 INFO HbmBinder:260 - Mapping class: org.hibernate.auction.User -> AuctionUser
[java] 11:00:05,921 INFO Configuration:875 - processing extends queue
[java] 11:00:05,921 INFO Configuration:879 - processing collection mappings
[java] 11:00:05,921 INFO HbmBinder:2041 - Mapping collection: org.hibernate.auction.AuctionItem.bids -> Bid
[java] 11:00:05,921 INFO HbmBinder:2041 - Mapping collection: org.hibernate.auction.User.bids -> Bid
[java] 11:00:05,921 INFO HbmBinder:2041 - Mapping collection: org.hibernate.auction.User.auctions -> AuctionItem
[java] 11:00:05,921 INFO Configuration:888 - processing association property references
[java] 11:00:05,921 INFO Configuration:917 - processing foreign key constraints
[java] 11:00:06,265 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
[java] 11:00:06,281 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
[java] 11:00:06,281 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
[java] 11:00:06,281 INFO DriverManagerConnectionProvider:80 - using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:testdb/demo

[java] 11:00:06,281 INFO DriverManagerConnectionProvider:86 - connection properties: {user=sa, password=****}
[java] 11:00:09,437 INFO SettingsFactory:77 - RDBMS: HSQL Database Engine, version: 1.6
[java] 11:00:09,437 INFO SettingsFactory:78 - JDBC driver: HSQL Database Engine Driver, version: 1.6
[java] 11:00:09,484 INFO Dialect:92 - Using dialect: org.hibernate.dialect.HSQLDialect
[java] 11:00:09,500 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
[java] 11:00:09,515 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of
read-write or transactional second-level cache is not recommended)
[java] 11:00:09,515 INFO SettingsFactory:125 - Automatic flush during beforeCompletion(): disabled
[java] 11:00:09,515 INFO SettingsFactory:129 - Automatic session close at end of transaction: disabled
[java] 11:00:09,515 INFO SettingsFactory:144 - Scrollable result sets: disabled
[java] 11:00:09,515 INFO SettingsFactory:152 - JDBC3 getGeneratedKeys(): disabled
[java] 11:00:09,515 INFO SettingsFactory:160 - Connection release mode: null
[java] 11:00:09,531 INFO SettingsFactory:184 - Maximum outer join fetch depth: 1
[java] 11:00:09,531 INFO SettingsFactory:187 - Default batch fetch size: 1
[java] 11:00:09,531 INFO SettingsFactory:191 - Generate SQL with comments: disabled
[java] 11:00:09,531 INFO SettingsFactory:195 - Order SQL updates by primary key: disabled
[java] 11:00:09,531 INFO SettingsFactory:334 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
[java] 11:00:09,531 INFO ASTQueryTranslatorFactory:21 - Using ASTQueryTranslatorFactory
[java] 11:00:09,531 INFO SettingsFactory:203 - Query language substitutions: {false=0, no='N', yes='Y', true=1}
[java] 11:00:09,546 INFO SettingsFactory:209 - Second-level cache: enabled
[java] 11:00:09,546 INFO SettingsFactory:213 - Query cache: disabled
[java] 11:00:09,546 INFO SettingsFactory:321 - Cache provider: org.hibernate.cache.HashtableCacheProvider
[java] 11:00:09,546 INFO SettingsFactory:228 - Optimize cache for minimal puts: disabled
[java] 11:00:09,546 INFO SettingsFactory:233 - Cache region prefix: hibernate.test
[java] 11:00:09,546 INFO SettingsFactory:237 - Structured second-level cache entries: disabled
[java] 11:00:09,562 INFO SettingsFactory:261 - Statistics: disabled
[java] 11:00:09,562 INFO SettingsFactory:265 - Deleted entity synthetic identifier rollback: disabled
[java] 11:00:09,562 INFO SettingsFactory:279 - Default entity-mode: pojo
[java] 11:00:09,703 INFO SessionFactoryImpl:152 - building session factory
[java] 11:00:10,531 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
[java] 11:00:10,546 INFO Dialect:92 - Using dialect: org.hibernate.dialect.HSQLDialect
[java] 11:00:10,546 INFO Configuration:875 - processing extends queue
[java] 11:00:10,546 INFO Configuration:879 - processing collection mappings
[java] 11:00:10,546 INFO Configuration:888 - processing association property references
[java] 11:00:10,546 INFO Configuration:917 - processing foreign key constraints
[java] 11:00:10,546 INFO Configuration:875 - processing extends queue
[java] 11:00:10,546 INFO Configuration:879 - processing collection mappings
[java] 11:00:10,562 INFO Configuration:888 - processing association property references
[java] 11:00:10,562 INFO Configuration:917 - processing foreign key constraints
[java] 11:00:10,562 INFO SchemaExport:113 - Running hbm2ddl schema export
[java] 11:00:10,562 INFO SchemaExport:129 - exporting generated schema to database
[java] 11:00:10,562 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
[java] 11:00:10,562 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
[java] 11:00:10,562 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
[java] 11:00:10,562 INFO DriverManagerConnectionProvider:80 - using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:testdb/demo

[java] 11:00:10,578 INFO DriverManagerConnectionProvider:86 - connection properties: {user=sa, password=****}
[java] 11:00:10,578 DEBUG SchemaExport:143 - alter table AuctionItem drop constraint FK522A9BD61107FE9B
[java] 11:00:10,578 DEBUG SchemaExport:149 - Unsuccessful: alter table AuctionItem drop constraint FK522A9BD61107FE9B
[java] 11:00:10,578 DEBUG SchemaExport:150 - Unexpected token: ALTER in statement [alter table AuctionItem drop constraint FK522A9
BD61107FE9B]
[java] 11:00:10,578 DEBUG SchemaExport:143 - alter table AuctionItem drop constraint FK522A9BD6F65B1FAF
[java] 11:00:10,578 DEBUG SchemaExport:149 - Unsuccessful: alter table AuctionItem drop constraint FK522A9BD6F65B1FAF
[java] 11:00:10,578 DEBUG SchemaExport:150 - Unexpected token: ALTER in statement [alter table AuctionItem drop constraint FK522A9
BD6F65B1FAF]
[java] 11:00:10,593 DEBUG SchemaExport:143 - alter table Bid drop constraint FK104DDF43A3910
[java] 11:00:10,593 DEBUG SchemaExport:149 - Unsuccessful: alter table Bid drop constraint FK104DDF43A3910
[java] 11:00:10,593 DEBUG SchemaExport:150 - Unexpected token: ALTER in statement [alter table Bid drop constraint FK104DDF43A3910
]
[java] 11:00:10,593 DEBUG SchemaExport:143 - alter table Bid drop constraint FK104DDEE6E7E98
[java] 11:00:10,593 DEBUG SchemaExport:149 - Unsuccessful: alter table Bid drop constraint FK104DDEE6E7E98
[java] 11:00:10,593 DEBUG SchemaExport:150 - Unexpected token: ALTER in statement [alter table Bid drop constraint FK104DDEE6E7E98
]
[java] 11:00:10,609 DEBUG SchemaExport:143 - drop table AuctionItem if exists
[java] 11:00:10,609 DEBUG SchemaExport:149 - Unsuccessful: drop table AuctionItem if exists
[java] 11:00:10,609 DEBUG SchemaExport:150 - Table not found: AUCTIONITEM in statement [drop table AuctionItem if exists]
[java] 11:00:10,609 DEBUG SchemaExport:143 - drop table AuctionUser if exists
[java] 11:00:10,609 DEBUG SchemaExport:149 - Unsuccessful: drop table AuctionUser if exists
[java] 11:00:10,609 DEBUG SchemaExport:150 - Table not found: AUCTIONUSER in statement [drop table AuctionUser if exists]
[java] 11:00:10,609 DEBUG SchemaExport:143 - drop table Bid if exists
[java] 11:00:10,625 DEBUG SchemaExport:149 - Unsuccessful: drop table Bid if exists
[java] 11:00:10,625 DEBUG SchemaExport:150 - Table not found: BID in statement [drop table Bid if exists]
[java] 11:00:10,625 DEBUG SchemaExport:161 - create table AuctionItem (
[java] id bigint generated by default as identity (start with 1),
[java] seller bigint not null,
[java] description varchar(200) not null,
[java] ends timestamp,
[java] condition integer,
[java] successfulBid bigint,
[java] primary key (id),
[java] unique (seller, description)
[java] )
[java] 11:00:10,640 ERROR SchemaExport:167 - Unsuccessful: create table AuctionItem (id bigint generated by default as identity (s
tart with 1), seller bigint not null, description varchar(200) not null, ends timestamp, condition integer, successfulBid bigint, prima
ry key (id), unique (seller, description))
[java] 11:00:10,640 ERROR SchemaExport:168 - Unexpected token: GENERATED in statement [create table AuctionItem (id bigint generat
ed by default as identity (start with 1), seller bigint not null, description varchar(200) not null, ends timestamp, condition integer,
successfulBid bigint, primary key (id), unique (seller, description))]
[java] 11:00:10,640 DEBUG SchemaExport:161 - create table AuctionUser (
[java] id bigint generated by default as identity (start with 1),
[java] userName varchar(10) not null,
[java] "password" varchar(15) not null,
[java] email varchar(255),
[java] firstName varchar(50) not null,
[java] "initial" char(1),
[java] lastName varchar(50) not null,
[java] primary key (id),
[java] unique (userName)
[java] )
[java] 11:00:10,640 ERROR SchemaExport:167 - Unsuccessful: create table AuctionUser (id bigint generated by default as identity (s
tart with 1), userName varchar(10) not null, "password" varchar(15) not null, email varchar(255), firstName varchar(50) not null, "init
ial" char(1), lastName varchar(50) not null, primary key (id), unique (userName))
[java] 11:00:10,671 ERROR SchemaExport:168 - Unexpected token: GENERATED in statement [create table AuctionUser (id bigint generat
ed by default as identity (start with 1), userName varchar(10) not null, "password" varchar(15) not null, email varchar(255), firstName
varchar(50) not null, "initial" char(1), lastName varchar(50) not null, primary key (id), unique (userName))]
[java] 11:00:10,671 DEBUG SchemaExport:161 - create table Bid (
[java] id bigint generated by default as identity (start with 1),
[java] isBuyNow char(1) not null,
[java] item bigint not null,
[java] amount float not null,
[java] "datetime" timestamp not null,
[java] bidder bigint not null,
[java] primary key (id),
[java] unique (item, amount)
[java] )
[java] 11:00:10,718 ERROR SchemaExport:167 - Unsuccessful: create table Bid (id bigint generated by default as identity (start wit
h 1), isBuyNow char(1) not null, item bigint not null, amount float not null, "datetime" timestamp not null, bidder bigint not null, pr
imary key (id), unique (item, amount))
[java] 11:00:10,718 ERROR SchemaExport:168 - Unexpected token: GENERATED in statement [create table Bid (id bigint generated by de
fault as identity (start with 1), isBuyNow char(1) not null, item bigint not null, amount float not null, "datetime" timestamp not null
, bidder bigint not null, primary key (id), unique (item, amount))]
[java] 11:00:10,750 DEBUG SchemaExport:161 - alter table AuctionItem
[java] add constraint FK522A9BD61107FE9B
[java] foreign key (seller)
[java] references AuctionUser
[java] 11:00:10,750 ERROR SchemaExport:167 - Unsuccessful: alter table AuctionItem add constraint FK522A9BD61107FE9B foreign key (
seller) references AuctionUser
[java] 11:00:10,750 ERROR SchemaExport:168 - Unexpected token: ALTER in statement [alter table AuctionItem add constraint FK522A9B
D61107FE9B foreign key (seller) references AuctionUser]
[java] 11:00:10,781 DEBUG SchemaExport:161 - alter table AuctionItem
[java] add constraint FK522A9BD6F65B1FAF
[java] foreign key (successfulBid)
[java] references Bid
[java] 11:00:10,781 ERROR SchemaExport:167 - Unsuccessful: alter table AuctionItem add constraint FK522A9BD6F65B1FAF foreign key (
successfulBid) references Bid
[java] 11:00:10,781 ERROR SchemaExport:168 - Unexpected token: ALTER in statement [alter table AuctionItem add constraint FK522A9B
D6F65B1FAF foreign key (successfulBid) references Bid]
[java] 11:00:10,812 DEBUG SchemaExport:161 - alter table Bid
[java] add constraint FK104DDF43A3910
[java] foreign key (bidder)
[java] references AuctionUser
[java] 11:00:10,812 ERROR SchemaExport:167 - Unsuccessful: alter table Bid add constraint FK104DDF43A3910 foreign key (bidder) ref
erences AuctionUser
[java] 11:00:10,812 ERROR SchemaExport:168 - Unexpected token: ALTER in statement [alter table Bid add constraint FK104DDF43A3910
foreign key (bidder) references AuctionUser]
[java] 11:00:10,859 DEBUG SchemaExport:161 - alter table Bid
[java] add constraint FK104DDEE6E7E98
[java] foreign key (item)
[java] references AuctionItem
[java] 11:00:10,859 ERROR SchemaExport:167 - Unsuccessful: alter table Bid add constraint FK104DDEE6E7E98 foreign key (item) refer
ences AuctionItem
[java] org.hibernate.exception.GenericJDBCException: could not insert: [org.hibernate.auction.User]
[java] at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
[java] at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
[java] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
[java] at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1777)
[java] at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2178)
[java] at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:34)
[java] at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
[java] at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:240)
[java] at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:160)
[java] at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:95)
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventList
ener.java:184)
[java] at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173
)
[java] at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
[java] 11:00:10,859 ERROR SchemaExport:168 - Unexpected token: ALTER in statement [alter table Bid add constraint FK104DDEE6E7E98
foreign key (item) references AuctionItem]
[java] 11:00:10,859 INFO SchemaExport:173 - schema export complete
[java] 11:00:10,875 INFO DriverManagerConnectionProvider:147 - cleaning up connection pool: jdbc:hsqldb:testdb/demo
[java] 11:00:10,875 INFO SessionFactoryImpl:379 - Checking 0 named queries
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
[java] Setting up some test data
[java] at org.hibernate.impl.SessionImpl.save(SessionImpl.java:481)
[java] 11:00:10,921 INFO DriverManagerConnectionProvider:147 - cleaning up connection pool: jdbc:hsqldb:testdb/demo
[java] at org.hibernate.impl.SessionImpl.save(SessionImpl.java:476)
[java] at org.hibernate.auction.Main.createTestAuctions(Main.java:293)
[java] at org.hibernate.auction.Main.main(Main.java:369)
[java] 11:00:11,015 WARN JDBCExceptionReporter:71 - SQL Error: 0, SQLState: S0002
[java] Caused by: java.sql.SQLException: Table not found: AUCTIONUSER in statement [insert into AuctionUser (userName, "password",
email, firstName, "initial", lastName, id) values ('xam', '******', 'max@hibernate.org', 'Max', 'R', 'Andersen', null)]
[java] 11:00:11,015 ERROR JDBCExceptionReporter:72 - Table not found: AUCTIONUSER in statement [insert into AuctionUser (userName,
"password", email, firstName, "initial", lastName, id) values ('xam', '******', 'max@hibernate.org', 'Max', 'R', 'Andersen', null)]
[java] at org.hsqldb.Trace.getError(Trace.java:180)
[java] at org.hsqldb.jdbcResultSet.<init>(jdbcResultSet.java:2645)
[java] at org.hsqldb.jdbcConnection.executeStandalone(jdbcConnection.java:994)
[java] at org.hsqldb.jdbcConnection.execute(jdbcConnection.java:721)
[java] at org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:686)
[java] at org.hsqldb.jdbcStatement.executeUpdate(jdbcStatement.java:85)
[java] at org.hsqldb.jdbcPreparedStatement.executeUpdate(jdbcPreparedStatement.java:152)
[java] at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1767)
[java] ... 15 more


Here's my properties file:
## HypersonicSQL

hibernate.dialect org.hibernate.dialect.HSQLDialect
hibernate.connection.driver_class org.hsqldb.jdbcDriver
hibernate.connection.username sa
hibernate.connection.password
#hibernate.connection.url jdbc:hsqldb:hsql://localhost/testdb
hibernate.connection.url jdbc:hsqldb:testdb/demo

Any help appreciated.

Thanks,
Albert