transaction

root-context.xml

<!-- 트랜잭션 처리 -->
	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource"></property>
	</bean>

 

servlet-context.xml

	<tx:advice id="txAdvice" transaction-manager="transactionManager">
		<tx:attributes>
			<tx:method name="*"/>
		</tx:attributes>
	</tx:advice>
	
	<aop:config>
		<aop:pointcut id="transactionPointcut"
			expression="execution(* com.naver.myhome5..*Impl.*Reply(..))"/>
		<aop:advisor advice-ref="txAdvice" pointcut-ref="transactionPointcut"/>
	</aop:config>

log4j.xml

	<root>
		<priority value="debug" />
		<appender-ref ref="console" />
	</root>

~ServiceImpl.java (에러 내는 곳)

double e= 1/0;

결과(sql처리를 2개를 하는데 1개 실행 후 에러가 나서 롤백을 시킴)

 

----------------------------------------annotation으로 깔끔하게 처리 가능--------------------------

servlet-context.xml

<tx:annotation-driven transaction-manager="transactionManager"/>

~ServiceImpl.java(에러 내는 곳)

@Override
	@Transactional
	public int boardReply(Board board) {
		boardReplyUpdate(board);
		double e= 1/0;
		board.setBOARD_RE_LEV(board.getBOARD_RE_LEV()+1);
		board.setBOARD_RE_SEQ(board.getBOARD_RE_SEQ()+1);
		return dao.boardReply(board);
	}