0 Replies Latest reply on Nov 13, 2003 3:13 PM by Naveeen JP

    Distributed tx accessing different schemas

    Naveeen JP Newbie

      Hi, i have a transaction accessing 2 different
      datasources each of which access different schemas
      but on the same database server. First part of the
      transaction uses a CMP to create a bean and
      another part uses a connection object and creates
      an entry in another table(in a dfferent schema)
      that references the 1st bean created. The 2nd insert
      fails for a parent key violation thought both the inserts are part of the same transaction. I am using
      Oracle. I have setup the xa datasource as required.
      Am I missing something or cant JBoss handle this.