存储过程回滚问题

在一个事务里面调用存储过程。使用了三种方法编写事务，下面的一)和二)都不能回滚存储过程，只能回滚存储过程外的sql数据库操作。第三种方法才能回滚存储过程。

一）
@Transactional

二）org.springframework.transaction.support.TransactionTemplate
java代码

public void savePurchaseOrder(final PurchaseOrder purchaseOrder,final long changerId) {
		transactionTemplate.execute(new TransactionCallback() {			
				public Object doInTransaction(TransactionStatus ts)
				{
					try{
						long identity0=0;//父级id
						identity0=savePurchaseOrderSummary(purchaseOrder, changerId);
						for(int i=0;i<purchaseOrder.getPurchaseOrder_material_list().size();i++){
							long identity1=0;//父级id
							PurchaseOrder_material purchaseOrder_material=purchaseOrder.getPurchaseOrder_material_list().get(i);
							identity1=savePurchaseOrderMaterial(purchaseOrder_material,identity0);
							for(int j=0;j<purchaseOrder_material.getPurchaseOrder_material_colorNo_list().size();j++){
								long identity2=0;//父级id
								PurchaseOrder_material_colorNo purchaseOrder_material_colorNo=purchaseOrder_material.getPurchaseOrder_material_colorNo_list().get(j);
								identity2=savePurchaseOrderMaterialColorNo(purchaseOrder_material_colorNo,identity1);
								for(int k=0;k<purchaseOrder_material_colorNo.getPurchaseOrder_material_colorNo_yarnCount_list().size();k++){
									long identity3=0;
									PurchaseOrder_material_colorNo_yarnCount purchaseOrder_material_colorNo_yarnCount=purchaseOrder_material_colorNo.getPurchaseOrder_material_colorNo_yarnCount_list().get(k);
									identity3=savePurchaseOrderMaterialColorNoYarnCount(purchaseOrder_material_colorNo_yarnCount,identity2);
									//此处不做循环，不需要有返回值identity，可使用预处理
									savePurchaseOrderMaterialColorNoYarnCountClNoOrYrNoList(purchaseOrder_material_colorNo_yarnCount.getPurchaseOrder_material_colorNo_yarnCount_clNoOrYrNo_list());
								}
							}
						}
					}catch(Exception e){
						ts.setRollbackOnly();
					}
					return null;
				}
		});
	}

xml配置：

<bean id="yarnSpinningScheduleService" class="com.jjfz.fasys.service.impl.YarnSpinningScheduleServiceImpl">
		<property name="dao" ref="dao"/>
		<property name="transactionTemplate">
			<bean class="org.springframework.transaction.support.TransactionTemplate">
				<property name="transactionManager" ref="transactionManager"/>
			</bean>
		</property>
	</bean>

三）确保每个调用的Connection con是同一个，发生错误时，回滚。

@Transactional//必须有这句，下面才能回滚
	public void savePurchaseOrder(final PurchaseOrder purchaseOrder,final long changerId) {
		dao.getJdbcTemplate().execute(new ConnectionCallback() {			
				public Object doInConnection(Connection con)
				{
					try{
						long identity0=0;//父级id
						identity0=savePurchaseOrderSummary(con,purchaseOrder, changerId);
						for(int i=0;i<purchaseOrder.getPurchaseOrder_material_list().size();i++){
							long identity1=0;//父级id
							PurchaseOrder_material purchaseOrder_material=purchaseOrder.getPurchaseOrder_material_list().get(i);
							identity1=savePurchaseOrderMaterial(con,purchaseOrder_material,identity0);
							for(int j=0;j<purchaseOrder_material.getPurchaseOrder_material_colorNo_list().size();j++){
								long identity2=0;//父级id
								PurchaseOrder_material_colorNo purchaseOrder_material_colorNo=purchaseOrder_material.getPurchaseOrder_material_colorNo_list().get(j);
								identity2=savePurchaseOrderMaterialColorNo(purchaseOrder_material_colorNo,identity1);
								for(int k=0;k<purchaseOrder_material_colorNo.getPurchaseOrder_material_colorNo_yarnCount_list().size();k++){
									long identity3=0;
									PurchaseOrder_material_colorNo_yarnCount purchaseOrder_material_colorNo_yarnCount=purchaseOrder_material_colorNo.getPurchaseOrder_material_colorNo_yarnCount_list().get(k);
									identity3=savePurchaseOrderMaterialColorNoYarnCount(purchaseOrder_material_colorNo_yarnCount,identity2);
									//此处不做循环，不需要有返回值identity，可使用预处理
									savePurchaseOrderMaterialColorNoYarnCountClNoOrYrNoList(purchaseOrder_material_colorNo_yarnCount.getPurchaseOrder_material_colorNo_yarnCount_clNoOrYrNo_list());
								}
							}
						}
					}catch(Exception e){
						try {
							con.rollback();
						} catch (SQLException e1) {
							// TODO Auto-generated catch block
							e1.printStackTrace();
						}
					}
					return null;
				}
		});
	}