Re: [JDBC] blob setBinaryStream

2001-09-24 Thread Rene Pijlman
On Mon, 24 Sep 2001 09:46:49 -0500, you wrote: >PreparedStatement ps = con.prepareStatement("update= >userpreferences set image='?' and time=? where user='?'"); I guess the single quotes around the question mark placeholder are the cause of your problem. Regards, René Pijlman <[EMAIL PR

Re: [JDBC] blob setBinaryStream

2001-09-24 Thread Matt Fair
The stack trace I get with this is: Parameter index out of range. at org.postgresql.jdbc2.PreparedStatement.set(PreparedStatement.java:658) at org.postgresql.jdbc2.PreparedStatement.setInt(PreparedStatement.java:210) at org.opensimpx.server.RequestHandler.storeBackgr

[JDBC] blob setBinaryStream

2001-09-24 Thread Matt Fair
Do you need to create a transaction to set blobs? con.setAutoCommit(false); FileInputStream fis = new FileInputStream(file); PreparedStatement ps = con.prepareStatement("update= userpreferences set image='?' and time=? where user='?'"); Logger.log("Setting Binary S