[jdjlist] =?windows-1252?Q?AW=3A_=C4jdjlist=DC_Copy_an_Oracle_Long_Colum?==?windows-1252?Q?n?=

[Tan Chao Ying]

Hallo David,
you can use following : 
"INSERT INTO " + dstTable + 
" SELECT "+longColumn+", "+pkColumn
+ " FROM " + srcTable + " src"
+ " WHERE src."+pkColumn+" = TO_NUMBER(?)");

Then you don't need to fetch the values, just let the database do the job.

Chao Ying


-----Urspr�ngliche Nachricht-----
Von: David Oldroyd [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 20. Februar 2003 16:57
An: jdjlist
Betreff: �jdjlist� Copy an Oracle Long Column


 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

---
You are currently subscribed to jdjlist as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
http://www.sys-con.com/fusetalk