Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 5 of 5

Thread: BLOB & CLOB

  1. #1
    Junior Member
    Join Date
    Aug 2012
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default BLOB & CLOB

    Hi,
    Could anybody please tell how to insert an image having datatype as CLOB in java?Let's say we have .jpg file for this case.

    Regards,
    Jajati


  2. #2
    Super Moderator Norm's Avatar
    Join Date
    May 2010
    Location
    Eastern Florida
    Posts
    25,139
    Thanks
    65
    Thanked 2,720 Times in 2,670 Posts

    Default Re: BLOB & CLOB

    What package is the datatype: CLOB defined in? Or is that a SQL thing?
    If you don't understand my answer, don't ignore it, ask a question.

  3. #3
    Administrator copeg's Avatar
    Join Date
    Oct 2009
    Location
    US
    Posts
    5,318
    Thanks
    181
    Thanked 833 Times in 772 Posts
    Blog Entries
    5

    Default Re: BLOB & CLOB

    Thread moved form I/O.

    CLOB is for characters. A jpg is binary...use a BLOB

  4. #4
    Junior Member
    Join Date
    Aug 2012
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Re: BLOB & CLOB

    can we store an image in db having clob datatype?

  5. #5
    Super Moderator jps's Avatar
    Join Date
    Jul 2012
    Posts
    2,642
    My Mood
    Daring
    Thanks
    90
    Thanked 263 Times in 232 Posts

    Default Re: BLOB & CLOB

    Quote Originally Posted by JajatiKesharibehera View Post
    can we store an image in db having clob datatype?
    What happened when you tried it? What code did you use? Was there an error message?

Similar Threads

  1. No data after downloading pdf BLOB from Oracle db
    By reubenmk in forum JDBC & Databases
    Replies: 1
    Last Post: February 23rd, 2012, 09:06 AM
  2. How to download a pdf file stored in a MySQL blob?
    By A4Andy in forum JDBC & Databases
    Replies: 1
    Last Post: October 20th, 2011, 11:35 PM
  3. issue with reading a clob variable from oracle
    By computerbum in forum What's Wrong With My Code?
    Replies: 2
    Last Post: August 28th, 2010, 06:08 PM
  4. Create a CLOB object with the string value
    By oshoarun in forum JDBC & Databases
    Replies: 0
    Last Post: March 6th, 2010, 02:54 AM
  5. Help needed regarding saving BLOB in oracle using JSP
    By smsouvik_2008 in forum JDBC & Databases
    Replies: 1
    Last Post: February 26th, 2010, 02:09 AM