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

You can generalize Steve's approach to non-Oravle databases as well.

See a working example of JDBC-Callout to SQL Server from within an Oracle database
in my book @
http://db360.blogspot.com/2006/08/oracle-database-programming-using-java_01.html

Kuassi

sporb wrote:
> 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 - 18:53:22 CDT