Skip site navigation (1) Skip section navigation (2)

BUG #3278: PSQLException when using setBinaryStream via JDBC

From: "jeffrey zhao" <jeffrey(dot)zhao(at)metalogic-inc(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3278: PSQLException when using setBinaryStream via JDBC
Date: 2007-05-14 16:02:42
Message-ID: 200705141602.l4EG2g70011058@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3278
Logged by:          jeffrey zhao
Email address:      jeffrey(dot)zhao(at)metalogic-inc(dot)com
PostgreSQL version: 8.2.4-1
Operating system:   Windows XP
Description:        PSQLException when using setBinaryStream via JDBC
Details: 

When I run the following program, I got an exception as following:

File file = new File("myimage.gif");
FileInputStream fis = new FileInputStream(file);
PreparedStatement ps = conn.prepareStatement("INSERT INTO images VALUES (?,
?)");
ps.setString(1, file.getName());
ps.setBinaryStream(2, fis, file.length());
ps.executeUpdate();
ps.close();
fis.close();

Exception: 

org.postgresql.util.PSQLException: Method
org.postgresql.jdbc4.Jdbc4PreparedStat
ement.setBinaryStream(int, InputStream, long) is not yet implemented.
        at org.postgresql.Driver.notImplemented(Driver.java:728)
        at
org.postgresql.jdbc4.AbstractJdbc4Statement.setBinaryStream(AbstractJ
dbc4Statement.java:70)

Is the method setBinaryStream really not yet implemented?

Thanks.

Responses

pgsql-bugs by date

Next:From: stevenDate: 2007-05-14 17:59:06
Subject: BUG #3279: insert or update
Previous:From: Tom LaneDate: 2007-05-14 13:25:21
Subject: Re: BUG #3276: unique index/unique constraint

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group