Re: Insert picture in MySQL using JDBC

From:

Lew <lew@lewscanon.nospam>

Newsgroups:

comp.lang.java.programmer

Date:

Wed, 01 Aug 2007 16:06:29 -0400

Message-ID:

<L-mdnZKWSKZYei3bnZ2dnUVZ_gadnZ2d@comcast.com>

Manish Pandit wrote:

On Aug 1, 8:22 am, reexana <fildz...@gmail.com> wrote:

I'm working on a project using Netbeans IDE 5.5 with Visual Web Pack
and MySQL as its database.

The project is about displaying the information about an item selected
by a user from a drop-down list.

I managed to display the information in the database when a user
selected the keyword but don't know how to store picture in the
database and retrieve it to display to the user along with the
information.

I tried to use BLOB, but it didn't work out. Maybe, I did the wrong
way.

Anyone please help me? I really need help.

Thank you in advance.

IMO you should be storing images on the file system, and serve them
via HTTP or local file system reading - based on the security
requirements.

Can you copy/paste the set of JDBC calls you made to store and
retrieve the files in a MySQL BLOB?

I've stored and retrieved images using PostgreSQL and Oracle. There are
"setBytes()" commands to the PreparedStatement that you can use to fill the
column.

Sometimes organizational policy prohibits the use of local files on an
application server. There are other reasons why one might choose to store
image or other binary data in a database. Extrinsic factors often force
pragmatic compromises.

--
Lew