Received: from smartr.hksmartone.com ([202.73.249.54]) by hub.org (8.9.3/8.9.3) with ESMTP id DAA02783 for ; Wed, 19 Apr 2000 03:36:17 -0400 (EDT) (envelope-from sam_ma@hksmartone.com) From: sam_ma@hksmartone.com Received: from localhost (root@localhost) by smartr.hksmartone.com (8.8.6 (PHNE_14041)/8.8.6) with SMTP id PAA01078 for pgsql-sql@postgresql.org; Wed, 19 Apr 2000 15:37:54 +0800 (EAT) X-OpenMail-Hops: 1 Date: Wed, 19 Apr 2000 15:37:43 +0800 Message-Id: Subject: problem on using JDBC interface MIME-Version: 1.0 TO: pgsql-sql@postgresql.org Content-Type: multipart/mixed; boundary="openmail-part-03b11482-00000001" X-Archive-Number: 200004/197 --openmail-part-03b11482-00000001 Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT" Content-Disposition: inline; filename="BDY.TXT" Content-Transfer-Encoding: 7bit Hi, I have construct the java program for inserting binary data into database but i get error message as "InputStream as parameter not supported" Java Program: String upstat = "insert into sent (Mess_size,Message, validity_period, dnc, pid, msisdn,submission,oa) values (?,?,?,?,?,?,0,?)"; PreparedStatement pstmt = con.prepareStatement(upstat); File file = new File("sample.txt"); FileInputStream fis = new FileInputStream(file); pstmt.setInt(1, message.length()); pstmt.setBinaryStream(2, fis,(int)file.length()); System.out.println("Update Result3 "); pstmt.setInt(3, validity_period); pstmt.setInt(4, dnc); pstmt.setInt(5, pid); pstmt.setString(6, msisdn); pstmt.setString(7, oa); pstmt.executeUpdate(); pstmt.close(); Can someone to tell me the reason and solution for this error message? rgds Sam Ma --openmail-part-03b11482-00000001 Content-Type: application/ms-tnef; name="WINMAIL.DAT" Content-Disposition: attachment; filename="WINMAIL.DAT" Content-Transfer-Encoding: base64 eJ8+ImO3AQaQCAAEAAAAAAABAAEAAQeQBgAIAAAAtgMAAAAAAAC5AAEIgAcA GAAAAElQTS5NaWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEE gAEAIAAAAHByb2JsZW0gb24gdXNpbmcgSkRCQyBpbnRlcmZhY2UAOAsBBYAD AA4AAADQBwQAEwAPACIABQADACcBAQCAAAAwAAAABAAwAAgAGABTYW0gTWEA AE9QRU5NQUlMOlNhbSBNYSAvb20xLERWAAAAAAAAAAAA4wgBIIADAA4AAADQ BwQAEwAPABUALgADAEMBAQmAAQAhAAAARTJCRDlFOTE5MDE1RDQxMThGNEQw MDEwNUE3NDU5OEYAEgcBA5AGANACAAAeAAAACwACAAEAAAALACMAAAAAAAMA JgAAAAAACwApAAAAAAADADYAAAAAAEAAOQBwscaj0am/AR4AQgABAAAABwAA AFNhbSBNYQAAQABIADCz+aTRqb8BHgBwAAEAAAAgAAAAcHJvYmxlbSBvbiB1 c2luZyBKREJDIGludGVyZmFjZQACAXEAAQAAABYAAAABv6nRo8CRnr3jFZAR 1I9NABBadFmPAAAeABoMAQAAAAcAAABTYW0gTWEAAAIBHQwBAAAAGAAAAE9Q RU5NQUlMOlNBTSBNQSAvT00xLERWAB4AHgwBAAAACQAAAE9QRU5NQUlMAAAA AB4AHwwBAAAADwAAAFNhbSBNYSAvb20xLERWAAADAIAQ/////0AABzBQ57/r z6m/AUAACDBQ57/rz6m/AQsAAIAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAA AAAAAwACgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADAAWACCAGAAAA AADAAAAAAAAARgAAAABShQAA8xUAAB4AJYAIIAYAAAAAAMAAAAAAAABGAAAA AFSFAAABAAAABQAAADguMDQAAAAAAwAmgAggBgAAAAAAwAAAAAAAAEYAAAAA AYUAAAAAAAALAC+ACCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMAMIAI IAYAAAAAAMAAAAAAAABGAAAAABGFAAAAAAAAAwAygAggBgAAAAAAwAAAAAAA AEYAAAAAGIUAAAAAAAAeAEGACCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAA AAEAAAAAAAAAHgBCgAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAA AAAAAB4AQ4AIIAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAAe AD0AAQAAAAEAAAAAAAAAAwANNP03AAATZA== --openmail-part-03b11482-00000001--