Re: Large Object

On 04/09/2003 10:44 Andreas Bauer wrote:
> Hi,
>
> I don't want to annoy anyone, but I just can't write a large object.
> Code:
> File file = null;
> FileInputStream fis = null;
> try{file = new File("c:/testen/test.pdf");
> fis = new FileInputStream(file);}catch(Exception e){e.printStackTrace();}
> try{
> dat.openDB();
> dat.db.setAutoCommit(false);
> PreparedStatement ps = dat.db.prepareStatement("INSERT INTO blob_test
> VALUES
> (?, ?)");
> ps.setString(1, file.getName());
> ps.setBinaryStream(2, fis, (int)file.length());
> ps.executeUpdate();
> System.out.println(ps.toString()); // shows: INSERT INTO blob_test VALUES
> ('test.pdf, 390368)
> ps.close();}catch(Exception e){e.printStackTrace();}
> fis.close();
>
> The table looks like this:
>
> CREATE TABLE blob_test (
>   name varchar(35),
>   pdf oid
> );

Your table definition is for use withe the Large Object storage mechanism
but your code is for storing binary data in a bytea column.

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+