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

[hurzeler]

I have also the same issue using JBoss Portal 2.4CR2 with Postgres 8.2 (postgresql-8.2-504.jdbc2.jar). However I noticed that it only happens with images that are stored as BLOBs. I have increased the heap size as suggested. It looks to me as it can't read the image file that is uploaded (gif). What's your take.

If anyone could help that would be great.

Let us know if a solution is available.

2007-01-08 09:22:19,859 DEBUG [org.hibernate.pretty.Printer] org.jboss.portal.cms.hibernate.state.WSPBinVal{key=4901, data=org.hibernate.lob.SerializableBlob at d5da26, id=6d3f3f3e-12c0-4207-814f-a56245fec7c0/{http://www.jcp.org/jcr/1.0}data[0]}
  | 2007-01-08 09:22:19,859 DEBUG [org.hibernate.engine.ActionQueue] changes must be flushed to space: jbp_cms_wsp_binval
  | 2007-01-08 09:22:19,859 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
  | 2007-01-08 09:22:19,859 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
  | 2007-01-08 09:22:19,875 DEBUG [org.hibernate.SQL] insert into jbp_cms_wsp_binval (BINVAL_ID, BINVAL_DATA, PK) values (?, ?, ?)
  | 2007-01-08 09:22:19,875 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
  | 2007-01-08 09:22:19,875 DEBUG [org.hibernate.jdbc.ConnectionManager] skipping aggressive-release due to flush cycle
  | 2007-01-08 09:22:19,890 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)
  | 	at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1932)
  | 	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2178)
  | 	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2595)
  | 	at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
  | 	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
  | 	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
  | 	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
  | 	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
  | 	at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
  | 	at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969)
  | 	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
  | 	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
  | 	at org.jboss.portal.cms.hibernate.state.JBossCachePersistenceManager$DbBLOBStore.get(JBossCachePersistenceManager.java:1363)
  | 	at org.apache.jackrabbit.core.state.util.Serializer.serialize(Serializer.java:219)
  | 	at org.jboss.portal.cms.hibernate.state.JBossCachePersistenceManager.store(JBossCachePersistenceManager.java:786)
  | 	at org.jboss.portal.cms.hibernate.state.JBossCachePersistenceManager.storeHB(JBossCachePersistenceManager.java:1252)
  | 	at org.jboss.portal.cms.hibernate.state.JBossCachePersistenceManager.store(JBossCachePersistenceManager.java:1207)
  | 	at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.end(SharedItemStateManager.java:569)
  | 	at org.apache.jackrabbit.core.state.XAItemStateManager.commit(XAItemStateManager.java:170)
  | 	at org.apache.jackrabbit.core.TransactionContext.commit(TransactionContext.java:172)
  | 	at org.apache.jackrabbit.core.XASessionImpl.commit(XASessionImpl.java:315)
  | 	at org.jboss.portal.cms.impl.jcr.JCRCMS.execute(JCRCMS.java:448)

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

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