how to insert a image file into the database and how to retrieve it from the database

[R.Karunanithi]

hai everybody,

if any one tried inserting and retrieving the image file using jdbcdbc tellme about that or tell where to refer to get detail about this.

awaiting your replies,

R.Karuna

[Abhisheik R Vishwakarma]

Hi,

Although I have not tried it myself

but try creating a datastream of the gif image and then try inserting it into the

data base

for this U will have to design Ur database such that it has a column which is

long so that it can hold byte streams

I hope this satisfies U

or U may look up the site java.sun.com

see documentation link

find JDBC page


If U have any question Pl mail me at


"[email protected]"

write FWD : Abhisheik in the subject field


bye

Abhishiek R Vishwakarma

[Mark]

The key is defining a column as a binary large object(BLOB).


I've done it with ODBC and DAO.


Mark

[rick]

someone knows, where I can find anything usefull about MSAccess cooperating with

Java (it all runs already, but the sql-Syntax of MS-Access seems not to be different

from the sql I formerly used)

[Rick]

someone knows, where I can find anything usefull about MSAccess cooperating with

Java (it all runs already, but the sql-Syntax of MS-Access seems not to be different

from the sql I formerly used)

[Mike2000]

you can do it on the server side with ODBC API.