GeeCON Prague 2014*
The moose likes EJB and other Java EE Technologies and the fly likes Error on Oracle while using DBLINK and XA transaction Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Error on Oracle while using DBLINK and XA transaction" Watch "Error on Oracle while using DBLINK and XA transaction" New topic
Author

Error on Oracle while using DBLINK and XA transaction

ray frid
Ranch Hand

Joined: Dec 23, 2010
Posts: 79
Hi all. I am Using jboss5.1.x, EJB3.0 ,JPA3

I am trying to do 'select' query from view which is connected via dblink to another database.

source databse is oracle 9 destination dabatase is oracle 8.

I am getting this error:

15:27:06,625 WARN [JDBCExceptionReporter] SQL Error: 24777, SQLState: 99999

15:27:06,625 ERROR [JDBCExceptionReporter] ORA-24777: use of non-migratable database link not allowed

I found solution to this error after I understood that I cant use dblink while using XA. So I managed to solved by changing the dblink script to create shared database link as follow:

CREATE SHARED DATABASE LINK CONNECT TO IDENTIFIED BY AUTHENTICATED BY IDENTIFIED BY USING
everything worked fine in this test enviroument.

Now I moved my application to production enviroument and there the source database is Oracle 11 while the destination database remine 8.

the trick that I used didnt work this time and I couldnt find solution. this is the new exception I am getting:

Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
at ....Caused by: java.sql.SQLException: ORA-01012: not logged on
ORA-02063: preceding line from TO_VANTIVE

Thanks for your help,

ray,
 
GeeCON Prague 2014
 
subject: Error on Oracle while using DBLINK and XA transaction