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.
Need more info.
(i) The driver you are using,
(ii) The application server you are using,
(iii) A stack trace.
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 9i DB