CONSOLE:

reg=> 'select * from pg_prepared_xacts';

transaction |                                               gid                                                |           prepared            |    owner     |   database  
-------------+--------------------------------------------------------------------------------------------------+-------------------------------+--------------+--------------
    27361558 | 131077_AAAAAAAAAAAAAP//wKiWzJ0AwrFTsrrwAAAqwjE=_AAAAAAAAAAAAAP//wKiWzJ0AwrFTsrrwAAAqywAAAAAAAAAA | 2014-07-01 09:48:35.441639-04 | reg | reg

reg=> ROLLBACK PREPARED '131077_AAAAAAAAAAAAAP//wKiWzJ0AwrFTsrrwAAAqwjE=_AAAAAAAAAAAAAP//wKiWzJ0AwrFTsrrwAAAqywAAAAAAAAAA';
ROLLBACK PREPARED

reg=> select * from pg_prepared_xacts;
transaction | gid | prepared | owner | database
-------------+-----+----------+-------+----------
(0 rows)

JBoss XA configuration:

                    <xa-datasource jndi-name="java:/jdbc/RegDS" pool-name="RegDS" enabled="true">
                        <xa-datasource-property name="serverName">
                            localhost
                        </xa-datasource-property>
                        <xa-datasource-property name="databaseName">
                            reg
                        </xa-datasource-property>
                        <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
                        <driver>postgresql-9.3-1101.jdbc41.jar</driver>
                        <xa-pool>
                            <max-pool-size>50</max-pool-size>
                            <pad-xid>false</pad-xid>
                            <wrap-xa-resource>false</wrap-xa-resource>
                        </xa-pool>
                        <security>
                            <user-name>reg</user-name>
                            <password>reg</password>
                        </security>
                        <recovery>
                            <recover-credential>
                                <user-name>reg</user-name>
                                <password>reg</password>
                            </recover-credential>
                        </recovery>
                        <validation>
                            <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker"/>
                            <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter"/>
                        </validation>
                        <statement>
                            <share-prepared-statements>false</share-prepared-statements>
                        </statement>
                    </xa-datasource>

'reg' user has permissions to roll-back prepared transaction. I was able to rollback prepared transaction with 'reg' user from psql console.

Same credentials are provided in <security/> and <recovery/> configuration in <xa-datasource />.

How do we know that which connection pool is used by Periodic recovery thread triggered by JBoss every 2 min ? I also have more xa data-sources configured in same server.

Is it possible Periodic Recovery is using different credentials, of different XA data-source, and hence, its getting this error. Or is there some configuration mistake.

Yes found the problem, Recovery Thread is picking up wrong connection (credentials), or i may say its trying to ROLLBACK transactions found by

'SELECT gid FROM pg_prepared_xacts;', irrespective of owner. So it fails when it tries to roll-back transaction different user.

instead it should be

'SELECT gid FROM pg_prepared_xacts,where owner = current_user ?'

Found it from:

http://www.postgresql.org/message-id/CAJZ63LON9=EAzyyyhuUCTTp85AcxKGGMiXA9MpLb1gGZj0vs+w@mail.gmail.com

it may be a fix in postgres driver, as mentioned.