Java - OLE or BLOB - MS Access

[hkansal]

Hello Experts,

Many databases support the storage of OLE or BLOBs i.e music, videos etc or binary large objects. I ve picked up Ms Access to learn this one. Could you please help me in learning about the process to follow to create and store large objects through java in db like MS Access.

If you think I ve not done enough home work before bothering you, please point me towards an option I may go through myself first.

Thank You.

Regards

[xcallmejudasx]

Are you going to be writing a Java program that saves your music files into an MS Access database? If that's the case read up on ObjectOutputStreams. It basically takes any object type you create, writes it to data, sends it wherever. From your DB your going to need to work with ObjectInputStream in order to convert the data back to your object type.

[hkansal]

Thanks! I ll get back after some homework on Object Streams.

[anandbhala]

hiiiiiiiiii
evry one.......
can any plz help me how can i insert and retrieve pdf files in ms access using java servlets.............plz...........

[toadaly]

A word of caution on blobs... many databases limit blobs to the maximum varchar size (often as little as 64k), which is generally not large enough for music or videos.

You may be better of storing the objects as files, and simply recording the meta information for them in the database.