Hibernate version: 3.1.3, March 20, 2006

Name and version of the database you are using: MySQL version: 3.23.58-max-debug

Issue Description :
I have installed the Hibernate 3.1.3 March 20th Version. I tried to execute the default example in MySql Database by executing the command build eg, got the following issues. As I am new to this, can you pls some one help me to rectify this issue.


Full stack trace of any exception that occurs:
D:\hibernate-3.1>build eg

D:\hibernate-3.1>c:\jdk1.5.0_06\bin\java -cp "lib/ant-launcher-1.6.5.jar" org.apache.tools.ant.launch.Launcher -lib li
b eg
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] 14:55:39,218 INFO Environment:479 - Hibernate 3.1.3
[java] 14:55:39,250 INFO Environment:494 - loaded properties from resource hibernate.properties: {hibernate.conn
ection.driver_class=com.mysql.jdbc.Driver, hibernate.cglib.use_reflection_optimizer=true, hibernate.cache.provider_cla
ss=org.hibernate.cache.HashtableCacheProvider, hibernate.max_fetch_depth=1, hibernate.dialect=org.hibernate.dialect.My
SQLMyISAMDialect, hibernate.jdbc.use_streams_for_binary=true, hibernate.format_sql=true, hibernate.query.substitutions
=yes 'Y', no 'N', hibernate.proxool.pool_alias=pool1, hibernate.connection.username=root, hibernate.cache.region_prefi
x=hibernate.test, hibernate.connection.url=jdbc:mysql://localhost/test, hibernate.connection.password=****, hibernate.
jdbc.batch_versioned_data=true, hibernate.connection.pool_size=1}
[java] 14:55:39,265 INFO Environment:524 - using java.io streams to persist binary types
[java] 14:55:39,265 INFO Environment:525 - using CGLIB reflection optimizer
[java] 14:55:39,265 INFO Environment:555 - using JDK 1.4 java.sql.Timestamp handling
[java] 14:55:39,453 INFO Configuration:497 - Reading mappings from resource: org/hibernate/auction/AuctionItem.h
bm.xml
[java] 14:55:40,187 INFO HbmBinder:309 - Mapping class: org.hibernate.auction.AuctionItem -> AuctionItem
[java] 14:55:40,406 INFO Configuration:497 - Reading mappings from resource: org/hibernate/auction/Bid.hbm.xml
[java] 14:55:40,500 INFO HbmBinder:309 - Mapping class: org.hibernate.auction.Bid -> Bid
[java] 14:55:40,578 INFO HbmBinder:824 - Mapping subclass: org.hibernate.auction.BuyNow -> Bid
[java] 14:55:40,593 INFO Configuration:497 - Reading mappings from resource: org/hibernate/auction/User.hbm.xml
[java] 14:55:40,687 INFO HbmBinder:309 - Mapping class: org.hibernate.auction.User -> AuctionUser
[java] 14:55:40,703 INFO HbmBinder:2349 - Mapping collection: org.hibernate.auction.AuctionItem.bids -> Bid
[java] 14:55:40,703 INFO HbmBinder:2349 - Mapping collection: org.hibernate.auction.User.bids -> Bid
[java] 14:55:40,703 INFO HbmBinder:2349 - Mapping collection: org.hibernate.auction.User.auctions -> AuctionItem

[java] 14:55:41,093 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for
production use!)
[java] 14:55:41,140 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
[java] 14:55:41,140 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
[java] 14:55:41,312 INFO DriverManagerConnectionProvider:80 - using driver: com.mysql.jdbc.Driver at URL: jdbc:m
ysql://localhost/test
[java] 14:55:41,312 INFO DriverManagerConnectionProvider:86 - connection properties: {user=root, password=****}
[java] 14:55:44,703 INFO SettingsFactory:77 - RDBMS: MySQL, version: 3.23.58-max-debug
[java] 14:55:44,703 INFO SettingsFactory:78 - JDBC driver: MySQL-AB JDBC Driver, version: 3.0.8-stable ( $Date:
2003/05/19 00:57:19 $, $Revision: 1.27.2.18 $ )
[java] 14:55:45,187 INFO Dialect:103 - Using dialect: org.hibernate.dialect.MySQLMyISAMDialect
[java] 14:55:45,328 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transact
ions)
[java] 14:55:47,687 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA env
ironment, use of read-write or transactional second-level cache is not recommended)
[java] 14:55:47,687 INFO SettingsFactory:125 - Automatic flush during beforeCompletion(): disabled
[java] 14:55:47,687 INFO SettingsFactory:129 - Automatic session close at end of transaction: disabled
[java] 14:55:47,703 INFO SettingsFactory:136 - JDBC batch size: 15
[java] 14:55:47,703 INFO SettingsFactory:139 - JDBC batch updates for versioned data: enabled
[java] 14:55:47,703 INFO SettingsFactory:144 - Scrollable result sets: enabled
[java] 14:55:47,703 INFO SettingsFactory:152 - JDBC3 getGeneratedKeys(): enabled
[java] 14:55:47,703 INFO SettingsFactory:160 - Connection release mode: auto
[java] 14:55:47,703 INFO SettingsFactory:184 - Maximum outer join fetch depth: 1
[java] 14:55:47,703 INFO SettingsFactory:187 - Default batch fetch size: 1
[java] 14:55:47,703 INFO SettingsFactory:191 - Generate SQL with comments: disabled
[java] 14:55:47,703 INFO SettingsFactory:195 - Order SQL updates by primary key: disabled
[java] 14:55:47,703 INFO SettingsFactory:338 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory

[java] 14:55:48,031 INFO ASTQueryTranslatorFactory:24 - Using ASTQueryTranslatorFactory
[java] 14:55:48,031 INFO SettingsFactory:203 - Query language substitutions: {no='N', yes='Y'}
[java] 14:55:48,031 INFO SettingsFactory:209 - Second-level cache: enabled
[java] 14:55:48,031 INFO SettingsFactory:213 - Query cache: disabled
[java] 14:55:48,031 INFO SettingsFactory:325 - Cache provider: org.hibernate.cache.HashtableCacheProvider
[java] 14:55:48,140 INFO SettingsFactory:228 - Optimize cache for minimal puts: disabled
[java] 14:55:48,140 INFO SettingsFactory:233 - Cache region prefix: hibernate.test
[java] 14:55:48,140 INFO SettingsFactory:237 - Structured second-level cache entries: disabled
[java] 14:55:48,156 INFO SettingsFactory:264 - Statistics: disabled
[java] 14:55:48,156 INFO SettingsFactory:268 - Deleted entity synthetic identifier rollback: disabled
[java] 14:55:48,156 INFO SettingsFactory:283 - Default entity-mode: pojo
[java] 14:55:49,515 INFO SessionFactoryImpl:154 - building session factory
[java] 14:55:51,656 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
[java] 14:55:51,734 INFO SchemaExport:152 - Running hbm2ddl schema export
[java] 14:55:51,750 DEBUG SchemaExport:168 - import file not found: /import.sql
[java] 14:55:51,750 INFO SchemaExport:177 - exporting generated schema to database
[java] 14:55:51,750 DEBUG SchemaExport:301 -
[java] drop table if exists AuctionItem
[java] 14:55:51,984 DEBUG SchemaExport:301 -
[java] drop table if exists AuctionUser
[java] 14:55:51,984 DEBUG SchemaExport:301 -
[java] drop table if exists Bid
[java] 14:55:52,000 DEBUG SchemaExport:301 -
[java] create table AuctionItem (
[java] id bigint not null auto_increment,
[java] seller bigint not null,
[java] shortDescription varchar(200) not null,
[java] description text,
[java] ends datetime,
[java] `CONDITION` integer,
[java] successfulBid bigint,
[java] primary key (id),
[java] unique (seller, shortDescription)
[java] ) comment='An item that is being auctioned.' type=MyISAM
[java] 14:55:52,390 DEBUG SchemaExport:301 -
[java] create table AuctionUser (
[java] id bigint not null auto_increment,
[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] ) comment='Users may bid for or sell auction items.' type=MyISAM
[java] 14:55:52,468 DEBUG SchemaExport:301 -
[java] create table Bid (
[java] id bigint not null auto_increment,
[java] isBuyNow char(1) not null comment 'Y if a "buy now", N if a regular bid.',
[java] item bigint not null,
[java] amount float not null,
[java] `datetime` datetime not null,
[java] bidder bigint not null,
[java] primary key (id),
[java] unique (item, amount)
[java] ) comment='A bid or "buy now" for an item.' type=MyISAM
[java] 14:55:52,484 ERROR SchemaExport:272 - Unsuccessful: create table Bid (id bigint not null auto_increment, i
sBuyNow char(1) not null comment 'Y if a "buy now", N if a regular bid.', item bigint not null, amount float not null,
`datetime` datetime not null, bidder bigint not null, primary key (id), unique (item, amount)) comment='A bid or "buy
now" for an item.' type=MyISAM
[java] 14:55:52,484 ERROR SchemaExport:273 - Syntax error or access violation, message from server: "You have an
error in your SQL syntax near 'comment 'Y if a "buy now", N if a regular bid.', item bigint not null, amount fl' at l
ine 1"

[java] 14:55:52,484 DEBUG SchemaExport:301 -
[java] alter table AuctionItem
[java] add index FK522A9BD6F65B1FAF (successfulBid),
[java] add constraint FK522A9BD6F65B1FAF
[java] foreign key (successfulBid)
[java] references Bid (id)
[java] 14:55:53,281 DEBUG SchemaExport:301 -
[java] alter table AuctionItem
[java] add index FK522A9BD61107FE9B (seller),
[java] add constraint FK522A9BD61107FE9B
[java] foreign key (seller)
[java] references AuctionUser (id)
[java] 14:55:53,593 DEBUG SchemaExport:301 -
[java] alter table Bid
[java] add index FK104DDF43A3910 (bidder),
[java] add constraint FK104DDF43A3910
[java] foreign key (bidder)
[java] references AuctionUser (id)
[java] 14:55:53,609 ERROR SchemaExport:272 - Unsuccessful: alter table Bid add index FK104DDF43A3910 (bidder), ad
d constraint FK104DDF43A3910 foreign key (bidder) references AuctionUser (id)
[java] 14:55:53,609 ERROR SchemaExport:273 - General error, message from server: "Table 'test.bid' doesn't exist
"
[java] 14:55:53,609 DEBUG SchemaExport:301 -
[java] alter table Bid
[java] add index FK104DDEE6E7E98 (item),
[java] add constraint FK104DDEE6E7E98
[java] foreign key (item)
[java] references AuctionItem (id)
[java] 14:56:01,593 ERROR SchemaExport:272 - Unsuccessful: alter table Bid add index FK104DDEE6E7E98 (item), add
constraint FK104DDEE6E7E98 foreign key (item) references AuctionItem (id)
[java] 14:56:01,593 ERROR SchemaExport:273 - General error, message from server: "Table 'test.bid' doesn't exist
"
[java] 14:56:01,593 INFO SchemaExport:194 - schema export complete
[java] Setting up some test data
[java] 14:56:04,281 WARN JDBCExceptionReporter:71 - SQL Error: 1146, SQLState: S1000
[java] 14:56:04,281 ERROR JDBCExceptionReporter:72 - General error, message from server: "Table 'test.bid' doesn
't exist"
[java] Exception in thread "main" org.hibernate.exception.GenericJDBCException: could not insert: [org.hibernate.
auction.Bid]
[java] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
[java] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
[java] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
[java] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1986)
[java] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2405)
[java] at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:37)
[java] at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
[java] at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.
java:269)
[java] at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167)
[java] at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.jav
a:101)
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSave
OrUpdateEventListener.java:186)
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEvent
Listener.java:175)
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEve
ntListener.java:98)
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventLis
tener.java:70)
[java] at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:502)
[java] at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:494)
[java] at org.hibernate.engine.CascadingAction$1.cascade(CascadingAction.java:134)
[java] at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:213)
[java] at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:157)
[java] at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
[java] at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:290)
[java] at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:185)
[java] at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:160)
[java] at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
[java] at org.hibernate.engine.Cascade.cascade(Cascade.java:248)
[java] at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:4
10)
[java] at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.
java:299)
[java] at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167)
[java] at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.jav
a:101)
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSave
OrUpdateEventListener.java:186)
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEvent
Listener.java:175)
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEve
ntListener.java:98)
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventLis
tener.java:70)
[java] at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:502)
[java] at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:494)
[java] at org.hibernate.engine.CascadingAction$1.cascade(CascadingAction.java:134)
[java] at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:213)
[java] at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:157)
[java] at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
[java] at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:290)
[java] at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:185)
[java] at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:160)
[java] at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
[java] at org.hibernate.engine.Cascade.cascade(Cascade.java:248)
[java] at org.hibernate.event.def.AbstractFlushingEventListener.cascadeOnFlush(AbstractFlushingEventListener.
java:130)
[java] at org.hibernate.event.def.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventLis
tener.java:121)
[java] at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingE
ventListener.java:65)
[java] at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
[java] at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
[java] at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:333)
[java] at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
[java] at org.hibernate.auction.Main.createTestAuctions(Main.java:349)
[java] at org.hibernate.auction.Main.main(Main.java:370)
[java] Caused by: java.sql.SQLException: General error, message from server: "Table 'test.bid' doesn't exist"
[java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1648)
[java] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:886)
[java] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:953)
[java] at com.mysql.jdbc.Connection.execSQL(Connection.java:1871)
[java] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1697)
[java] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1566)
[java] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1968)
[java] ... 49 more

BUILD FAILED
D:\hibernate-3.1\build.xml:707: Java returned: 1

Total time: 30 seconds

D:\hibernate-3.1>

really could be the problem of MYISAM, which u chose to be ur table type and myisam doesn't support foreign key