[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3576) out of memory

[Sanne Grinovero (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=35757#action_35757 ] 

Sanne Grinovero commented on HHH-3576:
--------------------------------------

In case of MySQL there's an easy workaround: use connection properties useCursorFetch=true and useServerPrepStmts=true

> out of memory
> -------------
>
>                 Key: HHH-3576
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3576
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.2.2
>         Environment: windows 2003 Standard edition SP2
>            Reporter: sridhar
>         Attachments: hibernate.zip
>
>   Original Estimate: 3 weeks
>  Remaining Estimate: 3 weeks
>
> Hibernate unable to use scrollable results and running out of memory for MS SQL Server 2005 and MySQL 5.0.
> But it is working fine for Oracle 10G.
> Problem Description:
> ===================
> I have a table with 10 columns and one of them is blob field. this blob field contains binary information about 33KB.
> I have 70,000 rows in database.
> When I read the complete data using scrollable results implementation of hibernate, for Oracle 10G, the process completeed in 10 Seconds.
> But when run the same program for MS SQL Server 2005 and MySQL 5.0 its running out of memory.
> Steps to reproduc the problem:
> =========================
> I am enclosing the eclipse project. In the lib folder it contains the JDBC drivers for Oracle 10G, Mysql 5, MS SQL Server2005.
> Remaing jar files will come with standard Springs distribution of  2.5.
> import the project into eclipse.
> Please configure the database details in jdbc.properties
> now run the DBRead.java.
> This will populate the 68828 records in the configured database and reads complete data from the database.
> For MySQL and MS SQl Server it will give out of memory error while reading.

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