Greetings,
I have an aplplication working fine on the following configuration:
spring 1.0m4,
hibernate 2.1.4,
jboss 3.2.2
jdk 1.4.2_2
I have now two goals:
1) use the jasperreports and quartz integration of Spring Framework, due this i think that its easier upgrade spring to version 1.1.3
2) To use the last performance improvements on JVM, I upgraded JBoss to version 3.2.6 and JVM to 1.5.0_01
Jboss 3.2.6 is shipped with hibernate 2.1.6 and Spring 1.1.3 with hibernate version 2.1.8.
I have tested all Hibernate versions (2.1.4, 2.1.6 and 2.1.8), on both JVMs, but in these configurations I always achieve the net.sf.hibernate.NonUniqueObjectException that was not throwed by past configurations.
Im fighting with this trouble for 3 days now, and have searched the long list of net.sf.hibernate.NonUniqueObjectException posts. I tried some recomendations, like
Code:
use session.lock()
, but I think that this is a new issue.
Thank you in advance
Hibernate version: 2.1.4 and 2.1.8
Mapping documents:Code:
<hibernate-mapping>
<class
name="com.imm.app.model.PessoaFila"
table="pessoafila"
dynamic-update="false"
dynamic-insert="false"
>
<id
name="def_Cod"
column="def_Dev_Cod"
type="java.lang.Long"
>
<generator class="assigned">
</generator>
</id>
<property
name="def_DataHoraAgenda"
type="java.util.Date"
update="true"
insert="true"
>
<column
name="def_datahoraagenda"
not-null="false"
/>
</property>
<property
name="def_Ordem"
type="java.lang.Long"
update="true"
insert="true"
>
<column
name="def_ordem"
not-null="false"
/>
</property>
<property
name="def_ProgramadaAutomatica"
type="java.lang.Long"
update="true"
insert="true"
>
<column
name="def_programadaAutomatica"
not-null="false"
/>
</property>
<one-to-one
name="devedor"
class="com.imm.app.model.Devedor"
cascade="none"
outer-join="true"
constrained="false"
/>
<many-to-one
name="fila"
class="com.imm.app.model.Fila"
cascade="none"
outer-join="auto"
update="true"
insert="true"
column="def_fil_cod"
not-null="false"
/>
<many-to-one
name="usuario"
class="com.imm.app.model.Usuario"
cascade="none"
outer-join="auto"
update="true"
insert="true"
column="def_usu_cod"
not-null="false"
/>
<property
name="def_EmAcionamento"
type="java.lang.Boolean"
update="true"
insert="true"
>
<column
name="Def_EmAcionamento"
not-null="true"
/>
</property>
<property
name="def_Tel_codPreferencial"
type="java.lang.Long"
update="true"
insert="true"
>
<column
name="def_Tel_codPreferencial"
not-null="false"
/>
</property>
<property
name="def_Fil_CodOriginal"
type="java.lang.Long"
update="true"
insert="true"
>
<column
name="def_fil_codoriginal"
not-null="false"
/>
</property>
<property
name="def_AgendaOriginal"
type="java.util.Date"
update="true"
insert="true"
>
<column
name="def_AgendaOriginal"
not-null="false"
/>
</property>
<property
name="def_progAutOriginal"
type="java.lang.Long"
update="true"
insert="true"
>
<column
name="def_progAutOriginal"
not-null="false"
/>
</property>
<many-to-one
name="realocacaoExecutada"
class="com.imm.app.model.RealocacaoExecutada"
cascade="none"
outer-join="auto"
update="true"
insert="true"
column="def_ree_cod"
not-null="false"
/>
<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-PessoaFila.xml
containing the additional properties and place it in your merge dir.
-->
</class>
</hibernate-mapping>
Code between sessionFactory.openSession() and session.close():Providede by Spring Framework HibernateDaoSupport
Code:
HibernateCallback hibCall = new HibernateCallback(){
public Object doInHibernate(Session session) throws HibernateException, SQLException {
Usuario usuario = new Usuario();
session.lock(pessoaFila, LockMode.NONE);
if (propriedadeFicha) {
usuario.setUsu_Cod(usu_Cod);
pessoaFila.setUsuario(usuario);
} else {
pessoaFila.setUsuario(null);
}
if (dataAgenda != null) {
pessoaFila.setDef_DataHoraAgenda(dataAgenda);
}
if (tipo_Agenda != null) {
Long ProgramadaAutomatica = ((tipo_Agenda.longValue() == 33)
? new Long(22)
: new Long(23));
pessoaFila.setDef_ProgramadaAutomatica(ProgramadaAutomatica);
}
pessoaFila.setDef_Ordem(ORDEM);
pessoaFila.setDef_EmAcionamento(EM_ACIONAMENTO);
pessoaFila.setDef_Tel_codPreferencial(tel_cod);
session.saveOrUpdate(pessoaFila);
return null;
}
};
Full stack trace of any exception that occurs:Code:
2005-02-18 19:42:32,652 ERROR [org.jboss.ejb.plugins.LogInterceptor] RuntimeException in method: public abstract com.imm.app.business.vo.ResultadoFechamentoContatoVO com.imm.app.business.FechaContatoBO.fechaContato(java.lang.String,com.imm.app.model.Devedor,com.imm.app.model.ParametroCobranca,java.lang.String,java.lang.String,java.util.Date,com.imm.app.model.Usuario,com.imm.app.model.Fila,java.lang.Long,java.lang.Integer,boolean) throws com.imm.app.business.IntranetException
org.springframework.orm.hibernate.HibernateSystemException: a different object with the same identifier value was already associated with the session: 307694, of class: com.imm.app.model.PessoaFila; nested exception is net.sf.hibernate.NonUniqueObjectException: a different object with the same identifier value was already associated with the session: 307694, of class: com.imm.app.model.PessoaFila
net.sf.hibernate.NonUniqueObjectException: a different object with the same identifier value was already associated with the session: 307694, of class: com.imm.app.model.PessoaFila
at net.sf.hibernate.impl.SessionImpl.checkUniqueness(SessionImpl.java:1687)
at net.sf.hibernate.impl.SessionImpl.reassociate(SessionImpl.java:1693)
at net.sf.hibernate.impl.SessionImpl.lock(SessionImpl.java:1719)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.orm.hibernate.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1196)
at $Proxy41.lock(Unknown Source)
at com.imm.app.dao.hibernate.PessoaFilaHib$3.doInHibernate(PessoaFilaHib.java:291)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:312)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:289)
at com.imm.app.dao.hibernate.PessoaFilaHib.gravaAgenda(PessoaFilaHib.java:325)
at com.imm.app.business.ejb.FechaContatoEJB.gravaAgenda(FechaContatoEJB.java:653)
at com.imm.app.business.ejb.FechaContatoEJB.fechaContato(FechaContatoEJB.java:135)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(Unknown Source)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:111)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
at org.jboss.ejb.Container.invoke(Container.java:709)
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:419)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:83)
at $Proxy139.fechaContato(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.ejb.access.LocalSlsbInvokerInterceptor.invoke(LocalSlsbInvokerInterceptor.java:62)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy240.fechaContato(Unknown Source)
at com.imm.app.web.controller.AbsContataDevedorMC.fechaContato(AbsContataDevedorMC.java:1921)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:352)
at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:305)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:128)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:595)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:543)
at org.springframework.web.servlet.FrameworkServlet.serviceWrapper(FrameworkServlet.java:390)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:350)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.web.filter.CompressionFilter.doFilter(CompressionFilter.java:239)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:595)
Name and version of the database you are using:
Oracle 9i last patch
The generated SQL (show_sql=true):
Debug level Hibernate log excerpt:
[code]
2005-02-18 19:42:32,532 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.Usuario#7]
2005-02-18 19:42:32,532 DEBUG [net.sf.hibernate.impl.SessionImpl] object not resolved in any cache [com.imm.app.model.Usuario#7]
2005-02-18 19:42:32,532 DEBUG [net.sf.hibernate.persister.EntityPersister] Materializing entity: [com.imm.app.model.Usuario#7]
2005-02-18 19:42:32,532 DEBUG [net.sf.hibernate.impl.BatcherImpl] about to open: 0 open PreparedStatements, 0 open ResultSets
2005-02-18 19:42:32,532 DEBUG [net.sf.hibernate.SQL] select usuario0_.usu_Cod as usu_Cod3_, usuario0_.usu_cod_supervisor as usu_cod_2_3_, usuario0_.usu_ativo as usu_ativo3_, usuario0_.usu_carga_horaria as usu_carg4_3_, usuario0_.usu_ramal as usu_ramal3_, usuario0_.usu_nome as usu_nome3_, usuario0_.usu_rh_cod as usu_rh_cod3_, usuario0_.usu_senha as usu_senha3_, usuario0_.usu_usuario as usu_usua9_3_, usuario0_.usu_uni_cod as usu_uni10_3_, usuario0_.usu_anotacoes as usu_ano11_3_, usuario0_.usu_liberaausencia as usu_lib12_3_, usuario0_.usu_valido as usu_valido3_, usuario0_.usu_nrocaixa as usu_nro14_3_, usuario0_.usu_CodAlteracao as usu_Cod15_3_, usuario0_.usu_dataalteracao as usu_dat16_3_, usuario0_.usu_DataInclusao as usu_Dat17_3_, usuario0_.usu_DataInvalido as usu_Dat18_3_, usuario1_.usu_Cod as usu_Cod0_, usuario1_.usu_cod_supervisor as usu_cod_2_0_, usuario1_.usu_ativo as usu_ativo0_, usuario1_.usu_carga_horaria as usu_carg4_0_, usuario1_.usu_ramal as usu_ramal0_, usuario1_.usu_nome as usu_nome0_, usuario1_.usu_rh_cod as usu_rh_cod0_, usuario1_.usu_senha as usu_senha0_, usuario1_.usu_usuario as usu_usua9_0_, usuario1_.usu_uni_cod as usu_uni10_0_, usuario1_.usu_anotacoes as usu_ano11_0_, usuario1_.usu_liberaausencia as usu_lib12_0_, usuario1_.usu_valido as usu_valido0_, usuario1_.usu_nrocaixa as usu_nro14_0_, usuario1_.usu_CodAlteracao as usu_Cod15_0_, usuario1_.usu_dataalteracao as usu_dat16_0_, usuario1_.usu_DataInclusao as usu_Dat17_0_, usuario1_.usu_DataInvalido as usu_Dat18_0_, unidade2_.uni_cod as uni_cod1_, unidade2_.uni_tun_cod as uni_tun_2_1_, unidade2_.uni_localbd as uni_loca3_1_, unidade2_.uni_localBDAtendimento as uni_loca4_1_, unidade2_.uni_nome as uni_nome1_, unidade2_.uni_tamanho as uni_tama6_1_, unidade2_.uni_cnpj as uni_cnpj1_, unidade2_.uni_endereco as uni_ende8_1_, unidade2_.uni_telefone as uni_tele9_1_, unidade2_.uni_DataAlteracao as uni_Dat10_1_, unidade2_.uni_DataInclusao as uni_Dat11_1_, unidade2_.uni_DataInvalido as uni_Dat12_1_, unidade2_.uni_CodRepasse as uni_Cod13_1_, unidade2_.uni_NomeEmpresa as uni_Nom14_1_, unidade2_.uni_valido as uni_valido1_, unidade2_.uni_Usu_CodAlteracao as uni_Usu16_1_, tipounidad3_.tun_Cod as tun_Cod2_, tipounidad3_.tun_descricao as tun_desc2_2_, tipounidad3_.tun_DataAlteracao as tun_Data3_2_, tipounidad3_.tun_DataInclusao as tun_Data4_2_, tipounidad3_.tun_DataInvalido as tun_Data5_2_, tipounidad3_.tun_Valido as tun_Valido2_, tipounidad3_.tun_Usu_CodAlteracao as tun_Usu_7_2_ from Usuario usuario0_, Usuario usuario1_, Unidade unidade2_, TipoUnidade tipounidad3_ where usuario0_.usu_Cod=? and usuario0_.usu_cod_supervisor=usuario1_.usu_Cod(+) and usuario1_.usu_uni_cod=unidade2_.uni_cod(+) and unidade2_.uni_tun_cod=tipounidad3_.tun_Cod(+)
2005-02-18 19:42:32,532 DEBUG [net.sf.hibernate.impl.BatcherImpl] preparing statement
2005-02-18 19:42:32,532 DEBUG [net.sf.hibernate.type.LongType] binding '7' to parameter: 1
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.loader.Loader] processing result set
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.LongType] returning '7' as column: usu_Cod0_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.StringType] returning 'SIC' as column: uni_cod1_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.LongType] returning '1' as column: tun_Cod2_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.loader.Loader] result row: 7, SIC, 1, 7
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.loader.Loader] Initializing object from ResultSet: 7
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.loader.Loader] Hydrating entity: com.imm.app.model.Usuario#7
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.LongType] returning '7' as column: usu_cod_2_0_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.BooleanType] returning 'true' as column: usu_ativo0_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.TimestampType] returning null as column: usu_carg4_0_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.StringType] returning null as column: usu_ramal0_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.StringType] returning 'MARCIA' as column: usu_nome0_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.StringType] returning '1' as column: usu_rh_cod0_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.StringType] returning '5678' as column: usu_senha0_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.StringType] returning 'MARCIA' as column: usu_usua9_0_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.StringType] returning 'SIC' as column: usu_uni10_0_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.StringType] returning 'asdfasdfasdfasdfasddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasdfasdfasdfasdfasddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasdfasdfasdfasdfasddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasdfasdfasdfasdfasddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasdfasdfasdfasdfasddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasdfasdfasdfasdfasddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasdfasdfasdfasdfasddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasdfasdfasdfasdfasddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasdfasdfasdfasdfasddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasdfasdfasdfasdfasddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasdfasdfasdfasdfasddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasdfasdfasdfasdfasddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasdfasdfasdfasdfasddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasdfasdfasdfasdfasddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasdfasdfasdfasdfasddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasdfasdfasdfasdfasddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasdfasdfasdfasdfasddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasdfasdfasdfasdfasddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasdfasdfasdfasdfasddddaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasdfasdfasdfffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdddddddddddddddddddddddddddddddddddddddddddddddddfffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdddddddddddddddddddddddddddddddddddddddddddddddddfffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdddddddddddddddddddddddddddd
' as column: usu_ano11_0_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.BooleanType] returning 'false' as column: usu_lib12_0_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.BooleanType] returning 'true' as column: usu_valido0_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.IntegerType] returning '2' as column: usu_nro14_0_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.LongType] returning null as column: usu_Cod15_0_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.TimestampType] returning null as column: usu_dat16_0_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.TimestampType] returning null as column: usu_Dat17_0_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.TimestampType] returning null as column: usu_Dat18_0_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.loader.Loader] Initializing object from ResultSet: SIC
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.loader.Loader] Hydrating entity: com.imm.app.model.Unidade#SIC
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.LongType] returning '1' as column: uni_tun_2_1_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.LongType] returning null as column: uni_loca3_1_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.IntegerType] returning '54' as column: uni_loca4_1_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.StringType] returning 'SICOB-LOS' as column: uni_nome1_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.StringType] returning null as column: uni_tama6_1_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.StringType] returning '92000000/0072-5' as column: uni_cnpj1_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.StringType] returning 'RUA URUGUAI 155, 11 ANDAR' as column: uni_ende8_1_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.StringType] returning '2131-2015' as column: uni_tele9_1_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.TimestampType] returning null as column: uni_Dat10_1_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.TimestampType] returning null as column: uni_Dat11_1_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.TimestampType] returning null as column: uni_Dat12_1_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.LongType] returning '36' as column: uni_Cod13_1_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.StringType] returning null as column: uni_Nom14_1_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.BooleanType] returning null as column: uni_valido1_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.LongType] returning null as column: uni_Usu16_1_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.loader.Loader] Initializing object from ResultSet: 1
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.loader.Loader] Hydrating entity: com.imm.app.model.TipoUnidade#1
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.StringType] returning 'tun_descricao' as column: tun_desc2_2_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.TimestampType] returning null as column: tun_Data3_2_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.TimestampType] returning null as column: tun_Data4_2_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.TimestampType] returning null as column: tun_Data5_2_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.BooleanType] returning null as column: tun_Valido2_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.LongType] returning null as column: tun_Usu_7_2_
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.loader.Loader] done processing result set (1 rows)
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.BatcherImpl] done closing: 0 open PreparedStatements, 0 open ResultSets
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.BatcherImpl] closing statement
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.loader.Loader] total objects hydrated: 3
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] resolving associations for [com.imm.app.model.Usuario#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.Usuario#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.Usuario#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] resolved object in session cache [com.imm.app.model.Usuario#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.Unidade#SIC]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.Unidade#SIC]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] resolved object in session cache [com.imm.app.model.Unidade#SIC]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.solicitacaoausencia#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.horarioUsuario#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.realocacaoExecutada#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.msg_usu_codoperador#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.msg_usucodsupervisor#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.estadoDevedor#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.fila#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.identidade#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.logOperadorResumido#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.identidadeLogada#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.historico#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.transferenciaEntreFilial#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.produto#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.logAtendimentoAtend#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.logAtendimentoCaixa#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.logAtendimentoRecep#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.permissao#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.permissaoAdicional#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.parcelaAcordoAlteracao#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.parcelaAcordoAtendente#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.parcelaAcordoOperador#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.parcelaAcordoSupervisor#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.simulacao#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.usuarioAcordoAlteracao#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.distribuicaoAlteracao#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.movimentoCaixa#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.boletoAlteracao#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.arquivoDebitoConta#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.originalAcordo#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.unidadealteracao#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.filaAlteracao#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.simulacaoSupervisor#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.parametrosUnidade#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.logPermissao#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.debitoConta#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.estadoOperador#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.fase#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.feriado#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.usuarioAlteracao#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.operacao#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.PAdicional#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.script#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Usuario.acordoSupervisor#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] done materializing entity [com.imm.app.model.Usuario#7]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] resolving associations for [com.imm.app.model.Unidade#SIC]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.realocacaoUnidade#SIC]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.conurbada#SIC]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.feriados#SIC]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.historico#SIC]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.logOperadorResumido#SIC]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.logoperador#SIC]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.mensagem#SIC]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.solicitacaoausencia#SIC]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.TipoUnidade#1]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.TipoUnidade#1]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] resolved object in session cache [com.imm.app.model.TipoUnidade#1]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.proximosCodigos#SIC]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.ParametrosUnidade#SIC]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.ParametrosUnidade#SIC]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.SessionImpl] object not resolved in any cache [com.imm.app.model.ParametrosUnidade#SIC]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.persister.EntityPersister] Materializing entity: [com.imm.app.model.ParametrosUnidade#SIC]
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.BatcherImpl] about to open: 0 open PreparedStatements, 0 open ResultSets
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.SQL] select parametros0_.pru_Uni_Cod as pru_Uni_1_4_, parametros0_.pru_cifracelular as pru_cifr2_4_, parametros0_.pru_cifraconvencional as pru_cifr3_4_, parametros0_.pru_nromaximosenha as pru_nrom4_4_, parametros0_.pru_NroSenhaAtual as pru_NroS5_4_, parametros0_.pru_operadorafFone as pru_oper6_4_, parametros0_.pru_NroSenhaAtualPref as pru_NroS7_4_, parametros0_.pru_NroMaximoSenhaPref as pru_NroM8_4_, parametros0_.pru_DDDLocal as pru_DDDL9_4_, parametros0_.pru_dataalteracao as pru_dat10_4_, parametros0_.pru_datainclusao as pru_dat11_4_, parametros0_.pru_datainvalido as pru_dat12_4_, parametros0_.pru_valido as pru_valido4_, parametros0_.pru_usu_codOpeGenerico as pru_usu14_4_, parametros0_.pru_guichePref as pru_gui15_4_, parametros0_.pru_Usu_CodAlteracao as pru_Usu16_4_, unidade1_.uni_cod as uni_cod0_, unidade1_.uni_tun_cod as uni_tun_2_0_, unidade1_.uni_localbd as uni_loca3_0_, unidade1_.uni_localBDAtendimento as uni_loca4_0_, unidade1_.uni_nome as uni_nome0_, unidade1_.uni_tamanho as uni_tama6_0_, unidade1_.uni_cnpj as uni_cnpj0_, unidade1_.uni_endereco as uni_ende8_0_, unidade1_.uni_telefone as uni_tele9_0_, unidade1_.uni_DataAlteracao as uni_Dat10_0_, unidade1_.uni_DataInclusao as uni_Dat11_0_, unidade1_.uni_DataInvalido as uni_Dat12_0_, unidade1_.uni_CodRepasse as uni_Cod13_0_, unidade1_.uni_NomeEmpresa as uni_Nom14_0_, unidade1_.uni_valido as uni_valido0_, unidade1_.uni_Usu_CodAlteracao as uni_Usu16_0_, tipounidad2_.tun_Cod as tun_Cod1_, tipounidad2_.tun_descricao as tun_desc2_1_, tipounidad2_.tun_DataAlteracao as tun_Data3_1_, tipounidad2_.tun_DataInclusao as tun_Data4_1_, tipounidad2_.tun_DataInvalido as tun_Data5_1_, tipounidad2_.tun_Valido as tun_Valido1_, tipounidad2_.tun_Usu_CodAlteracao as tun_Usu_7_1_, usuario3_.usu_Cod as usu_Cod2_, usuario3_.usu_cod_supervisor as usu_cod_2_2_, usuario3_.usu_ativo as usu_ativo2_, usuario3_.usu_carga_horaria as usu_carg4_2_, usuario3_.usu_ramal as usu_ramal2_, usuario3_.usu_nome as usu_nome2_, usuario3_.usu_rh_cod as usu_rh_cod2_, usuario3_.usu_senha as usu_senha2_, usuario3_.usu_usuario as usu_usua9_2_, usuario3_.usu_uni_cod as usu_uni10_2_, usuario3_.usu_anotacoes as usu_ano11_2_, usuario3_.usu_liberaausencia as usu_lib12_2_, usuario3_.usu_valido as usu_valido2_, usuario3_.usu_nrocaixa as usu_nro14_2_, usuario3_.usu_CodAlteracao as usu_Cod15_2_, usuario3_.usu_dataalteracao as usu_dat16_2_, usuario3_.usu_DataInclusao as usu_Dat17_2_, usuario3_.usu_DataInvalido as usu_Dat18_2_, usuario4_.usu_Cod as usu_Cod3_, usuario4_.usu_cod_supervisor as usu_cod_2_3_, usuario4_.usu_ativo as usu_ativo3_, usuario4_.usu_carga_horaria as usu_carg4_3_, usuario4_.usu_ramal as usu_ramal3_, usuario4_.usu_nome as usu_nome3_, usuario4_.usu_rh_cod as usu_rh_cod3_, usuario4_.usu_senha as usu_senha3_, usuario4_.usu_usuario as usu_usua9_3_, usuario4_.usu_uni_cod as usu_uni10_3_, usuario4_.usu_anotacoes as usu_ano11_3_, usuario4_.usu_liberaausencia as usu_lib12_3_, usuario4_.usu_valido as usu_valido3_, usuario4_.usu_nrocaixa as usu_nro14_3_, usuario4_.usu_CodAlteracao as usu_Cod15_3_, usuario4_.usu_dataalteracao as usu_dat16_3_, usuario4_.usu_DataInclusao as usu_Dat17_3_, usuario4_.usu_DataInvalido as usu_Dat18_3_ from ParametrosUnidade parametros0_, Unidade unidade1_, TipoUnidade tipounidad2_, Usuario usuario3_, Usuario usuario4_ where parametros0_.pru_Uni_Cod=? and parametros0_.pru_Uni_Cod=unidade1_.uni_cod(+) and unidade1_.uni_tun_cod=tipounidad2_.tun_Cod(+) and unidade1_.uni_Usu_CodAlteracao=usuario3_.usu_Cod(+) and usuario3_.usu_cod_supervisor=usuario4_.usu_Cod(+)
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.impl.BatcherImpl] preparing statement
2005-02-18 19:42:32,542 DEBUG [net.sf.hibernate.type.StringType] binding 'SIC' to parameter: 1
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.loader.Loader] processing result set
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.type.StringType] returning 'SIC' as column: uni_cod0_
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.type.LongType] returning '1' as column: tun_Cod1_
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.type.LongType] returning null as column: usu_Cod2_
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.type.LongType] returning null as column: usu_Cod3_
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.loader.Loader] result row: SIC, 1, null, null, SIC
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.loader.Loader] Initializing object from ResultSet: SIC
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.loader.Loader] Hydrating entity: com.imm.app.model.ParametrosUnidade#SIC
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.type.IntegerType] returning '9' as column: pru_cifr2_4_
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.type.IntegerType] returning null as column: pru_cifr3_4_
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.type.IntegerType] returning '5' as column: pru_nrom4_4_
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.type.IntegerType] returning '2' as column: pru_NroS5_4_
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.type.IntegerType] returning '25' as column: pru_oper6_4_
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.type.IntegerType] returning '1001' as column: pru_NroS7_4_
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.type.IntegerType] returning '1007' as column: pru_NroM8_4_
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.type.IntegerType] returning '55' as column: pru_DDDL9_4_
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.type.TimestampType] returning null as column: pru_dat10_4_
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.type.TimestampType] returning null as column: pru_dat11_4_
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.type.TimestampType] returning null as column: pru_dat12_4_
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.type.BooleanType] returning null as column: pru_valido4_
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.type.LongType] returning null as column: pru_usu14_4_
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.type.IntegerType] returning '1' as column: pru_gui15_4_
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.type.LongType] returning null as column: pru_Usu16_4_
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.loader.Loader] done processing result set (1 rows)
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.BatcherImpl] done closing: 0 open PreparedStatements, 0 open ResultSets
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.BatcherImpl] closing statement
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.loader.Loader] total objects hydrated: 1
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolving associations for [com.imm.app.model.ParametrosUnidade#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.Unidade#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.Unidade#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolved object in session cache [com.imm.app.model.Unidade#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] done materializing entity [com.imm.app.model.ParametrosUnidade#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.simulacao#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.realocacao#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.realocacaoExecutada#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.telefone#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.dividaAcionada#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.dividaRecebida#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.fila#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.filaCaixa#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.transferenciaEntreFilialDestino#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.transferenciaEntreFilialOrigem#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.logAtendimento#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.parcelaAcordo#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.cobrancaExterna#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.acordo#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.distribuicao#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.movimentoCaixa#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.repasse#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.boleto#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.debitoConta#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.chequePgto#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.movimentoPgto#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.filaPrompt#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.originalAcordo#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.filaAtendimento#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.estornoMC#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.endereco#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.fraude#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.dividaDevolvidaAcionada#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Unidade.dividaDevolvidaRecebida#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] done materializing entity [com.imm.app.model.Unidade#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolving associations for [com.imm.app.model.TipoUnidade#1]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.TipoUnidade.unidade#1]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] done materializing entity [com.imm.app.model.TipoUnidade#1]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.Produto#BC1]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.Produto#BC1]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolved object in session cache [com.imm.app.model.Produto#BC1]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.Unidade#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.Unidade#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolved object in session cache [com.imm.app.model.Unidade#SIC]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Fila.parametroCobranca#1]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Fila.transferenciaEntreFilialDestino#1]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.Fila.transferenciaEntreFilialOrigem#1]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] done materializing entity [com.imm.app.model.Fila#1]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolving associations for [com.imm.app.model.CalendarioDiscagem#2]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] creating collection wrapper:[com.imm.app.model.CalendarioDiscagem.fila#2]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.OrdenacaoDiscagem#2]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.OrdenacaoDiscagem#2]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolved object in session cache [com.imm.app.model.OrdenacaoDiscagem#2]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.OrdenacaoDiscagem#2]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.OrdenacaoDiscagem#2]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolved object in session cache [com.imm.app.model.OrdenacaoDiscagem#2]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolved object in session cache [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolved object in session cache [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolved object in session cache [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolved object in session cache [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolved object in session cache [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolved object in session cache [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolved object in session cache [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolved object in session cache [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolved object in session cache [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolved object in session cache [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.Usuario#2]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.Usuario#2]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolved object in session cache [com.imm.app.model.Usuario#2]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] done materializing entity [com.imm.app.model.CalendarioDiscagem#2]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolving associations for [com.imm.app.model.OrdenacaoDiscagem#2]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] done materializing entity [com.imm.app.model.OrdenacaoDiscagem#2]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolving associations for [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] done materializing entity [com.imm.app.model.OrdenacaoDiscagem#28]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] resolving associations for [com.imm.app.model.Usuario#2]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [com.imm.app.model.Unidade#POA]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [com.imm.app.model.Unidade#POA]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.SessionImpl] object not resolved in any cache [com.imm.app.model.Unidade#POA]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.persister.EntityPersister] Materializing entity: [com.imm.app.model.Unidade#POA]
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.impl.BatcherImpl] about to open: 0 open PreparedStatements, 0 open ResultSets
2005-02-18 19:42:32,552 DEBUG [net.sf.hibernate.SQL] select unidade0_.uni_cod as uni_cod3_, unidade0_.uni_tun_cod as uni_tun_2_3_, unidade0_.uni_localbd as uni_loca3_3_, unidade0_.uni_localBDAtendimento as uni_loca4_3_, unidade0_.uni_nome as uni_nome3_, unidade0_.uni_tamanho as uni_tama6_3_, unidade0_.uni_cnpj as uni_cnpj3_, unidade0_.uni_endereco as uni_ende8_3_, unidade0_.uni_telefone as uni_tele9_3_, unidade0_.uni_DataAlteracao as uni_Dat10_3_, unidade0_.uni_DataInclusao as uni_Dat11_3_, unidade0_.uni_DataInvalido as uni_Dat12_3_, unidade0_.uni_CodRepasse as uni_Cod13_3_, unidade0_.uni_NomeEmpresa as uni_Nom14_3_, unidade0_.uni_valido as uni_valido3_, unidade0_.uni_Usu_CodAlteracao as uni_Usu16_3_, tipounidad1_.tun_Cod as tun_Cod0_, tipounidad1_.tun_descricao as tun_desc2_0_, tipounidad1_.tun_DataAlteracao as tun_Data3_0_, tipounidad1_.tun_DataInclusao as tun_Data4_0_, tipounidad1_.tun_DataInvalido as tun_Data5_0_, tipounidad1_.tun_Valido as tun_Valido0_, tipounidad1_.tun_Usu_CodAlteracao as tun_Usu_7_0_, usuario2_.usu_Cod as usu_Cod1_, usuario2_.usu_cod_supervisor as usu_cod_2_1_, usuario2_.usu_ativo as usu_ativo1_, usuario2_.usu_carga_horaria as usu_carg4_1_, usuario2_.usu_ramal as usu_ramal1_, usuario2_.usu_nome as usu_nome1_, usuar