hibernate a createSQLQuery

[Ivan Polák]

tak si aj sam odpoviem, snad to niekomu pomoze:

treba nastavit transakcny mechanizmus pomocou AOP nasledovne:

<tx:advice id="txAdvice" transaction-manager="txManager">
      <tx:attributes>
            <tx:method name="get*" read-only="true" propagation="NEVER"/>
            <tx:method name="find*" read-only="true" propagation="NEVER"/>
            <tx:method name="save*" rollback-for="Exception"/>
            <tx:method name="update*" rollback-for="Exception"/>
            <tx:method name="delete*" rollback-for="Exception"/>
            <tx:method name="*"/>
      </tx:attributes>
  </tx:advice>
 
  <tx:annotation-driven transaction-manager="txManager"/>
 
  <aop:config>
          <aop:pointcut id="serviceOperation" expression="execution(* 
com.*.service.impl.*..*ManagerImpl.*(..))"/>
          <aop:advisor advice-ref="txAdvice" 
pointcut-ref="serviceOperation"/>
  </aop:config>

  <bean id="txManager" 
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
          <property name="dataSource" ref="dataSource"/>
  </bean>

Ivan

Info  wrote / napísal(a):
> zdravim konferenciu,
>
> pouzivam Hibernate a Spring. potrebujem vykonat jeden update nad DB mimo
> klasickeho pristupu Hibernate pomocou prikazu createSQLQuery:
>
> public void updateZdroj(final Long id) {
>
> final HibernateCallback callback = new HibernateCallback() {
>     	    public Object doInHibernate(final Session session) throws
> HibernateException {
>     	    	session.beginTransaction();
>     	    	int result = session.createSQLQuery("update zdroj set hodnota =
> hodnota + 1 where id = " + id).executeUpdate();
>     	    	session.getTransaction().commit();
>     	    	return result;
>     	    }
>     	  };
>     	  getHibernateTemplate().execute(callback);
> }
>
> tento kod je v triede ZdrojDaoHibernate (implements ZrojDao).
>
> skusal som aj dat
> @Transactional (propagation=Propagation.REQUIRED)
> public interface ZdrojDao extends GenericDao<Carrier, Long> {
>
> aj konktrentne nad funkciu updateZdroj:
> @Transactional (readOnly=false)
> void updateZdroj(Long id);
>
> a skusal som aj dat parameter Hibernate:
>
> <prop key="hibernate.current_session_context_class">thread</prop>
>
> bohuzial nic nepomohlo chyba je vzdy nasledovna:
>
> org.hibernate.HibernateException: No Hibernate Session bound to thread, and
> configuration does not allow creation of non-transactional one here
> 	org.springframework.orm.hibernate3.SpringSessionContext.currentSession(SpringSessionContext.java:63)
> 	org.hibernate.impl.SessionFactoryImpl.getCurrentSession(SessionFactoryImpl.java:574)
>
>
> nepoznate niekto presny postup ako pouzivat createSQLQuery?
>
> dakujem
>
> Ivan
>
> ________________________________________________
> Message sent using Webmail 2.7.9
>
>
>