Re: Using java to move large objects/data over db link?

Ah, I see... create an explicit JDBC connection from java code running on "my" database to the remote database! I think that will work; I'll try it tomorrow.

Thanks again, Steve! BTW, the constraint arises mostly from the desire to use the connection pool to the local db that is easily available. We are also looking at the possibility of setting up a connection pool to the remote database, but this will probably work in the mean time.

atb
-Bill

Steve Howard wrote:

>
> Bill,
>
> I hope I am understanding what you want to do. Do you not have access
> to the remote database from your webapp server because of a firewall,
> or is it procedural? If it is procedural, then what is below may not
> help.
>
> You can get around what I think is still your problem by building your
> java code *inside* the database to which you have access. This java
> code, using Oracle's JVM in the database, would invoke the function in
> the remote database...
Received on Wed Sep 13 2006 - 16:28:08 CDT