2 Replies Latest reply on Dec 10, 2012 5:26 AM by Betto McRose Gamarra

    org.hibernate.LazyInitializationException using RESTful

    Betto McRose Gamarra Newbie

      well, I really don't know if this issue goes here

       

       

      I'm having problems implementing RESTfull in a proyect because the eternal lazy initialization exception

       

      this is the stact trace:

       

      10:19:12,463 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [1970-01-01 06:30:00.0] as column [hora13_5_0_]

      10:19:12,463 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getInt]

      10:19:12,463 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,464 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [11749] as column [id14_5_0_]

      10:19:12,464 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getString]

      10:19:12,464 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,465 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [ofranco] as column [nombre15_5_0_]

      10:19:12,465 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getString]

      10:19:12,465 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,466 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [127.0.0.1] as column [ultimo16_5_0_]

      10:19:12,466 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getString]

      10:19:12,467 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,467 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [administrador] as column [usuario17_5_0_]

      10:19:12,467 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,468 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [next]

      10:19:12,468 TRACE [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Done processing result set (1 rows)

      10:19:12,468 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [close]

      10:19:12,469 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Releasing statement [org.hibernate.engine.jdbc.internal.proxy.PreparedStatementProxyHandler@49a218d8[valid=true]]

      10:19:12,469 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Closing result set [org.hibernate.engine.jdbc.internal.proxy.ResultSetProxyHandler@310d32ac[valid=true]]

      10:19:12,470 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getWrappedObject]

      10:19:12,470 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Closing result set [org.postgresql.jdbc4.Jdbc4ResultSet@310d32ac]

      10:19:12,470 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [invalidate]

      10:19:12,471 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [close]

      10:19:12,471 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Closing prepared statement [org.hibernate.engine.jdbc.internal.proxy.PreparedStatementProxyHandler@49a218d8[valid=true]]

      10:19:12,471 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [getWrappedObject]

      10:19:12,472 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Closing prepared statement [org.jboss.jca.adapters.jdbc.jdk6.WrappedPreparedStatementJDK6@49a218d8]

      10:19:12,472 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [invalidate]

      10:19:12,473 TRACE [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Starting after statement execution processing [AFTER_STATEMENT]

      10:19:12,473 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Releasing JDBC connection

      10:19:12,473 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Released JDBC connection

      10:19:12,474 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,474 TRACE [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Total objects hydrated: 1

      10:19:12,474 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,475 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http-localhost-127.0.0.1-8080-1) Resolving associations for [py.org.pti.sgpti.authentication.model.Usuario#420]

      10:19:12,475 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,475 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,476 TRACE [org.hibernate.engine.loading.internal.LoadContexts] (http-localhost-127.0.0.1-8080-1) Creating collection wrapper: [py.org.pti.sgpti.authentication.model.Usuario.rolUsuarios1#420]

      10:19:12,476 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,477 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,477 TRACE [org.hibernate.engine.loading.internal.LoadContexts] (http-localhost-127.0.0.1-8080-1) Creating collection wrapper: [py.org.pti.sgpti.authentication.model.Usuario.rolUsuarios2#420]

      10:19:12,477 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,478 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,478 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,478 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,479 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http-localhost-127.0.0.1-8080-1) Done materializing entity [py.org.pti.sgpti.authentication.model.Usuario#420]

      10:19:12,479 DEBUG [org.hibernate.engine.internal.StatefulPersistenceContext] (http-localhost-127.0.0.1-8080-1) Initializing non-lazy collections

      10:19:12,480 DEBUG [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Done entity load

      10:19:12,480 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,480 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Aggressively releasing JDBC connection

      10:19:12,480 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,481 TRACE [org.hibernate.internal.SessionImpl] (http-localhost-127.0.0.1-8080-1) Setting cache mode to: NORMAL

      10:19:12,481 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,481 TRACE [org.jboss.as.jpa] (http-localhost-127.0.0.1-8080-1) find entityClass 'py.org.pti.sgpti.authentication.model.Usuario' took 47ms

      10:19:12,482 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,482 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,483 TRACE [org.hibernate.internal.SessionImpl] (http-localhost-127.0.0.1-8080-1) Setting cache mode to: NORMAL

      10:19:12,483 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,483 TRACE [org.hibernate.event.internal.DefaultLoadEventListener] (http-localhost-127.0.0.1-8080-1) Loading entity: [py.org.pti.sgpti.authentication.model.Usuario#8]

      10:19:12,484 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,484 TRACE [org.hibernate.event.internal.DefaultLoadEventListener] (http-localhost-127.0.0.1-8080-1) Attempting to resolve: [py.org.pti.sgpti.authentication.model.Usuario#8]

      10:19:12,484 TRACE [org.hibernate.event.internal.DefaultLoadEventListener] (http-localhost-127.0.0.1-8080-1) Object not resolved in any cache: [py.org.pti.sgpti.authentication.model.Usuario#8]

      10:19:12,485 TRACE [org.hibernate.persister.entity.AbstractEntityPersister] (http-localhost-127.0.0.1-8080-1) Fetching entity: [py.org.pti.sgpti.authentication.model.Usuario#8]

      10:19:12,485 DEBUG [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Loading entity: [py.org.pti.sgpti.authentication.model.Usuario#8]

      10:19:12,485 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,486 TRACE [org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of connection method [prepareStatement]

      10:19:12,486 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Obtaining JDBC connection

      10:19:12,487 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Obtained JDBC connection

      10:19:12,487 DEBUG [org.hibernate.SQL] (http-localhost-127.0.0.1-8080-1) select usuario0_.id as id5_0_, usuario0_.cantidad_acceso as cantidad2_5_0_, usuario0_.cantidad_intento as cantidad3_5_0_, usuario0_.contrasenha as contrase4_5_0_, usuario0_.dias_aviso_caducidad as dias5_5_0_, usuario0_.dias_caducidad_contrasenha as dias6_5_0_, usuario0_.estado as estado5_0_, usuario0_.fecha_fin_uso as fecha8_5_0_, usuario0_.fecha_ing as fecha9_5_0_, usuario0_.fecha_inicio_uso as fecha10_5_0_, usuario0_.fecha_ult_mod_contrasenha as fecha11_5_0_, usuario0_.hora_fin_uso as hora12_5_0_, usuario0_.hora_inicio_uso as hora13_5_0_, usuario0_.id_empleado as id14_5_0_, usuario0_.nombre_usuario as nombre15_5_0_, usuario0_.ultimo_ip as ultimo16_5_0_, usuario0_.usuario_ing as usuario17_5_0_ from seguridad_sistema.usuario usuario0_ where usuario0_.id=?

      10:19:12,488 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Registering statement [org.hibernate.engine.jdbc.internal.proxy.PreparedStatementProxyHandler@54fabfa3[valid=true]]

      10:19:12,489 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Registering last query statement [org.hibernate.engine.jdbc.internal.proxy.PreparedStatementProxyHandler@54fabfa3[valid=true]]

      10:19:12,489 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [getWrappedObject]

      10:19:12,490 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Registering last query statement [org.jboss.jca.adapters.jdbc.jdk6.WrappedPreparedStatementJDK6@54fabfa3]

      10:19:12,490 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] (http-localhost-127.0.0.1-8080-1) binding parameter [1] as [INTEGER] - 8

      10:19:12,491 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [setInt]

      10:19:12,491 TRACE [org.hibernate.engine.jdbc.internal.proxy.PreparedStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Binding via setInt: [1, 8]

      10:19:12,491 TRACE [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Bound [2] parameters total

      10:19:12,492 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [executeQuery]

      10:19:12,493 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Registering result set [org.hibernate.engine.jdbc.internal.proxy.ResultSetProxyHandler@1a3b91eb[valid=true]]

      10:19:12,494 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getStatement]

      10:19:12,494 TRACE [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Processing result set

      10:19:12,494 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [next]

      10:19:12,495 DEBUG [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Result set row: 0

      10:19:12,495 DEBUG [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Result row: EntityKey[py.org.pti.sgpti.authentication.model.Usuario#8]

      10:19:12,495 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,496 TRACE [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Initializing object from ResultSet: [py.org.pti.sgpti.authentication.model.Usuario#8]

      10:19:12,496 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,496 TRACE [org.hibernate.persister.entity.AbstractEntityPersister] (http-localhost-127.0.0.1-8080-1) Hydrating entity: [py.org.pti.sgpti.authentication.model.Usuario#8]

      10:19:12,497 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getInt]

      10:19:12,497 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,498 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [0] as column [cantidad2_5_0_]

      10:19:12,498 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getInt]

      10:19:12,498 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,499 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [0] as column [cantidad3_5_0_]

      10:19:12,499 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getString]

      10:19:12,499 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,500 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [7110eda4d09e062aa5e4a390b0a572ac0d2c0220] as column [contrase4_5_0_]

      10:19:12,500 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getInt]

      10:19:12,500 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,501 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [15] as column [dias5_5_0_]

      10:19:12,501 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getInt]

      10:19:12,501 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,502 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [30] as column [dias6_5_0_]

      10:19:12,502 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getString]

      10:19:12,502 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,503 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [A] as column [estado5_0_]

      10:19:12,503 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getDate]

      10:19:12,503 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [null] as column [fecha8_5_0_]

      10:19:12,504 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getDate]

      10:19:12,504 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,505 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [2011-04-29] as column [fecha9_5_0_]

      10:19:12,505 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getDate]

      10:19:12,505 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [null] as column [fecha10_5_0_]

      10:19:12,506 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getDate]

      10:19:12,506 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [null] as column [fecha11_5_0_]

      10:19:12,506 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getTimestamp]

      10:19:12,507 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,507 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [1970-01-01 00:00:00.0] as column [hora12_5_0_]

      10:19:12,507 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getTimestamp]

      10:19:12,508 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,508 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [1970-01-01 06:00:00.0] as column [hora13_5_0_]

      10:19:12,508 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getInt]

      10:19:12,509 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,509 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [118] as column [id14_5_0_]

      10:19:12,510 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getString]

      10:19:12,510 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,510 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [pablo.villasanti] as column [nombre15_5_0_]

      10:19:12,511 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getString]

      10:19:12,511 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [null] as column [ultimo16_5_0_]

      10:19:12,511 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getString]

      10:19:12,512 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,512 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [administrador] as column [usuario17_5_0_]

      10:19:12,512 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,513 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [next]

      10:19:12,513 TRACE [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Done processing result set (1 rows)

      10:19:12,515 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [close]

      10:19:12,515 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Releasing statement [org.hibernate.engine.jdbc.internal.proxy.PreparedStatementProxyHandler@54fabfa3[valid=true]]

      10:19:12,516 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Closing result set [org.hibernate.engine.jdbc.internal.proxy.ResultSetProxyHandler@1a3b91eb[valid=true]]

      10:19:12,516 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getWrappedObject]

      10:19:12,517 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Closing result set [org.postgresql.jdbc4.Jdbc4ResultSet@1a3b91eb]

      10:19:12,517 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [invalidate]

      10:19:12,518 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [close]

      10:19:12,518 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Closing prepared statement [org.hibernate.engine.jdbc.internal.proxy.PreparedStatementProxyHandler@54fabfa3[valid=true]]

      10:19:12,518 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [getWrappedObject]

      10:19:12,519 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Closing prepared statement [org.jboss.jca.adapters.jdbc.jdk6.WrappedPreparedStatementJDK6@54fabfa3]

      10:19:12,519 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [invalidate]

      10:19:12,521 TRACE [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Starting after statement execution processing [AFTER_STATEMENT]

      10:19:12,521 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Releasing JDBC connection

      10:19:12,522 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Released JDBC connection

      10:19:12,522 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,522 TRACE [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Total objects hydrated: 1

      10:19:12,523 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,523 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http-localhost-127.0.0.1-8080-1) Resolving associations for [py.org.pti.sgpti.authentication.model.Usuario#8]

      10:19:12,523 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,524 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,524 TRACE [org.hibernate.engine.loading.internal.LoadContexts] (http-localhost-127.0.0.1-8080-1) Creating collection wrapper: [py.org.pti.sgpti.authentication.model.Usuario.rolUsuarios1#8]

      10:19:12,525 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,525 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,526 TRACE [org.hibernate.engine.loading.internal.LoadContexts] (http-localhost-127.0.0.1-8080-1) Creating collection wrapper: [py.org.pti.sgpti.authentication.model.Usuario.rolUsuarios2#8]

      10:19:12,526 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,526 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,527 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,527 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,528 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http-localhost-127.0.0.1-8080-1) Done materializing entity [py.org.pti.sgpti.authentication.model.Usuario#8]

      10:19:12,528 DEBUG [org.hibernate.engine.internal.StatefulPersistenceContext] (http-localhost-127.0.0.1-8080-1) Initializing non-lazy collections

      10:19:12,528 DEBUG [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Done entity load

      10:19:12,529 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,529 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Aggressively releasing JDBC connection

      10:19:12,529 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,530 TRACE [org.hibernate.internal.SessionImpl] (http-localhost-127.0.0.1-8080-1) Setting cache mode to: NORMAL

      10:19:12,530 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,531 TRACE [org.jboss.as.jpa] (http-localhost-127.0.0.1-8080-1) find entityClass 'py.org.pti.sgpti.authentication.model.Usuario' took 49ms

      10:19:12,531 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,531 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,532 TRACE [org.hibernate.internal.SessionImpl] (http-localhost-127.0.0.1-8080-1) Setting cache mode to: NORMAL

      10:19:12,532 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,533 TRACE [org.hibernate.event.internal.DefaultLoadEventListener] (http-localhost-127.0.0.1-8080-1) Loading entity: [py.org.pti.sgpti.authentication.model.Usuario#5]

      10:19:12,533 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,533 TRACE [org.hibernate.event.internal.DefaultLoadEventListener] (http-localhost-127.0.0.1-8080-1) Attempting to resolve: [py.org.pti.sgpti.authentication.model.Usuario#5]

      10:19:12,534 TRACE [org.hibernate.event.internal.DefaultLoadEventListener] (http-localhost-127.0.0.1-8080-1) Object not resolved in any cache: [py.org.pti.sgpti.authentication.model.Usuario#5]

      10:19:12,534 TRACE [org.hibernate.persister.entity.AbstractEntityPersister] (http-localhost-127.0.0.1-8080-1) Fetching entity: [py.org.pti.sgpti.authentication.model.Usuario#5]

      10:19:12,535 DEBUG [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Loading entity: [py.org.pti.sgpti.authentication.model.Usuario#5]

      10:19:12,535 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,536 TRACE [org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of connection method [prepareStatement]

      10:19:12,536 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Obtaining JDBC connection

      10:19:12,536 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Obtained JDBC connection

      10:19:12,537 DEBUG [org.hibernate.SQL] (http-localhost-127.0.0.1-8080-1) select usuario0_.id as id5_0_, usuario0_.cantidad_acceso as cantidad2_5_0_, usuario0_.cantidad_intento as cantidad3_5_0_, usuario0_.contrasenha as contrase4_5_0_, usuario0_.dias_aviso_caducidad as dias5_5_0_, usuario0_.dias_caducidad_contrasenha as dias6_5_0_, usuario0_.estado as estado5_0_, usuario0_.fecha_fin_uso as fecha8_5_0_, usuario0_.fecha_ing as fecha9_5_0_, usuario0_.fecha_inicio_uso as fecha10_5_0_, usuario0_.fecha_ult_mod_contrasenha as fecha11_5_0_, usuario0_.hora_fin_uso as hora12_5_0_, usuario0_.hora_inicio_uso as hora13_5_0_, usuario0_.id_empleado as id14_5_0_, usuario0_.nombre_usuario as nombre15_5_0_, usuario0_.ultimo_ip as ultimo16_5_0_, usuario0_.usuario_ing as usuario17_5_0_ from seguridad_sistema.usuario usuario0_ where usuario0_.id=?

      10:19:12,538 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Registering statement [org.hibernate.engine.jdbc.internal.proxy.PreparedStatementProxyHandler@4f83ec44[valid=true]]

      10:19:12,539 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Registering last query statement [org.hibernate.engine.jdbc.internal.proxy.PreparedStatementProxyHandler@4f83ec44[valid=true]]

      10:19:12,539 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [getWrappedObject]

      10:19:12,540 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Registering last query statement [org.jboss.jca.adapters.jdbc.jdk6.WrappedPreparedStatementJDK6@4f83ec44]

      10:19:12,540 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] (http-localhost-127.0.0.1-8080-1) binding parameter [1] as [INTEGER] - 5

      10:19:12,541 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [setInt]

      10:19:12,541 TRACE [org.hibernate.engine.jdbc.internal.proxy.PreparedStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Binding via setInt: [1, 5]

      10:19:12,541 TRACE [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Bound [2] parameters total

      10:19:12,542 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [executeQuery]

      10:19:12,543 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Registering result set [org.hibernate.engine.jdbc.internal.proxy.ResultSetProxyHandler@5e0c8d24[valid=true]]

      10:19:12,544 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getStatement]

      10:19:12,544 TRACE [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Processing result set

      10:19:12,544 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [next]

      10:19:12,544 DEBUG [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Result set row: 0

      10:19:12,545 DEBUG [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Result row: EntityKey[py.org.pti.sgpti.authentication.model.Usuario#5]

      10:19:12,545 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,545 TRACE [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Initializing object from ResultSet: [py.org.pti.sgpti.authentication.model.Usuario#5]

      10:19:12,546 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,546 TRACE [org.hibernate.persister.entity.AbstractEntityPersister] (http-localhost-127.0.0.1-8080-1) Hydrating entity: [py.org.pti.sgpti.authentication.model.Usuario#5]

      10:19:12,547 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getInt]

      10:19:12,547 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,547 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [0] as column [cantidad2_5_0_]

      10:19:12,548 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getInt]

      10:19:12,548 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,548 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [5] as column [cantidad3_5_0_]

      10:19:12,549 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getString]

      10:19:12,549 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,549 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [7110eda4d09e062aa5e4a390b0a572ac0d2c0220] as column [contrase4_5_0_]

      10:19:12,550 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getInt]

      10:19:12,550 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,551 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [15] as column [dias5_5_0_]

      10:19:12,551 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getInt]

      10:19:12,551 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,552 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [30] as column [dias6_5_0_]

      10:19:12,552 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getString]

      10:19:12,552 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,553 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [A] as column [estado5_0_]

      10:19:12,553 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getDate]

      10:19:12,553 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [null] as column [fecha8_5_0_]

      10:19:12,554 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getDate]

      10:19:12,554 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,555 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [2011-04-29] as column [fecha9_5_0_]

      10:19:12,555 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getDate]

      10:19:12,555 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [null] as column [fecha10_5_0_]

      10:19:12,555 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getDate]

      10:19:12,556 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [null] as column [fecha11_5_0_]

      10:19:12,556 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getTimestamp]

      10:19:12,557 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,557 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [1970-01-01 00:00:00.0] as column [hora12_5_0_]

      10:19:12,557 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getTimestamp]

      10:19:12,558 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,558 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [1970-01-01 06:00:00.0] as column [hora13_5_0_]

      10:19:12,558 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getInt]

      10:19:12,559 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,559 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [47] as column [id14_5_0_]

      10:19:12,559 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getString]

      10:19:12,560 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,560 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [perfumo.roberto] as column [nombre15_5_0_]

      10:19:12,561 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getString]

      10:19:12,561 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [null] as column [ultimo16_5_0_]

      10:19:12,561 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getString]

      10:19:12,562 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,562 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [administrador] as column [usuario17_5_0_]

      10:19:12,562 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,563 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [next]

      10:19:12,563 TRACE [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Done processing result set (1 rows)

      10:19:12,563 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [close]

      10:19:12,564 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Releasing statement [org.hibernate.engine.jdbc.internal.proxy.PreparedStatementProxyHandler@4f83ec44[valid=true]]

      10:19:12,564 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Closing result set [org.hibernate.engine.jdbc.internal.proxy.ResultSetProxyHandler@5e0c8d24[valid=true]]

      10:19:12,565 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getWrappedObject]

      10:19:12,565 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Closing result set [org.postgresql.jdbc4.Jdbc4ResultSet@5e0c8d24]

      10:19:12,565 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [invalidate]

      10:19:12,566 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [close]

      10:19:12,566 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Closing prepared statement [org.hibernate.engine.jdbc.internal.proxy.PreparedStatementProxyHandler@4f83ec44[valid=true]]

      10:19:12,567 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [getWrappedObject]

      10:19:12,567 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Closing prepared statement [org.jboss.jca.adapters.jdbc.jdk6.WrappedPreparedStatementJDK6@4f83ec44]

      10:19:12,568 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [invalidate]

      10:19:12,568 TRACE [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Starting after statement execution processing [AFTER_STATEMENT]

      10:19:12,569 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Releasing JDBC connection

      10:19:12,569 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Released JDBC connection

      10:19:12,569 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,570 TRACE [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Total objects hydrated: 1

      10:19:12,570 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,570 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http-localhost-127.0.0.1-8080-1) Resolving associations for [py.org.pti.sgpti.authentication.model.Usuario#5]

      10:19:12,571 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,571 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,572 TRACE [org.hibernate.engine.loading.internal.LoadContexts] (http-localhost-127.0.0.1-8080-1) Creating collection wrapper: [py.org.pti.sgpti.authentication.model.Usuario.rolUsuarios1#5]

      10:19:12,572 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,573 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,573 TRACE [org.hibernate.engine.loading.internal.LoadContexts] (http-localhost-127.0.0.1-8080-1) Creating collection wrapper: [py.org.pti.sgpti.authentication.model.Usuario.rolUsuarios2#5]

      10:19:12,573 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,574 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,574 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,575 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,575 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http-localhost-127.0.0.1-8080-1) Done materializing entity [py.org.pti.sgpti.authentication.model.Usuario#5]

      10:19:12,575 DEBUG [org.hibernate.engine.internal.StatefulPersistenceContext] (http-localhost-127.0.0.1-8080-1) Initializing non-lazy collections

      10:19:12,576 DEBUG [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Done entity load

      10:19:12,576 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,576 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Aggressively releasing JDBC connection

      10:19:12,577 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,577 TRACE [org.hibernate.internal.SessionImpl] (http-localhost-127.0.0.1-8080-1) Setting cache mode to: NORMAL

      10:19:12,577 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,578 TRACE [org.jboss.as.jpa] (http-localhost-127.0.0.1-8080-1) find entityClass 'py.org.pti.sgpti.authentication.model.Usuario' took 47ms

      10:19:12,578 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,579 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,579 TRACE [org.hibernate.internal.SessionImpl] (http-localhost-127.0.0.1-8080-1) Setting cache mode to: NORMAL

      10:19:12,579 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,580 TRACE [org.hibernate.event.internal.DefaultLoadEventListener] (http-localhost-127.0.0.1-8080-1) Loading entity: [py.org.pti.sgpti.authentication.model.Usuario#4]

      10:19:12,580 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,580 TRACE [org.hibernate.event.internal.DefaultLoadEventListener] (http-localhost-127.0.0.1-8080-1) Attempting to resolve: [py.org.pti.sgpti.authentication.model.Usuario#4]

      10:19:12,581 TRACE [org.hibernate.event.internal.DefaultLoadEventListener] (http-localhost-127.0.0.1-8080-1) Object not resolved in any cache: [py.org.pti.sgpti.authentication.model.Usuario#4]

      10:19:12,581 TRACE [org.hibernate.persister.entity.AbstractEntityPersister] (http-localhost-127.0.0.1-8080-1) Fetching entity: [py.org.pti.sgpti.authentication.model.Usuario#4]

      10:19:12,582 DEBUG [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Loading entity: [py.org.pti.sgpti.authentication.model.Usuario#4]

      10:19:12,582 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,582 TRACE [org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of connection method [prepareStatement]

      10:19:12,583 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Obtaining JDBC connection

      10:19:12,583 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Obtained JDBC connection

      10:19:12,584 DEBUG [org.hibernate.SQL] (http-localhost-127.0.0.1-8080-1) select usuario0_.id as id5_0_, usuario0_.cantidad_acceso as cantidad2_5_0_, usuario0_.cantidad_intento as cantidad3_5_0_, usuario0_.contrasenha as contrase4_5_0_, usuario0_.dias_aviso_caducidad as dias5_5_0_, usuario0_.dias_caducidad_contrasenha as dias6_5_0_, usuario0_.estado as estado5_0_, usuario0_.fecha_fin_uso as fecha8_5_0_, usuario0_.fecha_ing as fecha9_5_0_, usuario0_.fecha_inicio_uso as fecha10_5_0_, usuario0_.fecha_ult_mod_contrasenha as fecha11_5_0_, usuario0_.hora_fin_uso as hora12_5_0_, usuario0_.hora_inicio_uso as hora13_5_0_, usuario0_.id_empleado as id14_5_0_, usuario0_.nombre_usuario as nombre15_5_0_, usuario0_.ultimo_ip as ultimo16_5_0_, usuario0_.usuario_ing as usuario17_5_0_ from seguridad_sistema.usuario usuario0_ where usuario0_.id=?

      10:19:12,586 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Registering statement [org.hibernate.engine.jdbc.internal.proxy.PreparedStatementProxyHandler@1439ae7[valid=true]]

      10:19:12,586 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Registering last query statement [org.hibernate.engine.jdbc.internal.proxy.PreparedStatementProxyHandler@1439ae7[valid=true]]

      10:19:12,587 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [getWrappedObject]

      10:19:12,587 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Registering last query statement [org.jboss.jca.adapters.jdbc.jdk6.WrappedPreparedStatementJDK6@1439ae7]

      10:19:12,588 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] (http-localhost-127.0.0.1-8080-1) binding parameter [1] as [INTEGER] - 4

      10:19:12,588 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [setInt]

      10:19:12,588 TRACE [org.hibernate.engine.jdbc.internal.proxy.PreparedStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Binding via setInt: [1, 4]

      10:19:12,589 TRACE [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Bound [2] parameters total

      10:19:12,589 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [executeQuery]

      10:19:12,590 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Registering result set [org.hibernate.engine.jdbc.internal.proxy.ResultSetProxyHandler@7d6eb456[valid=true]]

      10:19:12,591 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getStatement]

      10:19:12,591 TRACE [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Processing result set

      10:19:12,591 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [next]

      10:19:12,592 DEBUG [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Result set row: 0

      10:19:12,592 DEBUG [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Result row: EntityKey[py.org.pti.sgpti.authentication.model.Usuario#4]

      10:19:12,592 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,593 TRACE [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Initializing object from ResultSet: [py.org.pti.sgpti.authentication.model.Usuario#4]

      10:19:12,593 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,594 TRACE [org.hibernate.persister.entity.AbstractEntityPersister] (http-localhost-127.0.0.1-8080-1) Hydrating entity: [py.org.pti.sgpti.authentication.model.Usuario#4]

      10:19:12,594 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getInt]

      10:19:12,594 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,595 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [0] as column [cantidad2_5_0_]

      10:19:12,595 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getInt]

      10:19:12,596 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,596 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [0] as column [cantidad3_5_0_]

      10:19:12,596 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getString]

      10:19:12,597 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,597 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [7110eda4d09e062aa5e4a390b0a572ac0d2c0220] as column [contrase4_5_0_]

      10:19:12,597 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getInt]

      10:19:12,598 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,598 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [0] as column [dias5_5_0_]

      10:19:12,598 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getInt]

      10:19:12,599 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,599 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [0] as column [dias6_5_0_]

      10:19:12,599 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getString]

      10:19:12,600 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,600 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [A] as column [estado5_0_]

      10:19:12,601 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getDate]

      10:19:12,601 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [null] as column [fecha8_5_0_]

      10:19:12,601 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getDate]

      10:19:12,602 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,602 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [2011-04-29] as column [fecha9_5_0_]

      10:19:12,603 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getDate]

      10:19:12,603 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [null] as column [fecha10_5_0_]

      10:19:12,603 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getDate]

      10:19:12,604 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [null] as column [fecha11_5_0_]

      10:19:12,604 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getTimestamp]

      10:19:12,605 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,605 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [1970-01-01 00:00:00.0] as column [hora12_5_0_]

      10:19:12,605 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getTimestamp]

      10:19:12,606 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,606 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [1970-01-01 06:00:00.0] as column [hora13_5_0_]

      10:19:12,607 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getInt]

      10:19:12,607 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,608 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [2] as column [id14_5_0_]

      10:19:12,608 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getString]

      10:19:12,608 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,609 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [sergio.duarte] as column [nombre15_5_0_]

      10:19:12,609 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getString]

      10:19:12,610 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [null] as column [ultimo16_5_0_]

      10:19:12,610 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getString]

      10:19:12,610 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [wasNull]

      10:19:12,611 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost-127.0.0.1-8080-1) Found [administrador] as column [usuario17_5_0_]

      10:19:12,611 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,611 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [next]

      10:19:12,612 TRACE [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Done processing result set (1 rows)

      10:19:12,612 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [close]

      10:19:12,612 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Releasing statement [org.hibernate.engine.jdbc.internal.proxy.PreparedStatementProxyHandler@1439ae7[valid=true]]

      10:19:12,613 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Closing result set [org.hibernate.engine.jdbc.internal.proxy.ResultSetProxyHandler@7d6eb456[valid=true]]

      10:19:12,613 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [getWrappedObject]

      10:19:12,614 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Closing result set [org.postgresql.jdbc4.Jdbc4ResultSet@7d6eb456]

      10:19:12,614 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [invalidate]

      10:19:12,615 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of ResultSet method [close]

      10:19:12,615 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Closing prepared statement [org.hibernate.engine.jdbc.internal.proxy.PreparedStatementProxyHandler@1439ae7[valid=true]]

      10:19:12,615 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [getWrappedObject]

      10:19:12,616 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Closing prepared statement [org.jboss.jca.adapters.jdbc.jdk6.WrappedPreparedStatementJDK6@1439ae7]

      10:19:12,616 TRACE [org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of statement method [invalidate]

      10:19:12,617 TRACE [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Starting after statement execution processing [AFTER_STATEMENT]

      10:19:12,617 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Releasing JDBC connection

      10:19:12,617 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Released JDBC connection

      10:19:12,618 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,618 TRACE [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Total objects hydrated: 1

      10:19:12,618 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,619 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http-localhost-127.0.0.1-8080-1) Resolving associations for [py.org.pti.sgpti.authentication.model.Usuario#4]

      10:19:12,619 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,619 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,620 TRACE [org.hibernate.engine.loading.internal.LoadContexts] (http-localhost-127.0.0.1-8080-1) Creating collection wrapper: [py.org.pti.sgpti.authentication.model.Usuario.rolUsuarios1#4]

      10:19:12,620 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,621 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,621 TRACE [org.hibernate.engine.loading.internal.LoadContexts] (http-localhost-127.0.0.1-8080-1) Creating collection wrapper: [py.org.pti.sgpti.authentication.model.Usuario.rolUsuarios2#4]

      10:19:12,621 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,622 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,622 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,623 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,623 DEBUG [org.hibernate.engine.internal.TwoPhaseLoad] (http-localhost-127.0.0.1-8080-1) Done materializing entity [py.org.pti.sgpti.authentication.model.Usuario#4]

      10:19:12,625 DEBUG [org.hibernate.engine.internal.StatefulPersistenceContext] (http-localhost-127.0.0.1-8080-1) Initializing non-lazy collections

      10:19:12,625 DEBUG [org.hibernate.loader.Loader] (http-localhost-127.0.0.1-8080-1) Done entity load

      10:19:12,626 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,626 DEBUG [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Aggressively releasing JDBC connection

      10:19:12,626 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,627 TRACE [org.hibernate.internal.SessionImpl] (http-localhost-127.0.0.1-8080-1) Setting cache mode to: NORMAL

      10:19:12,627 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,627 TRACE [org.jboss.as.jpa] (http-localhost-127.0.0.1-8080-1) find entityClass 'py.org.pti.sgpti.authentication.model.Usuario' took 49ms

      10:19:12,628 TRACE [org.hibernate.LazyInitializationException] (http-localhost-127.0.0.1-8080-1) failed to lazily initialize a collection of role: py.org.pti.sgpti.authentication.model.Usuario.rolUsuarios1, no session or session was closed: org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: py.org.pti.sgpti.authentication.model.Usuario.rolUsuarios1, no session or session was closed

          at org.hibernate.collection.internal.AbstractPersistentCollection.throwLazyInitializationException(AbstractPersistentCollection.java:393) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.collection.internal.AbstractPersistentCollection.throwLazyInitializationExceptionIfNotConnected(AbstractPersistentCollection.java:385) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:378) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:112) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.collection.internal.PersistentSet.iterator(PersistentSet.java:180) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.codehaus.jackson.map.ser.std.CollectionSerializer.serializeContents(CollectionSerializer.java:45)

          at org.codehaus.jackson.map.ser.std.CollectionSerializer.serializeContents(CollectionSerializer.java:23)

          at org.codehaus.jackson.map.ser.std.AsArraySerializerBase.serialize(AsArraySerializerBase.java:86)

          at org.codehaus.jackson.map.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:446)

          at org.codehaus.jackson.map.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:150)

          at org.codehaus.jackson.map.ser.BeanSerializer.serialize(BeanSerializer.java:112)

          at org.codehaus.jackson.map.ser.std.CollectionSerializer.serializeContents(CollectionSerializer.java:72)

          at org.codehaus.jackson.map.ser.std.CollectionSerializer.serializeContents(CollectionSerializer.java:23)

          at org.codehaus.jackson.map.ser.std.AsArraySerializerBase.serialize(AsArraySerializerBase.java:86)

          at org.codehaus.jackson.map.ser.StdSerializerProvider._serializeValue(StdSerializerProvider.java:659)

          at org.codehaus.jackson.map.ser.StdSerializerProvider.serializeValue(StdSerializerProvider.java:271)

          at org.codehaus.jackson.map.ObjectWriter.writeValue(ObjectWriter.java:325)

          at org.codehaus.jackson.jaxrs.JacksonJsonProvider.writeTo(JacksonJsonProvider.java:556)

          at org.jboss.resteasy.core.interception.MessageBodyWriterContextImpl.proceed(MessageBodyWriterContextImpl.java:117) [resteasy-jaxrs-2.3.2.Final.jar:]

          at org.jboss.resteasy.plugins.interceptors.encoding.GZIPEncodingInterceptor.write(GZIPEncodingInterceptor.java:100) [resteasy-jaxrs-2.3.2.Final.jar:]

          at org.jboss.resteasy.core.interception.MessageBodyWriterContextImpl.proceed(MessageBodyWriterContextImpl.java:123) [resteasy-jaxrs-2.3.2.Final.jar:]

          at org.jboss.resteasy.core.ServerResponse.writeTo(ServerResponse.java:250) [resteasy-jaxrs-2.3.2.Final.jar:]

          at org.jboss.resteasy.core.SynchronousDispatcher.writeJaxrsResponse(SynchronousDispatcher.java:585) [resteasy-jaxrs-2.3.2.Final.jar:]

          at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:506) [resteasy-jaxrs-2.3.2.Final.jar:]

          at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119) [resteasy-jaxrs-2.3.2.Final.jar:]

          at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208) [resteasy-jaxrs-2.3.2.Final.jar:]

          at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55) [resteasy-jaxrs-2.3.2.Final.jar:]

          at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.3.2.Final.jar:]

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

          at org.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:62) [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

          at py.org.pti.sgpti.authentication.rest.JSONPRequestFilter.doFilter(JSONPRequestFilter.java:77) [classes:]

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

          at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final]

          at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

          at java.lang.Thread.run(Thread.java:636) [rt.jar:1.6.0_18]

       

      10:19:12,664 GRAVE [org.jboss.resteasy.core.SynchronousDispatcher] (http-localhost-127.0.0.1-8080-1) Failed executing GET /auth/activeusers: org.jboss.resteasy.spi.WriterException: org.codehaus.jackson.map.JsonMappingException: failed to lazily initialize a collection of role: py.org.pti.sgpti.authentication.model.Usuario.rolUsuarios1, no session or session was closed (through reference chain: java.util.LinkedList[0]->py.org.pti.sgpti.authentication.model.Usuario["rolUsuarios1"])

          at org.jboss.resteasy.core.ServerResponse.writeTo(ServerResponse.java:262) [resteasy-jaxrs-2.3.2.Final.jar:]

          at org.jboss.resteasy.core.SynchronousDispatcher.writeJaxrsResponse(SynchronousDispatcher.java:585) [resteasy-jaxrs-2.3.2.Final.jar:]

          at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:506) [resteasy-jaxrs-2.3.2.Final.jar:]

          at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119) [resteasy-jaxrs-2.3.2.Final.jar:]

          at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208) [resteasy-jaxrs-2.3.2.Final.jar:]

          at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55) [resteasy-jaxrs-2.3.2.Final.jar:]

          at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.3.2.Final.jar:]

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

          at org.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:62) [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

          at py.org.pti.sgpti.authentication.rest.JSONPRequestFilter.doFilter(JSONPRequestFilter.java:77) [classes:]

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

          at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final]

          at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

          at java.lang.Thread.run(Thread.java:636) [rt.jar:1.6.0_18]

      Caused by: org.codehaus.jackson.map.JsonMappingException: failed to lazily initialize a collection of role: py.org.pti.sgpti.authentication.model.Usuario.rolUsuarios1, no session or session was closed (through reference chain: java.util.LinkedList[0]->py.org.pti.sgpti.authentication.model.Usuario["rolUsuarios1"])

          at org.codehaus.jackson.map.JsonMappingException.wrapWithPath(JsonMappingException.java:218)

          at org.codehaus.jackson.map.JsonMappingException.wrapWithPath(JsonMappingException.java:183)

          at org.codehaus.jackson.map.ser.std.SerializerBase.wrapAndThrow(SerializerBase.java:140)

          at org.codehaus.jackson.map.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:158)

          at org.codehaus.jackson.map.ser.BeanSerializer.serialize(BeanSerializer.java:112)

          at org.codehaus.jackson.map.ser.std.CollectionSerializer.serializeContents(CollectionSerializer.java:72)

          at org.codehaus.jackson.map.ser.std.CollectionSerializer.serializeContents(CollectionSerializer.java:23)

          at org.codehaus.jackson.map.ser.std.AsArraySerializerBase.serialize(AsArraySerializerBase.java:86)

          at org.codehaus.jackson.map.ser.StdSerializerProvider._serializeValue(StdSerializerProvider.java:659)

          at org.codehaus.jackson.map.ser.StdSerializerProvider.serializeValue(StdSerializerProvider.java:271)

          at org.codehaus.jackson.map.ObjectWriter.writeValue(ObjectWriter.java:325)

          at org.codehaus.jackson.jaxrs.JacksonJsonProvider.writeTo(JacksonJsonProvider.java:556)

          at org.jboss.resteasy.core.interception.MessageBodyWriterContextImpl.proceed(MessageBodyWriterContextImpl.java:117) [resteasy-jaxrs-2.3.2.Final.jar:]

          at org.jboss.resteasy.plugins.interceptors.encoding.GZIPEncodingInterceptor.write(GZIPEncodingInterceptor.java:100) [resteasy-jaxrs-2.3.2.Final.jar:]

          at org.jboss.resteasy.core.interception.MessageBodyWriterContextImpl.proceed(MessageBodyWriterContextImpl.java:123) [resteasy-jaxrs-2.3.2.Final.jar:]

          at org.jboss.resteasy.core.ServerResponse.writeTo(ServerResponse.java:250) [resteasy-jaxrs-2.3.2.Final.jar:]

          ... 27 more

      Caused by: org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: py.org.pti.sgpti.authentication.model.Usuario.rolUsuarios1, no session or session was closed

          at org.hibernate.collection.internal.AbstractPersistentCollection.throwLazyInitializationException(AbstractPersistentCollection.java:393) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.collection.internal.AbstractPersistentCollection.throwLazyInitializationExceptionIfNotConnected(AbstractPersistentCollection.java:385) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:378) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:112) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.collection.internal.PersistentSet.iterator(PersistentSet.java:180) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.codehaus.jackson.map.ser.std.CollectionSerializer.serializeContents(CollectionSerializer.java:45)

          at org.codehaus.jackson.map.ser.std.CollectionSerializer.serializeContents(CollectionSerializer.java:23)

          at org.codehaus.jackson.map.ser.std.AsArraySerializerBase.serialize(AsArraySerializerBase.java:86)

          at org.codehaus.jackson.map.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:446)

          at org.codehaus.jackson.map.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:150)

          ... 39 more

       

      10:19:12,685 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,685 DEBUG [org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl] (http-localhost-127.0.0.1-8080-1) Skipping JTA sync registration due to auto join checking

      10:19:12,686 TRACE [org.hibernate.internal.SessionImpl] (http-localhost-127.0.0.1-8080-1) Closing session

      10:19:12,686 TRACE [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Closing logical connection

      10:19:12,686 TRACE [org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler] (http-localhost-127.0.0.1-8080-1) Handling invocation of connection method [close]

      10:19:12,687 TRACE [org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler] (http-localhost-127.0.0.1-8080-1) Invalidating connection handle

      10:19:12,687 TRACE [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl] (http-localhost-127.0.0.1-8080-1) Closing JDBC container [org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl@2111e072]

      10:19:12,688 TRACE [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (http-localhost-127.0.0.1-8080-1) Logical connection closed

       

       

      all join tables are lazy loading, I don't want to put them in eager

       

      this is the rest file

       

      @Path("/auth")

      @RequestScoped

      public class AuthenticationResourceRESTService

      {

          @Inject

          private EntityManager em;

         

          @Inject

          private CheckUser checkUser;

         

          @Inject

          private UserListProducer users;

       

         

         

          @GET

          @Path("/users")

          @Produces(MediaType.APPLICATION_JSON)

          public List<Usuario> listAllUsers()

          {

              return load(users.getAllUsers());

          }

       

       

      this is the listproducer


      @ApplicationScoped

      public class UserListProducer

      {

          @Inject EntityManager em;

       

          @SuppressWarnings("unchecked")

          public List<Usuario> getAllUsers()

          {

              return em.createQuery("select u from users u order by u.username").getResultList();

          }

      }

       

      and the resourse class

       

      public class Resources

      {

          @SuppressWarnings("unused")

          @Produces

          @PersistenceContext

          private EntityManager em;

       

      }

       

      any ideas ?

        • 1. Re: org.hibernate.LazyInitializationException using RESTful
          Scott Marlow Master

          The pattern to solve the lazy init error is to merge the detached entity that your trying to reference, back into the persistence context (EntityManager).  This is done from with in a JTA transaction.  Try calling em.merge(yourentity) before trying to reference yourentity.getRolUsuarios().

           

          Scott

          • 2. Re: org.hibernate.LazyInitializationException using RESTful
            Betto McRose Gamarra Newbie

            thanks Scott

             

            my load method was

             

            private List<Usuario> load(List<Usuario> collection)
            {
                    List<Usuario> loaded = new LinkedList<Usuario>();
               
                    for(Usuario record : collection)
                    {
                            loaded.add(em.find(Usuario.class, record.getId()));
                    }
                    return loaded;
            }

             

             

            and now is

             

            private List<Usuario> load(List<Usuario> collection) throws Exception
            {
                List<Usuario> loaded = new LinkedList<Usuario>();
               
                try
                {
                    try
                    {
                        utx.begin();
                        for(Usuario record : collection)
                        {
                            loaded.add(em.merge(record));
                        }
                    }
                    finally
                    {
                        utx.commit();
                    }
                }
                catch (Exception e)
                {
                    utx.rollback();
                    throw e;
                }
               
                return loaded;
            }

             

             

            and I got the same error

             

            guess I have to do a DTO