Hello! I'm a new user of Hibernate and I can't fix a problem with the configuration. I'm following the steps of the reference documentation and at the time of storing I have this problem:
ant run -Daction=store
Buildfile: build.xml
clean:
[delete] Deleting directory /home/mjimenez/workspace/HibernatePrueba/bin
[mkdir] Created dir: /home/mjimenez/workspace/HibernatePrueba/bin
copy-resources:
[copy] Copying 4 files to /home/mjimenez/workspace/HibernatePrueba/bin
[copy] Copied 2 empty directories to 1 empty directory under /home/mjimenez/workspace/HibernatePrueba/bin
compile:
[javac] Compiling 3 source files to /home/mjimenez/workspace/HibernatePrueba/bin
run:
[java] 16:40:54,200 INFO Environment:479 - Hibernate 3.1.3
[java] 16:40:54,210 INFO Environment:494 - loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=org.hsqldb.jdbcDriver, hibernate.cglib.use_reflection_optimizer=true, hibernate.cache.provider_class=org.hibernate.cache.NoCacheProvider, hibernate.current_session_context_class=thread, hibernate.max_fetch_depth=1, hibernate.dialect=org.hibernate.dialect.HSQLDialect, hibernate.jdbc.use_streams_for_binary=true, hibernate.proxool.pool_alias=pool1, hibernate.connection.username=sa, hibernate.cache.region_prefix=hibernate.test, hibernate.hbm2ddl.auto=create, hibernate.connection.url=jdbc:hsqldb:., hibernate.show_sql=true, hibernate.connection.password=****, hibernate.jdbc.batch_versioned_data=true, hibernate.connection.pool_size=1}
[java] 16:40:54,212 INFO Environment:524 - using java.io streams to persist binary types
[java] 16:40:54,214 INFO Environment:525 - using CGLIB reflection optimizer
[java] 16:40:54,216 INFO Environment:555 - using JDK 1.4 java.sql.Timestamp handling
[java] 16:40:54,317 INFO Configuration:1308 - configuring from resource: /hibernate.cfg.xml
[java] 16:40:54,322 INFO Configuration:1285 - Configuration resource: /hibernate.cfg.xml
[java] 16:40:54,647 INFO Configuration:469 - Reading mappings from resource: events/Event.hbm.xml
[java] 16:40:54,804 INFO HbmBinder:309 - Mapping class: events.Event -> EVENTS
[java] 16:40:54,865 INFO Configuration:1419 - Configured SessionFactory: null
[java] 16:40:54,970 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
[java] 16:40:54,970 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
[java] 16:40:54,975 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
[java] 16:40:54,981 INFO DriverManagerConnectionProvider:80 - using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:hsql://localhost
[java] 16:40:54,982 INFO DriverManagerConnectionProvider:86 - connection properties: {user=sa, password=****}
[java] 16:40:55,044 INFO SettingsFactory:77 - RDBMS: HSQL Database Engine, version: 1.6
[java] 16:40:55,045 INFO SettingsFactory:78 - JDBC driver: HSQL Database Engine Driver, version: 1.6
[java] 16:40:55,101 INFO Dialect:103 - Using dialect: org.hibernate.dialect.HSQLDialect
[java] 16:40:55,154 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
[java] 16:40:55,157 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
[java] 16:40:55,158 INFO SettingsFactory:125 - Automatic flush during beforeCompletion(): disabled
[java] 16:40:55,159 INFO SettingsFactory:129 - Automatic session close at end of transaction: disabled
[java] 16:40:55,160 INFO SettingsFactory:144 - Scrollable result sets: disabled
[java] 16:40:55,161 INFO SettingsFactory:152 - JDBC3 getGeneratedKeys(): disabled
[java] 16:40:55,161 INFO SettingsFactory:160 - Connection release mode: auto
[java] 16:40:55,163 INFO SettingsFactory:184 - Maximum outer join fetch depth: 1
[java] 16:40:55,163 INFO SettingsFactory:187 - Default batch fetch size: 1
[java] 16:40:55,164 INFO SettingsFactory:191 - Generate SQL with comments: disabled
[java] 16:40:55,164 INFO SettingsFactory:195 - Order SQL updates by primary key: disabled
[java] 16:40:55,166 INFO SettingsFactory:338 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
[java] 16:40:55,169 INFO ASTQueryTranslatorFactory:24 - Using ASTQueryTranslatorFactory
[java] 16:40:55,170 INFO SettingsFactory:203 - Query language substitutions: {}
[java] 16:40:55,170 INFO SettingsFactory:209 - Second-level cache: enabled
[java] 16:40:55,172 INFO SettingsFactory:213 - Query cache: disabled
[java] 16:40:55,174 INFO SettingsFactory:325 - Cache provider: org.hibernate.cache.NoCacheProvider
[java] 16:40:55,177 INFO SettingsFactory:228 - Optimize cache for minimal puts: disabled
[java] 16:40:55,177 INFO SettingsFactory:233 - Cache region prefix: hibernate.test
[java] 16:40:55,178 INFO SettingsFactory:237 - Structured second-level cache entries: disabled
[java] 16:40:55,184 INFO SettingsFactory:257 - Echoing all SQL to stdout
[java] 16:40:55,184 INFO SettingsFactory:264 - Statistics: disabled
[java] 16:40:55,185 INFO SettingsFactory:268 - Deleted entity synthetic identifier rollback: disabled
[java] 16:40:55,185 INFO SettingsFactory:283 - Default entity-mode: pojo
[java] 16:40:55,255 INFO SessionFactoryImpl:154 - building session factory
[java] 16:40:55,613 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
[java] 16:40:55,618 INFO SchemaExport:152 - Running hbm2ddl schema export
[java] 16:40:55,621 DEBUG SchemaExport:168 - import file not found: /import.sql
[java] 16:40:55,622 INFO SchemaExport:177 - exporting generated schema to database
[java] 16:40:55,624 DEBUG SchemaExport:301 - drop table EVENTS if exists
[java] 16:40:55,626 DEBUG SchemaExport:286 - Unsuccessful: drop table EVENTS if exists
[java] 16:40:55,626 DEBUG SchemaExport:287 - Table not found: EVENTS in statement [drop table EVENTS if exists]
[java] 16:40:55,627 DEBUG SchemaExport:301 - create table EVENTS (EVENT_ID bigint generated by default as identity (start with 1), EVENT_DATE timestamp, title varchar(255), primary key (EVENT_ID))
[java] 16:40:55,635 ERROR SchemaExport:272 - Unsuccessful: create table EVENTS (EVENT_ID bigint generated by default as identity (start with 1), EVENT_DATE timestamp, title varchar(255), primary key (EVENT_ID))
[java] 16:40:55,637 ERROR SchemaExport:273 - Unexpected token: GENERATED in statement [create table EVENTS (EVENT_ID bigint generated by default as identity (start with 1), EVENT_DATE timestamp, title varchar(255), primary key (EVENT_ID))]
[java] 16:40:55,638 INFO SchemaExport:194 - schema export complete
[java] 16:40:55,794 WARN EventManager:? - #############último paso dnd me imprime, a partir de aquí peta del todo
[java] Hibernate: insert into EVENTS (EVENT_DATE, title, EVENT_ID) values (?, ?, null)
[java] 16:40:55,848 WARN JDBCExceptionReporter:71 - SQL Error: 0, SQLState: S0002
[java] 16:40:55,882 ERROR JDBCExceptionReporter:72 - Table not found: EVENTS in statement [insert into EVENTS (EVENT_DATE, title, EVENT_ID) values ('2006-04-28 16:40:54.155', 'My Event', null)]
[java] Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not insert: [events.Event]
[java] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
[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.java:101)
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)
[java] at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)
[java] at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
[java] at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:530)
[java] at org.hibernate.impl.SessionImpl.save(SessionImpl.java:518)
[java] at org.hibernate.impl.SessionImpl.save(SessionImpl.java:514)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:585)
[java] at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:301)
[java] at $Proxy0.save(Unknown Source)
[java] at events.EventManager.createAndStoreEvent(Unknown Source)
[java] at events.EventManager.main(Unknown Source)
[java] Caused by: java.sql.SQLException: Table not found: EVENTS in statement [insert into EVENTS (EVENT_DATE, title, EVENT_ID) values ('2006-04-28 16 :40:54.155', 'My Event', null)]
[java] at org.hsqldb.Trace.getError(Trace.java:180)
[java] at org.hsqldb.Result.<init>(Result.java:175)
[java] at org.hsqldb.jdbcConnection.executeHSQL(jdbcConnection.java:907)
[java] at org.hsqldb.jdbcConnection.execute(jdbcConnection.java:718)
[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.AbstractEntityPersister.insert(AbstractEntityPersister.java:1976)
[java] ... 22 more
[java] Java Result: 1
BUILD SUCCESSFUL
Total time: 3 seconds
Which is my problem? Thank you very much for your time
|