Hi All,

I'm having below code in applicationContext.xml(spring) file.

<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="mySessionFactory"/>
<property name="dataSource" ref="dataSource"/>
</bean>

<bean id="eventManagerService" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager"><ref local="transactionManager"/></property>
<property name="target"><ref local="eventManagerDAOTarget"/></property>
<property name="transactionAttributes">
<props>
<prop key="save">PROPAGATION_REQUIRED</prop>
</props>
</property>
</bean>
In this configuration, when I try to access 'save' method I'm getting below error message. If I comment <prop key="save">PROPAGATION_REQUIRED</prop> this line then it is working fine.

14:16:21,760 WARN JDBCExceptionReporter:77 - SQL Error: 0, SQLState: HY000
14:16:21,760 ERROR JDBCExceptionReporter:78 - [BEA][Sybase JDBC Driver]No rows affected.
<Apr 24, 2008 2:16:22 PM EDT> <Error> <HTTP> <BEA-101017> <[weblogic.servlet.internal.WebAppServletContext@1e2d16b - appName: '_appsdir_spring_war', name: 'spring.war', context-path: '/spring'] Root cause of ServletException.
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [events.EventManager]; uncategorized SQLException for SQL [insert into EVENTS (EVENT_DATE, title, TEST_DATE)
values (?, ?, ?)]; SQL state [HY000]; error code [0]; [BEA][Sybase JDBC Driver]No rows affected.; nested exception is java.sql.SQLException: [BEA][Sybase JDBC Driver]No rows affected.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:124)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:379)
Truncated. see log file for complete stacktrace
java.sql.SQLException: [BEA][Sybase JDBC Driver]No rows affected.
at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
at weblogic.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at weblogic.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:128)
Truncated. see log file for complete stacktrace

I even tried with Jta transation still I'm getting same error.

Thanks in advance.

Regards,
Sharath.