A non xa transaction always involves just one resource. But if you try to run the same query directly on db with out using any java or xa transaction it will work fine. This is not allowed and this is documented in following entry. Please make sure the db link you are using is public and shared, if the db link is not public and shared it will throw an exception ora 24777. Developing applications with oracle xa stanford university. This chapter describes how to use the oracle xa library. We are using dblink through unixtoodbc driver to get postgres data on oracle db. Everything was great until we called a stored procedure that queries across a database link. I am using xa driver using oracle 9iwebsphere mq version 5. Hi all, we are facing problem while implementing distributed transaction using oracle xa thin driver. The app has an area which invokes a plsql proc which in turn calls a proc in another oracle database also v10. Ora 24777 reported when using a database link from within an xa coordinated transaction doc id 1506756. Then we got the dreaded ora24777 use of nonmigratable database link not allowed. Microsoft oracle odbc driver and oracle 8 currently, the microsoft oracle odbc driver msorcl32.
Use of nonmigratable database link not allowed using oracle xa datasource when executing a select via database. This function used a private database link to insert data in a local table. Authenticated by jim identified by jimspass23 using db01. This cannot be overridden by application developers. Weblogic server ships with the oracle thin driver version 10g preconfigured and ready to use. We are calling some plsql stored procedures through jca adapters on the oracle service bus osb. Ora24777 reported when using a database link from within. Ora 24777 reported by a jdbc xa application when utilising a database link between two oracle databases. On restart or as part of the normal transaction processing, the driving data source can then. Use materialized views or a separate entitymanager which directly points at the other db instead. When you use xa transactions together with microsoft distributed. Enterprise resource planning erp merupakan sebuah kesatuan sistem yang terintegrasi baik informasi internal maupun eksternal yang meliputi keseluruhan organisasi perusahaan, mulai dari sistem keuangan financial, pemasaran, penjualan dan dsitribusi sales and distribution, manajemen transportasi, material management, production planning, plant maintenance, project system, human.
This problem shows up when i make a query to a different database instance connected via dblink. Aug 04, 2010 we are calling some plsql stored procedures through jca adapters on the oracle service bus osb. Ora24777 when using xa driver heres something we came across this past week, and after some searching, it appears to be a fairly common issue. Configuration, connection pool, use the following driver for oracle databases. Developing applications with oracle xa oracle help center.
We have the same problem with weblogic, and the solution is to utilize the non xa oracle jdbc driver. Heres something we came across this past week, and after some searching, it appears to be a fairly common issue. Understanding xa transactions sql server microsoft docs. Ora 24777 use of nonmigratable database link not allowed ora 24778 cannot open connections ora 24779 detach not allowed with open remote cursor ora 24780 cannot recover a transaction while in an existing transaction ora 24781 branches dont belong to the same global transaction ora 24782 cannot detach from a nonmigratable transaction ora 24783. Note all the version numbers that are listed in this article were current at the time that the article was written. For more information about these steps, see the set up oracle support section. Difference between xa and nonxa datasource and limitations with nonxa an xa transaction, in the most general terms, is a global transaction that may span multiple resources.
For some reason the btmconfig in the applicationcontext. Distributed transaction error and binding exception. Ora0054 resource busy and acquire with nowait specified 2. Fix error ora24777 use of nonmigratable database link not. Even the above stored procedure generates a ora 24777. What we did is created a db datasource of xa type and tried to call the stored proc but it was giving a problem ora24777. Oracle database error messages3 just solve the file format. How to call a dblink over a xa datasource stack overflow. Pastikan bahwa anda telah mengaktifkan dukungan oracle xa. This chapter explains how to use the oracle xa library. Contact oracle for information about the recommended configuration to use this feature, the required updates, and any related issues. Now i moved my application to production enviroument and there the source database is oracle 11 while the destination database remine 8. This feature requires the use of the oracle odbc driver. Ora24777 reported when using a database link from within an.
Another transaction can use the connection, provided the user who created the connection is the same as the user who owns the transaction. Use of nonmigratable database link not allowed when called from a windows service. We strongly recommend that you use the most current versions and updates. Fix error ora24777 use of nonmigratable database link.
Error on oracle while using dblink and xa transaction. Only one of my clientusing xa transaction is getting error ora. The oracle xa library subroutines allow a tm to instruct an oracle8 server what to do about transactions. Ora24777 reported when using a database link from within an xa coordinated transaction doc id 1506756. Error on oracle while using dblink and xa transaction ejb. If you want to update the driver or use a different version, see using oracle extensions with the oracle thin driver in programming jdbc for oracle weblogic server the following sections provide information for using the oracle thin xa driver with weblogic server. Difference between xa and nonxa datasource blogger. Membuat odbc data sumber nama dsn yang merujuk ke oracle database. The xa features are most useful in applications in which transactions interact with multiple databases. Enterprise application deployed on weblogic server 9.
An ora24777 is a warning that you are trying to utilise a database link within an xa coordinated transaction and the connection to the source database which is trying to use the database link has been made through a dedicated server connection. Using oracle databases with microsoft transaction server version 2. To use the net8 string without actually accessing a remote database, use the pipe driver. Jun 14, 2006 does someone know how to resolve this. Enterprise resource planning erp merupakan sebuah kesatuan sistem yang terintegrasi baik informasi internal maupun eksternal yang meliputi keseluruhan organisasi perusahaan, mulai dari sistem keuangan financial, pemasaran, penjualan dan dsitribusi sales and distribution, manajemen transportasi, material management, production planning, plant maintenance, project system, human resources. Then when you access the database b through a database link, you receive an ora24777 error. Oraclexadatasource driver and it tests ok in the console. I have a spring based web app deployed on weblogic 10. Error on oracle while using dblink and xa transaction ejb and. Our connection pool on weblogic is setup using the xa jdbc driver.
Pastikan bahwa anda dsn menggunakan microsoft oracle odbc driver. Xa sessions must be migratable and so 8162 1103036 must use mts for dblinks. Using xa and the oracle database from the middle tier xa and oracle weblogic server fusion middleware 11gr1 oracle weblogic server implements tightly coupled xa transactions via the oracle jdbc driver using the standard jta jdbc xaresource interface. Dec 24, 20 difference between xa and nonxa datasource an xa transaction, in the most general terms, is a global transaction that may span multiple resources. An ora24777 is a warning that you are trying to utilise a database link within an xa coordinated transaction and the connection to the source database which is trying to use the database link has been made through a dedicated.
However when called from a console app or directly via sql developer, it works fine. A bpel process used an xa datasource with global transaction. A nonxa transaction always involves just one resource. Hello, im using atomikos xa transaction with oracle 10 g database. Please make sure the db link you are using is public and shared, if the db link is not public and shared it will throw an exception ora24777. The microsoft jdbc driver for sql server provides support for java. This can result in a response of ora24777 use of nonmigratable. The xa features are most useful in applications in which transactions interact with more than one database. Xa transactions use migratable open connections so that the connections are cached after a transaction is committed. I have a feeling the issue lies somewhere with the type of session oracle is making for the windows service.
1290 766 594 408 579 84 1341 937 1065 365 253 1480 442 596 991 702 5 1491 434 507 38 308 1396 812 293 861 1238 1289 1193