facebook

Reverse Engineer MySQL BLOB

  1. MyEclipse Archived
  2.  > 
  3. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #294015 Reply

    Douglas M Hurst
    Participant

    When I perform reverse engineering on a MySQL table with a BLOB, MyEclipse is generating the field as a String. IS THIS CORRECT?

    I attempted to use the save method with

    setUserImage(“images/Face.jpg”);

    … and it didn’t throw up. Do you have any idea how I’m supposed to retrieve the BLOB as a string? Is it actually a byte []? Are there any examples on demand or otherwise?

    #294047 Reply

    Brian Fernandes
    Moderator

    Douglas,

    No, String is incorrect. On certain databases the RE tool does not correctly detect this data type. To fix this, when you RE your table, go to page 3 and expand the tree to select the column which is of type BLOB. In the Hibernate type field, use “java.sql.Blob” and click Finish. This must only be done once for this column, the setting will persist across sessions.

    Sorry for the inconvenience caused.

    #312783 Reply

    logixplayer
    Member

    This message has not been recovered.

    #312789 Reply

    support-swapna
    Moderator

    This message has not been recovered.

Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: Reverse Engineer MySQL BLOB

This topic is marked as closed to new replies, however your posting capabilities still allow you to do so.

You must be logged in to post in the forum log in