From: Brian P Millett <bpm@ec-group.com>
To: Henri-Pierre CHARLES <hpc@prism.uvsq.fr>
Cc: pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] Trouble with large objets and jdbc
Date: Thu, 13 May 1999 10:26:51 -0500
Message-ID: <373AEF3B.7310BE9E@ec-group.com> (raw)
References: <19990512133557.A24315@gibet.prism.uvsq.fr>
Henri-Pierre CHARLES wrote:
> Hello,
>
> I want to use large objets to store images in a database with the jdbc
> interface. I have try to use PreparedStatement which has
> setBinaryStream () but it's not possible with the old version I
> usually use (6.4.2). I have download the 6.5b1 and unfortunately
> setBinaryStream () is still not implemented.
This bug has been fixed as of Monday. They (Hackers group) have also fixed a big hairy bug with the backend. If you use the anonymous cvs to checkout the latest snapshot, you will
find an ImageViewer.java example that works, the blobtest.java works also.
I also use code such as this to work fine:
// The UPDATE statement to be used for populating the item_picture and
// item_descr columns
String itemUpdateStmt = "UPDATE item SET item_picture = ?, item_descr = ?"+
" WHERE item_num = ?";
// Create a PreparedStatement object & use it to update the item_picture
// and item_descr columns in the item table
PreparedStatement updateStmt = conn.prepareStatement(itemUpdateStmt);
// File names for the image & text files
String itemPictureFileName = ("item_" + new Integer(i).toString()
+ ".gif");
String itemDescrFileName = ("item_" + new Integer(i).toString()
+ ".txt");
// java.io.File objects corresponding to the image & text files
File itemPictureFile = new File(itemPictureFileName);
File itemDescrFile = new File(itemDescrFileName);
// Byte arrays to store text & byte data for the item_picture and
// item_descr columns
byte itemPictureArray [] = new byte[(int)itemPictureFile.length()];
String itemDescrString = "";
// Using java.io.FileInputStream to reading the image & text files
// into byte arrays
FileInputStream itemPictureInputStream = new
FileInputStream(itemPictureFile);
itemPictureInputStream.read(itemPictureArray, 0,
(int)itemPictureFile.length());
FileReader fr = new FileReader(itemDescrFile);
BufferedReader br = new BufferedReader(fr);
String lineIn;
while ((lineIn = br.readLine()) != null)
itemDescrString += lineIn;
// Set the values of the parameters & execute the statement
updateStmt.setBytes(1, itemPictureArray);
updateStmt.setString(2, itemDescrString);
updateStmt.setInt(3, i);
updateStmt.executeUpdate();
Then to read/view the image, I do:
// read the image from the resultset
byte itemPictureArray [] = queryResults.getBytes(2);
Image img = Toolkit.getDefaultToolkit().createImage(itemPictureArray);
itemPictureCanvas.setImage(img);
itemPictureCanvas.repaint();
--
Brian Millett
Enterprise Consulting Group "Heaven can not exist,
(314) 205-9030 If the family is not eternal"
bpm@ec-group.com F. Ballard Washburn
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: bpm@ec-group.com, hpc@prism.uvsq.fr, pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] Trouble with large objets and jdbc
In-Reply-To: <373AEF3B.7310BE9E@ec-group.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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