Description of the problem:
I use a class (see ProposalHandlerPoc below) that starts a new transaction when its method is called. In it, another class (ProposalPoc) is called to perform some database actions, including locking a row in a table. This method runs in the same transaction and throws an unchecked exception, causing the transaction to rollback. The handler catches this exception, clears and closes the session, and tries to perform the same database actions in a new transaction. However, locking the record in the new transaction fails. It seems to me that the record would no longer be locked after the transaction is rolled back and the session is cleared, but apparantly it is. Does any one have any idea what I'm doing wrong?


Hibernate version: 3.1

Spring configuration:
<bean id="SessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="entityInterceptor">
<bean class="be.smalsmvm.dmfa.odysseus.server.support.hibernate.interceptor.ProposalElementInterceptor"/>
</property>
<property name="dataSource">
<ref bean="DataSource"/>
</property>
<property name="mappingResources">
<list>
<value>be/smalsmvm/dmfa/odysseus/server/proposal/bom/Proposal.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<map>
<entry>
<key><value>hibernate.dialect</value></key><ref bean="HibernateDialect"/>
</entry>
<entry>
<key><value>hibernate.hbm2ddl.auto</value></key><ref bean="HibernateCreateDb"/>
</entry>
<entry>
<key><value>hibernate.show_sql</value></key><value>true</value>
</entry>
<entry>
<key><value>hibernate.format_sql</value></key><value>false</value>
</entry>
<entry>
<key><value>hibernate.use_sql_comments</value></key><value>true</value>
</entry>
<entry>
<key><value>hibernate.cache.provider_class</value></key><value>org.hibernate.cache.NoCacheProvider</value>
</entry>
<entry>
<key><value>hibernate.cache.use_second_level_cache</value></key><value>false</value>
</entry>
<entry>
<key><value>hibernate.cache.use_query_cache</value></key><value>false</value>
</entry>
<entry>
<key><value>hibernate.cglib.use_reflection_optimizer</value></key><value>false</value>
</entry>
<entry>
<!-- Weblogic uses another version of ANTLR in it's classpath so the new Hibernate AST Query Factory is unavailable in Weblogic -->
<key><value>hibernate.query.factory_class</value></key><value>org.hibernate.hql.classic.ClassicQueryTranslatorFactory</value>
</entry>
</map>
</property>
</bean>

<bean id="HibernateDialect" class="java.lang.String">
<constructor-arg type="java.lang.String"><value>org.hibernate.dialect.Oracle9Dialect</value></constructor-arg>
</bean>

<bean id="HibernateCreateDb" class="java.lang.String"/>

<bean id="DataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName">
<value>.../value>
</property>
</bean>

<bean id="TransactionManager" class="org.springframework.transaction.jta.WebLogicJtaTransactionManager"/>

<bean id="proposalPocNoTx" class="be.smalsmvm.dmfa.odysseus.server.proposal.ProposalPoc">
<property name="proposalDao" ref="ProposalDao"/>
</bean>

<bean id="proposalPoc" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager" ref="TransactionManager"/>
<property name="target" ref="proposalPocNoTx"/>
<property name="transactionAttributes">
<props>
<prop key="updateProposalNewTx">PROPAGATION_REQUIRES_NEW,timeout_120</prop>
<prop key="*">PROPAGATION_REQUIRED,timeout_30</prop>
</props>
</property>
</bean>

<bean id="proposalHandlerPocNoTx" class="be.smalsmvm.dmfa.odysseus.server.proposal.ProposalHandlerPoc">
<property name="proposalPoc" ref="proposalPoc"/>
<property name="sessionFactory" ref="SessionFactory"/>
</bean>

<bean id="proposalHandlerPoc" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager" ref="TransactionManager"/>
<property name="target" ref="proposalHandlerPocNoTx"/>
<property name="transactionAttributes">
<props>
<prop key="*">PROPAGATION_REQUIRES_NEW,timeout_600</prop>
</props>
</property>
</bean>

<bean id="ProposalDao" class="...ProposalDao">
<property name="sessionFactory">
<ref bean="SessionFactory"/>
</property>
</bean>


Code between sessionFactory.openSession() and session.close():
public class ProposalHandlerPoc {

private ProposalPoc proposalPoc;
private SessionFactory sessionFactory;


public void setProposalPoc(ProposalPoc proposalPoc) {
this.proposalPoc = proposalPoc;
}

public void setSessionFactory(SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}

// This method is called using a new transaction.
public void doTest() {
long proposalId = 7810;

try {
// Call the updateProposal() method that will throw an
// unchecked exception (causing a rollback of the transaction).
proposalPoc.updateProposalThrowException(proposalId);

} catch (Exception e) {
try {
// Make sure the session is closed after the rollback.
Session session = sessionFactory.getCurrentSession();
session.clear();
session.close();

// Call the updateProposal() method that uses a new transaction.
proposalPoc.updateProposalNewTx(proposalId);

} catch (Exception e1) {
// This line is added for debugging purposes.
throw new RuntimeException(e1);
}

// propagate the exception to the caller.
throw new RuntimeException(e);
}
}
}


public class ProposalPoc {

private ProposalDao proposalDao;


public void setProposalDao(ProposalDao proposalDao) {
this.proposalDao = proposalDao;
}


public void updateProposal(long proposalId) {
long start = System.currentTimeMillis();
try {
// Find out how long locking the entity takes.
// Lock the entity using a load with LockMode.UPGRADE.
proposalDao.lockProposal(proposalId);
} finally {
long end = System.currentTimeMillis();
System.out.println("joso - duration=" + (end - start) + "ms");
}

// Update the entity.
Proposal proposal = proposalDao.loadById(new Long(proposalId));
proposal.setNetOwedAmount(new Long(proposal.getNetOwedAmount().longValue() + 1));
proposalDao.save(proposal);
}

// This method uses a new transaction.
public void updateProposalNewTx(long proposalId) {
updateProposal(proposalId);
}

// This method throws an unchecked exception (causing a rollback of the transaction).
public void updateProposalThrowException(long proposalId) {
updateProposal(proposalId);
throw new NullPointerException();
}
}


Full stack trace of any exception that occurs:
be.smalsmvm.dmfa.odysseus.server.frontend.ejb.facade.ServerException

at sun.reflect.GeneratedConstructorAccessor36.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:274)

at weblogic.xml.schema.binding.BeanExceptionCodecBase.invokeConstructor(BeanExceptionCodecBase.java:134)

at weblogic.xml.schema.binding.BeanExceptionCodecBase.deserialize(BeanExceptionCodecBase.java:72)

at weblogic.xml.schema.binding.RuntimeUtils.invoke_deserializer(RuntimeUtils.java:428)

at weblogic.xml.schema.binding.RuntimeUtils.invoke_deserializer(RuntimeUtils.java:328)

at weblogic.webservice.core.DefaultPart.toJava(DefaultPart.java:388)

at weblogic.webservice.core.FaultMessage.toJava(FaultMessage.java:240)

at weblogic.webservice.core.ClientDispatcher.deserializeFault(ClientDispatcher.java:392)

at weblogic.webservice.core.ClientDispatcher.receive(ClientDispatcher.java:318)

at weblogic.webservice.core.ClientDispatcher.dispatch(ClientDispatcher.java:144)

at weblogic.webservice.core.DefaultOperation.invoke(DefaultOperation.java:471)

at weblogic.webservice.core.DefaultOperation.invoke(DefaultOperation.java:457)

at weblogic.webservice.core.rpc.StubImpl._invoke(StubImpl.java:303)

at be.smalsmvm.dmfa.odysseus.server.frontend.ejb.facade.FacadePort_Stub.control(FacadePort_Stub.java:695)

at be.smalsmvm.dmfa.odysseus.webservice.WebService.control(WebService.java:1292)

at be.smalsmvm.dmfa.odysseus.swing.task.ExecuteRulesTask.construct(ExecuteRulesTask.java:73)

at be.smalsmvm.common.swing.task.SwingWorker$2.run(SwingWorker.java:114)

at java.lang.Thread.run(Thread.java:534)

Caused by: javax.xml.rpc.soap.SOAPFaultException: Service specific exception: be.smalsmvm.dmfa.odysseus.server.frontend.ejb.facade.ServerException: java.lang.RuntimeException: org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not load an entity: [be.smalsmvm.dmfa.odysseus.server.proposal.bom.Proposal#7810]; bad SQL grammar [/* load be.smalsmvm.dmfa.odysseus.server.proposal.bom.Proposal */ select proposal0_.ID as ID0_0_, proposal0_.QUARTER as QUARTER0_0_, proposal0_.TYPE_ID as TYPE3_0_0_, proposal0_.INSTITUTION_TYPE_ID as INSTITUT4_0_0_, proposal0_.TICKET_NBR as TICKET5_0_0_, proposal0_.PROP_STATUS_ID as PROP6_0_0_, proposal0_.WF_STATUS_ID as WF7_0_0_, proposal0_.NOSS_NBR as NOSS8_0_0_, proposal0_.COMPANY_ID as COMPANY9_0_0_, proposal0_.TRUSTEESHIP_ID as TRUSTEE10_0_0_, proposal0_.EMPLOYER_NAME as EMPLOYER11_0_0_, proposal0_.LAST_MODIFIED as LAST12_0_0_, proposal0_.RECEIVED as RECEIVED0_0_, proposal0_.LAST_MODIFIED_USER_ID as LAST14_0_0_, proposal0_.OWNER_USER_ID as OWNER15_0_0_, proposal0_.PROPOSAL_GROUP_ID as PROPOSAL16_0_0_, proposal0_.PROXY_NBR as PROXY17_0_0_, proposal0_.PROXY_NAME as PROXY18_0_0_, proposal0_.NET_OWED_AMOUNT as NET19_0_0_, proposal0_.WORKFLOW_ID as WORKFLOW20_0_0_, proposal0_.OFFICE as OFFICE0_0_, proposal0_.SECTION as SECTION0_0_, proposal0_.COUNT_NP as COUNT23_0_0_, proposal0_.COUNT_CUNP as COUNT24_0_0_, proposal0_.COUNT_CV as COUNT25_0_0_, proposal0_.CREATOR as CREATOR0_0_, proposal0_.ORIGIN_ID as ORIGIN27_0_0_, proposal0_.DECISION_ID as DECISION28_0_0_, proposal0_.DIAGNOSIS_ID as DIAGNOSIS29_0_0_, proposal0_.TRANSMISSION_MODE_ID as TRANSMI30_0_0_ from PROPOSAL proposal0_ where proposal0_.ID=? for update]; nested exception is java.sql.SQLException: ORA-02049: timeout: distributed transaction waiting for lock

at be.smalsmvm.dmfa.odysseus.server.proposal.ProposalHandlerPoc.doTest(ProposalHandlerPoc.java:55)
at be.smalsmvm.dmfa.odysseus.server.proposal.ProposalHandlerPoc$$FastClassByCGLIB$$9e509c4f.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:660)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:147)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:169)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:601)
at be.smalsmvm.dmfa.odysseus.server.proposal.ProposalHandlerPoc$$EnhancerByCGLIB$$152724c7.doTest(<generated>)
at be.smalsmvm.dmfa.odysseus.server.frontend.ejb.facade.FacadeBean.control(FacadeBean.java:797)
at be.smalsmvm.dmfa.odysseus.server.frontend.ejb.facade.OdysseusFacade_nyxo5f_EOImpl.control(OdysseusFacade_nyxo5f_EOImpl.java:3712)
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:324)
at weblogic.webservice.component.slsb.SLSBInvocationHandler.invoke(SLSBInvocationHandler.java:88)
at weblogic.webservice.core.handler.InvokeHandler.handleRequest(InvokeHandler.java:104)
at weblogic.webservice.core.HandlerChainImpl.handleRequest(HandlerChainImpl.java:143)
at weblogic.webservice.core.DefaultOperation.process(DefaultOperation.java:549)
at weblogic.webservice.server.Dispatcher$1.run(Dispatcher.java:211)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
at weblogic.webservice.server.Dispatcher.process(Dispatcher.java:217)
at weblogic.webservice.server.Dispatcher.doDispatch(Dispatcher.java:176)
at weblogic.webservice.server.Dispatcher.dispatch(Dispatcher.java:96)
at weblogic.webservice.server.WebServiceManager.dispatch(WebServiceManager.java:100)
at weblogic.webservice.server.servlet.WebServiceServlet.serverSideInvoke(WebServiceServlet.java:297)
at weblogic.webservice.server.servlet.ServletBase.doPost(ServletBase.java:498)
at weblogic.webservice.server.servlet.WebServiceServlet.doPost(WebServiceServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1077)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:348)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:7047)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3902)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2773)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)
Caused by: org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not load an entity: [be.smalsmvm.dmfa.odysseus.server.proposal.bom.Proposal#7810]; bad SQL grammar [/* load be.smalsmvm.dmfa.odysseus.server.proposal.bom.Proposal */ select proposal0_.ID as ID0_0_, proposal0_.QUARTER as QUARTER0_0_, proposal0_.TYPE_ID as TYPE3_0_0_, proposal0_.INSTITUTION_TYPE_ID as INSTITUT4_0_0_, proposal0_.TICKET_NBR as TICKET5_0_0_, proposal0_.PROP_STATUS_ID as PROP6_0_0_, proposal0_.WF_STATUS_ID as WF7_0_0_, proposal0_.NOSS_NBR as NOSS8_0_0_, proposal0_.COMPANY_ID as COMPANY9_0_0_, proposal0_.TRUSTEESHIP_ID as TRUSTEE10_0_0_, proposal0_.EMPLOYER_NAME as EMPLOYER11_0_0_, proposal0_.LAST_MODIFIED as LAST12_0_0_, proposal0_.RECEIVED as RECEIVED0_0_, proposal0_.LAST_MODIFIED_USER_ID as LAST14_0_0_, proposal0_.OWNER_USER_ID as OWNER15_0_0_, proposal0_.PROPOSAL_GROUP_ID as PROPOSAL16_0_0_, proposal0_.PROXY_NBR as PROXY17_0_0_, proposal0_.PROXY_NAME as PROXY18_0_0_, proposal0_.NET_OWED_AMOUNT as NET19_0_0_, proposal0_.WORKFLOW_ID as WORKFLOW20_0_0_, proposal0_.OFFICE as OFFICE0_0_, proposal0_.SECTION as SECTION0_0_, proposal0_.COUNT_NP as COUNT23_0_0_, proposal0_.COUNT_CUNP as COUNT24_0_0_, proposal0_.COUNT_CV as COUNT25_0_0_, proposal0_.CREATOR as CREATOR0_0_, proposal0_.ORIGIN_ID as ORIGIN27_0_0_, proposal0_.DECISION_ID as DECISION28_0_0_, proposal0_.DIAGNOSIS_ID as DIAGNOSIS29_0_0_, proposal0_.TRANSMISSION_MODE_ID as TRANSMI30_0_0_ from PROPOSAL proposal0_ where proposal0_.ID=? for update]; nested exception is java.sql.SQLException: ORA-02049: timeout: distributed transaction waiting for lock

at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:89)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:258)
at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:411)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:371)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:332)
at be.smalsmvm.dmfa.odysseus.server.proposal.dao.ProposalDao.lockProposal(ProposalDao.java:141)
at be.smalsmvm.dmfa.odysseus.server.proposal.ProposalPoc.updateProposal(ProposalPoc.java:35)
at be.smalsmvm.dmfa.odysseus.server.proposal.ProposalPoc.updateProposalNewTx(ProposalPoc.java:49)
at be.smalsmvm.dmfa.odysseus.server.proposal.ProposalPoc$$FastClassByCGLIB$$e7d0e2f.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:660)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:147)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:169)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:601)
at be.smalsmvm.dmfa.odysseus.server.proposal.ProposalPoc$$EnhancerByCGLIB$$365276a7.updateProposalNewTx(<generated>)
at be.smalsmvm.dmfa.odysseus.server.proposal.ProposalHandlerPoc.doTest(ProposalHandlerPoc.java:51)
... 40 more
Caused by: java.sql.SQLException: ORA-02049: timeout: distributed transaction waiting for lock

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1060)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3361)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:131)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1785)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:93)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:81)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2730)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:365)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:346)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:123)
at org.hibernate.event.def.DefaultLoadEventListener.lockAndLoad(DefaultLoadEventListener.java:272)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:90)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:869)
at org.hibernate.impl.SessionImpl.load(SessionImpl.java:851)
at org.hibernate.impl.SessionImpl.load(SessionImpl.java:846)
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:324)
at org.springframework.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1205)
at $Proxy420.load(Unknown Source)
at be.smalsmvm.dmfa.odysseus.server.proposal.dao.ProposalDao$3.doInHibernate(ProposalDao.java:143)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
... 53 more


at weblogic.webservice.core.ClientDispatcher.receive(ClientDispatcher.java:314)

... 9 more



Name and version of the database you are using: Oracle 9

The generated SQL (show_sql=true):
Hibernate: /* load ...Proposal */ select proposal0_.ID as ID0_0_, proposal0_.QUARTER as QUARTER0_0_, proposal0_.TYPE_ID as TYPE3_0_0_, proposal0_.INSTITUTION_TYPE_ID as INSTITUT4_0_0_, proposal0_.TICKET_NBR as TICKET5_0_0_, proposal0_.PROP_STATUS_ID as PROP6_0_0_, proposal0_.WF_STATUS_ID as WF7_0_0_, proposal0_.NOSS_NBR as NOSS8_0_0_, proposal0_.COMPANY_ID as COMPANY9_0_0_, proposal0_.TRUSTEESHIP_ID as TRUSTEE10_0_0_, proposal0_.EMPLOYER_NAME as EMPLOYER11_0_0_, proposal0_.LAST_MODIFIED as LAST12_0_0_, proposal0_.RECEIVED as RECEIVED0_0_, proposal0_.LAST_MODIFIED_USER_ID as LAST14_0_0_, proposal0_.OWNER_USER_ID as OWNER15_0_0_, proposal0_.PROPOSAL_GROUP_ID as PROPOSAL16_0_0_, proposal0_.PROXY_NBR as PROXY17_0_0_, proposal0_.PROXY_NAME as PROXY18_0_0_, proposal0_.NET_OWED_AMOUNT as NET19_0_0_, proposal0_.WORKFLOW_ID as WORKFLOW20_0_0_, proposal0_.OFFICE as OFFICE0_0_, proposal0_.SECTION as SECTION0_0_, proposal0_.COUNT_NP as COUNT23_0_0_, proposal0_.COUNT_CUNP as COUNT24_0_0_, proposal0_.COUNT_CV as COUNT25_0_0_, proposal0_.CREATOR as CREATOR0_0_, proposal0_.ORIGIN_ID as ORIGIN27_0_0_, proposal0_.DECISION_ID as DECISION28_0_0_, proposal0_.DIAGNOSIS_ID as DIAGNOSIS29_0_0_, proposal0_.TRANSMISSION_MODE_ID as TRANSMI30_0_0_ from PROPOSAL proposal0_ where proposal0_.ID=? for update
joso - duration=14ms
Hibernate: /* load ...Proposal */ select proposal0_.ID as ID0_0_, proposal0_.QUARTER as QUARTER0_0_, proposal0_.TYPE_ID as TYPE3_0_0_, proposal0_.INSTITUTION_TYPE_ID as INSTITUT4_0_0_, proposal0_.TICKET_NBR as TICKET5_0_0_, proposal0_.PROP_STATUS_ID as PROP6_0_0_, proposal0_.WF_STATUS_ID as WF7_0_0_, proposal0_.NOSS_NBR as NOSS8_0_0_, proposal0_.COMPANY_ID as COMPANY9_0_0_, proposal0_.TRUSTEESHIP_ID as TRUSTEE10_0_0_, proposal0_.EMPLOYER_NAME as EMPLOYER11_0_0_, proposal0_.LAST_MODIFIED as LAST12_0_0_, proposal0_.RECEIVED as RECEIVED0_0_, proposal0_.LAST_MODIFIED_USER_ID as LAST14_0_0_, proposal0_.OWNER_USER_ID as OWNER15_0_0_, proposal0_.PROPOSAL_GROUP_ID as PROPOSAL16_0_0_, proposal0_.PROXY_NBR as PROXY17_0_0_, proposal0_.PROXY_NAME as PROXY18_0_0_, proposal0_.NET_OWED_AMOUNT as NET19_0_0_, proposal0_.WORKFLOW_ID as WORKFLOW20_0_0_, proposal0_.OFFICE as OFFICE0_0_, proposal0_.SECTION as SECTION0_0_, proposal0_.COUNT_NP as COUNT23_0_0_, proposal0_.COUNT_CUNP as COUNT24_0_0_, proposal0_.COUNT_CV as COUNT25_0_0_, proposal0_.CREATOR as CREATOR0_0_, proposal0_.ORIGIN_ID as ORIGIN27_0_0_, proposal0_.DECISION_ID as DECISION28_0_0_, proposal0_.DIAGNOSIS_ID as DIAGNOSIS29_0_0_, proposal0_.TRANSMISSION_MODE_ID as TRANSMI30_0_0_ from PROPOSAL proposal0_ where proposal0_.ID=? for update
joso - duration=60219ms