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.
|