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

From: SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com>
To: General postgres mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Read a CLOB data from an Oracle table and INSERT it into a BYTEA column in Postgres using jdbc?
Date: 2009-03-30 20:10:44
Message-ID: 520691.57660.qm@web110712.mail.gq1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message MargaretGillon 2009-03-30 20:50:54 Schema for J2EE project
Previous Message Steve Crawford 2009-03-30 20:03:53 Re: Postgres startup processes on linux?