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 jdbc:odbc 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


"and52350@telco.co.in"

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.