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)
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)