BLOB support is broken in the 7.2/7.3 JDBC driver, works in 7.1 driver

(NOTE: This is a report ... my cut-and-paste went a little haywire on
the last one.)

BLOB support is broken in the 7.2/7.3 JDBC driver, works in 7.1 driver
though. Basically, returns an error like the following on executeUpdate():

java.sql.SQLException: ERROR: oidin: error in "x": can't parse "x"

Fails on any file. In this case, I created a 1 byte file with the
character 'x' in it. I'm on Linux 2.4.16 using JDK 1.4.0 but it fails in
1.3.1 as well. Here's a quick reproducible test case:

-- start --

package sample.java.jdbc;

import java.sql.*;

import java.io.*;
import java.util.*;

class testBlob
{
public static void main(String args[])
{
new testBlob();
System.exit(0);
}

public testBlob()
{
System.out.println("Let's begin the test ...");

String v_username = "postgre";
String v_password = "postgre";
String v_database = "jdbc:postgresql://127.0.0.1/TEST";

PreparedStatement v_pstmt = null;

try
{
DriverManager.registerDriver(new org.postgresql.Driver());
Connection v_conn = DriverManager.getConnection(
v_database, v_username, v_password);

v_conn.setAutoCommit(false);

File v_file = new File("/home/postgre/something.jpg");
FileInputStream v_fis = new FileInputStream(v_file);
v_pstmt = v_conn.prepareStatement(
"insert into lob_test (id,data) values (?,?)");

v_pstmt.setInt(1,2);
v_pstmt.setBinaryStream(2,v_fis,(int)v_file.length());

System.out.println("now you see me");
v_pstmt.executeUpdate();
System.out.println("now you don't");

v_conn.commit();

v_fis.close();
v_pstmt.close();
}
catch (IOException e_io)
{
System.out.println(e_io);
}
catch (SQLException e_sql)
{
System.out.println(e_sql);
}
System.out.println("You'll only get here with the 7.1 driver!");
}
}

-- end --

01010101010101010101010101010101010101010101010101

Marc P. Lavergne [wk:407-648-6996]
Product Development
richLAVA Corporation

--

"Anyone who slaps a 'this page is best viewed with
Browser X' label on a Web page appears to be
yearning for the bad old days, before the Web,
when you had very little chance of reading a
document written on another computer, another word
processor, or another network."
-Tim Berners-Lee (Technology Review, July 1996)

01010101010101010101010101010101010101010101010101