Does the connection owner (the on in the XA datasource config file) have permission to up access the ORACLE tables (dba_pending_transactions exct). You can find the relevent permissions you will need in the transactions administration guide.
Thanks for your answers. But you did not get my questions.
That error is popping up only after the network cable is unplugged.
I am expecting the oracle recovery module can detect the cached connection is bad and auto recovery to use an new one.
BTW, my user has all the needed permission here:
GRANT SELECT ON SYS.dba_pending_transactions TO <user>; GRANT SELECT ON SYS.pending_trans$ TO <user>; GRANT SELECT ON SYS.dba_2pc_pending TO <user>; GRANT EXECUTE ON SYS.dbms_system TO <user>;
> I am expecting the oracle recovery module can detect the cached connection is bad and auto recovery to use an new one.
It relies on the connection being reported as bad - that's what the ConnectionEventListener is for. Looks like the Oracle driver doesn't do that though. Just subclass the existing implementation and add explicit connection validation if you want that feature.
Did you intend to fix this in next release?
Thanks for your reply in advance.