Thread: 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?
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.jarand the jdbc7.0-1.1.jarBoth doesn't seem to support the setAsciiStreamjdbc2 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?