-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 7 posts ] 
Author Message
 Post subject: Error while inserting a new object
PostPosted: Mon Mar 07, 2005 5:58 pm 
Beginner
Beginner

Joined: Sat Oct 18, 2003 8:00 pm
Posts: 22
Hibernate version 3.0RC1

Mapping xml:

<hibernate-mapping>
<class name="gov.tresc.admsist.model.Usuario" table="USUARIO"
schema="ADMSIST">
<id name="id" column="IDO_USUARIO" type="long">
<generator class="select"></generator>
</id>
<property name="nome" column="NOME_USUARIO" type="string" length="70"
not-null="true"/>
<property name="login" column="LOGIN" type="string" length="70"
not-null="true"/>
<property name="email" column="E_MAIL" type="string" length="70"
not-null="true"/>
</class>
</hibernate-mapping>

- Opening and closing in a servletfilter

Database
- Oracle 9


- Sql generated and stack tracle:

Hibernate: insert into ADMSIST.USUARIO (NOME_USUARIO, LOGIN, E_MAIL) values (?, ?, ?)
org.hibernate.MappingException: unknown property: null
at org.hibernate.persister.entity.AbstractPropertyMapping.getColumnNames(AbstractPropertyMapping.java:54)
at org.hibernate.persister.entity.BasicEntityPersister.getPropertyColumnNames(BasicEntityPersister.java:1112)
at org.hibernate.persister.entity.BasicEntityPersister.getSelectByUniqueKeyString(BasicEntityPersister.java:1769)
at org.hibernate.id.SelectGenerator.getSQL(SelectGenerator.java:35)
at org.hibernate.id.AbstractPostInsertGenerator.getGenerated(AbstractPostInsertGenerator.java:34)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1755)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2149)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:34)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:238)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:158)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:104)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:429)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:424)
at gov.tresc.admsist.dao.DAOAdmSist.criaUsuario(DAOAdmSist.java:135)

PS: all the three properties are set.

thanks
Emerson


Top
 Profile  
 
 Post subject: more info
PostPosted: Mon Mar 07, 2005 6:03 pm 
Beginner
Beginner

Joined: Sat Oct 18, 2003 8:00 pm
Posts: 22
I have a trigger in the db that already populate the ido with a sequence number.
For what i read in docs, i should use the select ID generator (page 36 of reference manual)

thanks


Top
 Profile  
 
 Post subject: hibernate debug log
PostPosted: Tue Mar 08, 2005 12:53 pm 
Beginner
Beginner

Joined: Sat Oct 18, 2003 8:00 pm
Posts: 22
Here goes the hibernate debug log:


13:32:39,169 INFO Environment:456 - Hibernate 3.0rc1
13:32:39,230 INFO Environment:469 - hibernate.properties not found
13:32:39,276 INFO Environment:502 - using CGLIB reflection optimizer
13:32:39,299 INFO Environment:532 - using JDK 1.4 java.sql.Timestamp handling
13:32:39,344 INFO Configuration:1228 - configuring from resource: /hibernate.cfg.xml
13:32:39,370 INFO Configuration:1199 - Configuration resource: /hibernate.cfg.xml
13:32:40,224 DEBUG DTDEntityResolver:42 - trying to locate http://hibernate.sourceforge.net/hibern ... on-3.0.dtd in classpath under org/hibernate/
13:32:40,259 DEBUG DTDEntityResolver:53 - found http://hibernate.sourceforge.net/hibern ... on-3.0.dtd in classpath
13:32:40,693 DEBUG Configuration:1185 - hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
13:32:40,714 DEBUG Configuration:1185 - hibernate.connection.url=jdbc:oracle:thin:@setubal.tre-sc.gov.br:1521:des
13:32:40,736 DEBUG Configuration:1185 - hibernate.connection.username=admsist
13:32:40,760 DEBUG Configuration:1185 - hibernate.connection.password=admsist
13:32:40,789 DEBUG Configuration:1185 - dialect=org.hibernate.dialect.OracleDialect
13:32:40,809 DEBUG Configuration:1185 - show_sql=true
13:32:40,839 DEBUG Configuration:1185 - transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory
13:32:40,864 DEBUG Configuration:1380 - null<-org.dom4j.tree.DefaultAttribute@eb3f66 [Attribute: name resource value "gov/tresc/admsist/model/Usuario.hbm.xml"]
13:32:40,891 INFO Configuration:439 - Mapping resource: gov/tresc/admsist/model/Usuario.hbm.xml
13:32:40,974 DEBUG DTDEntityResolver:42 - trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
13:32:41,017 DEBUG DTDEntityResolver:53 - found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
13:32:43,050 INFO HbmBinder:256 - Mapping class: gov.tresc.admsist.model.Usuario -> USUARIO
13:32:43,147 DEBUG HbmBinder:1086 - Mapped property: id -> IDO_USUARIO
13:32:43,403 DEBUG HbmBinder:1086 - Mapped property: nome -> NOME_USUARIO
13:32:43,437 DEBUG HbmBinder:1086 - Mapped property: login -> LOGIN
13:32:43,464 DEBUG HbmBinder:1086 - Mapped property: email -> E_MAIL
13:32:43,490 DEBUG Configuration:1380 - null<-org.dom4j.tree.DefaultAttribute@600a08 [Attribute: name resource value "gov/tresc/admsist/model/Sistema.hbm.xml"]
13:32:43,515 INFO Configuration:439 - Mapping resource: gov/tresc/admsist/model/Sistema.hbm.xml
13:32:43,583 DEBUG DTDEntityResolver:42 - trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
13:32:43,611 DEBUG DTDEntityResolver:53 - found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
13:32:44,864 INFO HbmBinder:256 - Mapping class: gov.tresc.admsist.model.Sistema -> SISTEMA
13:32:44,892 DEBUG HbmBinder:1086 - Mapped property: id -> IDO_SISTEMA
13:32:44,919 DEBUG HbmBinder:1086 - Mapped property: nomeSistema -> NOME_SISTEMA
13:32:44,954 DEBUG HbmBinder:1086 - Mapped property: estacoesAcesso -> ESTACOES_ACESSO
13:32:45,026 INFO HbmBinder:1194 - Mapping collection: gov.tresc.admsist.model.Sistema.usuarios -> USUARIO_SISTEMA
13:32:45,073 DEBUG HbmBinder:1086 - Mapped property: usuarios
13:32:45,098 INFO Configuration:1340 - Configured SessionFactory: null
13:32:45,136 DEBUG Configuration:1341 - properties: {hibernate.connection.password=admsist, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory, sun.boot.library.path=/home/emerson/download/jdk1.5.0_01/jre/lib/i386, java.vm.version=1.5.0_01-b08, shared.loader=${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar, hibernate.connection.username=admsist, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=:, java.vm.name=Java HotSpot(TM) Client VM, tomcat.util.buf.StringCache.byte.enabled=true, file.encoding.pkg=sun.io, user.country=BR, sun.os.patch.level=unknown, java.vm.specification.name=Java Virtual Machine Specification, user.dir=/home/emerson, java.runtime.version=1.5.0_01-b08, java.awt.graphicsenv=sun.awt.X11GraphicsEnvironment, java.endorsed.dirs=/home/emerson/jakarta-tomcat-5.5.7/common/endorsed, os.arch=i386, java.io.tmpdir=/tmp, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., java.naming.factory.url.pkgs=org.apache.naming, os.name=Linux, sun.jnu.encoding=ISO-8859-1, java.library.path=/home/emerson/download/jdk1.5.0_01/jre/lib/i386/client:/home/emerson/download/jdk1.5.0_01/jre/lib/i386:/home/emerson/download/jdk1.5.0_01/jre/../lib/i386:/usr/java/j2sdk1.4.2_06/jre/lib/i386/client:/usr/java/j2sdk1.4.2_06/jre/lib/i386:/usr/java/j2sdk1.4.2_06/jre/../lib/i386:/opt/mozilla/lib, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, hibernate.transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory, os.version=2.6.8-24-smp, user.home=/home/emerson, user.timezone=Brazil/East, catalina.useNaming=true, java.awt.printerjob=sun.print.PSPrinterJob, file.encoding=ISO-8859-1, java.specification.version=1.5, hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver, show_sql=true, catalina.home=/home/emerson/jakarta-tomcat-5.5.7, java.class.path=/home/emerson/jakarta-tomcat-5.5.7/bin/bootstrap.jar:/home/emerson/download/jdk1.5.0_01/lib/tools.jar, user.name=emerson, hibernate.show_sql=true, java.naming.factory.initial=org.apache.naming.java.javaURLContextFactory, package.definition=sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper., java.vm.specification.version=1.0, java.home=/home/emerson/download/jdk1.5.0_01/jre, sun.arch.data.model=32, hibernate.dialect=org.hibernate.dialect.OracleDialect, hibernate.connection.url=jdbc:oracle:thin:@setubal.tre-sc.gov.br:1521:des, user.language=pt, java.specification.vendor=Sun Microsystems Inc., hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, java.version=1.5.0_01, java.ext.dirs=/home/emerson/download/jdk1.5.0_01/jre/lib/ext, sun.boot.class.path=/home/emerson/download/jdk1.5.0_01/jre/lib/rt.jar:/home/emerson/download/jdk1.5.0_01/jre/lib/i18n.jar:/home/emerson/download/jdk1.5.0_01/jre/lib/sunrsasign.jar:/home/emerson/download/jdk1.5.0_01/jre/lib/jsse.jar:/home/emerson/download/jdk1.5.0_01/jre/lib/jce.jar:/home/emerson/download/jdk1.5.0_01/jre/lib/charsets.jar:/home/emerson/download/jdk1.5.0_01/jre/classes, server.loader=${catalina.home}/server/classes,${catalina.home}/server/lib/*.jar, java.vendor=Sun Microsystems Inc., catalina.base=/home/emerson/jakarta-tomcat-5.5.7, file.separator=/, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, common.loader=${catalina.home}/common/classes,${catalina.home}/common/i18n/*.jar,${catalina.home}/common/endorsed/*.jar,${catalina.home}/common/lib/*.jar, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, package.access=sun.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.,sun.beans., sun.desktop=gnome, dialect=org.hibernate.dialect.OracleDialect, sun.cpu.isalist=}
13:32:45,171 DEBUG Configuration:1035 - Preparing to build session factory with filters : {}
13:32:45,190 INFO Configuration:844 - processing extends queue
13:32:45,214 INFO Configuration:848 - processing collection mappings
13:32:45,240 DEBUG HbmBinder:2264 - Second pass for collection: gov.tresc.admsist.model.Sistema.usuarios
13:32:46,187 DEBUG HbmBinder:2280 - Mapped collection key: IDO_SISTEMA, element: IDO_USUARIO
13:32:46,207 INFO Configuration:857 - processing association property references
13:32:46,226 INFO Configuration:884 - processing foreign key constraints
13:32:46,253 DEBUG Configuration:928 - resolving reference to class: gov.tresc.admsist.model.Sistema
13:32:46,273 DEBUG Configuration:928 - resolving reference to class: gov.tresc.admsist.model.Usuario
13:32:46,763 INFO Dialect:89 - Using dialect: org.hibernate.dialect.OracleDialect
13:32:46,866 DEBUG SQLExceptionConverterFactory:52 - Using dialect defined converter
13:32:47,036 INFO SettingsFactory:90 - Default batch fetch size: 1
13:32:47,063 INFO SettingsFactory:94 - Generate SQL with comments: disabled
13:32:47,083 INFO SettingsFactory:98 - Order SQL updates by primary key: disabled
13:32:47,103 INFO SettingsFactory:273 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
13:32:47,194 INFO ASTQueryTranslatorFactory:21 - Using ASTQueryTranslatorFactory
13:32:47,217 INFO SettingsFactory:106 - Query language substitutions: {}
13:32:47,291 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
13:32:47,313 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
13:32:47,342 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
13:32:48,509 INFO DriverManagerConnectionProvider:80 - using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@setubal.tre-sc.gov.br:1521:des
13:32:48,532 INFO DriverManagerConnectionProvider:83 - connection properties: {user=admsist, password=admsist}
13:32:48,559 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
13:32:48,587 DEBUG DriverManagerConnectionProvider:109 - opening new JDBC connection
13:32:52,789 DEBUG DriverManagerConnectionProvider:115 - created connection to: jdbc:oracle:thin:@setubal.tre-sc.gov.br:1521:des, Isolation Level: 2
13:32:52,907 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
13:32:52,941 INFO SettingsFactory:148 - JDBC batch size: 15
13:32:52,963 INFO SettingsFactory:151 - JDBC batch updates for versioned data: disabled
13:32:52,996 INFO SettingsFactory:156 - Scrollable result sets: enabled
13:32:53,028 DEBUG SettingsFactory:160 - Wrap result sets: disabled
13:32:53,057 INFO SettingsFactory:164 - JDBC3 getGeneratedKeys(): disabled
13:32:53,129 INFO TransactionFactoryFactory:34 - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
13:32:53,198 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
13:32:53,226 INFO SettingsFactory:176 - Automatic flush during beforeCompletion(): disabled
13:32:53,246 INFO SettingsFactory:179 - Automatic session close at end of transaction: disabled
13:32:53,266 INFO SettingsFactory:260 - Cache provider: org.hibernate.cache.EhCacheProvider
13:32:53,380 INFO SettingsFactory:187 - Second-level cache: enabled
13:32:53,400 INFO SettingsFactory:192 - Optimize cache for minimal puts: disabled
13:32:53,427 INFO SettingsFactory:199 - Structured second-level cache entries: enabled
13:32:53,447 INFO SettingsFactory:203 - Query cache: disabled
13:32:53,467 INFO SettingsFactory:210 - Echoing all SQL to stdout
13:32:53,492 INFO SettingsFactory:214 - Statistics: disabled
13:32:53,522 INFO SettingsFactory:218 - Deleted entity synthetic identifier rollback: disabled
13:32:53,575 INFO SettingsFactory:232 - Default entity-mode: pojo
13:32:56,099 INFO SessionFactoryImpl:140 - building session factory
13:32:56,120 DEBUG SessionFactoryImpl:149 - Session factory constructed with filter configurations : {}
13:32:56,161 DEBUG SessionFactoryImpl:152 - instantiating session factory with properties: {hibernate.connection.password=admsist, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory, sun.boot.library.path=/home/emerson/download/jdk1.5.0_01/jre/lib/i386, java.vm.version=1.5.0_01-b08, shared.loader=${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar, hibernate.connection.username=admsist, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=:, java.vm.name=Java HotSpot(TM) Client VM, tomcat.util.buf.StringCache.byte.enabled=true, file.encoding.pkg=sun.io, user.country=BR, sun.os.patch.level=unknown, java.vm.specification.name=Java Virtual Machine Specification, user.dir=/home/emerson, java.runtime.version=1.5.0_01-b08, java.awt.graphicsenv=sun.awt.X11GraphicsEnvironment, java.endorsed.dirs=/home/emerson/jakarta-tomcat-5.5.7/common/endorsed, os.arch=i386, java.io.tmpdir=/tmp, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., java.naming.factory.url.pkgs=org.apache.naming, os.name=Linux, sun.jnu.encoding=ISO-8859-1, java.library.path=/home/emerson/download/jdk1.5.0_01/jre/lib/i386/client:/home/emerson/download/jdk1.5.0_01/jre/lib/i386:/home/emerson/download/jdk1.5.0_01/jre/../lib/i386:/usr/java/j2sdk1.4.2_06/jre/lib/i386/client:/usr/java/j2sdk1.4.2_06/jre/lib/i386:/usr/java/j2sdk1.4.2_06/jre/../lib/i386:/opt/mozilla/lib, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, hibernate.transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory, os.version=2.6.8-24-smp, user.home=/home/emerson, user.timezone=Brazil/East, catalina.useNaming=true, java.awt.printerjob=sun.print.PSPrinterJob, file.encoding=ISO-8859-1, java.specification.version=1.5, hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver, show_sql=true, catalina.home=/home/emerson/jakarta-tomcat-5.5.7, java.class.path=/home/emerson/jakarta-tomcat-5.5.7/bin/bootstrap.jar:/home/emerson/download/jdk1.5.0_01/lib/tools.jar, user.name=emerson, hibernate.show_sql=true, java.naming.factory.initial=org.apache.naming.java.javaURLContextFactory, package.definition=sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper., java.vm.specification.version=1.0, java.home=/home/emerson/download/jdk1.5.0_01/jre, sun.arch.data.model=32, hibernate.dialect=org.hibernate.dialect.OracleDialect, hibernate.connection.url=jdbc:oracle:thin:@setubal.tre-sc.gov.br:1521:des, user.language=pt, java.specification.vendor=Sun Microsystems Inc., hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, java.version=1.5.0_01, java.ext.dirs=/home/emerson/download/jdk1.5.0_01/jre/lib/ext, sun.boot.class.path=/home/emerson/download/jdk1.5.0_01/jre/lib/rt.jar:/home/emerson/download/jdk1.5.0_01/jre/lib/i18n.jar:/home/emerson/download/jdk1.5.0_01/jre/lib/sunrsasign.jar:/home/emerson/download/jdk1.5.0_01/jre/lib/jsse.jar:/home/emerson/download/jdk1.5.0_01/jre/lib/jce.jar:/home/emerson/download/jdk1.5.0_01/jre/lib/charsets.jar:/home/emerson/download/jdk1.5.0_01/jre/classes, server.loader=${catalina.home}/server/classes,${catalina.home}/server/lib/*.jar, java.vendor=Sun Microsystems Inc., catalina.base=/home/emerson/jakarta-tomcat-5.5.7, file.separator=/, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, common.loader=${catalina.home}/common/classes,${catalina.home}/common/i18n/*.jar,${catalina.home}/common/endorsed/*.jar,${catalina.home}/common/lib/*.jar, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, package.access=sun.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.,sun.beans., sun.desktop=gnome, dialect=org.hibernate.dialect.OracleDialect, sun.cpu.isalist=}
13:32:56,342 WARN Configurator:126 - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/home/emerson/eclipse3/eclipse/workspace/AdmSistWebManager/webapp/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
13:33:01,061 DEBUG BasicEntityPersister:2191 - Static SQL for entity: gov.tresc.admsist.model.Usuario
13:33:01,084 DEBUG BasicEntityPersister:2193 - Version select: select IDO_USUARIO from ADMSIST.USUARIO where IDO_USUARIO =?
13:33:01,108 DEBUG BasicEntityPersister:2194 - Snapshot select: select usuario_.IDO_USUARIO, usuario_.NOME_USUARIO as NOME2_0_, usuario_.LOGIN as LOGIN0_, usuario_.E_MAIL as E4_0_ from ADMSIST.USUARIO usuario_ where usuario_.IDO_USUARIO=?
13:33:01,134 DEBUG BasicEntityPersister:2196 - Insert 0: insert into ADMSIST.USUARIO (NOME_USUARIO, LOGIN, E_MAIL, IDO_USUARIO) values (?, ?, ?, ?)
13:33:01,156 DEBUG BasicEntityPersister:2197 - Update 0: update ADMSIST.USUARIO set NOME_USUARIO=?, LOGIN=?, E_MAIL=? where IDO_USUARIO=?
13:33:01,180 DEBUG BasicEntityPersister:2198 - Delete 0: delete from ADMSIST.USUARIO where IDO_USUARIO=?
13:33:01,217 DEBUG BasicEntityPersister:2201 - Identity insert: insert into ADMSIST.USUARIO (NOME_USUARIO, LOGIN, E_MAIL) values (?, ?, ?)
13:33:02,176 DEBUG BasicEntityPersister:2191 - Static SQL for entity: gov.tresc.admsist.model.Sistema
13:33:02,200 DEBUG BasicEntityPersister:2193 - Version select: select IDO_SISTEMA from ADMSIST.SISTEMA where IDO_SISTEMA =?
13:33:02,228 DEBUG BasicEntityPersister:2194 - Snapshot select: select sistema_.IDO_SISTEMA, sistema_.NOME_SISTEMA as NOME2_1_, sistema_.ESTACOES_ACESSO as ESTACOES3_1_ from ADMSIST.SISTEMA sistema_ where sistema_.IDO_SISTEMA=?
13:33:02,250 DEBUG BasicEntityPersister:2196 - Insert 0: insert into ADMSIST.SISTEMA (NOME_SISTEMA, ESTACOES_ACESSO, IDO_SISTEMA) values (?, ?, ?)
13:33:02,272 DEBUG BasicEntityPersister:2197 - Update 0: update ADMSIST.SISTEMA set NOME_SISTEMA=?, ESTACOES_ACESSO=? where IDO_SISTEMA=?
13:33:02,294 DEBUG BasicEntityPersister:2198 - Delete 0: delete from ADMSIST.SISTEMA where IDO_SISTEMA=?
13:33:02,391 DEBUG AbstractCollectionPersister:475 - Static SQL for collection: gov.tresc.admsist.model.Sistema.usuarios
13:33:02,413 DEBUG AbstractCollectionPersister:476 - Row insert: insert into USUARIO_SISTEMA (IDO_SISTEMA, IDO_USUARIO) values (?, ?)
13:33:02,449 DEBUG AbstractCollectionPersister:477 - Row update: update USUARIO_SISTEMA set IDO_USUARIO=? where IDO_SISTEMA=? and IDO_USUARIO=?
13:33:02,471 DEBUG AbstractCollectionPersister:478 - Row delete: delete from USUARIO_SISTEMA where IDO_SISTEMA=? and IDO_USUARIO=?
13:33:02,493 DEBUG AbstractCollectionPersister:479 - One-shot delete: delete from USUARIO_SISTEMA where IDO_SISTEMA=?
13:33:02,715 DEBUG EntityLoader:118 - Static select for entity gov.tresc.admsist.model.Usuario: select usuario0_.IDO_USUARIO as IDO1_0_, usuario0_.NOME_USUARIO as NOME2_0_0_, usuario0_.LOGIN as LOGIN0_0_, usuario0_.E_MAIL as E4_0_0_ from ADMSIST.USUARIO usuario0_ where usuario0_.IDO_USUARIO=?
13:33:02,748 DEBUG EntityLoader:118 - Static select for entity gov.tresc.admsist.model.Usuario: select usuario0_.IDO_USUARIO as IDO1_0_, usuario0_.NOME_USUARIO as NOME2_0_0_, usuario0_.LOGIN as LOGIN0_0_, usuario0_.E_MAIL as E4_0_0_ from ADMSIST.USUARIO usuario0_ where usuario0_.IDO_USUARIO=?
13:33:02,775 DEBUG EntityLoader:118 - Static select for entity gov.tresc.admsist.model.Usuario: select usuario0_.IDO_USUARIO as IDO1_0_, usuario0_.NOME_USUARIO as NOME2_0_0_, usuario0_.LOGIN as LOGIN0_0_, usuario0_.E_MAIL as E4_0_0_ from ADMSIST.USUARIO usuario0_ where usuario0_.IDO_USUARIO=? for update
13:33:02,803 DEBUG EntityLoader:118 - Static select for entity gov.tresc.admsist.model.Usuario: select usuario0_.IDO_USUARIO as IDO1_0_, usuario0_.NOME_USUARIO as NOME2_0_0_, usuario0_.LOGIN as LOGIN0_0_, usuario0_.E_MAIL as E4_0_0_ from ADMSIST.USUARIO usuario0_ where usuario0_.IDO_USUARIO=? for update nowait
13:33:02,861 DEBUG EntityLoader:118 - Static select for entity gov.tresc.admsist.model.Sistema: select sistema0_.IDO_SISTEMA as IDO1_0_, sistema0_.NOME_SISTEMA as NOME2_1_0_, sistema0_.ESTACOES_ACESSO as ESTACOES3_1_0_ from ADMSIST.SISTEMA sistema0_ where sistema0_.IDO_SISTEMA=?
13:33:02,894 DEBUG EntityLoader:118 - Static select for entity gov.tresc.admsist.model.Sistema: select sistema0_.IDO_SISTEMA as IDO1_0_, sistema0_.NOME_SISTEMA as NOME2_1_0_, sistema0_.ESTACOES_ACESSO as ESTACOES3_1_0_ from ADMSIST.SISTEMA sistema0_ where sistema0_.IDO_SISTEMA=?
13:33:02,921 DEBUG EntityLoader:118 - Static select for entity gov.tresc.admsist.model.Sistema: select sistema0_.IDO_SISTEMA as IDO1_0_, sistema0_.NOME_SISTEMA as NOME2_1_0_, sistema0_.ESTACOES_ACESSO as ESTACOES3_1_0_ from ADMSIST.SISTEMA sistema0_ where sistema0_.IDO_SISTEMA=? for update
13:33:02,954 DEBUG EntityLoader:118 - Static select for entity gov.tresc.admsist.model.Sistema: select sistema0_.IDO_SISTEMA as IDO1_0_, sistema0_.NOME_SISTEMA as NOME2_1_0_, sistema0_.ESTACOES_ACESSO as ESTACOES3_1_0_ from ADMSIST.SISTEMA sistema0_ where sistema0_.IDO_SISTEMA=? for update nowait
13:33:03,120 DEBUG CollectionLoader:70 - Static select for collection gov.tresc.admsist.model.Sistema.usuarios: select usuarios0_.IDO_SISTEMA as IDO1___, usuarios0_.IDO_USUARIO as IDO2___, usuario1_.IDO_USUARIO as IDO1_0_, usuario1_.NOME_USUARIO as NOME2_0_0_, usuario1_.LOGIN as LOGIN0_0_, usuario1_.E_MAIL as E4_0_0_ from USUARIO_SISTEMA usuarios0_, ADMSIST.USUARIO usuario1_ where usuarios0_.IDO_USUARIO=usuario1_.IDO_USUARIO and usuarios0_.IDO_SISTEMA=?
13:33:03,170 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
13:33:03,222 DEBUG SessionFactoryObjectFactory:76 - registered: 8a8987ba028303020102830322af0000 (unnamed)
13:33:03,249 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
13:33:03,279 DEBUG SessionFactoryImpl:249 - instantiated session factory
13:33:03,299 INFO SessionFactoryImpl:366 - Checking 0 named queries
13:33:03,474 DEBUG SessionImpl:229 - opened session
13:33:03,486 DEBUG DefaultSaveOrUpdateEventListener:159 - saving transient instance
13:33:03,491 DEBUG AbstractSaveEventListener:89 - generated identifier: , using strategy: org.hibernate.id.SelectGenerator
13:33:03,502 DEBUG AbstractSaveEventListener:132 - saving [gov.tresc.admsist.model.Usuario#<null>]
13:33:03,507 DEBUG AbstractSaveEventListener:193 - executing insertions
13:33:03,560 DEBUG BasicEntityPersister:1705 - Inserting entity: gov.tresc.admsist.model.Usuario (native id)
13:33:03,571 DEBUG AbstractBatcher:258 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
13:33:03,578 DEBUG AbstractBatcher:379 - opening JDBC connection
13:33:03,587 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
13:33:03,597 DEBUG DriverManagerConnectionProvider:99 - using pooled JDBC connection, pool size: 0
13:33:03,605 DEBUG SQL:292 - insert into ADMSIST.USUARIO (NOME_USUARIO, LOGIN, E_MAIL) values (?, ?, ?)
Hibernate: insert into ADMSIST.USUARIO (NOME_USUARIO, LOGIN, E_MAIL) values (?, ?, ?)
13:33:03,611 DEBUG AbstractBatcher:343 - preparing statement
13:33:03,674 DEBUG BasicEntityPersister:1587 - Dehydrating entity: [gov.tresc.admsist.model.Usuario#<null>]
13:33:03,831 DEBUG AbstractBatcher:266 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
13:33:03,841 DEBUG AbstractBatcher:363 - closing statement
org.hibernate.MappingException: unknown property: null
at org.hibernate.persister.entity.AbstractPropertyMapping.getColumnNames(AbstractPropertyMapping.java:54)
at org.hibernate.persister.entity.BasicEntityPersister.getPropertyColumnNames(BasicEntityPersister.java:1112)
at org.hibernate.persister.entity.BasicEntityPersister.getSelectByUniqueKeyString(BasicEntityPersister.java:1769)
at org.hibernate.id.SelectGenerator.getSQL(SelectGenerator.java:35)
at org.hibernate.id.AbstractPostInsertGenerator.getGenerated(AbstractPostInsertGenerator.java:34)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1755)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2149)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:34)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:238)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:158)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:104)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:429)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:424)
at gov.tresc.admsist.dao.DAOAdmSist.criaUsuario(DAOAdmSist.java:135)
at gov.tresc.admsist.AdmSistFacade.criaUsuario(AdmSistFacade.java:53)
at gov.tresc.admsist.struts.UsuariosCRUDAction.criarFinish(UsuariosCRUDAction.java:41)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at gov.tresc.hibplugin.ActionFilter.doFilter(ActionFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:738)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
13:33:26,544 ERROR DAOAdmSist:139 - Erro ao criar usuario
org.hibernate.MappingException: unknown property: null
at org.hibernate.persister.entity.AbstractPropertyMapping.getColumnNames(AbstractPropertyMapping.java:54)
at org.hibernate.persister.entity.BasicEntityPersister.getPropertyColumnNames(BasicEntityPersister.java:1112)
at org.hibernate.persister.entity.BasicEntityPersister.getSelectByUniqueKeyString(BasicEntityPersister.java:1769)
at org.hibernate.id.SelectGenerator.getSQL(SelectGenerator.java:35)
at org.hibernate.id.AbstractPostInsertGenerator.getGenerated(AbstractPostInsertGenerator.java:34)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1755)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2149)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:34)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:238)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:158)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:104)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:429)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:424)
at gov.tresc.admsist.dao.DAOAdmSist.criaUsuario(DAOAdmSist.java:135)
at gov.tresc.admsist.AdmSistFacade.criaUsuario(AdmSistFacade.java:53)
at gov.tresc.admsist.struts.UsuariosCRUDAction.criarFinish(UsuariosCRUDAction.java:41)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at gov.tresc.hibplugin.ActionFilter.doFilter(ActionFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:738)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
13:33:26,554 WARN RequestProcessor:538 - Unhandled Exception thrown: class gov.tresc.admsist.dao.DAOException
13:33:26,556 DEBUG AbstractFlushingEventListener:52 - flushing session
13:33:26,564 DEBUG AbstractFlushingEventListener:102 - processing flush-time cascades
13:33:26,598 DEBUG AbstractFlushingEventListener:150 - dirty checking collections
13:33:26,600 DEBUG AbstractFlushingEventListener:167 - Flushing entities and processing referenced collections
13:33:26,604 ERROR AssertionFailure:22 - an assertion failure occured (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session)
org.hibernate.AssertionFailure: null id in entry (don't flush the Session after an exception occurs)
at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:49)
at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:82)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:190)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:70)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:669)
at gov.tresc.hibplugin.ServiceLocator.closeSession(ServiceLocator.java:141)
at gov.tresc.hibplugin.ActionFilter.doFilter(ActionFilter.java:72)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:738)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
13:33:26,607 ERROR ActionFilter:76 - Error closing hibernate session.
org.hibernate.AssertionFailure: null id in entry (don't flush the Session after an exception occurs)
at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:49)
at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:82)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:190)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:70)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:669)
at gov.tresc.hibplugin.ServiceLocator.closeSession(ServiceLocator.java:141)
at gov.tresc.hibplugin.ActionFilter.doFilter(ActionFilter.java:72)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:738)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
org.hibernate.AssertionFailure: null id in entry (don't flush the Session after an exception occurs)
at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:49)
at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:82)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:190)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:70)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:669)
at gov.tresc.hibplugin.ServiceLocator.closeSession(ServiceLocator.java:141)
at gov.tresc.hibplugin.ActionFilter.doFilter(ActionFilter.java:72)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:738)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
13:33:26,615 ERROR StandardWrapper[/admsist:action]:269 - Servlet.service() for servlet action threw exception
gov.tresc.admsist.dao.DAOException: org.hibernate.MappingException: unknown property: null
at gov.tresc.admsist.dao.DAOAdmSist.criaUsuario(DAOAdmSist.java:140)
at gov.tresc.admsist.AdmSistFacade.criaUsuario(AdmSistFacade.java:53)
at gov.tresc.admsist.struts.UsuariosCRUDAction.criarFinish(UsuariosCRUDAction.java:41)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at gov.tresc.hibplugin.ActionFilter.doFilter(ActionFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:738)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.hibernate.MappingException: unknown property: null
at org.hibernate.persister.entity.AbstractPropertyMapping.getColumnNames(AbstractPropertyMapping.java:54)
at org.hibernate.persister.entity.BasicEntityPersister.getPropertyColumnNames(BasicEntityPersister.java:1112)
at org.hibernate.persister.entity.BasicEntityPersister.getSelectByUniqueKeyString(BasicEntityPersister.java:1769)
at org.hibernate.id.SelectGenerator.getSQL(SelectGenerator.java:35)
at org.hibernate.id.AbstractPostInsertGenerator.getGenerated(AbstractPostInsertGenerator.java:34)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1755)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2149)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:34)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:238)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:158)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:104)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:429)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:424)
at gov.tresc.admsist.dao.DAOAdmSist.criaUsuario(DAOAdmSist.java:135)
... 31 more


Top
 Profile  
 
 Post subject:
PostPosted: Tue Mar 08, 2005 12:56 pm 
Hibernate Team
Hibernate Team

Joined: Tue Sep 09, 2003 2:10 pm
Posts: 3246
Location: Passau, Germany
Please read the manual, generator=select needs you to specify a unique property, which you did not do.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Mar 08, 2005 4:12 pm 
Beginner
Beginner

Joined: Sat Oct 18, 2003 8:00 pm
Posts: 22
Thanks a lot, this information was not included in the hibernate reference PDF.

Emerson


Top
 Profile  
 
 Post subject: still with error
PostPosted: Tue Mar 08, 2005 5:11 pm 
Beginner
Beginner

Joined: Sat Oct 18, 2003 8:00 pm
Posts: 22
The manual is a little confuse.
<manual>
5.1.4.6. Primary keys assigned by triggers

For legacy schemas only (Hibernate does not generate DDL with triggers).

<id name="id" type="long" column="person_id">
<generator class="select">
<param name="key">socialSecurityNumber</param>
</generator>
</id>

In the above example, there is a unique valued property named socialSecurityNumber defined by the class, as a natural key, and a surrogate key named person_id whose value is generated by a trigger.
</manual>

Why there's another natural key? Why is this used?
In my case, I have the id, which is a number with precision 9. If I use other natural key, let's say login, I get a classcast, and if I use the id I get the error : "org.hibernate.PropertyNotFoundException: Unable to resolve property [name=id] to corresponding index"

Here goes the log:

17:43:35,155 DEBUG BasicEntityPersister:2191 - Static SQL for entity: gov.tresc.admsist.model.Usuario
17:43:35,156 DEBUG BasicEntityPersister:2193 - Version select: select IDO_USUARIO from ADMSIST.USUARIO where IDO_USUARIO =?
17:43:35,157 DEBUG BasicEntityPersister:2194 - Snapshot select: select usuario_.IDO_USUARIO, usuario_.NOME_USUARIO as NOME2_0_, usuario_.LOGIN as LOGIN0_, usuario_.E_MAIL as E4_0_ from ADMSIST.USUARIO usuario_ where usuario_.IDO_USUARIO=?
17:43:35,159 DEBUG BasicEntityPersister:2196 - Insert 0: insert into ADMSIST.USUARIO (NOME_USUARIO, LOGIN, E_MAIL, IDO_USUARIO) values (?, ?, ?, ?)
17:43:35,166 DEBUG BasicEntityPersister:2197 - Update 0: update ADMSIST.USUARIO set NOME_USUARIO=?, LOGIN=?, E_MAIL=? where IDO_USUARIO=?
17:43:35,167 DEBUG BasicEntityPersister:2198 - Delete 0: delete from ADMSIST.USUARIO where IDO_USUARIO=?
17:43:35,168 DEBUG BasicEntityPersister:2201 - Identity insert: insert into ADMSIST.USUARIO (NOME_USUARIO, LOGIN, E_MAIL) values (?, ?, ?)
17:43:35,278 DEBUG BasicEntityPersister:2191 - Static SQL for entity: gov.tresc.admsist.model.Sistema
17:43:35,279 DEBUG BasicEntityPersister:2193 - Version select: select IDO_SISTEMA from ADMSIST.SISTEMA where IDO_SISTEMA =?
17:43:35,280 DEBUG BasicEntityPersister:2194 - Snapshot select: select sistema_.IDO_SISTEMA, sistema_.NOME_SISTEMA as NOME2_1_, sistema_.ESTACOES_ACESSO as ESTACOES3_1_ from ADMSIST.SISTEMA sistema_ where sistema_.IDO_SISTEMA=?
17:43:35,286 DEBUG BasicEntityPersister:2196 - Insert 0: insert into ADMSIST.SISTEMA (NOME_SISTEMA, ESTACOES_ACESSO, IDO_SISTEMA) values (?, ?, ?)
17:43:35,287 DEBUG BasicEntityPersister:2197 - Update 0: update ADMSIST.SISTEMA set NOME_SISTEMA=?, ESTACOES_ACESSO=? where IDO_SISTEMA=?
17:43:35,288 DEBUG BasicEntityPersister:2198 - Delete 0: delete from ADMSIST.SISTEMA where IDO_SISTEMA=?
17:43:35,344 DEBUG AbstractCollectionPersister:475 - Static SQL for collection: gov.tresc.admsist.model.Sistema.usuarios
17:43:35,345 DEBUG AbstractCollectionPersister:476 - Row insert: insert into USUARIO_SISTEMA (IDO_SISTEMA, IDO_USUARIO) values (?, ?)
17:43:35,346 DEBUG AbstractCollectionPersister:477 - Row update: update USUARIO_SISTEMA set IDO_USUARIO=? where IDO_SISTEMA=? and IDO_USUARIO=?
17:43:35,348 DEBUG AbstractCollectionPersister:478 - Row delete: delete from USUARIO_SISTEMA where IDO_SISTEMA=? and IDO_USUARIO=?
17:43:35,349 DEBUG AbstractCollectionPersister:479 - One-shot delete: delete from USUARIO_SISTEMA where IDO_SISTEMA=?
17:43:35,382 DEBUG EntityLoader:118 - Static select for entity gov.tresc.admsist.model.Usuario: select usuario0_.IDO_USUARIO as IDO1_0_, usuario0_.NOME_USUARIO as NOME2_0_0_, usuario0_.LOGIN as LOGIN0_0_, usuario0_.E_MAIL as E4_0_0_ from ADMSIST.USUARIO usuario0_ where usuario0_.IDO_USUARIO=?
17:43:35,385 DEBUG EntityLoader:118 - Static select for entity gov.tresc.admsist.model.Usuario: select usuario0_.IDO_USUARIO as IDO1_0_, usuario0_.NOME_USUARIO as NOME2_0_0_, usuario0_.LOGIN as LOGIN0_0_, usuario0_.E_MAIL as E4_0_0_ from ADMSIST.USUARIO usuario0_ where usuario0_.IDO_USUARIO=?
17:43:35,387 DEBUG EntityLoader:118 - Static select for entity gov.tresc.admsist.model.Usuario: select usuario0_.IDO_USUARIO as IDO1_0_, usuario0_.NOME_USUARIO as NOME2_0_0_, usuario0_.LOGIN as LOGIN0_0_, usuario0_.E_MAIL as E4_0_0_ from ADMSIST.USUARIO usuario0_ where usuario0_.IDO_USUARIO=? for update
17:43:35,389 DEBUG EntityLoader:118 - Static select for entity gov.tresc.admsist.model.Usuario: select usuario0_.IDO_USUARIO as IDO1_0_, usuario0_.NOME_USUARIO as NOME2_0_0_, usuario0_.LOGIN as LOGIN0_0_, usuario0_.E_MAIL as E4_0_0_ from ADMSIST.USUARIO usuario0_ where usuario0_.IDO_USUARIO=? for update nowait
17:43:35,443 DEBUG EntityLoader:118 - Static select for entity gov.tresc.admsist.model.Sistema: select sistema0_.IDO_SISTEMA as IDO1_0_, sistema0_.NOME_SISTEMA as NOME2_1_0_, sistema0_.ESTACOES_ACESSO as ESTACOES3_1_0_ from ADMSIST.SISTEMA sistema0_ where sistema0_.IDO_SISTEMA=?
17:43:35,444 DEBUG EntityLoader:118 - Static select for entity gov.tresc.admsist.model.Sistema: select sistema0_.IDO_SISTEMA as IDO1_0_, sistema0_.NOME_SISTEMA as NOME2_1_0_, sistema0_.ESTACOES_ACESSO as ESTACOES3_1_0_ from ADMSIST.SISTEMA sistema0_ where sistema0_.IDO_SISTEMA=?
17:43:35,446 DEBUG EntityLoader:118 - Static select for entity gov.tresc.admsist.model.Sistema: select sistema0_.IDO_SISTEMA as IDO1_0_, sistema0_.NOME_SISTEMA as NOME2_1_0_, sistema0_.ESTACOES_ACESSO as ESTACOES3_1_0_ from ADMSIST.SISTEMA sistema0_ where sistema0_.IDO_SISTEMA=? for update
17:43:35,447 DEBUG EntityLoader:118 - Static select for entity gov.tresc.admsist.model.Sistema: select sistema0_.IDO_SISTEMA as IDO1_0_, sistema0_.NOME_SISTEMA as NOME2_1_0_, sistema0_.ESTACOES_ACESSO as ESTACOES3_1_0_ from ADMSIST.SISTEMA sistema0_ where sistema0_.IDO_SISTEMA=? for update nowait
17:43:35,465 DEBUG CollectionLoader:70 - Static select for collection gov.tresc.admsist.model.Sistema.usuarios: select usuarios0_.IDO_SISTEMA as IDO1___, usuarios0_.IDO_USUARIO as IDO2___, usuario1_.IDO_USUARIO as IDO1_0_, usuario1_.NOME_USUARIO as NOME2_0_0_, usuario1_.LOGIN as LOGIN0_0_, usuario1_.E_MAIL as E4_0_0_ from USUARIO_SISTEMA usuarios0_, ADMSIST.USUARIO usuario1_ where usuarios0_.IDO_USUARIO=usuario1_.IDO_USUARIO and usuarios0_.IDO_SISTEMA=?
17:43:35,475 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
17:43:35,485 DEBUG SessionFactoryObjectFactory:76 - registered: 8a8987ba0283e87d010283e882ac0000 (unnamed)
17:43:35,486 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
17:43:35,489 DEBUG SessionFactoryImpl:249 - instantiated session factory
17:43:35,490 INFO SessionFactoryImpl:366 - Checking 0 named queries
17:43:35,612 DEBUG SessionImpl:229 - opened session
17:43:35,615 DEBUG DefaultSaveOrUpdateEventListener:159 - saving transient instance
17:43:35,617 DEBUG AbstractSaveEventListener:89 - generated identifier: , using strategy: org.hibernate.id.SelectGenerator
17:43:35,622 DEBUG AbstractSaveEventListener:132 - saving [gov.tresc.admsist.model.Usuario#<null>]
17:43:35,623 DEBUG AbstractSaveEventListener:193 - executing insertions
17:43:35,644 DEBUG BasicEntityPersister:1705 - Inserting entity: gov.tresc.admsist.model.Usuario (native id)
17:43:35,645 DEBUG AbstractBatcher:258 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
17:43:35,646 DEBUG AbstractBatcher:379 - opening JDBC connection
17:43:35,648 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
17:43:35,651 DEBUG DriverManagerConnectionProvider:99 - using pooled JDBC connection, pool size: 0
17:43:35,657 DEBUG SQL:292 - insert into ADMSIST.USUARIO (NOME_USUARIO, LOGIN, E_MAIL) values (?, ?, ?)
Hibernate: insert into ADMSIST.USUARIO (NOME_USUARIO, LOGIN, E_MAIL) values (?, ?, ?)
17:43:35,660 DEBUG AbstractBatcher:343 - preparing statement
17:43:35,726 DEBUG BasicEntityPersister:1587 - Dehydrating entity: [gov.tresc.admsist.model.Usuario#<null>]
17:43:35,729 DEBUG AbstractBatcher:266 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
17:43:35,730 DEBUG AbstractBatcher:363 - closing statement
17:43:35,732 DEBUG AbstractBatcher:258 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
17:43:35,733 DEBUG SQL:292 - select IDO_USUARIO from ADMSIST.USUARIO where IDO_USUARIO =?
Hibernate: select IDO_USUARIO from ADMSIST.USUARIO where IDO_USUARIO =?
17:43:35,734 DEBUG AbstractBatcher:343 - preparing statement
17:43:35,741 DEBUG AbstractBatcher:266 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
17:43:35,742 DEBUG AbstractBatcher:363 - closing statement
org.hibernate.PropertyNotFoundException: Unable to resolve property [name=id] to corresponding index
at org.hibernate.tuple.EntityMetamodel.getPropertyIndex(EntityMetamodel.java:285)
at org.hibernate.tuple.AbstractTuplizer.getPropertyValue(AbstractTuplizer.java:199)
at org.hibernate.persister.entity.BasicEntityPersister.getPropertyValue(BasicEntityPersister.java:2899)
at org.hibernate.id.SelectGenerator.bindParameters(SelectGenerator.java:40)
at org.hibernate.id.AbstractPostInsertGenerator.getGenerated(AbstractPostInsertGenerator.java:41)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1755)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2149)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:34)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:238)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:158)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:104)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:429)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:424)
at gov.tresc.admsist.dao.DAOAdmSist.criaUsuario(DAOAdmSist.java:135)


Top
 Profile  
 
 Post subject:
PostPosted: Tue Mar 08, 2005 6:36 pm 
Beginner
Beginner

Joined: Sat Oct 18, 2003 8:00 pm
Posts: 22
I undertood the need of the key, but when using any other key I get a classcast exception, as the following debug log shows:

19:17:42,712 DEBUG SessionImpl:229 - opened session
19:17:42,713 DEBUG DefaultSaveOrUpdateEventListener:159 - saving transient instance
19:17:42,714 DEBUG AbstractSaveEventListener:89 - generated identifier: , using strategy: org.hibernate.id.SelectGenerator
19:17:42,715 DEBUG AbstractSaveEventListener:132 - saving [gov.tresc.admsist.model.Usuario#<null>]
19:17:42,716 DEBUG AbstractSaveEventListener:193 - executing insertions
19:17:42,717 DEBUG BasicEntityPersister:1705 - Inserting entity: gov.tresc.admsist.model.Usuario (native id)
19:17:42,719 DEBUG AbstractBatcher:258 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
19:17:42,720 DEBUG AbstractBatcher:379 - opening JDBC connection
19:17:42,724 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 1
19:17:42,725 DEBUG DriverManagerConnectionProvider:109 - opening new JDBC connection
19:17:42,782 DEBUG DriverManagerConnectionProvider:115 - created connection to: jdbc:oracle:thin:@setubal.tre-sc.gov.br:1521:des, Isolation Level: 2
19:17:42,783 DEBUG SQL:292 - insert into ADMSIST.USUARIO (NOME_USUARIO, LOGIN, E_MAIL) values (?, ?, ?)
Hibernate: insert into ADMSIST.USUARIO (NOME_USUARIO, LOGIN, E_MAIL) values (?, ?, ?)
19:17:42,784 DEBUG AbstractBatcher:343 - preparing statement
19:17:42,785 DEBUG BasicEntityPersister:1587 - Dehydrating entity: [gov.tresc.admsist.model.Usuario#<null>]
19:17:42,787 DEBUG AbstractBatcher:266 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
19:17:42,789 DEBUG AbstractBatcher:363 - closing statement
19:17:42,791 DEBUG AbstractBatcher:258 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
19:17:42,791 DEBUG SQL:292 - select IDO_USUARIO from ADMSIST.USUARIO where E_MAIL =?
Hibernate: select IDO_USUARIO from ADMSIST.USUARIO where E_MAIL =?
19:17:42,792 DEBUG AbstractBatcher:343 - preparing statement
19:17:42,793 DEBUG AbstractBatcher:266 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
19:17:42,794 DEBUG AbstractBatcher:363 - closing statement
java.lang.ClassCastException: java.lang.String
at org.hibernate.type.LongType.set(LongType.java:40)
at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:62)
at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:44)
at org.hibernate.id.SelectGenerator.bindParameters(SelectGenerator.java:40)
at org.hibernate.id.AbstractPostInsertGenerator.getGenerated(AbstractPostInsertGenerator.java:41)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1755)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2149)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:34)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:238)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:158)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:104)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:429)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:424)
at gov.tresc.admsist.dao.DAOAdmSist.criaUsuario(DAOAdmSist.java:135)
at gov.tresc.admsist.AdmSistFacade.criaUsuario(AdmSistFacade.java:53)
at gov.tresc.admsist.struts.UsuariosCRUDAction.criarFinish(UsuariosCRUDAction.java:41)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at gov.tresc.hibplugin.ActionFilter.doFilter(ActionFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:738)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 7 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.