Uploaded image for project: 'Spring Roo'
  1. Spring Roo
  2. ROO-2648

The used version of PostgreSQL JDBC driver causes abnormal behavior of BLOB fields

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Works as Designed
    • Affects Version/s: 1.1.5.RELEASE
    • Fix Version/s: None
    • Component/s: @ CORE
    • Labels:
    • Environment:
      OSX Lion
      Postgresql 9.0.4 running on Archlinux

      Description

      I'm storing images (jpeg, png, etc.) in a byte-array column of a postgresql 9.0.4 database.

      Spring Roo uses version 8.4-702.jdbc3 of the postgresql jdbc driver, which causes the retrieved BLOB values to be rendered by the servlet as hex-string!
      All HTTP-response headers are correct (content-type, length). I was able to reproduce the problem even in a simple non-Roo setup (only using spring mvc 3.0.5).

      Solution:
      Changing the version in pom.xml to 9.0-801.jdbc4 solves the problem.

        Attachments

          Issue Links

          is related to

          Improvement - An improvement or enhancement to an existing feature or task. ROO-2650 Upgrade PostgreSQL driver to 9.0

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

              Assignee:
              stewarta Alan Stewart
              Reporter:
              codingrobot Nikolai Spassoff
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: