I am using PostgreSQL 8.1.

I just now tried it again with a 600KB zip file.  Here is a partial stack trace:

2006-08-24 12:00:27,553 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL 
Error: 0, SQLState: 99999
  | 2006-08-24 12:00:27,553 ERROR [org.hibernate.util.JDBCExceptionReporter] 
Unexpected error writing large object to database.
  | 2006-08-24 12:00:27,553 ERROR 
[org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize 
database state with session
  | org.hibernate.exception.GenericJDBCException: could not insert: 
[org.jboss.portal.cms.hibernate.state.WSPBinVal]
  |     at 
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
  |     at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
  |     at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
  |     ...
  |     at 
org.jboss.portal.cms.hibernate.state.HibernatePersistenceManager$DbBLOBStore.get(HibernatePersistenceManager.java:997)
  |     at 
org.apache.jackrabbit.core.state.util.Serializer.serialize(Serializer.java:219)
  |     at 
org.jboss.portal.cms.hibernate.state.HibernatePersistenceManager.store(HibernatePersistenceManager.java:624)
  |   ...
  |     at 
org.jboss.portal.core.portlet.cms.admin.CMSAdminPortlet.internalProcessAction(CMSAdminPortlet.java:505)
  |     at 
org.jboss.portal.core.portlet.cms.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:353)
  |     at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:379)
  |   ...
  |     at 
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
  |     at 
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
  |     at java.lang.Thread.run(Thread.java:595)
  | Caused by: org.postgresql.util.PSQLException: Unexpected error writing 
large object to database.
  |     at 
org.postgresql.jdbc2.AbstractJdbc2Statement.setBlob(AbstractJdbc2Statement.java:2740)
  |     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)
  |     at 
org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1910)
  |     at 
org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1887)
  |     at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2117)
  |     ... 250 more
  | Caused by: 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:2727)
  |     ... 256 more

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

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3967313
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to