₦airaland Forum

I want to write files directly from the internet via a URL object into a Blob field in MySQL. I don't want to store it as a normal file with extension before writing it to the DB.
Has anyone done this before? If yes, I need it.

What do u mean file.

Files have extensions.

Mysql is a column db.

Besides that your using "insert into ...."

See w3c

Check this reference


http://www.java2s.com/Code/Java/Database-SQL-JDBC/StoreBLOBsdataintodatabase.htm

proxy20:
Check this reference


http://www.java2s.com/Code/Java/Database-SQL-JDBC/StoreBLOBsdataintodatabase.htm

Oga that's not what I am looking for. I am looking for one that reads inputStream from a URL object directly in the Insert PreparedStatement. The one you provided is the simple and common way. I am not guaranteed full file io access when hosting my app so want to play safe by reading from the internet (URL Object) into SQL blob column.

download the file from internet

store it as a variable or disk

insert into db

then delete from file

......

or save it as a variable

used a function to check if the variable Contain the file

if yes the. directly insert it into db

@ehinorlive,
That's what I am avoiding. I want to stream the file from the internet via a URL object in to a db without saving it as a file in between.

Check stackoverflow

proxy20:
Check stackoverflow

Not there. Seem a rare task and I plan to solve it as soon as I am less busy.

Desyner:
Not there. Seem a rare task and I plan to solve it as soon as I am less busy.

Ok