Здравствуйте, я пытаюсь изучить Hibernate по книге "Hibernate: A Developer's Notebook".
В связи с этим возникли проблемы (в архиве - иерархия каталогов с файлами):

1. не генерируется схема базы данных:

C:\Program Files\Apache Group\Tomcat 4.1\webapps\play>ant schema
Buildfile: build.xml

prepare:

compile:
[javac] Compiling 1 source file to C:\Program Files\Apache Group\Tomcat 4.1\
webapps\play\classes

schema:
[schemaexport] 21:19:30,516 INFO Environment:483 - Hibernate 2.1.8
[schemaexport] 21:19:30,536 INFO Environment:517 - loaded properties from resou
rce hibernate.properties: {hibernate.connection.username=sa, hibernate.connectio
n.password=, hibernate.cglib.use_reflection_optimizer=true, hibernate.dialect=ne
t.sf.hibernate.dialect.HSQLDialect, hibernate.connection.url=jdbc:hsqldb:data/mu
sic, hibernate.connection.driver_class=org.hsqldb.jdbcDriver}
[schemaexport] 21:19:30,546 INFO Environment:543 - using CGLIB reflection optim
izer
[schemaexport] 21:19:30,556 INFO Environment:572 - using JDK 1.4 java.sql.Times
tamp handling
[schemaexport] 21:19:30,576 INFO Configuration:170 - Mapping file: C:\Program F
iles\Apache Group\Tomcat 4.1\webapps\play\classes\com\oreilly\hh\Track.hbm.xml
[schemaexport] 21:19:31,217 INFO Binder:229 - Mapping class: com.oreilly.hh.Tra
ck -> TRACK
[schemaexport] 21:19:31,517 INFO Dialect:86 - Using dialect: net.sf.hibernate.d
ialect.HSQLDialect
[schemaexport] 21:19:31,537 INFO Configuration:641 - processing one-to-many ass
ociation mappings
[schemaexport] 21:19:31,537 INFO Configuration:650 - processing one-to-one asso
ciation property references
[schemaexport] 21:19:31,537 INFO Configuration:675 - processing foreign key con
straints
[schemaexport] 21:19:31,648 INFO Configuration:641 - processing one-to-many ass
ociation mappings
[schemaexport] 21:19:31,648 INFO Configuration:650 - processing one-to-one asso
ciation property references
[schemaexport] 21:19:31,648 INFO Configuration:675 - processing foreign key con
straints
[schemaexport] 21:19:31,668 INFO SchemaExport:98 - Running hbm2ddl schema expor
t
[schemaexport] 21:19:31,668 INFO SchemaExport:112 - writing generated schema to
file: schema-export.sql
[schemaexport] 21:19:31,678 INFO SchemaExport:117 - exporting generated schema
to database
[schemaexport] 21:19:31,698 INFO DriverManagerConnectionProvider:42 - Using Hib
ernate built-in connection pool (not for production use!)
[schemaexport] 21:19:31,698 INFO DriverManagerConnectionProvider:43 - Hibernate
connection pool size: 20
[schemaexport] 21:19:31,708 INFO DriverManagerConnectionProvider:77 - using dri
ver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:data/music
[schemaexport] 21:19:31,718 INFO DriverManagerConnectionProvider:78 - connectio
n properties: {user=sa, password=}
[schemaexport] drop table TRACK if exists;
[schemaexport] 21:19:32,709 DEBUG SchemaExport:132 - drop table TRACK if exists;

[schemaexport] create table TRACK (
[schemaexport] TRACK_ID integer generated by default as identity (start with
1),
[schemaexport] title varchar(255) not null,
[schemaexport] filePath varchar(255) not null,
[schemaexport] playTime time,
[schemaexport] added date,
[schemaexport] volume smallint
[schemaexport] );
[schemaexport] 21:19:32,719 DEBUG SchemaExport:149 - create table TRACK (
[schemaexport] TRACK_ID integer generated by default as identity (start with
1),
[schemaexport] title varchar(255) not null,
[schemaexport] filePath varchar(255) not null,
[schemaexport] playTime time,
[schemaexport] added date,
[schemaexport] volume smallint
[schemaexport] );
[schemaexport] 21:19:32,739 INFO SchemaExport:160 - schema export complete
[schemaexport] 21:19:32,749 INFO DriverManagerConnectionProvider:143 - cleaning
up connection pool: jdbc:hsqldb:data/music

BUILD SUCCESSFUL
Total time: 9 seconds

Насколько я понял, выдаются сообщения, что экспорт схемы прошел успешно, одноко на самом деле таблица в базе данных не создается. Я добавил экспорт скрипта в файл sql, после этого выполнив команды файла в базе все нормально создалось. Понятно, что можно делать все руками, но хотелось бы автоматом. Скажите, где и что я пропустил?

2. не получается ввести данные в таблицу базы:

C:\Program Files\Apache Group\Tomcat 4.1\webapps\play>ant ctest
Buildfile: build.xml

prepare:

compile:

ctest:
[java] 21:25:42,791 INFO Environment:483 - Hibernate 2.1.8
[java] 21:25:42,841 INFO Environment:517 - loaded properties from resource
hibernate.properties: {hibernate.connection.username=sa, hibernate.connection.p
assword=, hibernate.cglib.use_reflection_optimizer=true, hibernate.dialect=net.s
f.hibernate.dialect.HSQLDialect, hibernate.connection.url=jdbc:hsqldb:data/music
, hibernate.connection.driver_class=org.hsqldb.jdbcDriver}
[java] 21:25:42,841 INFO Environment:543 - using CGLIB reflection optimize
r
[java] 21:25:42,851 INFO Environment:572 - using JDK 1.4 java.sql.Timestam
p handling
[java] 21:25:42,851 INFO Configuration:351 - Mapping resource: com/oreilly
/hh/Track.hbm.xml
[java] 21:25:44,093 INFO Binder:229 - Mapping class: com.oreilly.hh.Track
-> TRACK
[java] 21:25:44,283 INFO Configuration:641 - processing one-to-many associ
ation mappings
[java] 21:25:44,283 INFO Configuration:650 - processing one-to-one associa
tion property references
[java] 21:25:44,283 INFO Configuration:675 - processing foreign key constr
aints
[java] 21:25:44,344 INFO Dialect:86 - Using dialect: net.sf.hibernate.dial
ect.HSQLDialect
[java] 21:25:44,364 INFO SettingsFactory:74 - Use outer join fetching: tru
e
[java] 21:25:44,384 INFO DriverManagerConnectionProvider:42 - Using Hibern
ate built-in connection pool (not for production use!)
[java] 21:25:44,384 INFO DriverManagerConnectionProvider:43 - Hibernate co
nnection pool size: 20
[java] 21:25:44,384 INFO DriverManagerConnectionProvider:77 - using driver
: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:data/music
[java] 21:25:44,384 INFO DriverManagerConnectionProvider:78 - connection p
roperties: {user=sa, password=}
[java] 21:25:44,424 INFO TransactionManagerLookupFactory:33 - No Transacti
onManagerLookup configured (in JTA environment, use of process level read-write
cache is not recommended)
[java] 21:25:45,455 INFO SettingsFactory:114 - Use scrollable result sets:
true
[java] 21:25:45,465 INFO SettingsFactory:117 - Use JDBC3 getGeneratedKeys(
): false
[java] 21:25:45,465 INFO SettingsFactory:120 - Optimize cache for minimal
puts: false
[java] 21:25:45,465 INFO SettingsFactory:129 - Query language substitution
s: {}
[java] 21:25:45,465 INFO SettingsFactory:140 - cache provider: net.sf.hibe
rnate.cache.EhCacheProvider
[java] 21:25:45,485 INFO Configuration:1130 - instantiating and configurin
g caches
[java] 21:25:45,525 WARN Configurator:125 - No configuration found. Config
uring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/C:/Pro
gram%20Files/Apache%20Group/Tomcat%204.1/webapps/play/lib/ehcache-0.9.jar!/ehcac
he-failsafe.xml
[java] 21:25:45,856 INFO SessionFactoryImpl:119 - building session factory

[java] 21:25:46,607 INFO SessionFactoryObjectFactory:82 - Not binding fact
ory to JNDI, no JNDI name configured
[java] 21:25:46,837 INFO SessionFactoryImpl:542 - closing
[java] 21:25:46,837 INFO DriverManagerConnectionProvider:143 - cleaning up
connection pool: jdbc:hsqldb:data/music

BUILD SUCCESSFUL
Total time: 7 seconds

Опять таки BUILD SUCCESSFUL, но данных в таблицу не добавляется.

Подскажите пожалуйста, где я ошибся.
Вообще кто-нибудь с hibernate разбирался, можете подсказать с чего лучше начать, может книжку какую посоветуете.

Alexey TurnИмхо пытаться изучить хбернэйт начиная с изучения его тулз по генерации бд и прочего -это подход немного не с той стороны.


1.Возможно я начал и не с той строны, но создав руками таблицу в базе не могу внести в нее данные с помощью hibernate. Уж это-то наверно та самая сторона?

Если ты работал с hibernate, можешь объяснить на простом примере, как все завести например с тойже hsqldb или MySQL?