Re: [JDBC] blobs in a client/server environment

2001-09-27 Thread Matt Fair
, and it is very easy to use. It must be something that I missed. I will look at it again and see what else I can do with the database. Any ideas? Thank you, Matt Pete Jewell wrote: Matt Fair [EMAIL PROTECTED] writes: Hello, I have been playing around with storing images with setBinaryStream

Re: [JDBC] blobs in a client/server environment

2001-09-27 Thread Matt Fair
Does anyone know if it is nessesary to have objects stored into the database encoded as unicode that you had to compile the database with the following opions: --enable-unicode-conversion --enable-multibyte Thanks, Matt Matt Fair wrote: Hello, I did set the encoding to UNICODE

[JDBC] downloading image blobs

2001-09-25 Thread Matt Fair
Hello, I am having a similary problem that I was having when I was trying to upload an image to the database. I am already able to upload blobs into the database but I cannot download them. I get the error 'inv_open: large object 12992 not found', which I assume means that the statement should

[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