1. Nhibernate hql left join question stackoverflow.comIs it possible to do a left join like this in Nhibernate: |
2. Hibernate criteria. Left join question stackoverflow.comThe below SQL able to execute without error. My first table has this field |
3. hibernate inner join question stackoverflow.comI have a question in hibernate HQL query with HQL. I have two entities one is Notes and other is NotesEmp class which has one to one relation ship. my notes class looks ... |
4. newbie hibernate question regarding joins coderanch.comHi I have a simple question, I have two tables in a one-to-many relationship and I want to join them in an HQL query. How do I do that? Lets say I have the classic example of a "departments" table and an "employees" table. I have this bit of XML in my employees.hbm.xml file: |
5. hibernate question - left outer join (best practices) coderanch.comTable 1: Question Columns: QuestionID QuestionName Object: @Entity @Table(name = "question") public class Question { @Id @GeneratedValue(strategy = GenerationType.AUTO) @Column(name = "QuestionID", nullable = false) private Long id; @Basic @Column(name = "QuestionName", nullable = true, unique = false) private String name; public void setId(Long id) { this.id = id; } public Long getId() { return id; } public void setName(String v) ... |
6. Left join question in hibernate coderanch.com |
7. Join Question forum.hibernate.orgHi Hoping this is a basic question. Hibernate is executing this query (which I've converted to SQL to make it easier to read) select a.* from account a, person p where (a.personID=p.personID) and (a.username like 'ABC123') and p.person_state<>'left' and p.person_state<>'missing' and p.person_state<>'absent' and p.person_state<>'deleted' order by p.RealName asc, p.forenames asc limit 10; In my Account object, the relationship with Person is ... |
8. Join With question (possible bug) forum.hibernate.orgI've got a unidirectional OneToMany relationship that I'd like to do an outer join on. However, the query results aren't exactly correct unless I change the table structure a bit. As an example lets use the entities Team and Player. On the team entity we'll include the following mapping to player: @OneToMany() public Set |
9. Understanding results of a join (newbie question) forum.hibernate.org |
10. HQL join question forum.hibernate.orgHello, I've been trying to get something to work without success. Here's a simple example: I have two Hibernate classes: A and B. Each has its own table in the database. A has some attributes, and has a foreign key to B. It does not, however, have a hibernate relationship to B in A's mapping file. Only a foreign key stored ... |
11. Question about joins forum.hibernate.org |
12. HQL Join question forum.hibernate.org |
13. HQL outer join question forum.hibernate.orgI am trying to convert a SQL statement to HQL and I have been having some problems. I have read the online docs but I can't quite figure it out. Here is my SQL query SELECT a.*,b.* FROM schema.table1 a RIGHT OUTER JOIN schmea.table2 b ON ((a.col1 = b.col1 ) AND ( a.col2 = b.col2 ) ) WHERE b.col3 = 'blah' ... |
14. outer join question forum.hibernate.orgI have a HQL statement like this: "from Course_Info as c, Courses as s where c.id = s.courseId and s.courseCode = 13 order by c.id" I didnot define any association between Course_Info and Courses. Now the problem is that I want to use left outer join. because there is no association between Course_Info and Courses. I cannot use HQL like this ... |
15. question about join-type functionality forum.hibernate.orgA coworker of mine asked me the following question: I am trying to just do a simple inner join on a table through hibernate to pull a count of how many rows there are. I had myeclipse create all my business objects and configuration mappings. My table structure is like this: SdtProgramTable primary key = ProgramID IdmsPartProgTable foreign key ... |
16. Advice/question on joins forum.hibernate.orgHowdy all! I've got a join question that I can't seem to be able to figure out. I have two tables, both O/R mapped. There is no mapping relation between them. Now I want to do a (left) join between them but I can't figure out how. In SQL it would be 'select * from table1 left join table2 on table1.id ... |
17. Newbie question: join forum.hibernate.orgHello everyone, I'm having problems with a simple join. I have the following statement, from a createQuery: Code: from FichaTecnica as f join auge.bean.Produto as p where upper(p.descricao) like upper(?) order by descricao and I get the error: Code: 2005-09-30 14:47:32,328 ERROR StandardWrapper[/AugeProducao:action] -> Servlet.service() for servlet action threw exception java.lang.NullPointerException ... |
18. Newbie join Question forum.hibernate.orgSimplified version of the object structure at hand: Code: class A { public int id; public B bReference; }; class B { public int id; public String someData; }; My simplified code: Code: Session session = HibernateUtil.getCurrentThreadSession(); try { ... |
19. Joins - (newbie question) forum.hibernate.org |
20. hql question (joins) forum.hibernate.orgHi, i've got the following hql query (running this using springs hibernate template) FROM ClientId ci,ClientId ci2 WHERE ci.caisiId=? AND ci.groupId = ci2.groupId ORDER BY ci.groupPosition this does what i want, but it returns a list of 2 element arrays, not just the list of ClientIds any ideas on how to get this to just return a single list of ClientId ... |
21. basic HQL join question forum.hibernate.orgHi, I'm trying to get this query back: Query q = aSession.createQuery("select ma.affiliate from ModuleAffiliate ma left join fetch ma.affiliate where ma.module.id = 10"); But for some reason the generated sql puts in a weird comma: select affiliate1_.id as id0_, (a lotta fields...), affiliate1_.z_updt as z6_11_1_ from module_affiliate moduleaffi0_, left outer join affiliate affiliate1_ on moduleaffi0_.affiliateId=affiliate1_.id where moduleaffi0_.moduleId=10 Just removing the ... |
22. JOIN - Newbie Question forum.hibernate.org |
23. Newbie question - Join to another table. forum.hibernate.orgLets say I have a table CUSTOMER with 3 columns CUSTOMER_ID, NAME , STATUS_ID. The STATUS_ID maps to LOOKUP table which has 2 columns LOOKUPTYPE_ID, LOOKUP_ID , DESCRIPTION. I know the LOOKUPTYPE_ID is 100 for STATUS_ID . So all I need to do is join the STATUS_ID to LOOKUP_ID and grab the DESCRIPTION. My java mapping class looks like this. customer ... |
24. CreateCriteria question: A few JOINs forum.hibernate.orgI'm having trouble understanding what I need to do to get what I want out of a HibernateHelper.getSession().createCriteria() query. Below is an example of my current query. If it helps to understand, it's for a 'quick search' where a user can type in "Bad Boy Bill" and get any media objects that contain all three words in either the title, artist, ... |
25. Question regarding joins forum.hibernate.org |
26. newbie HQL questions ( trying to execute join ) forum.hibernate.orgI am trying to duplicate an HQL join example from the manual as below in my code but am having no luck, to pull data from two related tables via a join http://www.hibernate.org/hib_docs/v3/re ... ryhql.html select cust from Product prod, Store store inner join store.customers cust where prod.name = 'widget' and store.location.name in ( 'Melbourne', 'Sydney' ) and prod = all ... |
27. HQL: right join question forum.hibernate.org |
28. join question forum.hibernate.orgHello, I need to pull up a customer object with its addresses using HQL. Note that the relation is between a customer and an address are a common state. If the address doesn't have a state we also return that as an address for every customer. I have the following situation: 1. A customer object which has a collection of addresses: ... |
29. Question about Joins forum.hibernate.orgNewbie Joined: Thu Jan 24, 2008 1:35 am Posts: 9 Hello: In the tables below I have a Many to Many relationship between Group and Role. GroupRole does the linking between these tables. In the objects below, is it necessary to use the intermediary object to facilitate the linking? ie: In the Group object I have a collection of Code: |
30. I need help making a Criteria question with Join forum.hibernate.orgI need make this SQL question with Criteria. SELECT a.id_ FROM vsc_userversion AS a JOIN vsc_usuario AS b on a.idusuario = b.id_ and b.nombre = "xxx" I try with this but doesn't work for me. How can i get a join in Criteria sintaxys? criteria.createAlias("Usuario", "idusuario",JoinFragment.FULL_JOIN); Criteria user = criteria.createCriteria("idusuario"); user.add(Restrictions.eq("nombre", this.params.get("nb"))); criteria = user; |
31. Newbie-ish Inefficient Join / HQL Question forum.hibernate.orgHey, I have got the basics of HQL down, but now I'm getting into more complex queries as I port my application over and am wondering what the best way to handle this is. I have these two POJO's and their definitions: Code: |
32. Questions mount as a criteria where I join an object outside forum.hibernate.orgQuestions mount as a criteria where I join an object outside of the object what to do? I'm trying to do a query using criteria where my class master Criteria criteria = session.createCriteria (EstoqueItem, EstoqueItem); and try to get all the records where the field name EstoqueItem the object model equal "LG" but is giving me error: [code] between creating an ... |
33. HQL Join Question forum.hibernate.org |
34. Novice question about joins forum.hibernate.orgHello, This may be simple, but I havent found an answer yet, please help. I have two tables, A and B which are in many-to many relationship to each other, so there is also table C, containing A.id and B.id pairs. I want to fetch entities from B, which relate to single known id of A. I do not want to ... |
35. Question about implementing a multiple join forum.hibernate.orgNewbie Joined: Wed Apr 08, 2009 1:11 am Posts: 1 I'm facing a problem to join two tables request, request_approve_panel based on two conditions. The traditional sql query should look like: select * from request r, request_approve_panel rap where r. request_id = rap.request_id and r.status = r.status I only need join the "status" column in method which I posted below. I'm ... |