resultset « Query « JPA Q&A





1. How to reconstruct sql query from a ResultSet    stackoverflow.com

Somewhere way inside JBoss in a hibernate query I'm catching an error that leaves me with a ResultSet. This code is a plugged in custom data type. It would be nice if ...

2. Facing the problem while reterving the resultsets in java from named query function in hibernate    coderanch.com

Hi, I am facing the problem while executing the calling of funtion through named query. My java bean class file like this package org.com.test; public class Contact { private String firstName; private String lastName; private String email; private long contact_id; public String getFirstName() { return firstName; } public void setFirstName(String firstName) { this.firstName = firstName; } public String getLastName() { return ...

3. org.hibernate.AssertionFailure:scrollable resultsets not    forum.hibernate.org

Hi All, I am using Oracle 11g and I am trying to delete some records from database using some GUI. In that case I am getting following error: java.lang.Exception: org.hibernate.AssertionFailure: scrollable result sets are not enabled. When I restart the application's service, this error is going away and deletion is working fine. Other related jars that I am using is as ...

7. Unique/Distinct resultset and Criteria    forum.hibernate.org

8. Error with query: Unsupported method: ResultSet.absolute    forum.hibernate.org

I am getting the following error while performing a query. Has anyone experienced this and how did you resove it? Thanks! Dec 28, 2004 6:03:43 PM net.sf.hibernate.JDBCException SEVERE: Could not execute query java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Unsupported method: ResultSet.absolute at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BaseResultSet.validateScrollable(Unknown Source) at com.microsoft.jdbc.base.BaseResultSet.absolute(Unknown Source) at org.apache.commons.dbcp.DelegatingResultSet.absolute(DelegatingResultSet.java:254) at com.opensourceconnections.msjdbcproxy.ResultSetProxy.absolute(ResultSetProxy.java:314) at net.sf.hibernate.loader.Loader.advance(Loader.java:629) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:803) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:189) ...





10. Problem with Scrollable resultsets    forum.hibernate.org

Hi, We noticed that hql query like : Code: "select partner.PartnerId,partner.PartnerName,partner_loc.DsppCountry.CountryName, partner_loc.DsppCountry.CountryCode,detail.DsppPartnerTaxonomy.Name from DsppPartner partner join partner.SetOfDsppPartnerManagement_1 partner_mgmt join partner.DsppPartnerLocation partner_loc join partner_mgmt.DsppPartnerTaxonomy_1.SetOfDsppPartnerTaxonomyDetail detail where (upper(partner.PartnerName) like upper('%next%') or upper(partner_mgmt.PreviousPartnerName) like upper('%next%')) and (partner_mgmt.MarkedForDeletion <> 1) and detail.DsppLanguage.LangId = 1 order by partner.PartnerName" executes properly with the Hiberrnate Version 3.0.0, but ...

11. How to order a resultset without OutOfMemory errors....    forum.hibernate.org

public List getLatestMembers() { Criteria criteria = _session.createCriteria(User.class); criteria.addOrder(Order.desc("lasttime")); criteria.setMaxResults(20); List users = criteria.list(); return users; }

12. Order resultset    forum.hibernate.org

Hi, First of all, i'm sorry for my english, i'm spanish. I have this mapping: user_seq ...

13. Order resultset    forum.hibernate.org

Hi, First of all, i'm sorry for my english, i'm spanish. I have this mapping: user_seq ...

14. Problem ordering resultSet by Criteria    forum.hibernate.org

Hi! We have the following problem. We have a class JobGroup with an One-To-Many relation to Jobs. So, the jobGroup has a Vector of jobs. Now, we want to fetch the Jobgroups and jobs in one query, ordering by jobGroup-id and by job-id. The code-snippet should make it more clear: Code: public Vector getJobGroupsAndJobs() throws Exception { ...

16. Problem counting the resultset    forum.hibernate.org





17. Problem with closed ResultSet when trying to refresh()    forum.hibernate.org

..... java.util.Collection ...