Thread: JDBC - setAsciiStream - how to support?

JDBC - setAsciiStream - how to support?

From
"George Henry C. Daswani"
Date:
Hello,
 
    I've taken a look at the JDBC driver (from www.retep.org.uk) - tried the jdbc7.1-1.2.jar
and the jdbc7.0-1.1.jar
 
Both doesn't seem to support the setAsciiStream
jdbc2 PreparedStatement accessor..
 
I tried using setBytes instead under a transaction block (setAutoCommit(false)), ie..
 
ps.setBytes(9,this.description.trim().getBytes())
 
but an error shows up,
 
FastPath call returned ERROR: lo_write: invalid large obj descriptor (0);
 
Any ideas?

RE: JDBC - setAsciiStream - how to support?

From
Peter Mount
Date:
You must turn off AutoCommit before any large object call using setAutoCommit(false);
 
Peter

--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount@maidstone.gov.uk
WWW: http://www.maidstone.gov.uk
All views expressed within this email are not the views of Maidstone Borough Council

-----Original Message-----
From: George Henry C. Daswani [mailto:gdaswani@marketgroups.com]
Sent: Thursday, November 02, 2000 7:32 AM
To: pgsql-interfaces@postgresql.org
Subject: [INTERFACES] JDBC - setAsciiStream - how to support?

Hello,
 
    I've taken a look at the JDBC driver (from www.retep.org.uk) - tried the jdbc7.1-1.2.jar
and the jdbc7.0-1.1.jar
 
Both doesn't seem to support the setAsciiStream
jdbc2 PreparedStatement accessor..
 
I tried using setBytes instead under a transaction block (setAutoCommit(false)), ie..
 
ps.setBytes(9,this.description.trim().getBytes())
 
but an error shows up,
 
FastPath call returned ERROR: lo_write: invalid large obj descriptor (0);
 
Any ideas?