Atomikos Forum

mysql  run  procedure  with error  but  no rollback

When I consolidate multiple data sources, one data source involves the operation of a stored procedure, when I for transaction control, when an error occurs within a stored procedure, the stored procedure will break but will not be rolled back, I do not know why?
Spring transaction code is as follows:

@Transactional(readOnly = false,rollbackForClassName={"RuntimeException","Exception"})
    public void registerUser(Map<String, String> params) throws CassideException{
        String username = (String)params.get("username");    
        if(existUser(username)){
             throw  new UserValidationException();
        }        
        ssoJDBC.registerUser(params);
        discuzJDBC.registerUser(params);
        tshopJDBC.registerUser(params);
    }
MySQL environment:
Server version: 5.5.22 MySQL Community Server (GPL)
zhairz Send private email
Wednesday, August 15, 2012
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics