-
15. Re: File upload problem
plexiq Dec 7, 2006 2:56 PM (in response to peterj)Im getting the same error on Postgresql8.1, but even for very small file sizes (<200k).
-
16. Re: File upload problem
hurzeler Jan 7, 2007 6:08 PM (in response to peterj)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@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)
-
17. Re: File upload problem
soshah Jan 31, 2007 9:48 PM (in response to peterj)Guys-
This issue is now resolved. See http://jira.jboss.com/jira/browse/JBPORTAL-983
for more details
Thanks -
18. Re: File upload problem
peterj Feb 1, 2007 10:49 AM (in response to peterj)Sohil, JIRA indicates that this fix will be in 2.6. Is there any chance of getting it into 2.4.2 also?
-
19. Re: File upload problem
soshah Feb 1, 2007 11:12 AM (in response to peterj)Yes
I will backport it to that branch.
Not sure about the release process for 2.4.2, but if you urgently need it, you can grab it from the SVN repo once its done.
Thanks -
20. Re: File upload problem
soshah Feb 2, 2007 11:23 AM (in response to peterj)Peter-
This fix is backported to the 2.4 branch. It should be included when 2.4.2 is released.
If you need it before that, you can grab the 2.4 branch at:
https://svn.jboss.org/repos/portal/branches/JBoss_Portal_Branch_2_4
Thanks -
21. Re: File upload problem
k3nnymusic Jul 17, 2007 12:53 PM (in response to peterj)what is a login and pass?
-
22. Re: File upload problem
peterj Jul 17, 2007 5:13 PM (in response to peterj)Try this instead: http://anonsvn.jboss.org/repos/portal/branches/JBoss_Portal_Branch_2_4/
-
23. Re: File upload problem
k3nnymusic Jul 18, 2007 2:52 AM (in response to peterj)This version are diferent than Jboss Portal 2.4.2 Builded.zip? If yes, whitch files should I replace to fix this bug? Could you give me any solution for that?
-
24. Re: File upload problem
k3nnymusic Jul 18, 2007 2:53 AM (in response to peterj)I am using jboss portal 2.4.2 builded, and I have got the same problem.