Re: java.sql.SQLException: ORA-24777: use of non-migratable database link not allowed

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_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l