Databases
StackOverflow2013
Postsdbo
PO"No Hibernate Session bound to thread", transactional method breaks execution of the next transaction
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO"No Hibernate Session bound to thread", transactional method breaks execution of the next transaction
    primarykey
    data
    text
    <p>My problem is hidden in class, with 2 methods. </p> <pre><code>@Repository @Transactional(isolation = Isolation.READ_COMMITTED) public class RetentionController { @Autowired private SessionFactory sessionFactory; ... @Transactional(readOnly = true) public BaseResource getResource(String pPath)throws ResourceNotFoundException{ ... Criteria critDirExists = sessionFactory.getCurrentSession().createCriteria(Directory.class); critDirExists.add(Restrictions.eq(PATH, pPath)); Directory dir = (Directory) critDirExists.uniqueResult(); ...processing results... } @Transactional(readOnly = false) public void addDirectory(String pPath) { modelValidator.validateDirectoryURI(pPath); //check if such exists Criteria critExists = sessionFactory.getCurrentSession().createCriteria(Directory.class); critExists.add(Restrictions.eq("path", pPath)); ... } ... } </code></pre> <p>SessionFactory is injected correctly - first method executes normally. The problem is: addDirectory throws "No Hibernate Session bound to thread" at " Criteria critExists = sessionFactory.getCurrentSession().createCriteria(Directory.class);", when it is invoked after "getResource()" method. </p> <p>Logs (I added marks to see where methods are started and finished: GET RESOURCE: START/END, ADD DIRECTORY: START/END):</p> <pre><code> DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Returning cached instance of singleton bean 'transactionManager' DEBUG [org.springframework.orm.hibernate3.HibernateTransactionManager] - Creating new transaction with name [com.asg.tciclientadapters.webdav.dal.RetentionController.getResource]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,readOnly; '' DEBUG [org.springframework.orm.hibernate3.HibernateTransactionManager] - Opened new Session [org.hibernate.impl.SessionImpl@1be3bb2] for Hibernate transaction DEBUG [org.springframework.orm.hibernate3.HibernateTransactionManager] - Preparing JDBC Connection of Hibernate Session [org.hibernate.impl.SessionImpl@1be3bb2] DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] - Setting JDBC Connection [jdbc:sqlserver://******\****:****;selectMethod=direct;lastUpdateCount=true;, UserName=*********, Microsoft SQL Server 2005 JDBC Driver] read-only DEBUG [org.springframework.orm.hibernate3.HibernateTransactionManager] - Exposing Hibernate transaction as JDBC transaction [jdbc:sqlserver://******\****:****;selectMethod=direct;lastUpdateCount=true;, UserName=*********, Microsoft SQL Server 2005 JDBC Driver] TRACE [org.springframework.transaction.support.TransactionSynchronizationManager] - Bound value [org.springframework.jdbc.datasource.ConnectionHolder@13b8f62] for key [org.apache.commons.dbcp.BasicDataSource@115512] to thread [http-9080-1] TRACE [org.springframework.transaction.support.TransactionSynchronizationManager] - Bound value [org.springframework.orm.hibernate3.SessionHolder@299629] for key [org.hibernate.impl.SessionFactoryImpl@1429498] to thread [http-9080-1] TRACE [org.springframework.transaction.support.TransactionSynchronizationManager] - Initializing transaction synchronization TRACE [org.springframework.transaction.interceptor.TransactionInterceptor] - Getting transaction for [com.asg.tciclientadapters.webdav.dal.RetentionController.getResource] DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Returning cached instance of singleton bean 'com.asg.tciclientadapters.webdav.aspect.TraceLog#0' DEBUG [com.asg.tciclientadapters.webdav.dal.RetentionController] - ---GET RESOURCE: START TRACE [org.springframework.transaction.support.TransactionSynchronizationManager] - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@299629] for key [org.hibernate.impl.SessionFactoryImpl@1429498] bound to thread [http-9080-1] DEBUG [com.asg.tciclientadapters.webdav.dal.RetentionController] - Getting ILM object: /CADPWebDAV DEBUG [com.asg.tciclientadapters.webdav.dal.RetentionController] - RequestType is MKCOL DEBUG [com.asg.tciclientadapters.webdav.dal.RetentionController] - EmbryoResource was created. TRACE [org.springframework.transaction.support.TransactionSynchronizationManager] - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@299629] for key [org.hibernate.impl.SessionFactoryImpl@1429498] bound to thread [http-9080-1] DEBUG [com.asg.tciclientadapters.webdav.dal.RetentionController] - ---GET RESOURCE: END TRACE [com.asg.tciclientadapters.webdav.aspect.TraceLog] - RetentionController.getResource(..) Executed at: 78 ms TRACE [com.asg.tciclientadapters.webdav.aspect.TraceLog] - Method Argument [1]: com.asg.tciclientadapters.webdav.servlet.CADPRequest@10241ae TRACE [com.asg.tciclientadapters.webdav.aspect.TraceLog] - Method Argument [2]: com.asg.tciclientadapters.webdav.tci.TCIWrapper@1ca203 TRACE [org.springframework.transaction.interceptor.TransactionInterceptor] - Completing transaction for [com.asg.tciclientadapters.webdav.dal.RetentionController.getResource] TRACE [org.springframework.orm.hibernate3.HibernateTransactionManager] - Triggering beforeCommit synchronization TRACE [org.springframework.orm.hibernate3.HibernateTransactionManager] - Triggering beforeCompletion synchronization DEBUG [org.springframework.orm.hibernate3.HibernateTransactionManager] - Initiating transaction commit DEBUG [org.springframework.orm.hibernate3.HibernateTransactionManager] - Committing Hibernate transaction on Session [org.hibernate.impl.SessionImpl@1be3bb2] TRACE [org.springframework.orm.hibernate3.HibernateTransactionManager] - Triggering afterCommit synchronization TRACE [org.springframework.orm.hibernate3.HibernateTransactionManager] - Triggering afterCompletion synchronization TRACE [org.springframework.transaction.support.TransactionSynchronizationManager] - Clearing transaction synchronization TRACE [org.springframework.transaction.support.TransactionSynchronizationManager] - Removed value [org.springframework.orm.hibernate3.SessionHolder@299629] for key [org.hibernate.impl.SessionFactoryImpl@1429498] from thread [http-9080-1] TRACE [org.springframework.transaction.support.TransactionSynchronizationManager] - Removed value [org.springframework.jdbc.datasource.ConnectionHolder@13b8f62] for key [org.apache.commons.dbcp.BasicDataSource@115512] from thread [http-9080-1] DEBUG [org.springframework.orm.hibernate3.HibernateTransactionManager] - Closing Hibernate Session [org.hibernate.impl.SessionImpl@1be3bb2] after transaction DEBUG [org.springframework.orm.hibernate3.SessionFactoryUtils] - Closing Hibernate Session DEBUG [com.asg.tciclientadapters.webdav.dal.RetentionController] - ---ADD DIRECTORY: START DEBUG [com.asg.tciclientadapters.webdav.dal.RetentionController] - Validation: OK DEBUG [org.springframework.orm.hibernate3.SessionFactoryUtils] - Opening Hibernate Session DEBUG [org.springframework.orm.hibernate3.SessionFactoryUtils] - Closing Hibernate Session ERROR [com.asg.tciclientadapters.webdav.servlet.CADPServlet] - org.hibernate.HibernateException: No Hibernate Session bound to thread, and configuration does not allow creation of non-transactional one here </code></pre> <p>Spring configuration xml file:</p> <pre><code>&lt;context:property-placeholder location="classpath:spring.properties"/&gt; &lt;context:annotation-config/&gt; &lt;tx:annotation-driven/&gt; &lt;aop:aspectj-autoproxy/&gt; &lt;context:mbean-export/&gt; &lt;bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" p:driverClassName="${jdbc.driverClassName}" p:url="${jdbc.url}" p:username="${jdbc.username}" p:password="${jdbc.password}"/&gt; &lt;!-- Hibernate SessionFactory --&gt; &lt;bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean" p:dataSource-ref="dataSource" p:mappingResources="CADPWebDAV_hbm.xml"&gt; &lt;property name="hibernateProperties"&gt; &lt;props&gt; &lt;prop key="hibernate.dialect"&gt;${hibernate.dialect}&lt;/prop&gt; &lt;prop key="hibernate.show_sql"&gt;${hibernate.show_sql}&lt;/prop&gt; &lt;prop key="hibernate.generate_statistics"&gt;${hibernate.generate_statistics}&lt;/prop&gt; &lt;prop key="hibernate.cache.use_structured_entries"&gt;true&lt;/prop&gt; &lt;/props&gt; &lt;/property&gt; &lt;property name="eventListeners"&gt; &lt;map&gt; &lt;entry key="merge"&gt; &lt;bean class="org.springframework.orm.hibernate3.support.IdTransferringMergeEventListener"/&gt; &lt;/entry&gt; &lt;/map&gt; &lt;/property&gt; &lt;/bean&gt;' &lt;bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager" p:sessionFactory-ref="sessionFactory"/&gt; </code></pre> <p>Here is the StackTrace of the exception:</p> <pre><code>[com.asg.tciclientadapters.webdav.servlet.CADPServlet] - org.hibernate.HibernateException: No Hibernate Session bound to thread, and configuration does not allow creation of non-transactional one here [com.asg.tciclientadapters.webdav.servlet.CADPServlet] - org.springframework.orm.hibernate3.SpringSessionContext.currentSession(SpringSessionContext.java:63) [com.asg.tciclientadapters.webdav.servlet.CADPServlet] - org.hibernate.impl.SessionFactoryImpl.getCurrentSession(SessionFactoryImpl.java:687) [com.asg.tciclientadapters.webdav.servlet.CADPServlet] - com.asg.tciclientadapters.webdav.dal.RetentionController.addDirectory(RetentionController.java:189) ... </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USGleb
    1. USGleb
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PO"No Hibernate Session bound to thread", transactional method breaks execution of the next transaction
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCan you add the relevant part of the stack trace showing that the exception originates from the addDirectory method, from the logs it is not evident that it is from the addDirectory method. The log is associated with the servlet.
      singulars
      1. PO"No Hibernate Session bound to thread", transactional method breaks execution of the next transaction
      1. USgkamal
    2. COI added StackTrace of the thrown exception - it is definitely 'addDirectory()'.
      singulars
      1. PO"No Hibernate Session bound to thread", transactional method breaks execution of the next transaction
      1. USGleb
    3. COCan you check if You are calling the addDirectory method on a object that is retreived from spring (context.getBean or @Autowired). From the logs it looks like the transaction proxy is being bypassed for the addDirectory call - one reason that can happen is that the object is not a spring bean. You can put a breakpoint and debug - check if the object is really a proxy, if yes why it is not starting a new transaction.
      singulars
      1. PO"No Hibernate Session bound to thread", transactional method breaks execution of the next transaction
      1. USgkamal
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload