Help!! on displaying LONG RAW datatype from JDBC on Oracle

I need to display a LONG RAW datatype from Oracle into

a JTable.I have used getBinaryStream method in the resultSet class. After some coversions, I got some 'garbages' and some characters. It looks like my code could not convert them 100% correctly.

Here is segment of my test code:

char [] buf = char[8196];

java.io.InputStream in = null;

.......

ResultSet rs = stmt.executeQuery(

"select longraw_col from myTable");

......

while (rs.next()) {

Vector row = new Vector();

for (i=1; i<=Totcolumns; i++)

in = rs.getBinaryStream(i);

BufferedReader inB = new BufferedReader

((new InputStreamReader(in)), 4096);

inB.read(buf, 0, 4096);

String strbuf = new String(buf);

row.add(strbuf);

Data.add(row);

}

table = new JTable(Data, ColumnNames);

table.setPreferredScrollableViewportSize(new Dimension(500, 70));

Can anyone help? Greatly appreciate it.

[1013 byte] By [adu2000] at [2007-9-26 9:14:29]
# 1
Hia dirty way round it might be to change your SQL statement to "select rawtochar(longraw_col) from myTable".I'm sure there is sth like rawtochar in Oracle.HTHPhil
PhHein at 2007-7-1 20:26:15 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...