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,