memory « Query « JPA Q&A





1. Techniques for querying a set of object in-memory in a Java application    stackoverflow.com

We have a system which performs a 'coarse search' by invoking an interface on another system which returns a set of Java objects. Once we have received the search results I ...

2. NHibernate Criteria query on in-memory collection of entities    stackoverflow.com

I would like to apply a Criteria query to an in-memory collection of entities, instead of on the database. Is this possible? To have Criteria API work like LINQ? Or alternatively, convert Criteria query ...

3. Dynamic queries in Hibernate keeps in memory    stackoverflow.com

I use Hibernate in my app and I have this question: Queries are automatically generated by Hibernate, I use this code to retrieve objects from DB:

Object result = session.get(clazz, id);
where id is ...

4. Hibernate - Java pagination - Out of memory exception    stackoverflow.com

I am using the following piece of code to get results from DB as result set is huge. Is it the correct way doing? I am running in to Out of memory ...

5. Large query strings in the cache using a lot of memory    forum.hibernate.org

I've been debugging the memory use of our application and I found that in some cases hibernate generated some pretty extensive SQL queries, up to 40KB in length. These strings go into the query cache as keys and use a lot of memory (potentially). It's also not necessary for the queries to be so big - they're a symptom of mapping ...

6. Memory problem with Query    forum.hibernate.org

I'm having a problem paging through a large number of records with setMaxResults() and setFirstResult() using Hibernate with Sybase Anywhere. According to the documentation, query results are not cached by default so I'm unsure where the problem is coming in. Here is a snippet of my code: Code: Session session = ConnectionFactory.getInstance().getSession(); ...

7. question about collection sort in memory    forum.hibernate.org

database table Users: userId not null int primary key ... SystemMenu: menuId not null int primary key ... user_menu:(the map of Users and SystemMenu) userId int not null primary key menuId int not null primary key foreign key (userId) references Users(userId) foreign key (menuId) references SystemMenu (menuId) The Record Of Users (omit) userId 1 The Record Of SystemMenu (omit) ...

8. Bulk Operations + Query Cache leads to High Memory Consumpti    forum.hibernate.org

for(int i=0; i<100000; i++) { // create and persist a new entity Entity e = createEntity(...); session.save(e); // flush and clear the session periodically to free memory if ( (i % 100)==0) { session.flush(); ...





10. about the cost of memory when select    forum.hibernate.org

11. Scrollable Results Out of Memory error    forum.hibernate.org

Newbie Joined: Thu Oct 30, 2008 3:26 am Posts: 10 Hi I am trying to read all the rows from MS SQL Server. There are 70000 rows in a table. Blob field size in each row is 33KB. When read all records with the JDBC program, it took 2-3 minutes to read all the records. But when tried to with hibernate, ...

12. when query result is very big,how to avoid out of memory    forum.hibernate.org

if the result set is very big , for example ,1G data ,we used getResultList, Easily machine will out of memory, so in hibernate we can used Query.iterater to avoid out of memory ,but if we use only jpa , Query.iterater is not available, it seemed that we can use getResultList only, how to resolve the problem:out of memory. Of course ...