Java: How to store MediumBlob in MySQL

Question

I'm trying to store MediumBlob data in MySQL using java. But I have no success to retrieve the data.

To store I'm using:

PreparedStatement = stmt conn.prepareStatement("UPDATE INTO table VALUE(?)");
ByteArrayInputStream bais = new ByteArrayInputStream(data);
stmt.setBinaryStream(position, bais, data.length);

Is there correcty?

Does it get into the database correctly? When you say you have no success retrieving the data what do you mean? — jzd
– jzd, Commented Feb 24, 2011 at 14:38
Using setBlob() a exception occurs when I call stmt.update() — Victor
– Victor, Commented Feb 24, 2011 at 14:55
@jzd some data is returned by the databse, but is not the data that I have on setBinaryData. Is something different... :( — Victor
– Victor, Commented Feb 24, 2011 at 14:55
@Victor, what is the exception you are getting with setBlob()? — jzd
– jzd, Commented Feb 24, 2011 at 14:57

Victor · Accepted Answer · 2011-02-24 15:51:36Z

1

I fix it!!!!

The problem was when I was retrieving the data. I was calling:

ResultSet.getClob

But I should call:

ResultSet.getBinaryStream

I have used setBinaryStream to input data!

This was confusing because I have a Clob field, and I was expecting retrieving a Clob field in Java code!

answered Feb 24, 2011 at 15:51

Victor

8,48914 gold badges87 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Java: How to store MediumBlob in MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related