[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3576?page=c...
]
Sanne Grinovero commented on HHH-3576:
--------------------------------------
had some discussions about this on the forums:
https://forum.hibernate.org/viewtopic.php?f=9&t=997987
at the moment it looks like a MySQL issue (server and or driver), not really fixable in
hibernate: workaround for now is to avoid scrollable results and use pagination.
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira