Read a CLOB data from an Oracle table and INSERT it into a BYTEA column in Postgres using jdbc?

Started by SHARMILA JOTHIRAJAHabout 17 years ago2 messagesgeneral
Jump to latest
#1SHARMILA JOTHIRAJAH
sharmi_jo@yahoo.com

Hi,
Im reading from an Oracle table and inserting the values to a postgres table thro' jdbc. Everything works fine except for the BLOB data in Oracle.

My code snippet ...

while (rs1.next())
{
for (int m=1;m<=colCount;m++)
{
pstmt.setObject(m, rs1.getObject(m));
}
pstmt.executeUpdate();
connection2.commit();
System.out.println("DONE");
}

This inserts the data into teh postgres table but gives this error for a BLOB datatype....
Exception in thread "main" org.postgresql.util.PSQLException: ERROR: column "columnXXX" is of type bytea but expression is of type bigint

Any thoughts?

Thanks
Sharmila

In reply to: SHARMILA JOTHIRAJAH (#1)
Re: Read a CLOB data from an Oracle table and INSERT it into a BYTEA column in Postgres using jdbc?

You are fetching an Oracle LOB locator. I am not a guru of OCI let alone
JDBC but AFAIK you should create a LOB descriptor, bind it to the locator
and load the LOB data that you can insert into postgres.