pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

JDBC - setAsciiStream - how to support?
2+ messages / 2 participants
[nested] [flat]

* JDBC - setAsciiStream - how to support?
@ 2000-11-02 07:32 George Henry C. Daswani <gdaswani@marketgroups.com>
  0 siblings, 0 replies; 2+ messages in thread

From: George Henry C. Daswani @ 2000-11-02 07:32 UTC (permalink / raw)
  To: pgsql-interfaces

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?

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* RE: JDBC - setAsciiStream - how to support?
@ 2000-11-02 10:25 Peter Mount <petermount@maidstone.gov.uk>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Mount @ 2000-11-02 10:25 UTC (permalink / raw)
  To: 'George Henry C. Daswani' <gdaswani@marketgroups.com>; pgsql-interfaces

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 <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
<http://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?

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2000-11-02 10:25 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-11-02 07:32 JDBC - setAsciiStream - how to support? George Henry C. Daswani <gdaswani@marketgroups.com>
2000-11-02 10:25 RE: JDBC - setAsciiStream - how to support? Peter Mount <petermount@maidstone.gov.uk>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox