BLOB-Instance?

Hi,

I want to create an instance of a BLOB(MySQL-DB). I use the MySQL-jdbc-driver. The problem is, that the constructor of the BLOB-class is not public. And i don't see any Factory-methods for creating a BLOB-object. The reason is - i want to store pictures in a DB. But i don't want to use Varbinary.

Thanks

[330 byte] By [Oleka] at [2007-11-27 11:50:41]
# 1

You can just use setBytes() or rather setBinaryStream() on a BLOB field.

BalusCa at 2007-7-29 18:33:23 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2

Hm...

what do you mean with BLOB-field?

By the way why the constructor of the BLOB-class of the mysql-driver is not public?

I need BLOB-object in a preparedStatement-call.

but the method ps.setBlob()

need a BLOB-object....

so again the question ... can you post some code to explain?

regards

Oleka at 2007-7-29 18:33:23 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3

I mean the BLOB field of the database.

And like I said, you can just use setBytes() and setBinaryStream() on a BLOB field.

BalusCa at 2007-7-29 18:33:23 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...