0 Replies Latest reply on Jan 12, 2007 6:27 PM by Bernhard Hurzeler

    Unable to upload image in CMS (JBoss Portal 2.4.1.SP1)

    Bernhard Hurzeler Novice

      Hello there,

      I just tried to upload an image and or archive with images in CMS (admin page). I am using jboss4.0.5GA with postgress 8.2. I thought this issue would have been looked at by now as a portal without any images is not much good.

      The error I am getting is:

      2007-01-13 10:12:41,140 DEBUG [org.hibernate.SQL] insert into jbp_cms_wsp_binval (BINVAL_ID, BINVAL_DATA, PK) values (?, ?, ?)
      2007-01-13 10:12:41,140 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
      2007-01-13 10:12:41,140 DEBUG [org.hibernate.jdbc.ConnectionManager] skipping aggressive-release due to flush cycle
      2007-01-13 10:12:41,156 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not insert: [org.jboss.portal.cms.hibernate.state.WSPBinVal] [insert into jbp_cms_wsp_binval (BINVAL_ID, BINVAL_DATA, PK) values (?, ?, ?)]
      org.postgresql.util.PSQLException: Unexpected error writing large object to database.
      Exception: java.io.IOException: Read error
      Stack Trace:
      java.io.IOException: Read error
       at java.io.FileInputStream.readBytes(Native Method)
       at java.io.FileInputStream.read(FileInputStream.java:194)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.setBlob(AbstractJdbc2Statement.java:2745)
       at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setBlob(WrappedPreparedStatement.java:517)
       at org.hibernate.type.BlobType.set(BlobType.java:49)
       at org.hibernate.type.BlobType.nullSafeSet(BlobType.java:117)

      then further down

      Caused by: org.postgresql.util.PSQLException: Unexpected error writing large object to database.
      Exception: java.io.IOException: Read error
      Stack Trace:
      java.io.IOException: Read error
       at java.io.FileInputStream.readBytes(Native Method)
       at java.io.FileInputStream.read(FileInputStream.java:194)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.setBlob(AbstractJdbc2Statement.java:2745)
       at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setBlob(WrappedPreparedStatement.java:517)


      Do I have to configure postgres specially for this or what else can I do to get this working?

      Thanks for your help.