Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can a Java Stored Procedure in one database instance open a connection to another database instance?

April 26, 2017connection database instance Java procedure stored

0

Posted

Can a Java Stored Procedure in one database instance open a connection to another database instance?

1 Answer

0

Posted

Yes, using the Thin-server driver. This has been supported since 8.1.6sdk.The only known workaround at this time is to configure the first installation to use DBLINKS when contacting the second installation. This fakes the jdbc drivers into thinking that its still working in the same one instance, and relies on DBLINKS to take care of the details. However, there are rumored to be problems with using DBLINKS on an MTS server installation.