Results 1 to 5 of 5
  1. #1
    hkansal is offline Member
    Join Date
    Oct 2008
    Posts
    7
    Rep Power
    0

    Default Java - OLE or BLOB - MS Access

    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

  2. #2
    xcallmejudasx's Avatar
    xcallmejudasx is offline Senior Member
    Join Date
    Oct 2008
    Location
    Houston, TX & Flint, MI
    Posts
    609
    Rep Power
    7

    Default

    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.

  3. #3
    hkansal is offline Member
    Join Date
    Oct 2008
    Posts
    7
    Rep Power
    0

    Default

    Thanks! I ll get back after some homework on Object Streams.
    Last edited by hkansal; 12-03-2008 at 06:38 PM.

  4. #4
    anandbhala is offline Member
    Join Date
    Feb 2009
    Posts
    1
    Rep Power
    0

    Default

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

  5. #5
    toadaly is offline Senior Member
    Join Date
    Jan 2009
    Posts
    671
    Rep Power
    6

    Default

    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.

Similar Threads

  1. Saving Blob through Hibernate
    By Ed in forum JDBC
    Replies: 2
    Last Post: 01-05-2009, 06:03 AM
  2. MS Access with Java
    By Doctor Cactus in forum New To Java
    Replies: 4
    Last Post: 10-24-2008, 03:59 AM
  3. Help with Java and MS access
    By lemurian in forum New To Java
    Replies: 1
    Last Post: 04-30-2008, 02:46 PM
  4. Problems updating blob columns on Oracle 9
    By ljustiniano in forum JDBC
    Replies: 0
    Last Post: 08-14-2007, 07:17 PM
  5. Replies: 1
    Last Post: 08-07-2007, 08:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •