Distributed database in Oracle9i for Oracle Data base !

Discussions

EJB programming & troubleshooting: Distributed database in Oracle9i for Oracle Data base !

  1. Hi all,
      i got stuck here with distributed database problem !

    I have an stateless EJB am getting 2 different connection from 2 different datasource and inserting a record in each table. I am using Container managed transaction. When teh method execution completes transaction manager try to commin using two phase commmit am getting error !
    Please can any one help me out who has really worked on distributed database !

    Softwares used : Oracle9iAS,Oracle 9.0.1 dtabase !


    eagerly waiting for your reply.
  2. Need more info.

    (i) The driver you are using,
    (ii) The application server you are using,
    (iii) A stack trace.

    David
  3. Hi,

    we have 2 oracle databases.
    I am using Stateless EJB and container managed transaction !
    And inside a ejb method i am getting 2 different connection from 2 different datasources ok !
    Since am using container managed transaction it starts transaction automatically when the method begins,
    and the transaction ends when the method exit out ok !
    Now i insert into 2 databases and when the method exits it gives an error listed below !

    i am using NON emulated datasource with class name "com.evermindsql.DriverManagerDataSource"
    and looking up this datasource in the EJB with name specified in location attribute of datasource !


    "com.evermind.server.rmi.OrionRemoteExcepttion: Transaction was rolled back: javax.transaction.SystemException: could not commit: error code 29540- for additional error code check the oracle log file"

    For distributed database we configured DBLINK also !
    If u can give more info regarding DBlink it will be better ! Even after we set DBlink we are getting error !
    Please tell us how to configure the database !

    Oracle 9iAS
    Oracle 9i DB



    regards
    Sreenath.V