A little more info ... it fails on any file ... I tested with a 1 byte
file with a single byte (value of that byte is irrespective ... fails in
all cases)
-------- Original Message --------
java.sql.SQLException: ERROR: oidin: error in "\377\330\377\340...
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:
-- see prior post --
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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
![[BUGS] [Fwd: BLOB support is broken in the 7.2/7.3 JDBC driver, works in 7.1 driver java.sql.SQLException: ERROR: oidin: error in "\377\330\377\340... 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/someth!ing.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 v!ery little chance of reading a document written on another computer, a](/search?l=pgsql-bugs@postgresql.org&q=subject:%22%5C%5BBUGS%5C%5D+%5C%5BFwd%5C%3A+BLOB+support+is+broken+in+the+7.2%5C%2F7.3+JDBC+driver%2C+works+in+7.1+driver%09%09%09java.sql.SQLException%5C%3A+ERROR%5C%3A++oidin%5C%3A+error+in+%5C%22%5C%5C377%5C%5C330%5C%5C377%5C%5C340...%09%09I%27m+on+Linux+2.4.16+using+JDK+1.4.0+but+it+fails+in+1.3.1+as+well.+Here%27s+a+quick+reproducible+test+case%5C%3A%09%09%5C-%5C-+start+%5C-%5C-%09%09package+sample.java.jdbc%3B%09%09import+java.sql.%5C%2A%3B%09%09import+java.io.%5C%2A%3B%09import+java.util.%5C%2A%3B%09%09class+testBlob%09%5C%7B%09++public+static+void+main%5C%28String+args%5C%5B%5C%5D%5C%29%09++%5C%7B%09++++new+testBlob%5C%28%5C%29%3B%09++++System.exit%5C%280%5C%29%3B%09++%5C%7D%09%09++public+testBlob%5C%28%5C%29%09++%5C%7B%09++++System.out.println%5C%28%5C%22Let%27s+begin+the+test+...%5C%22%5C%29%3B%09%09++++String+v_username+%3D+%5C%22postgre%5C%22%3B%09++++String+v_password+%3D+%5C%22postgre%5C%22%3B%09++++String+v_database+%3D+%5C%22jdbc%5C%3Apostgresql%5C%3A%5C%2F%5C%2F127.0.0.1%5C%2FTEST%5C%22%3B%09%09++++PreparedStatement+v_pstmt+%3D+null%3B%09%09++++try%09++++%5C%7B%09++++++DriverManager.registerDriver%5C%28new+org.postgresql.Driver%5C%28%5C%29%5C%29%3B%09++++++Connection+v_conn+%3D+DriverManager.getConnection%5C%28%09++++++++v_database%2C+v_username%2C+v_password%5C%29%3B%09%09++++++v_conn.setAutoCommit%5C%28false%5C%29%3B%09++++++%09++++++File+v_file+%3D+new+File%5C%28%5C%22%5C%2Fhome%5C%2Fpostgre%5C%2Fsometh%5C%21ing.jpg%5C%22%5C%29%3B%09++++++FileInputStream+v_fis+%3D+new+FileInputStream%5C%28v_file%5C%29%3B%09++++++v_pstmt+%3D+v_conn.prepareStatement%5C%28%09++++++++%5C%22insert+into+lob_test+%5C%28id%2Cdata%5C%29+values+%5C%28%5C%3F%2C%5C%3F%5C%29%5C%22%5C%29%3B%09%09++++++v_pstmt.setInt%5C%281%2C2%5C%29%3B%09++++++v_pstmt.setBinaryStream%5C%282%2Cv_fis%2C%5C%28int%5C%29v_file.length%5C%28%5C%29%5C%29%3B%09%09++++++System.out.println%5C%28%5C%22now+you+see+me%5C%22%5C%29%3B%09++++++v_pstmt.executeUpdate%5C%28%5C%29%3B%09++++++System.out.println%5C%28%5C%22now+you+don%27t%5C%22%5C%29%3B%09++++++%09++++++v_conn.commit%5C%28%5C%29%3B%09++++++%09++++++v_fis.close%5C%28%5C%29%3B%09++++++v_pstmt.close%5C%28%5C%29%3B%09++++%5C%7D%09++++catch+%5C%28IOException+e_io%5C%29%09++++%5C%7B%09++++++System.out.println%5C%28e_io%5C%29%3B%09++++%5C%7D%09++++catch+%5C%28SQLException+e_sql%5C%29%09++++%5C%7B%09++++++System.out.println%5C%28e_sql%5C%29%3B%09++++%5C%7D%09++++System.out.println%5C%28%5C%22You%27ll+only+get+here+with+the+7.1+driver%5C%21%5C%22%5C%29%3B%09++%5C%7D%09%5C%7D%09%09%5C-%5C-+end+%5C-%5C-%09%0901010101010101010101010101010101010101010101010101%09%09Marc+P.+Lavergne+%5C%5Bwk%5C%3A407%5C-648%5C-6996%5C%5D%09Product+Development%09richLAVA+Corporation%09%09%5C-%5C-%09%09%5C%22Anyone+who+slaps+a+%27this+page+is+best+viewed+with%09Browser+X%27+label+on+a+Web+page+appears+to+be%09yearning+for+the+bad+old+days%2C+before+the+Web%2C%09when+you+had+v%5C%21ery+little+chance+of+reading+a%09document+written+on+another+computer%2C+a%22&o=newest){kind=link}
