Error: Active Spring transaction synchronization required

[Vijay Vishwanath]

Hello all,

I'm getting this error when i try to write a clob to the DB.

Exception in thread "main" java.lang.IllegalStateException: Active Spring transaction synchronization or active JTA transaction with specified [javax.transaction.TransactionManager] required
at org.springframework.jdbc.support.lob.LobCreatorUtils.registerTransactionSynchronization(LobCreatorUtils.java:79)
at org.springframework.orm.hibernate3.support.AbstractLobType.nullSafeSet(AbstractLobType.java:185)
at org.hibernate.type.CustomType.nullSafeSet(CustomType.java:146)
at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1997)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2243)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.springframework.orm.hibernate3.HibernateAccessor.flushIfNecessary(HibernateAccessor.java:390)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:373)
at org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:686)
at bgc.sfe.dao.impl.SampleClobDAOImpl.saveSampleClob(SampleClobDAOImpl.java:25)
at bgc.sfe.service.impl.ClobManagerImpl.saveSampleClob(ClobManagerImpl.java:24)
at bgc.sfe.client.CategoryTest.main(CategoryTest.java:77)

The source and mapping files are:

package bgc.sfe.data;
 
public class SampleClob {
 
    private Integer clobID;
    
    private String clobNm;
    
    private String clobData;
 
    public SampleClob() {
    }
 
    public void setClobID(Integer clobID) {
        this.clobID = clobID;
    }
 
    public Integer getClobID() {
        return clobID;
    }
 
    public void setClobNm(String clobNm) {
        this.clobNm = clobNm;
    }
 
    public String getClobNm() {
        return clobNm;
    }
 
    public void setClobData(String cobData) {
        this.clobData = cobData;
    }
 
    public String getClobData() {
        return clobData;
    }
}
 

  
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="bgc.sfe.data.SampleClob" table="SAMPLE_CLOB">
<id column="CLOB_ID" name="clobID" type="java.lang.Integer">
<generator class="native" />
</id>
<property column="CLOB_NM" name="clobNm" type="java.lang.String"/>
<property column="CLOB_DATA" name="clobData" type="org.springframework.orm.hibernate3.support.ClobStringType"/>
</class>
         <query name="findClobByName">
            <![CDATA[from bgc.sfe.data.SampleClob clb WHERE clb.clobNm = ? ]]>
        </query>
</hibernate-mapping>
 

    
package bgc.sfe.dao.impl;
 
import bgc.sfe.dao.SampleClobDAO;
import bgc.sfe.data.SampleClob;
 
import java.util.List;
 
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
 
public class SampleClobDAOImpl extends HibernateDaoSupport implements SampleClobDAO {
    public SampleClobDAOImpl() {
    }
    
    public SampleClob getSampleClob(Integer clobID) {
        return (SampleClob) getHibernateTemplate().get(SampleClob.class,clobID);
    }
    
    public List getSampleClobByClobNm(String clobNm){
        Object params[] = {clobNm};
        
        return getHibernateTemplate().findByNamedQuery("findClobByName", params);
    }
    
    public void saveSampleClob(SampleClob sampleClob) {
        getHibernateTemplate().saveOrUpdate(sampleClob);
    }
}
 

    
package bgc.sfe.service.impl;
 
import bgc.sfe.dao.SampleClobDAO;
import bgc.sfe.data.SampleClob;
import bgc.sfe.service.ClobManager;
 
import java.util.List;
 
public class ClobManagerImpl implements ClobManager {
    SampleClobDAO clbDao = null;
    public ClobManagerImpl() {
    }
    
    public void setSampleClobDAO(SampleClobDAO clbDao) {
        this.clbDao = clbDao;
    }
    
   
    public SampleClob getSampleClob(Integer clobId) {
        return clbDao.getSampleClob(clobId);
    }
    
    public void saveSampleClob(SampleClob sClb) {
        clbDao.saveSampleClob(sClb);
    }
    
    public List getSampleClobsByName(String clobNm) {
        return clbDao.getSampleClobByClobNm(clobNm);
    }
}
 

    
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
    "http://www.springframework.org/dtd/spring-beans.dtd">
 
<beans>    
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName"><value>oracle.jdbc.driver.OracleDriver</value></property>
        <property name="url"><value>jdbc  :-o	  racle:thin:@localhost:1521  :mrgreen:  bname</value></property>
        <property name="username"><value>scott</value></property>
       <property name="password"><value>tiger</value></property>
    </bean>   
   
    <!-- Hibernate SessionFactory -->   
    <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">   
        <property name="dataSource"><ref local="dataSource"/></property>   
        <property name="mappingResources">   
            <list>   
                 <value>SampleClob.hbm.xml</value>
            </list>   
        </property>   
        <property name="hibernateProperties">   
        <props>   
            <prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop>   
            <prop key="hibernate.hbm2ddl.auto">update</prop>   
        </props>   
        </property>  
        <property name="lobHandler">
            <bean class="org.springframework.jdbc.support.lob.OracleLobHandler">
                <property name="nativeJdbcExtractor">
                    <bean class="org.springframework.jdbc.support.nativejdbc.WebSphereNativeJdbcExtractor"/>
                </property>
            </bean>
        </property>
    </bean>   
  
   <!-- Transaction manager for a single Hibernate SessionFactory (alternative to JTA) -->   
    <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">   
        <property name="sessionFactory"><ref local="sessionFactory"/></property>   
    </bean>   
   
    
    <bean id="sampleClobDAO" class="bgc.sfe.dao.impl.SampleClobDAOImpl">   
        <property name="sessionFactory"><ref local="sessionFactory"/></property>   
    </bean>
 
    <bean id="clobManagerTarget" class="bgc.sfe.service.impl.ClobManagerImpl">
        <property name="sampleClobDAO"><ref local="sampleClobDAO"/></property>
    </bean>    
 
    <bean id="clobManager" 
        class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
        <property name="transactionManager"><ref local="transactionManager"/></property>
        <property name="target"><ref local="clobManagerTarget"/></property>
        <property name="transactionAttributes">
            <props>
                <prop key="save*">PROPAGATION_REQUIRED</prop>
                <prop key="remove*">PROPAGATION_REQUIRED</prop>
                <prop key="change*">PROPAGATION_REQUIRED</prop>
                <prop key="*">PROPAGATION_REQUIRED,readOnly</prop>
            </props>
        </property>
    </bean>
    
</beans>  

    
package bgc.sfe.client;
 
 
import bgc.sfe.dao.SampleClobDAO;
import bgc.sfe.data.Category;
 
import bgc.sfe.data.CategoryProp;
 
import bgc.sfe.data.SampleClob;
 
import bgc.sfe.service.ClobManager;
 
import bgc.sfe.service.impl.ClobManagerImpl;
 
import java.io.StringWriter;
 
import java.util.Iterator;
import java.util.List;
import java.util.Set;
 
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.orm.hibernate3.support.ClobStringType;
 
public class CategoryTest {
  public static void main(String args[]){
      ApplicationContext ctx = null;  
      String[] paths = {"applicationContext.xml"};  
      ctx = new ClassPathXmlApplicationContext(paths);  
        
 
 
        SampleClobDAO clobDao = (SampleClobDAO)ctx.getBean("sampleClobDAO");
        System.out.println("Saving the clob");
        SampleClob clob = new SampleClob();
        //clob.setClobID();
        clob.setClobNm("THIRD");
        clob.setClobData("12345");
        
        ClobManager mgr = new ClobManagerImpl();
        mgr.setSampleClobDAO(clobDao);
        
        mgr.saveSampleClob(clob);
  }
}
 

Am I not giving some info in the applicationcontext.xml file.
Please help me resolve this problem.
Thanks in Advance.
[ July 23, 2007: Message edited by: Vijay Vishwanath ]

[Vijay Vishwanath]

I have removed the clob column from the mapping file and then
tried inserting the record with just two fields (id and name) and
it worked fine, i get the problem only when I try to
insert the clob into the DB.
Can anyone help me resolve this problem?
thanks in advance.