I've started some work using Oracle Java Stored procedures. The Java SP's
use ADBC to connect to the 3000.
I have three scenarios.
1. Batch.
My java stored procedure copies the contents of a table from the 3000 to
my oracle database. The client then accesses the Oracle data.
2. Single table SQL.
I can use the initateRead with a column and value to replicate a single
table select.
3. Multi table joins.
I think I can do this by pulling the tables via java but I need a way of
passing
those to PL/SQL at the Oracle level so I can do the SQL join there. I
don't want to write the data to Oracle, I need to return the 'resultset'
to a client and performance is the big issue.
I've yet to find a fast way of doing number there and a datatype to pass
turbo image to an oracle in memory table.
Has anyone done any work around this topic? I'm avoiding the ODBC route as
the ADBC performance is much better.
Many thanks
Nick Southwell
**********
Posted from www.3kworld.com