postgresql-jdbc.git / summary / log / commit / refs
commit aeddf58f81eb04abc7c272ef56527156e945ceb4
Author: Kris Jurka <books@ejurka.com>
Date: Sun Apr 10 15:15:05 2005 +0000
In a binary data example: File.length() returns long, but
PreparedStatement.setBinaryStream() wants an int.
From lluad in #postgresql.
doc/pgjdbc.xml | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/doc/pgjdbc.xml b/doc/pgjdbc.xml
index c22df565..8a8970a5 100644
--- a/doc/pgjdbc.xml
+++ b/doc/pgjdbc.xml
@@ -1,7 +1,7 @@
<?xml version="1.0"?>
<!--
Copyright (c) 2004-2005, PostgreSQL Global Development Group
- $PostgreSQL: pgjdbc/doc/pgjdbc.xml,v 1.23 2005/02/02 20:05:20 jurka Exp $
+ $PostgreSQL: pgjdbc/doc/pgjdbc.xml,v 1.24 2005/03/04 07:10:13 jurka Exp $
-->
<!DOCTYPE book PUBLIC "-//OASIS//DTD DocBook XML V4.2//EN" "http://www.oasis-open.org/docbook/xml/4.2/docbookx.dtd">
@@ -1321,7 +1321,7 @@ 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.setBinaryStream(2, fis, (int)file.length());
ps.executeUpdate();
ps.close();
fis.close();
[parent: 2cec47d1f71d]