[jboss-user] [JBoss Portal] - Re: File upload problem

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#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...