[SQL] FastPath protocol SQLException

2001-01-31 Thread Som
Dear All, i am trying to insert image in postgres 7.0 by using following code: i am getting FastPath protocol error : Z Could any one reply earliest...? Any feasible solution ? PreparedStatement stmnt =conn.prepareStatement("insert into grms_photogallary (user_id,oid) values (?,?)"); /

[SQL] Image insertion by using BLOB

2001-01-31 Thread Som
open unix file "/jigsaw/jigsaw/www/som.gif " No such file or directory Query is as follows:: insert into tablename values('som', lo_import('PATH')); If possible , how ? -som

[SQL] FastPath Protocol Error

2001-01-28 Thread Som
Helooo.. I have problem while retrieving image from postgres 7.0.0 through some front-end. I am getting Exception saying: FastPath protocol error : Z any idea? -- som

[SQL] Insertion and Retrieval of BLOB

2001-01-24 Thread Som
lobj; LargeObject  lobj.open(OID); Exception    :Fast path protocol error: Z If im trying insert image by  JDBC way i.e  by getBinaryStream()a and setBinaryStreams() methods of PreparedStatement Im getting Exception saying : Exception : InputStream parameter is not supported. any idea ? --  Som                     --  

[SQL] Some queries

2001-01-24 Thread Som
any such methods pls. send me the code too.. Rgds Som