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
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to