What driver are you using? I've heard that the Oracle thin driver
has performance issues with long data and that the oci driver
is a lot faster.
-Dennis
David Oldroyd wrote:
>
> need to copy the value of an Oracle long column from one table to
> another. I have been able to accomplish this by querying the source
> table and using the result set
>
> String temporaryLong = rs.getString(1)
>
> to store the value into a string.
>
> To put the value into the destination I create a String Reader on my
> string
>
> StringReader str = new StringReader(temporaryLong);
>
> dstStmt.setCharacterStream(1, str, temporaryLong.length());
>
> and send it via a character stream.
>
> On big long columns storing the long as a string takes up an awful lot
> of memory and is fairly slow. Is there a way to take the character
> stream from the result set of the source table and feed it directly to
> the character stream of the destination?
>
> Here is the actual snippet of code:
> srcStmt = conn.prepareStatement(
> " SELECT "+longColumn+", "+pkColumn
> + " FROM " + srcTable + " src"
> + " WHERE src."+pkColumn+" = TO_NUMBER(?)");
>
> srcStmt.setString(1,pkValue);
> srcResult = srcStmt.executeQuery();
>
> if (srcResult.next()) {
> temporaryLong = srcResult.getString(1);
> if (srcResult.wasNull()) {
> temporaryLong="";
> }
> dstStmt = conn.prepareStatement(
> " INSERT INTO " + dstTable
> + " (" + longColumn + "," + pkColumn + ")"
> + " VALUES(?, TO_NUMBER(?))");
>
> StringReader str = new StringReader(temporaryLong);
>
> dstStmt.setCharacterStream(1, str, temporaryLong.length());
> dstStmt.setString(2, pkValue);
>
> result = dstStmt.executeUpdate();
> dstStmt.close();
>
> Thanks,
>
> Dave
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, more
> http://taxes.yahoo.com/
>
> ---
> You are currently subscribed to jdjlist as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to [EMAIL PROTECTED]
> http://www.sys-con.com/fusetalk
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Dennis DiMaria The American Institute of Physics
[EMAIL PROTECTED] Suite 1NO1
2 Huntington Quadrangle
516-576-2319 Melville NY, 11747-4502
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
---
You are currently subscribed to jdjlist as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
http://www.sys-con.com/fusetalk
