[jboss-user] [JBoss Portal] - Unable to upload image in CMS (JBoss Portal 2.4.1.SP1)

[hurzeler]

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.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4001161#4001161

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4001161