[JDBC] blob setBinaryStream

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

Re: [JDBC] blob setBinaryStream

advanced. Matt Matt Fair wrote: > 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='

[JDBC] downloading image blobs

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] blobs in a client/server environment

Hello, I have been playing around with storing images with setBinaryStream and getBinaryStream for a couple of days now, but I am continually running into a problem. I don't know if I am getting the data in the right format or not, but I am not able to get my image from the database. I have a

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

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 imag

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

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