A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
EJB and other Java EE Technologies
Error on Oracle while using DBLINK and XA transaction
Joined: Dec 23, 2010
Mar 31, 2011 01:58:09
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
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:
: ORA-01012: not logged on
ORA-02063: preceding line from TO_VANTIVE
Thanks for your help,
I agree. Here's the link:
subject: Error on Oracle while using DBLINK and XA transaction
problem with XA driver
XA vs non-XA
Could not create connection; - nested throwable:
Cant select VIEW via dblink with JPA
ORA-24777: use of non-migratable database link not allowed
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013