[jboss-jira] [JBoss JIRA] Commented: (JBPORTAL-983) Upload of large files fails.

[Sohil Shah (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBPORTAL-983?page=comments#action_12352050 ] 
            
Sohil Shah commented on JBPORTAL-983:
-------------------------------------

This issue is fixed now.

The problem was with the postgres and oracle jdbc driver implementations not handling BLOBs properly within the context of a Hibernate transaction.

Hibernate typically does not flush changes to the database right away, but optimizes database access by flushing data to the database later during a transaction.

However, these two drivers if not flushed right away, result in loss of the BLOB data

Solution: Manual flushing is done the moment the BLOB data is inserted/updated or removed


Solution tested on:
Postgresql 8.2
Oracle 10g Express

> Upload of large files fails.
> ----------------------------
>
>                 Key: JBPORTAL-983
>                 URL: http://jira.jboss.com/jira/browse/JBPORTAL-983
>             Project: JBoss Portal
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Portal CMS
>    Affects Versions: 2.6.Beta1
>         Environment: Windows XP, JDK 1.5, JBoss AS 4.0.4GA
>            Reporter: Peter Johnson
>         Assigned To: Sohil Shah
>             Fix For: 2.6.Beta1
>
>         Attachments: jboss-service.xml, OracleFileSystem.java, OraclePersistenceManager.java
>
>
> Using the CMS Admin portlet, I attempted to upload a zip file into a directory, as per section 3.2.9 of the User Guide. Initially I tried a zip ofabout 6MB containing many files, and eventually got down to a a zip file of about 500M with only a single Word document inside.  The upload failed and an "SQLException: could not reset reader" error appeared (see forum post for stack trace).
> I am, however, able to upload very small zip files.
>  

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira