In addition to the standard jdbc api, oracle drivers provide properties, type, and performance extensions. I was experiencing the same problem here with a oracle 11g ora 24777. I have to connecto to an oracle 12c database from tomcat 6. This can result in a response of ora24777 use of non migratable. The transaction, which needs to be migratable between sessions, tried to access a remote database from a nonmultithreaded server process. Our connection pool on weblogic is setup using the xa jdbc driver. Ive performed a join between a single table in my schema and a view created by a database link. I made a servlet that create a connection to this datasource from metainfcontext. Use of nonmigratable database link not allowed using oracle xa datasource when executing a select via database. Mariadbs java driver also supports this workaround since v. It seems because of xa datasource i am facing this issue. We are calling some plsql stored procedures through jca adapters on the oracle service bus osb. Error on oracle while using dblink and xa transaction. I am using xa driver using oracle 9iwebsphere mq version 5.
Researching into this oracle provide the follwoing documentation. Error on oracle while using dblink and xa transaction ejb and. Using oracle wallets and seps with perl, jdbc, and odbc. Using jdbc, the universal connection pool ucp and the embedded jvm ojvm through technical articles, white papers, code samples, faqs and more. On restart or as part of the normal transaction processing, the driving data. My oracle support provides customers with access to over a million knowledge articles and a vibrant support community of peers and oracle experts. Also a discussion on whether to use certificates instead. Update the oracle jdbc driver to the latest version 12. 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.
Ora 24777 use of nonmigratable database link not allowed cause. No matching authentication protocol jdbc driver vendor name webmethods, inc. How to call a dblink over a xa datasource stack overflow. Cant select view via dblink with jpa object relational mapping. Connection pool, use the following driver for oracle databases.
325 489 101 761 521 278 326 1063 587 978 1470 1525 406 508 817 1172 1267 727 1006 700 310 1263 375 776 315 1591 916 39 906 247 415 825 327 709 53 307 1504 485 1086 1372 145 762 438 95