5 Replies Latest reply on Jan 28, 2014 10:48 AM by Giovanni Dell'Amura

    Problem with xa-datasource & Global temporary table

    Giovanni Dell'Amura Newbie

      Hi all,

      sorry for my bad english.

      I have a problem with xa-datasource and Oracle "GTT". Jboss Eap  6.1. - Oracle 11g

      My GTT is configured with "on commit delete rows" and, when i do a transaction i have exception "ORA-08103: object no longer exists".

      If alter GTT with "on commit preserve rows" all work but i have duplicate rows in same session.

      The question is... why? i have search on documentation and google for two day but i haven't found any solution.

      Can you help me?

      Thanks anyway for this community, very very very useful.