To na luta p/ aprender Hibernate, ate q na teoria usando xml to entendendo. Dai fui fazer um “alo mundo” do Hibernate p mexer na pratica, mas so q ta dando um problema q ate agora n sei oq eh, alguem sabe como arrumar isso?
O proposito da mini aplicacao, eh gravar os dados do objeto “Event” na tabela “eventos” do banco, usando hibernate.
Vo postar o problema e os arquivos:
A mensagem de saida completa com o erro:
init:
deps-jar:
compile-single:
run-single:
02:12:51,810 INFO Environment:514 - Hibernate 3.2.4.sp1
02:12:51,825 INFO Environment:547 - hibernate.properties not found
02:12:51,825 INFO Environment:681 - Bytecode provider name : cglib
02:12:51,841 INFO Environment:598 - using JDK 1.4 java.sql.Timestamp handling
02:12:51,981 INFO Configuration:1426 - configuring from resource: /hibernate.cfg.xml
02:12:51,997 INFO Configuration:1403 - Configuration resource: /hibernate.cfg.xml
02:12:52,091 DEBUG DTDEntityResolver:38 - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd]
02:12:52,106 DEBUG DTDEntityResolver:40 - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
02:12:52,106 DEBUG DTDEntityResolver:50 - located [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd] in classpath
02:12:52,185 DEBUG Configuration:1387 - connection.driver_class=org.postgresql.Driver
02:12:52,185 DEBUG Configuration:1387 - connection.url=jdbc:postgresql://localhost
02:12:52,185 DEBUG Configuration:1387 - connection.username=postgres
02:12:52,185 DEBUG Configuration:1387 - connection.password=senha
02:12:52,185 DEBUG Configuration:1387 - connection.pool_size=1
02:12:52,185 DEBUG Configuration:1387 - dialect=org.hibernate.dialect.HSQLDialect
02:12:52,185 DEBUG Configuration:1387 - current_session_context_class=thread
02:12:52,185 DEBUG Configuration:1387 - cache.provider_class=org.hibernate.cache.NoCacheProvider
02:12:52,200 DEBUG Configuration:1387 - show_sql=true
02:12:52,200 DEBUG Configuration:1387 - hbm2ddl.auto=create
02:12:52,216 DEBUG Configuration:1586 - null<-org.dom4j.tree.DefaultAttribute@a761fe [Attribute: name resource value "events/Event.hbm.xml"]
02:12:52,216 INFO Configuration:553 - Reading mappings from resource : events/Event.hbm.xml
02:12:52,216 DEBUG DTDEntityResolver:38 - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
02:12:52,216 DEBUG DTDEntityResolver:40 - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
02:12:52,216 DEBUG DTDEntityResolver:50 - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
02:12:52,403 INFO HbmBinder:300 - Mapping class: events.Event -> eventos
02:12:52,419 DEBUG HbmBinder:1270 - Mapped property: id -> id
02:12:52,419 DEBUG HbmBinder:1270 - Mapped property: date -> date
02:12:52,419 DEBUG HbmBinder:1270 - Mapped property: title -> title
02:12:52,419 INFO Configuration:1541 - Configured SessionFactory: null
02:12:52,419 DEBUG Configuration:1542 - properties: {java.vendor=Sun Microsystems Inc., show_sql=true, hibernate.connection.url=jdbc:postgresql://localhost, sun.management.compiler=HotSpot Client Compiler, os.name=Windows XP, hbm2ddl.auto=create, sun.boot.class.path=C:\Arquivos de programas\Sun\AppServer\jdk\jre\lib\rt.jar;C:\Arquivos de programas\Sun\AppServer\jdk\jre\lib\i18n.jar;C:\Arquivos de programas\Sun\AppServer\jdk\jre\lib\sunrsasign.jar;C:\Arquivos de programas\Sun\AppServer\jdk\jre\lib\jsse.jar;C:\Arquivos de programas\Sun\AppServer\jdk\jre\lib\jce.jar;C:\Arquivos de programas\Sun\AppServer\jdk\jre\lib\charsets.jar;C:\Arquivos de programas\Sun\AppServer\jdk\jre\classes, hibernate.current_session_context_class=thread, sun.desktop=windows, java.vm.specification.vendor=Sun Microsystems Inc., java.runtime.version=1.5.0_06-b05, hibernate.cache.provider_class=org.hibernate.cache.NoCacheProvider, user.name=hlds, connection.driver_class=org.postgresql.Driver, current_session_context_class=thread, user.language=pt, sun.boot.library.path=C:\Arquivos de programas\Sun\AppServer\jdk\jre\bin, dialect=org.hibernate.dialect.HSQLDialect, java.version=1.5.0_06, user.timezone=GMT-03:00, sun.arch.data.model=32, java.endorsed.dirs=C:\Arquivos de programas\Sun\AppServer\jdk\jre\lib\endorsed, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86, sun.jnu.encoding=Cp1252, file.encoding.pkg=sun.io, file.separator=\, java.specification.name=Java Platform API Specification, java.class.version=49.0, user.country=BR, connection.url=jdbc:postgresql://localhost, java.home=C:\Arquivos de programas\Sun\AppServer\jdk\jre, java.vm.info=mixed mode, os.version=5.1, path.separator=;, connection.password=senha, java.vm.version=1.5.0_06-b05, hibernate.connection.password=senha, user.variant=, java.awt.printerjob=sun.awt.windows.WPrinterJob, sun.io.unicode.encoding=UnicodeLittle, awt.toolkit=sun.awt.windows.WToolkit, hibernate.connection.username=postgres, user.home=C:\Documents and Settings\hlds, java.specification.vendor=Sun Microsystems Inc., hibernate.hbm2ddl.auto=create, java.library.path=C:\Arquivos de programas\Sun\AppServer\jdk\jre\bin;.;C:\WINDOWS\System32;C:\WINDOWS;C:\Arquivos de programas\Borland\Delphi7\Bin;C:\Arquivos de programas\Borland\Delphi7\Projects\Bpl\;C:\Arquivos de programas\Sun\AppServer\jdk\bin;C:\Arquivos de programas\Sun\AppServer\jdk\lib;C:\WINDOWS\system32;C:\Documents and Settings\hlds\Meus documentos\NetBeans workspace\Catalogo_codata_servidor\build;C:\Documents and Settings\hlds\Meus documentos\NetBeans workspace\Catalogo_codata_servidor\build\classes;C:\Documents and Settings\hlds\Meus documentos\NetBeans workspace\Catalogo_codata_servidor\build\classes\catalogo_codata_servidor;C:\Documents and Settings\hlds\Meus documentos\NetBeans workspace\Catalogo_codata_servidor\dist;C:\Documents and Settings\hlds\Meus documentos\NetBeans workspace\Catalogo_codata_servidor\dist\Catalogo_codata_servidor.jar;C:\Arquivos de programas\Sun\AppServer\bin;h-?, java.vendor.url=http://java.sun.com/, hibernate.connection.driver_class=org.postgresql.Driver, connection.username=postgres, java.vm.vendor=Sun Microsystems Inc., hibernate.dialect=org.hibernate.dialect.HSQLDialect, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, java.class.path=C:\Arquivos de programas\Java Api\postgresql-8.2-505.jdbc3.jar;C:\Arquivos de programas\hibernate-3.2\hibernate3.jar;C:\Arquivos de programas\hibernate-3.2\lib\antlr-2.7.6.jar;C:\Arquivos de programas\hibernate-3.2\lib\cglib-2.1.3.jar;C:\Arquivos de programas\hibernate-3.2\lib\asm-attrs.jar;C:\Arquivos de programas\hibernate-3.2\lib\asm.jar;C:\Arquivos de programas\hibernate-3.2\lib\commons-collections-2.1.1.jar;C:\Arquivos de programas\hibernate-3.2\lib\commons-logging-1.0.4.jar;C:\Arquivos de programas\hibernate-3.2\lib\dom4j-1.6.1.jar;C:\Arquivos de programas\hibernate-3.2\lib\jta.jar;C:\Arquivos de programas\hibernate-3.2\lib\log4j-1.2.11.jar;C:\Documents and Settings\hlds\Meus documentos\NetBeans workspace\Testando_hibernate\build\classes, hibernate.bytecode.use_reflection_optimizer=false, java.vm.specification.name=Java Virtual Machine Specification, java.vm.specification.version=1.0, sun.cpu.endian=little, sun.os.patch.level=, connection.pool_size=1, java.io.tmpdir=C:\DOCUME~1\hlds\CONFIG~1\Temp\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, os.arch=x86, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.ext.dirs=C:\Arquivos de programas\Sun\AppServer\jdk\jre\lib\ext, user.dir=C:\Documents and Settings\hlds\Meus documentos\NetBeans workspace\Testando_hibernate, line.separator=
, java.vm.name=Java HotSpot(TM) Client VM, cache.provider_class=org.hibernate.cache.NoCacheProvider, file.encoding=Cp1252, java.specification.version=1.5, hibernate.show_sql=true, hibernate.connection.pool_size=1}
02:12:52,435 DEBUG Configuration:1285 - Preparing to build session factory with filters : {}
02:12:52,435 DEBUG Configuration:1120 - processing extends queue
02:12:52,435 DEBUG Configuration:1124 - processing collection mappings
02:12:52,435 DEBUG Configuration:1135 - processing native query and ResultSetMapping mappings
02:12:52,435 DEBUG Configuration:1143 - processing association property references
02:12:52,435 DEBUG Configuration:1165 - processing foreign key constraints
02:12:52,528 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
02:12:52,544 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
02:12:52,544 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
02:12:52,575 INFO DriverManagerConnectionProvider:80 - using driver: org.postgresql.Driver at URL: jdbc:postgresql://localhost
02:12:52,575 INFO DriverManagerConnectionProvider:83 - connection properties: {user=postgres, password=senha}
02:12:52,575 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
02:12:52,575 DEBUG DriverManagerConnectionProvider:109 - opening new JDBC connection
02:12:52,778 DEBUG DriverManagerConnectionProvider:115 - created connection to: jdbc:postgresql://localhost, Isolation Level: 2
02:12:52,794 INFO SettingsFactory:89 - RDBMS: PostgreSQL, version: 8.2.4
02:12:52,794 INFO SettingsFactory:90 - JDBC driver: PostgreSQL Native Driver, version: PostgreSQL 8.2 JDBC3 with SSL (build 505)
02:12:52,794 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
02:12:52,841 INFO Dialect:152 - Using dialect: org.hibernate.dialect.HSQLDialect
02:12:52,841 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
02:12:52,856 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
02:12:52,856 INFO SettingsFactory:143 - Automatic flush during beforeCompletion(): disabled
02:12:52,856 INFO SettingsFactory:147 - Automatic session close at end of transaction: disabled
02:12:52,856 INFO SettingsFactory:154 - JDBC batch size: 15
02:12:52,872 INFO SettingsFactory:157 - JDBC batch updates for versioned data: disabled
02:12:52,872 INFO SettingsFactory:162 - Scrollable result sets: enabled
02:12:52,872 DEBUG SettingsFactory:166 - Wrap result sets: disabled
02:12:52,872 INFO SettingsFactory:170 - JDBC3 getGeneratedKeys(): disabled
02:12:52,872 INFO SettingsFactory:178 - Connection release mode: auto
02:12:52,872 INFO SettingsFactory:205 - Default batch fetch size: 1
02:12:52,872 INFO SettingsFactory:209 - Generate SQL with comments: disabled
02:12:52,872 INFO SettingsFactory:213 - Order SQL updates by primary key: disabled
02:12:52,872 INFO SettingsFactory:217 - Order SQL inserts for batching: disabled
02:12:52,872 INFO SettingsFactory:386 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
02:12:52,888 INFO ASTQueryTranslatorFactory:24 - Using ASTQueryTranslatorFactory
02:12:52,888 INFO SettingsFactory:225 - Query language substitutions: {}
02:12:52,888 INFO SettingsFactory:230 - JPA-QL strict compliance: disabled
02:12:52,888 INFO SettingsFactory:235 - Second-level cache: enabled
02:12:52,888 INFO SettingsFactory:239 - Query cache: disabled
02:12:52,888 INFO SettingsFactory:373 - Cache provider: org.hibernate.cache.NoCacheProvider
02:12:52,888 INFO SettingsFactory:254 - Optimize cache for minimal puts: disabled
02:12:52,888 INFO SettingsFactory:263 - Structured second-level cache entries: disabled
02:12:52,888 DEBUG SQLExceptionConverterFactory:52 - Using dialect defined converter
02:12:52,903 INFO SettingsFactory:283 - Echoing all SQL to stdout
02:12:52,903 INFO SettingsFactory:290 - Statistics: disabled
02:12:52,903 INFO SettingsFactory:294 - Deleted entity synthetic identifier rollback: disabled
02:12:52,903 INFO SettingsFactory:309 - Default entity-mode: pojo
02:12:52,903 INFO SettingsFactory:313 - Named query checking : enabled
02:12:52,950 INFO SessionFactoryImpl:161 - building session factory
02:12:52,950 DEBUG SessionFactoryImpl:173 - Session factory constructed with filter configurations : {}
02:12:52,950 DEBUG SessionFactoryImpl:177 - instantiating session factory with properties: {java.vendor=Sun Microsystems Inc., show_sql=true, hibernate.connection.url=jdbc:postgresql://localhost, sun.management.compiler=HotSpot Client Compiler, os.name=Windows XP, hbm2ddl.auto=create, sun.boot.class.path=C:\Arquivos de programas\Sun\AppServer\jdk\jre\lib\rt.jar;C:\Arquivos de programas\Sun\AppServer\jdk\jre\lib\i18n.jar;C:\Arquivos de programas\Sun\AppServer\jdk\jre\lib\sunrsasign.jar;C:\Arquivos de programas\Sun\AppServer\jdk\jre\lib\jsse.jar;C:\Arquivos de programas\Sun\AppServer\jdk\jre\lib\jce.jar;C:\Arquivos de programas\Sun\AppServer\jdk\jre\lib\charsets.jar;C:\Arquivos de programas\Sun\AppServer\jdk\jre\classes, hibernate.current_session_context_class=thread, sun.desktop=windows, java.vm.specification.vendor=Sun Microsystems Inc., java.runtime.version=1.5.0_06-b05, hibernate.cache.provider_class=org.hibernate.cache.NoCacheProvider, user.name=hlds, connection.driver_class=org.postgresql.Driver, current_session_context_class=thread, user.language=pt, sun.boot.library.path=C:\Arquivos de programas\Sun\AppServer\jdk\jre\bin, dialect=org.hibernate.dialect.HSQLDialect, java.version=1.5.0_06, user.timezone=GMT-03:00, sun.arch.data.model=32, java.endorsed.dirs=C:\Arquivos de programas\Sun\AppServer\jdk\jre\lib\endorsed, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86, sun.jnu.encoding=Cp1252, file.encoding.pkg=sun.io, file.separator=\, java.specification.name=Java Platform API Specification, java.class.version=49.0, user.country=BR, connection.url=jdbc:postgresql://localhost, java.home=C:\Arquivos de programas\Sun\AppServer\jdk\jre, java.vm.info=mixed mode, os.version=5.1, path.separator=;, connection.password=senha, java.vm.version=1.5.0_06-b05, hibernate.connection.password=senha, user.variant=, java.awt.printerjob=sun.awt.windows.WPrinterJob, sun.io.unicode.encoding=UnicodeLittle, awt.toolkit=sun.awt.windows.WToolkit, hibernate.connection.username=postgres, user.home=C:\Documents and Settings\hlds, java.specification.vendor=Sun Microsystems Inc., hibernate.hbm2ddl.auto=create, java.library.path=C:\Arquivos de programas\Sun\AppServer\jdk\jre\bin;.;C:\WINDOWS\System32;C:\WINDOWS;C:\Arquivos de programas\Borland\Delphi7\Bin;C:\Arquivos de programas\Borland\Delphi7\Projects\Bpl\;C:\Arquivos de programas\Sun\AppServer\jdk\bin;C:\Arquivos de programas\Sun\AppServer\jdk\lib;C:\WINDOWS\system32;C:\Documents and Settings\hlds\Meus documentos\NetBeans workspace\Catalogo_codata_servidor\build;C:\Documents and Settings\hlds\Meus documentos\NetBeans workspace\Catalogo_codata_servidor\build\classes;C:\Documents and Settings\hlds\Meus documentos\NetBeans workspace\Catalogo_codata_servidor\build\classes\catalogo_codata_servidor;C:\Documents and Settings\hlds\Meus documentos\NetBeans workspace\Catalogo_codata_servidor\dist;C:\Documents and Settings\hlds\Meus documentos\NetBeans workspace\Catalogo_codata_servidor\dist\Catalogo_codata_servidor.jar;C:\Arquivos de programas\Sun\AppServer\bin;h-?, java.vendor.url=http://java.sun.com/, hibernate.connection.driver_class=org.postgresql.Driver, connection.username=postgres, java.vm.vendor=Sun Microsystems Inc., hibernate.dialect=org.hibernate.dialect.HSQLDialect, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, java.class.path=C:\Arquivos de programas\Java Api\postgresql-8.2-505.jdbc3.jar;C:\Arquivos de programas\hibernate-3.2\hibernate3.jar;C:\Arquivos de programas\hibernate-3.2\lib\antlr-2.7.6.jar;C:\Arquivos de programas\hibernate-3.2\lib\cglib-2.1.3.jar;C:\Arquivos de programas\hibernate-3.2\lib\asm-attrs.jar;C:\Arquivos de programas\hibernate-3.2\lib\asm.jar;C:\Arquivos de programas\hibernate-3.2\lib\commons-collections-2.1.1.jar;C:\Arquivos de programas\hibernate-3.2\lib\commons-logging-1.0.4.jar;C:\Arquivos de programas\hibernate-3.2\lib\dom4j-1.6.1.jar;C:\Arquivos de programas\hibernate-3.2\lib\jta.jar;C:\Arquivos de programas\hibernate-3.2\lib\log4j-1.2.11.jar;C:\Documents and Settings\hlds\Meus documentos\NetBeans workspace\Testando_hibernate\build\classes, hibernate.bytecode.use_reflection_optimizer=false, java.vm.specification.name=Java Virtual Machine Specification, java.vm.specification.version=1.0, sun.cpu.endian=little, sun.os.patch.level=, connection.pool_size=1, java.io.tmpdir=C:\DOCUME~1\hlds\CONFIG~1\Temp\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, os.arch=x86, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.ext.dirs=C:\Arquivos de programas\Sun\AppServer\jdk\jre\lib\ext, user.dir=C:\Documents and Settings\hlds\Meus documentos\NetBeans workspace\Testando_hibernate, line.separator=
, java.vm.name=Java HotSpot(TM) Client VM, cache.provider_class=org.hibernate.cache.NoCacheProvider, file.encoding=Cp1252, java.specification.version=1.5, hibernate.connection.pool_size=1, hibernate.show_sql=true}
02:12:53,294 DEBUG AbstractEntityPersister:2738 - Static SQL for entity: events.Event
02:12:53,294 DEBUG AbstractEntityPersister:2743 - Version select: select id from eventos where id =?
02:12:53,294 DEBUG AbstractEntityPersister:2746 - Snapshot select: select event_.id, event_.date as date0_, event_.title as title0_ from eventos event_ where event_.id=?
02:12:53,294 DEBUG AbstractEntityPersister:2749 - Insert 0: insert into eventos (date, title, id) values (?, ?, ?)
02:12:53,294 DEBUG AbstractEntityPersister:2750 - Update 0: update eventos set date=?, title=? where id=?
02:12:53,310 DEBUG AbstractEntityPersister:2751 - Delete 0: delete from eventos where id=?
02:12:53,310 DEBUG AbstractEntityPersister:2755 - Identity insert: insert into eventos (id, date, title) values (null, ?, ?)
02:12:53,341 DEBUG EntityLoader:79 - Static select for entity events.Event: select event0_.id as id0_0_, event0_.date as date0_0_, event0_.title as title0_0_ from eventos event0_ where event0_.id=?
02:12:53,341 DEBUG EntityLoader:79 - Static select for entity events.Event: select event0_.id as id0_0_, event0_.date as date0_0_, event0_.title as title0_0_ from eventos event0_ where event0_.id=?
02:12:53,356 DEBUG EntityLoader:79 - Static select for entity events.Event: select event0_.id as id0_0_, event0_.date as date0_0_, event0_.title as title0_0_ from eventos event0_ where event0_.id=?
02:12:53,356 DEBUG EntityLoader:79 - Static select for entity events.Event: select event0_.id as id0_0_, event0_.date as date0_0_, event0_.title as title0_0_ from eventos event0_ where event0_.id=?
02:12:53,356 DEBUG EntityLoader:79 - Static select for entity events.Event: select event0_.id as id0_0_, event0_.date as date0_0_, event0_.title as title0_0_ from eventos event0_ where event0_.id=?
02:12:53,372 DEBUG EntityLoader:34 - Static select for action ACTION_MERGE on entity events.Event: select event0_.id as id0_0_, event0_.date as date0_0_, event0_.title as title0_0_ from eventos event0_ where event0_.id=?
02:12:53,372 DEBUG EntityLoader:34 - Static select for action ACTION_REFRESH on entity events.Event: select event0_.id as id0_0_, event0_.date as date0_0_, event0_.title as title0_0_ from eventos event0_ where event0_.id=?
02:12:53,372 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
02:12:53,372 DEBUG SessionFactoryObjectFactory:76 - registered: 297e2d5413237f9f0113237fa17c0000 (unnamed)
02:12:53,372 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
02:12:53,372 DEBUG SessionFactoryImpl:308 - instantiated session factory
02:12:53,388 DEBUG Configuration:1120 - processing extends queue
02:12:53,388 DEBUG Configuration:1124 - processing collection mappings
02:12:53,388 DEBUG Configuration:1135 - processing native query and ResultSetMapping mappings
02:12:53,388 DEBUG Configuration:1143 - processing association property references
02:12:53,388 DEBUG Configuration:1165 - processing foreign key constraints
02:12:53,388 DEBUG Configuration:1120 - processing extends queue
02:12:53,388 DEBUG Configuration:1124 - processing collection mappings
02:12:53,388 DEBUG Configuration:1135 - processing native query and ResultSetMapping mappings
02:12:53,388 DEBUG Configuration:1143 - processing association property references
02:12:53,388 DEBUG Configuration:1165 - processing foreign key constraints
02:12:53,388 INFO SchemaExport:154 - Running hbm2ddl schema export
02:12:53,388 DEBUG SchemaExport:170 - import file not found: /import.sql
02:12:53,388 INFO SchemaExport:179 - exporting generated schema to database
02:12:53,388 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
02:12:53,388 DEBUG DriverManagerConnectionProvider:99 - using pooled JDBC connection, pool size: 0
02:12:53,388 DEBUG SchemaExport:303 - drop table eventos if exists
02:12:53,403 DEBUG SchemaExport:288 - Unsuccessful: drop table eventos if exists
02:12:53,403 DEBUG SchemaExport:289 - ERROR: syntax error at or near "if"
02:12:53,403 DEBUG SchemaExport:303 - create table eventos (id integer generated by default as identity (start with 1), date date, title varchar(255), primary key (id))
02:12:53,403 ERROR SchemaExport:274 - Unsuccessful: create table eventos (id integer generated by default as identity (start with 1), date date, title varchar(255), primary key (id))
02:12:53,403 ERROR SchemaExport:275 - ERROR: syntax error at or near "generated"
02:12:53,403 INFO SchemaExport:196 - schema export complete
02:12:53,403 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
02:12:53,419 DEBUG SessionFactoryImpl:392 - Checking 0 named HQL queries
02:12:53,419 DEBUG SessionFactoryImpl:412 - Checking 0 named SQL queries
02:12:53,481 DEBUG SessionImpl:220 - opened session at timestamp: [telefone removido]
02:12:53,560 DEBUG ThreadLocalSessionContext:290 - allowing method [beginTransaction] in non-transacted context
02:12:53,560 DEBUG ThreadLocalSessionContext:300 - allowing proxied method [beginTransaction] to proceed to real session
02:12:53,560 DEBUG JDBCTransaction:54 - begin
02:12:53,575 DEBUG ConnectionManager:421 - opening JDBC connection
02:12:53,575 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
02:12:53,575 DEBUG DriverManagerConnectionProvider:99 - using pooled JDBC connection, pool size: 0
02:12:53,575 DEBUG JDBCTransaction:59 - current autocommit status: false
02:12:53,575 DEBUG JDBCContext:210 - after transaction begin
02:12:53,575 DEBUG ThreadLocalSessionContext:300 - allowing proxied method [createQuery] to proceed to real session
02:12:53,575 DEBUG QueryPlanCache:70 - unable to locate HQL query plan in cache; generating (from Event)
02:12:53,653 DEBUG QueryTranslatorImpl:246 - parse() - HQL: from events.Event
02:12:53,669 DEBUG AST:266 - --- HQL AST ---
\-[QUERY] 'query'
\-[SELECT_FROM] 'SELECT_FROM'
\-[FROM] 'from'
\-[RANGE] 'RANGE'
\-[DOT] '.'
+-[IDENT] 'events'
\-[IDENT] 'Event'
02:12:53,669 DEBUG ErrorCounter:68 - throwQueryException() : no errors
02:12:53,888 DEBUG HqlSqlBaseWalker:111 - select << begin [level=1, statement=select]
02:12:53,919 DEBUG FromElement:108 - FromClause{level=1} : events.Event (no alias) -> event0_
02:12:53,919 DEBUG HqlSqlBaseWalker:117 - select : finishing up [level=1, statement=select]
02:12:53,935 DEBUG HqlSqlWalker:509 - processQuery() : ( SELECT ( FromClause{level=1} eventos event0_ ) )
02:12:53,935 DEBUG HqlSqlWalker:716 - Derived SELECT clause created.
02:12:53,981 DEBUG JoinProcessor:148 - Using FROM fragment [eventos event0_]
02:12:53,981 DEBUG HqlSqlBaseWalker:123 - select >> end [level=1, statement=select]
02:12:53,981 DEBUG AST:232 - --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (eventos)
+-[SELECT_CLAUSE] SelectClause: '{derived select clause}'
| +-[SELECT_EXPR] SelectExpressionImpl: 'event0_.id as id0_' {FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=eventos,tableAlias=event0_,origin=null,colums={,className=events.Event}}}
| \-[SQL_TOKEN] SqlFragment: 'event0_.date as date0_, event0_.title as title0_'
\-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[], fromElementByTableAlias=[event0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
\-[FROM_FRAGMENT] FromElement: 'eventos event0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=eventos,tableAlias=event0_,origin=null,colums={,className=events.Event}}
02:12:53,981 DEBUG ErrorCounter:68 - throwQueryException() : no errors
02:12:53,997 DEBUG QueryTranslatorImpl:216 - HQL: from events.Event
02:12:54,013 DEBUG QueryTranslatorImpl:217 - SQL: select event0_.id as id0_, event0_.date as date0_, event0_.title as title0_ from eventos event0_
02:12:54,013 DEBUG ErrorCounter:68 - throwQueryException() : no errors
02:12:54,013 DEBUG HQLQueryPlan:269 - HQL param location recognition took 0 mills (from Event)
02:12:54,028 DEBUG QueryPlanCache:76 - located HQL query plan in cache (from Event)
02:12:54,028 DEBUG HQLQueryPlan:150 - find: from Event
02:12:54,028 DEBUG QueryParameters:277 - named parameters: {}
02:12:54,028 DEBUG AbstractBatcher:366 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
02:12:54,028 DEBUG SQL:401 - select event0_.id as id0_, event0_.date as date0_, event0_.title as title0_ from eventos event0_
Hibernate: select event0_.id as id0_, event0_.date as date0_, event0_.title as title0_ from eventos event0_
02:12:54,028 DEBUG AbstractBatcher:484 - preparing statement
02:12:54,044 DEBUG AbstractBatcher:374 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
02:12:54,044 DEBUG AbstractBatcher:533 - closing statement
02:12:54,044 DEBUG JDBCExceptionReporter:69 - could not execute query [select event0_.id as id0_, event0_.date as date0_, event0_.title as title0_ from eventos event0_]
org.postgresql.util.PSQLException: ERROR: relation "eventos" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at events.EventManager.listEvents(EventManager.java:49)
at events.EventManager.main(EventManager.java:16)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "eventos" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 9 more
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at events.EventManager.listEvents(EventManager.java:49)
at events.EventManager.main(EventManager.java:16)
02:12:54,044 WARN JDBCExceptionReporter:77 - SQL Error: 0, SQLState: 42P01
02:12:54,044 ERROR JDBCExceptionReporter:78 - ERROR: relation "eventos" does not exist
Java Result: 1
BUILD SUCCESSFUL (total time: 2 seconds)
So a parte do erro:
org.postgresql.util.PSQLException: ERROR: relation "eventos" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at events.EventManager.listEvents(EventManager.java:49)
at events.EventManager.main(EventManager.java:16)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "eventos" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 9 more
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at events.EventManager.listEvents(EventManager.java:49)
at events.EventManager.main(EventManager.java:16)
02:12:54,044 WARN JDBCExceptionReporter:77 - SQL Error: 0, SQLState: 42P01
02:12:54,044 ERROR JDBCExceptionReporter:78 - ERROR: relation "eventos" does not exist
Java Result: 1
BUILD SUCCESSFUL (total time: 2 seconds)
Ele diz q a relacao “eventos” q eh a tabela n existe, eu mexi nos xml, mas axo q estao corretos.
Classe Event:
package events;
import java.util.Date;
public class Event {
private int id;
private String title;
private Date date;
public Event() {}
public int getId() {
return id;
}
private void setId(int id) {
this.id = id;
}
public Date getDate() {
return date;
}
public void setDate(Date date) {
this.date = date;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
}
Event Manager(q tem o main()):
package events;
import java.util.List;
import org.hibernate.Session;
import java.util.Date;
import util.HibernateUtil;
public class EventManager {
public static void main(String[] args) {
EventManager mgr = new EventManager();
//if (args[0].equals("store")) {
//mgr.createAndStoreEvent("My Event", new Date());
//} else if (args[0].equals("list")) {
List events = mgr.listEvents();
for (int i = 0; i < events.size(); i++) {
Event theEvent = (Event) events.get(i);
System.out.println("Event: " + theEvent.getTitle() +
" Time: " + theEvent.getDate());
}
//}
HibernateUtil.getSessionFactory().close();
}
private void createAndStoreEvent(String title, Date theDate) {
Session session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
Event theEvent = new Event();
theEvent.setTitle(title);
theEvent.setDate(theDate);
//theEvent.setId(20);
session.save(theEvent);
session.getTransaction().commit();
}
private List listEvents() {
Session session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
List result = session.createQuery("from Event").list();
session.getTransaction().commit();
return result;
}
}
Event.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="events.Event" table="eventos">
<id name="id" type="int" column="id">
<generator class="assigned"/>
</id>
<property name="date" type="date" column="date"/>
<property name="title" type="string" column="title"/>
</class>
</hibernate-mapping>
Hibernate.cfg.xml
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- Database connection settings -->
<property name="connection.driver_class">org.postgresql.Driver</property>
<property name="connection.url">jdbc:postgresql://localhost/loja_db</property>
<property name="connection.username">postgres</property>
<property name="connection.password">senha</property>
<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>
<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>
<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>
<!-- Disable the second-level cache -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>
<!-- Drop and re-create the database schema on startup -->
<property name="hbm2ddl.auto">create</property>
<mapping resource="events/Event.hbm.xml"/>
</session-factory>
</hibernate-configuration>
HibernateUtil
package util;
import org.hibernate.*;
import org.hibernate.cfg.*;
public class HibernateUtil {
private static final SessionFactory sessionFactory;
static {
try {
// Create the SessionFactory from hibernate.cfg.xml
sessionFactory = new Configuration().configure().buildSessionFactory();
} catch (Throwable ex) {
// Make sure you log the exception, as it might be swallowed
System.err.println("Initial SessionFactory creation failed." + ex);
throw new ExceptionInInitializerError(ex);
}
}
public static SessionFactory getSessionFactory() {
return sessionFactory;
}
}
Ae, mals o tamanho, mas coloquei td q axo ser necessario. Ja rodei d+ e n consegui fazer funcionar, alguem sabe o erro? Vlw…
