java.lang.IllegalStateException: No recoveryService set yet! 错误解决

oracle分布式事务开启配置
由于要将超级用户下的表授权给普通用户使用，用户很谨慎的考虑到可能会对同一个数据库的其他用户和业务产生影响

grant select on sys.dba_pending_transactions to mtsbwtst;
grant select on sys.pending_trans$ to mtsbwtst;
grant select on sys.dba_2pc_pending to mtsbwtst;
grant execute on sys.dbms_system to mtsbwtst;

grant select on sys.dba_pending_transactions to mtsbw;
grant select on sys.pending_trans$ to mtsbw;
grant select on sys.dba_2pc_pending to mtsbw;
grant execute on sys.dbms_system to mtsbw;


需要执行以下四个脚本:
$ORACLE_HOME/rdbms/admin/initxa.sql            
$ORACLE_HOME/rdbms/admin/xaview.sql            
$ORACLE_HOME/javavm/install/initjvm.sql            
$ORACLE_HOME/javavm/install/initxa.sql




以SYSDBA登录SQL Plus

执行如下代码

Sql代码 


Java代码 

grant select on sys.dba_pending_transactions to  username;      
grant select on sys.pending_trans$ to username;      
grant select on sys.dba_2pc_pending to username;      
grant execute on sys.dbms_system to username;     
  
grant select on sys.dba_pending_transactions to  username;   
grant select on sys.pending_trans$ to username;   
grant select on sys.dba_2pc_pending to username;  

grant select on sys.dba_pending_transactions to  username;   
grant select on sys.pending_trans$ to username;   
grant select on sys.dba_2pc_pending to username;   
grant execute on sys.dbms_system to username;  

grant select on sys.dba_pending_transactions to  username;
grant select on sys.pending_trans$ to username;
grant select on sys.dba_2pc_pending to username;
grant execute on sys.dbms_system to username;

username ==> 获取oracle XA数据库连接的用户


参考：http://364434006.iteye.com/blog/981819