[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

Re: [JDBC] getObject()

2001-09-24 Thread Antonio Fiol Bonnín
Hi Rene, I am wondering if the driver I am using is outdated (the functionality I am looking for seems to be already implemented, since Aug 24). In fact, I see what you saw about the cache, and looking into it a bit deeper, the cache is effectively updated (at least, on CVS HEAD). Could anyone

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

Re: [JDBC] getObject()

2001-09-24 Thread Dave Cramer
Sorry, they were until this morning probably older than Aug 24, I rebuilt them from source last evening Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Antonio Fiol Bonnín Sent: September 24, 2001 11:43 AM To: Antonio Fiol Bonnín; [EMAIL