Customizing Hibernate Criteria - Adding conditions to a left join

Posted by Douglas Ferguson on Stack Overflow See other posts from Stack Overflow or by Douglas Ferguson
Published on 2010-05-14T03:59:05Z Indexed on 2010/05/14 4:04 UTC
Read the original article Hit count: 362

Filed under:

hibernate

|

criteria

|

left

|

join

I need to be able to do the following:

Select * from Table1 left join Table2 on id1 = id2 AND i1 = ?

Hibernate criteria doesn't allow be to specify the i1 = ? part.

The existing code is using hibernate criteria and it would be a huge refactor to swap out for HQL

Does anybody have any tips how I could implement this differently or any way to override the Hibernate Criteria? I'm not opposed to cracking open hibernate and modifying, but when I began to dig it, there seems to be layers upon layers of abstractions. I never found the the point where SQL is actually generated...

© Stack Overflow or respective owner

Related posts about hibernate

Hibernate + PostgreSQL : relation does not exist - SQL Error: 0, SQLState: 42P01

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I am having some problems trying to work with PostgreSQL and Hibernate, more specifically, the issue mentioned in the title. I've been searching the net for a few hours now but none of the found solutions worked for me. I am using Eclipse Java EE IDE for Web Developers. Build id: 20090920-1017… >>> More
Hibernate unable to instantiate default tuplizer - cannot find getter

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to use Hibernate to persist a class that looks like this: public class Item implements Serializable, Comparable<Item> { // Item id private Integer id; // Description of item in inventory private String description; // Number of items described by this inventory item private int… >>> More
Problem connecting to Hsqldb via Hibernate when running a Eclipse GWT project.

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm trying to run a simple GWT project where I'm trying to do a simple persitence via hibernate to a HSQLDB database. The database I'm using I have been using for at least 2 years with several osgi applications without any problems. So all I done is reused the same configuration and added a simple… >>> More
Hibernate : load and

as seen on Stack Overflow - Search for 'Stack Overflow'
According to the tutorial : http://jpa.ezhibernate.com/Javacode/learn.jsp?tutorial=27hibernateloadvshibernateget, If you initialize a JavaBean instance with a load method call, you can only access the properties of that JavaBean, for the first time, within the transactional context in which it… >>> More
Hibernate Exception, what wrong ? [[Exception in thread "main" org.hibernate.InvalidMappingException

as seen on Stack Overflow - Search for 'Stack Overflow'
I use netbean 6.7.1 to write "hello world" witch hibernate, but I get some errors, plz help me, thank you very much. my exception init: deps-module-jar: deps-ear-jar: deps-jar: Copying 1 file to F:\Documents and Settings\My Dropbox\DropboxNetBeanProjects\loginspring\build\web\WEB-INF\classes compile-single: run-main: Oct… >>> More

Related posts about criteria

Hibernate Criteria: Add restrictions to Criteria and DetachedCriteria

as seen on Stack Overflow - Search for 'Stack Overflow'
Currently our queries add a variety of Restrictions to ensure the results are considered active or live. These Restrictions are used in several places/queries so a method was setup similar to public Criteria addStandardCriteria(Criteria criteria, ...) { // Add restrictions, create aliases… >>> More
Criteria SpatialRestrictions.IsWithinDistance NHibernate.Spatial

as seen on Stack Overflow - Search for 'Stack Overflow'
Has anyone implemented this, or know if it would be difficult to implement this/have any pointers? public static SpatialRelationCriterion IsWithinDistance(string propertyName, object anotherGeometry, double distance) { // TODO: Implement throw new NotImplementedException(); } from NHibernate… >>> More
Hibernate Criteria query on association

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi There, How would I go about executing the following Hibernate query using the criteria API. I have an object Parent with List children. I would like to search through all parents and find which parents contain a specified child. i.e. List findParent(Child child); Thanks. >>> More
Delete all rows that do not have the value: Criteria 1 or Criteria 2 or Criteria 3 in Column D --> Using VBA Macro for excel

as seen on Stack Overflow - Search for 'Stack Overflow'
I am new to Macro's/VBA and cannot seem to figure out how to do this action for multiple criteria. I am trying to Delete all rows that do not have the value: Identify Fail or Identify Success in Column D. I write the following code and it works for one criteria "Identify Fail": '***********************************************' Sub… >>> More
More than one location provider at same time

as seen on Stack Overflow - Search for 'Stack Overflow'
I have some problems with location systems. I have a service that implements locationlistener. I want to get the best location using network when possible, gps if network is not enough accurate (accuracy greater than 300mt). The problem is this. I need location (accurate if possible, inaccuarte otherways)… >>> More