Adding BLOBS to mysql database using java

Matfinn · 2004-03-03 19:16:34

Hi I was wonderind can anyone help me with inserting BLOBS to a MySQL database using java. I have an object that I have serialized, and I want to convert that to a byte array. I would then like to transfer that byte array to the SQL server and store it there as the MySQL BLOB datatype. Is blob the right thing to use? And…

03-03-2004 07:16PM

#1

Matfinn

Closed Accounts Posts: 364 ✭✭

Join Date: June 2001

Posts: 294

Hi

I was wonderind can anyone help me with inserting BLOBS to a MySQL database using java. I have an object that I have serialized, and I want to convert that to a byte array. I would then like to transfer that byte array to the SQL server and store it there as the MySQL BLOB datatype.

Is blob the right thing to use? And how would one go about doing this? I have searched the internet for help on this, and I have had no lucck so far.

Thanks for any help.

0

Comments

#2 03-03-2004 07:26PM

stuyg

Closed Accounts Posts: 19 ✭

Join Date: February 2004

Posts: 16

why not use filebaths? ITS A LOT EASIER!!!!
store the filepath of the imageas a "varchar" or "string" and get ur prog to grab the image from the file!

0
#3 03-03-2004 07:35PM

Matfinn

Closed Accounts Posts: 364 ✭✭

Join Date: June 2001

Posts: 294

Im trying to store an object that has been serialized. I have an object that I must transfer to an array of bytes, and then I want to store them bytes as a BLOB in the mysql database.

0