Re: Question about efficient ways to pass data from java to oracle

the Rat wrote:
> Hello all,
>
> I'm looking for an efficient way to pass data from java 1.3 (and
> above) to oracle 8.0 (and above).
>
> I've tried 2 mechanisms already but I'm not really happy with the
> performance of either:
> 1. Obtain an OracleConnection to oracle from
> DriverManager.getConnection() and then convert an array of java
> objects into an array of structs and pass the array of structs to a
> stored procedure. I found this to be very slow.
> 2. Obtain a connection to oracle from an application server's
> connection pool. Then create a batch update command. I found this
> solution to be about 20% faster than solution #1 above - and I like it
> better because it's getting the connection from an appServer's
> connection pool instead of through the DriverManager class.
>
> Still, is there a faster way? In the end, all I want to do is update
> a number of rows in a table. I can do that through a batch update or
> by calling a stored procedure or by...? Is there a way to get a
> connection (not an OracleConnection) from an appServer's connection
> pool and then use it to pass an array of ints to a stored procedure?

Difficult to tell without further knowledge. You don't even convey where the slowness comes from. Is it from the connection handling? Are inserts slow? Does your DB have slow IO subsystem or is just too busy? How slow is slow? Tons of questions and possible causes...

Kind regards

    robert Received on Tue Dec 13 2005 - 07:57:06 CST