Re: java.sql.SQLException: ORA-24777: use of non-migratable database link not allowed
- From: "Finn Jorgensen" <finn.oracledba@xxxxxxxxx>
- To: p4cldba@xxxxxxxxx
- Date: Mon, 10 Dec 2007 20:35:52 -0500
I think this is because this is an XA transaction. You need to configure MTS
in order for your JBOSS connection to work. It works locally, but not
through JBOSS.
There are many references to this on Metalink.
Finn
On Dec 10, 2007 6:52 PM, Prasad <p4cldba@xxxxxxxxx> wrote:
> All,
>
>
> when I try to update or insert a remote db from sqlplus with db link it
> works fine . but the web application which runs on the JBOSS server it
> complains
>
> java.sql.SQLException: ORA-24777: use of non-migratable database link not
> allowed
> ORA-06512: at "ACTIONLIST.TRG_PRODUCT_ACTIONLIST", line 39
> ORA-04088: error during execution of trigger '
> ACTIONLIST.TRG_PRODUCT_ACTIONLIST'
>
> at oracle.jdbc.dbaccess.DBError.throwSqlException (DBError.java:134)
>
> Appreciate any idea.
>
> Thanks
> -Prasad
>
Other related posts:
