From gdaswani@marketgroups.com Thu Nov 2 07:29:56 2000 Received: from core.marketgroups.com (core.marketgroups.com [216.4.66.18]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA27Tul22399 for ; Thu, 2 Nov 2000 02:29:56 -0500 (EST) (envelope-from gdaswani@marketgroups.com) Received: from funks (1Cust227.tnt1.ontario2.ca.da.uu.net [63.24.0.227]) by core.marketgroups.com (8.11.0/8.11.0) with SMTP id eA27Tcv24496 for ; Wed, 1 Nov 2000 23:29:39 -0800 Message-ID: <002101c0449f$0f03f3e0$4b00a8c0@funks> From: "George Henry C. Daswani" To: Subject: JDBC - setAsciiStream - how to support? Date: Wed, 1 Nov 2000 23:32:29 -0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001E_01C0445C.001574A0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200011/28 X-Sequence-Number: 64 This is a multi-part message in MIME format. ------=_NextPart_000_001E_01C0445C.001574A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I've taken a look at the JDBC driver (from www.retep.org.uk) - tried th= e 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(fal= se)), 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? ------=_NextPart_000_001E_01C0445C.001574A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,
 
    I've taken a look at th= e JDBC=20 driver (from www.retep.org.uk) - tr= ied the=20 jdbc7.1-1.2.jar
and the jdbc7.0-1.1.jar
 
Both doesn't seem to support the=20 setAsciiStream
jdbc2 PreparedStatement accessor..<= /DIV>
 
I tried using setBytes instead under a tra= nsaction=20 block (setAutoCommit(false)), ie..
 
ps.setBytes(9,this.description.trim().getBytes())
 
but an error shows up,
 
FastPath call returned ERROR: lo_write: in= valid=20 large obj descriptor (0);
 
Any ideas?
------=_NextPart_000_001E_01C0445C.001574A0-- From petermount@maidstone.gov.uk Thu Nov 2 10:28:55 2000 Received: from anchor-post-30.mail.demon.net (anchor-post-30.mail.demon.net [194.217.242.88]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA2AStl28636 for ; Thu, 2 Nov 2000 05:28:55 -0500 (EST) (envelope-from petermount@maidstone.gov.uk) Received: from mailgate.maidstone.gov.uk ([194.159.6.98] helo=gatekeeper.maidstone.gov.uk) by anchor-post-30.mail.demon.net with esmtp (Exim 2.12 #1) id 13rHbq-000DPI-0U; Thu, 2 Nov 2000 10:28:38 +0000 Received: from exchange1.nt.maidstone.gov.uk (exchange1.maidstone.gov.uk [172.16.0.150]) by gatekeeper.maidstone.gov.uk (8.9.3/8.9.3) with ESMTP id KAA16564; Thu, 2 Nov 2000 10:28:37 GMT Received: by exchange1.nt.maidstone.gov.uk with Internet Mail Service (5.5.2650.21) id ; Thu, 2 Nov 2000 10:25:52 -0000 Message-ID: <1B3D5E532D18D311861A00600865478CF1B4C2@exchange1.nt.maidstone.gov.uk> From: Peter Mount To: "'George Henry C. Daswani'" , pgsql-interfaces@postgresql.org Subject: RE: JDBC - setAsciiStream - how to support? Date: Thu, 2 Nov 2000 10:25:51 -0000 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C044B7.46794330" X-Archive-Number: 200011/35 X-Sequence-Number: 71 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C044B7.46794330 Content-Type: text/plain; charset="iso-8859-1" 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? ------_=_NextPart_001_01C044B7.46794330 Content-Type: text/html; charset="iso-8859-1"
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?
------_=_NextPart_001_01C044B7.46794330--