Query « Composite « JPA Q&A





1. Hibernate Basic: how to query when there is a composite id    stackoverflow.com

I have a domain object say, SalesOrder which has a composite id called id, made of salesOrder id and repid which is contained in another class called SalesOrderID(which is serializable and ...

2. HIbernate Query returning incorrect records when used with Composite Keys    stackoverflow.com

class Mstatkey

// This defines the coomposite key over the columns deviceid, groupaddr, srcaddr

@Embeddable public final class MstatKey implements Serializable {
private  Integer associatedNetDeviceId;
private  Long groupAddr;
private  Long sourceAddr;
.... // Here we use ...

3. Hibernate query caching when selecting objects with composite id    stackoverflow.com

I'm having a hard time figuring out how to make effective use of query caching criteria queries on the following entity:

@Entity @Table(name = "category_configuration_values")
@Immutable
@Cacheable
@org.hibernate.annotations.Cache(usage = CacheConcurrencyStrategy.READ_ONLY)
public class CategoryConfigurationValue implements Serializable {
 ...

4. Hibernate : Opinions in Composite PK vs Surrogate PK    stackoverflow.com

As i understand it, whenever i use @Id and @GeneratedValue on a Long field inside JPA/Hibernate entity, i'm actually using a surrogate key, and i think this is a very nice ...

5. Querying my JPA provider (Hibernate) for a collection of of an entity    stackoverflow.com


I have an entity which looks something like this:
Id (PK) Name
Other business properties and associations... I have the need for my DAL (JPA with hibernate as provider) to return a ...

6. conditional query with hibernate Composite(key) Object    stackoverflow.com

CREATE TABLE ratecodes ( roomId int(11) NOT NULL DEFAULT '0', date date NOT NULL DEFAULT '0000-00-00', ..., PRIMARY KEY (roomId,date)) hbm.xml

<class catalog="hermes" name="com.hermes.data.RateCode" table="ratecodes">
<composite-id class="com.hermes.data.RateCodeId" name="id">
     ...

7. sql generated with hql query with composite user type    stackoverflow.com

I'm using hibernate 3.6.1 and i have a strange behaviour on the sql generated by hql. Here is the hql:

from Floor as floor where (floor.type != :var1)
type is a composite user type ...

8. Querying Composite Key inner Entity properties    stackoverflow.com

I have one entity called ProductTemplate with the following hibernate mapping

<hibernate-mapping default-cascade="none">
    <class name="com.stackoverflow.ProductTemplateImpl" table="PRODUCT_TEMPLATE" dynamic-insert="false" dynamic-update="false">
        <composite-id name="productTemplatePk" class="com.stackoverflow.product.ProductTemplatePK">
  ...

9. Hibernate HQL Query : How to set a Collection as a named parameter of a Query with composite key?    stackoverflow.com

Given the following HQL Query: from Foo foo where foo.id in (:fooIds) but here i have composite key in the Id ex we have two PK1 and pk2 as Id's. How can we implement ...





11. Query about Composite keys - Hibernate    coderanch.com

we are generating POJO classes using My Eclipse. Table which is not having primary key is autogenerated by eclipse as a composite key while generating POJO files. i.e. a id class is generated say for eg DVLMASTER.java DVLMASTERID.java AbstractDVLMASTERID.java AbstractDVLMASTER.java and the mapping file . i m using dao file also , in which findbyproperty is present .after using that i ...

12. Query Criteria: Can't build with composite keys    forum.hibernate.org

13. Query on composite keys?    forum.hibernate.org

Hello, I am running into difficulties running queries on Hibernate mapped class/tables that have composite keys defined. When I query by criteria, I can query on all the class's properties except those that are part of the composite key. In fact when I interrogate the Hibernate class metadata via the SessionFactory, the properties in the composite key don't even show up. ...

14. Mapping and named query issue with composite key many to one    forum.hibernate.org

I have three tables, one of which is a relationship table between the other two. For simplicity sake, here are the relevant tables/columns (I did not design these tables or their naming, don't yell at me lol): table: povendsite column: vendno column: vend_site table: rt_sub_category column: category column: sub_category table: store_services_vend_subcat column: vendno column: vend_site column: category column: sub_category the first ...

15. How to make HQL query using composite key annotation    forum.hibernate.org

Newbie Joined: Tue Feb 08, 2011 5:34 am Posts: 1 Hi I have searched the internet for how to make a HQL query for a table which has a composite primary key. I have done the following: This is my table definition: create table experience (project_id integer, person_id integer, competence_id integer, grade_id integer, from_date date, to_date date, description varchar(400), unique(project_id, person_id, ...

16. Named query for a Composite key problem    forum.hibernate.org

Newbie Joined: Thu Jul 14, 2011 4:44 am Posts: 1 Hi folks, would massively appreciate some guidance on the below prob. Have trawled the documentation, other posts, sites etc until my eyes have begun to mist :( Anyway, trying to introduce Hibernate at my current client's site, against a rather poor legacy SqlServer database and (as luck would have it) my ...





17. Querying Composite Key inner Entity properties    forum.hibernate.org

...

18. Cant use composite id with native sql query and mapping    forum.hibernate.org

I've been trying to use a sql result set mapping to return entities with a composite key but to no avail; Hibernate is using names for the composite key columns that aren't found in the query, specified in the sql result set mapping or @Column annotations. I also tried @AttributeOverrides but those are ignored. The query uses some Oracle specific stuff ...

19. query based on a collection composite-element property value    forum.hibernate.org

I'm trying to follow the instructions from the faq How do a write a query that returns objects based upon a WHERE clause condition applied to their collection elements? select distinct parent from Parent parent, join parent.children child where child.name = :name First off, the comma seems to be causing a problem Second this doesn't work when the collection is mapped ...

20. Querying on a composite-id    forum.hibernate.org

When I try to execute the query: select max(p.id) from QueryParameter p where p.query.id = ? I get the following error: --- net.sf.hibernate.QueryException: path expr ession ends in a composite value: querypar0_.id [select max(p.id) from com.estob el.model.QueryParameter p where p.query.id = ?] -- My class QueryParameter has a composite-id: How can ...

21. Problem using find method with composite-id based query    forum.hibernate.org

Hello. I'm new to Hibernate. I'm having problem on performing a query using a composite-id key. My schema was generated by Middle-Gen. I'm using the following query: Code: String id="10"; List params = s.find("from Parameter as parameter where parameter.comp_id.id = ?",id,Hibernate.STRING); Following is the hbm map file: Code: ...

22. Query by Mapped Composite Element - illegally dereferenced    forum.hibernate.org

Hi, I am trying to create a query based on the values of a map containing composite-elements. I have a Map property called propertiesMapped. The elements withing this map are mapped as composite-elements. I want to join only based on a property of the composite-element, in my example the property 'valueLong'. If I execute the query as attached, I get the ...

23. Query to get last element of composite-element list?    forum.hibernate.org

Hi Folks, I wish to write a query to get the very last element of a composite-element list. Sure, we can just get the list and then get the size()-1 element, but this list will likely be large and we don't want to read the whole list into memory just to get the last element. If I use lazy="true" I can ...

24. Composite-Id, Aggregate function Query    forum.hibernate.org

I have a simple scenario : My table config looks like this: Code: ...

25. Problem formulating join select query with composite keys.    forum.hibernate.org

Hey, I want to perform a join between two tables CustomerorderT and CustomerorderlineT. The thing is that I have composite keys in both tables. Below is my select query so far, what I want to get out. I haven't formulated the WHERE statement since that's what I'm wondering about. I believe I can't use the prefix "id" since that checks after ...

26. composite-element query yields object with null parent    forum.hibernate.org

Newbie Joined: Wed Jun 30, 2004 1:10 am Posts: 2 Using a composite-element with a parent tag and running this query: Code: select elements(grp.frames) from com.trailmagic.image.ImageGroup grp join grp.frames frame where grp = :album AND frame.image.id = :imageId I get back an object that has the parent (ImageGroup) set to null (even just running the query in Hibern8ide, modified only to ...

27. Middlegen - Composite id w/ key-many-to-one and HQL queries    forum.hibernate.org

Beginner Joined: Thu Jun 24, 2004 1:04 pm Posts: 35 Location: Minnesota - USA This question is about how composite keys that use mappings affect HQL queries. Obligatory hours searching, reading documentation and FAQs are already spent. ;) Middlegen created my initial *.hbm.xml files based on my legacy database. Snippets from the files are at the end of this post, ...

28. Query on a composite element : is it possible ?    forum.hibernate.org

I'd like to execute a query over an object declared in a composite element. To illustrate what I mean I take a piece of text in the reference documentation : Here, as you can see, the list maps a table ...

29. query by Criteria and set of composite-elements not working    forum.hibernate.org

Author Message danny_mandel Post subject: query by Criteria and set of composite-elements not working Posted: Fri Jul 23, 2004 6:42 pm Newbie Joined: Tue Jul 13, 2004 9:55 pm Posts: 7 Location: Tucson, AZ Relevant platform details: Hibernate 2.1.2 Spring 1.0.1 jdk1.4.2 MySQL 4.0.16-standard Hi all. I'm trying to rewite an HQL query for use in a search page ...

30. Query on Composite Element, Return Type    forum.hibernate.org

Hi, I am quite new to Hibernate and am in need of assistance! I am required to execute a Hibernate query on a Composite Element type (we'll call it C) contained in a Set under a standard Class mapping (we'll call it A). By reading the forums I discovered I can execute queries on composite elements using the 'join' HQL syntax. ...

31. Query returning a mix of normal and "composite" el    forum.hibernate.org

I have been using Hibernate for some time quite happily, but ran into a issue with a new query. I am trying to create a query: ... select s.name, s.description, count(elements(s.children)), elements(s.favoriteActivities), s.birthday from Staff s order by s.name ... where s.children is a List and s.favoriteActivities is a Map. I am trying to get the query to return an Object[] ...

32. sql-query syntax problem on object with composite-id    forum.hibernate.org

Hibernate version: 2.1.1 Mapping documents: select {strain}.sptr_code as {strain.key.oscode}, {strain}.name as {strain.key.name}, {strain}.strain as {strain.strain}, {strain}.name_class as {strain.nameclass} from strains {strain} EXCEPT select s.sptr_code, s.name, s.strain, s.name_class from testeditor_strains order ...

33. use composite object in query    forum.hibernate.org

Hibernate version: 2.1.6 Mapping documents:

34. How to do query against Hibernate Object with composite id?    forum.hibernate.org

Hibernate version: 2.1 Mapping documents: I have a USERLOG table and an ACTIVITY table. the relationship is one-to-many respectively. USERLOG has a primary key made up of userid and date fields. ACITITY has a foreign key made up of userid and date fields and a primary key made up of userid, date and taskno fields So, any user can have many ...

35. Query by Criteria with Composite Key Class?    forum.hibernate.org

I don't follow. From my experience you can do id.name but you aren't able to do id.someObject.someProperty. We do the id.name syntax quite frequently in our code (until we eliminate all the comp PKs). For the id.someObject.someProperty a workaround is to specify a many-to-one on someObject with insert="false", update="false" and then walk the chain from there.

36. Composite primary key query help needed    forum.hibernate.org

37. Querying according to one of the keys in composite-id    forum.hibernate.org

Hibernate version: 2.1.6 Name and version of the database you are using: Oracle 9i I have an object with a composite-id and I have the composite-id as a seperate class. I can load the instance by giving whole composite-id attributes but I want to retrieve the row with a maximum of one of the key columns. Example: (from Hibernate references) User ...

38. native sql query and composite-id    forum.hibernate.org

39. hibernate queries not working for composite keys/ids???    forum.hibernate.org

Exception in thread "main" org.springframework.orm.hibernate.HibernateQueryException: path expression ends in a composite value: versionimp0_.id [from de.vodafone.rnp.core.business.persistence.jdo.VersionImpl as v where v.id = ? and v.workspaceId = ?]; nested exception is net.sf.hibernate.QueryException: path expression ends in a composite value: versionimp0_.id [from de.vodafone.rnp.core.business.persistence.jdo.VersionImpl as v where v.id = ? and v.workspaceId = ?] net.sf.hibernate.QueryException: path expression ends in a composite value: versionimp0_.id [from de.vodafone.rnp.core.business.persistence.jdo.VersionImpl as ...

40. query a class with a composite id    forum.hibernate.org

Hello, I have a class called ClientAccount that has two primary keys (clientId and instanceId). I have created another class called ClientAccountId to manage the two primary keys (in this class i have extended serializable and implemented hashCode and equals methods). Now I want to query the database and ask for all the entries where instaceId=3 and clientId contains 'DER'. Is ...

41. How to query for properties of composite-elements?    forum.hibernate.org

Hibernate version: 2.1.7c Mapping documents: ...

42. how to write the find query with composite key mapping    forum.hibernate.org

Newbie Joined: Mon Apr 11, 2005 2:08 pm Posts: 8 To use a composite PK in a query, you have to implement a UserType for your Primary Key class: Code: public abstract class DESCRIPTIONPK_UserType implements UserType { private static final int SQLTYPES[] = { ...

43. Quck question: Composite-Id and named queries    forum.hibernate.org

The reason I am asking, is because line 37 of the class "org.hibernate.loader.DefaultEntityAliases" returns the correct user established result set aliases when using a standard "id" property. Ufortunately, when using a "composite-id" line 37 always returns null, which results in hibernate trying to alias the column names. I'm not sure if this is a bug, or my improper usage (probably the ...

44. composite-id and normal id property conflicted in Query    forum.hibernate.org

composite-id and normal id property conflicted in Criteria Query I used composite-id as the unique identifier of POJO,and Role class has another field named as 'id'.When I create a Criteria query,and set 'id' to query,hibernate will generated error sql statement which use composite-id as parameter. Hibernate version:3.03 Java code: Code: package test.enkisoft.db; import java.io.Serializable; public class OID implements Serializable, Comparable { ...

45. ** Query of composite element fields in HQL **    forum.hibernate.org

Need help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version: 3 Mapping documents: A Message contains a list of MessageFields. I have ...

46. Trying to query with object having composite key    forum.hibernate.org

Author Message ggaviotis Post subject: Trying to query with object having composite key Posted: Fri Jun 24, 2005 7:07 am Newbie Joined: Fri Jun 24, 2005 4:24 am Posts: 1 Hi, I am having problem to query on a persistent class using as a parameter an object that has a composite key. It seems that the problem is the ...

47. named sql query - problem with composite-id    forum.hibernate.org

-Hibernate3- Hello, I'm try to perform a named sql-query that returns a bean which is mapped with a composite-id. For example I have a class Person with name,surname and email. And [name,surname] is the key of the object. So I have a class named KeyPerson with 2 attributes : name ans surname. THen my class Person has 2 attributes: the keyPerson ...

48. question on composite id ans query    forum.hibernate.org

Hello, I have a question about composite id. I used middlegen to generate the hbm and java file. I have three tables with below relationship: profile_skill: profile_skill_id_no, skill_skill_id_no (both primary keys) skill: skill_id_no (prim key) lob_skill: lob_lob_id_no, skill_skill_id_no (both prim keys) profile_skill.skill_skill_id_no references to skill.skill_id_no lob_skill.skill_skill_id_no references to skill.skill_id_no profile_skill: has composite id as lob_profile_id_no and skill_skill_id_no lob_skill : has composite ...

49. How to query a composite key class    forum.hibernate.org

50. HELP! HELP! URGENT!How to query a composite key class    forum.hibernate.org

true true

51. Query problem - Composite key    forum.hibernate.org

I have a major problem that I need your help on: Here's one of my table of my database Table Event -------------- sid cid signature timestamp PK (sid, cid) FK1 (signature) FK2 (sid) I used middlegen to reverse engineer the database to POJO and ended up with 2 classes (Event.java and EventPK.java) I'm trying to query the table Event and retrieve ...

52. Is it now possible to query composite-elements?    forum.hibernate.org

List ls = dataManager.getSession().createFilter( user.getUserAttributeValues(), "where this.userAttribute.name = ?" ). setString( 0, "UserAttribute0" ).list();

53. Query works, but access by composite-id does not    forum.hibernate.org

Assortment t = new Assortment(); t.setAssortNo(new Integer(80)); t.setClientBpCd("0009"); t.setClientOdsCd("V"); t = (Assortment) sess.load(Assortment.class, t);

54. Criteria Queries for class having composite key    forum.hibernate.org

Hi All , I am using Hibernate 3.0 . The back end database is Oracle 9.0 i I have problem wih Criteria Query . The scenario is , i want to fetch records from table which has composite key . The class corresponding to this table is InvoiceCharge. I have mapping documents like thiis ..................... InvoiceCharge ---------

55. criteria api query on composite-element    forum.hibernate.org

56. Queries on composite-id - help needed a.s.a.p    forum.hibernate.org

Hi, I have 3 tables : 1. Documents - pk :document-id 2. Attributesets - pk:attribute-id and a connecting table: 3. DocumentAttributesets - pk: document-id & attribute-id I have generated the mapping files & classes by MyEclipse plugin. The DocumentAttributesets mapping file: DocumentAttributesetsKey class contains the ...

57. Example queries with composite id    forum.hibernate.org

58. Query composite id    forum.hibernate.org

Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message noone Post subject: Query composite id Posted: Tue Sep 13, 2005 3:34 pm Regular Joined: Thu Sep 23, 2004 11:53 am Posts: 83 Try to execute a query where the property I am restricting is a ...

59. How to query the object by the composite primary?    forum.hibernate.org

I have the class which primary key is composed of two attribute. How to query it by the user id and the group id? The following is the source code. public class GroupMembersVO implements Serializable{ private GroupMembersVOPK groupMembersVOPK; private int revision; private UserAccountVO userAccountVO; private UserGroupVO userGroupVO; public GroupMembersVO() { groupMembersVOPK = new GroupMembersVOPK(); } public void setGroupMembersVOPK(GroupMembersVOPK groupMembersVOPK) { this.groupMembersVOPK ...

60. composite ids with named queries    forum.hibernate.org

I have a problem using the the composite id and would like to get some help please. I am using named queries and want to join 2 tables. I have created a name query in TableA which is joining to TableB. The problem I am having is when using an individual key of the composite id, I am unable to get ...

61. Composite-Element criteria query    forum.hibernate.org

TWR_SEQ_RETAIL_LOCATION_GROUP

62. how to construct a HQL query when using a composite key    forum.hibernate.org

hi (from a newbie), Can someone help me as to how to construct a HQL query when there is a composite key involved. It is a simple table with the following 2 fields as primary keys: table = Auction pkey 1 = auction_number pkey 2 = lot_number i used hibernate console to generate POJOs. The 2 keys become part of a ...

63. How to query based on composite element / parent property    forum.hibernate.org

I have a problem understanding the operation of composite-element in queries. I have an object MRWObject that references parents and children that are collections of the same MRWObject. In order to record the date of association between a parent and child, I have used composite-element - this works fine until I come to write queries where I wish to restrict the ...

64. How to query composite key    forum.hibernate.org

Hi Folks, I have a help table, a primary key consists of contextid field and appid field. But I don't know how to query. the id is passed to query Help.HelpId id = new Help.HelpId(new Integer(1), new Integer(99)) ; q = sess.createQuery("from Help where hp.id = :id" ) .setParameter("id", searchKeyObj); But I got this error. Hibernate: select help0_.ContextID as ContextID, help0_.AppID ...

65. composite-id in named queries    forum.hibernate.org

I have a class with composite id , and mapping is i am executing sql to return a result set. how should i map in for composite-id ? following doesn't work ...

66. Mapped composite-id: strange behaviour in queries    forum.hibernate.org

snpesnpe wrote: remove it and make class I can't make a class since we're mapping the same class twice here. In one case only the id is primary key, in the other case (for historization purposes) we need a composite key containing both id and validFrom. The fact that a mapped composite-id works like a kind of overlay appealed to me. ...

67. query on composite-Id containing wildcards    forum.hibernate.org

Hi Folks, I try to generate a query with hibernate criterias on a mapping with a composite-id. I set the criteria as I think it should be, but the query then returns nothing :-( As I can see on the relevant part of my sql-statement (just the where-clause) hibernate tries to set all three values of the composite-id whereas I only ...

68. Query with join on composite element?    forum.hibernate.org

Hibernate version: 3.1.3 I have a many-to-many mapping between my domain classes Organization and Person. Because i need an additional attribute in their association table i use a composite-element with a nested many-to-one mapping (see below for mapping files). I want to build a query to retrieve all persons for a certain organization_id. But now i'm really lost how to form ...

69. Problem in query that use a composite-id    forum.hibernate.org

70. Query on a composite element    forum.hibernate.org

I've a little problem with a SELECT query on a composite field ( is the table primary key too). The field is like the following on hibernate mapping file ...... ..... The query that i'm using is SELECT a FROM MyObject a WHERE a.Field1 = :username and ...

71. Composite-Key Join Query Is Not Working Correctly    forum.hibernate.org

Newbie Joined: Tue Jun 27, 2006 12:11 pm Posts: 2 Hi, I am using Hibernate 3.0. I am facing really weird problem. We are using oracle 9i for data store. For some tables composite-key FetchMode.JOIN query works fine but for some others it doesn't. I am including both examples below. Below are the tables which works fine with composite key ------------------------------------------------------------------ ...

72. query returns null - composite with association    forum.hibernate.org

Hibernate version: 3.1.3 Name and version of the database you are using: mySQL 5.0 Mapping documents: ... ......

73. composite id hql or criteria query matching a list    forum.hibernate.org

...

74. Using Criteria query with composite-id columns    forum.hibernate.org

Hi I am using Hibernate 3.1 and Weblogic 8. I have the following Hibernate Mappings

75. HQL queries using objects with composite keys    forum.hibernate.org

... ...

76. Querying on Composite key    forum.hibernate.org

Hi, I have a composite key mapping with a table's primary key. I want to write query either query.hbm or use criteria and select records with restriction(filter criteria) on one of the primary key column. Suppose A table has APk as primary key having x and y columns then i am writing as below [code] Criteria criteria = session.createCriteria(A) criteria.add(Restrictions.eq("comp_key.x",new Integer(1))); ...

77. query a property from a composite-element    forum.hibernate.org

78. Querying composite object in set    forum.hibernate.org

Hi, I have the following issue, I have object A, Which contains a Set of Object B, B contains object C. In the mapping file of object A I've put a namedQuery, I need to return object A where A.attribute =: xxx and C.attribute := xxx. So I have to return object A which depands on a filter of object A.attribute, ...

79. Using Query By Example when i work with Composite Keys    forum.hibernate.org

Hi, I am tyring to use QBE. My class structure is like the one below: When i use QBE by se ExoticCurrencyId exoticCurrencyId = new ExoticCurrencyId(originCountry, currency); ExoticCurrency exoticCurrency = new ExoticCurrency(exoticCurrencyId); Example anExample = Example.create(exoticCurrency); ...

80. composite key + jpa query    forum.hibernate.org

I have a database that I can't change It's structure and need to query over tables with composite keys I'm trying to use the documentation strategy : I have a fee pojo class named Fee and an Iten pojo class The last one has a composite key with two atributes: Fee and ItemFee I created a class named ItemPK and added ...

81. querying for composite key    forum.hibernate.org

thank you. So when dealing with hibernate columns that define the table should not be a composite key? That kind of goes against ER database, correct? Ie. I have a table where the three columns define its primary key, how should I change this to be hibernate complian then? create a unique_id and disregard the other three columns as beinga composite? ...

82. how to hql query a composite primary key    forum.hibernate.org

Hey, My question is how to query in HQL a composite primary key using @EmbeddedId. I have the embeddable class ClubPk: ___________________________________________________________ @Embeddable public class NamePk implements Serializable{ String FirstName; String LastName;............. ___________________________________________________________ And the class where it is embedded as the composite primary key: __________________________________________________________ public class Group implements Serializable { NamePk CompKey; .......... public Group(){} @EmbeddedId public NamePk getCompKey() ...

83. How to query with condition on composite-map-key?    forum.hibernate.org

... ...

84. Querying on composite key's foreign key props    forum.hibernate.org

@Entity public class Team { @Id private Long id; @ManyToOne @JoinColumn(name="division_id") private Division division; ... } @Entity public class Division { @Id private Long id; ...

85. Composite key with query    forum.hibernate.org

I used Hibernate tools to generate db code. I have a table called Transaction. The reverse engineering created 3 classes: 1. Transaction.java 2. TransactionId.java for my composite key 3. TranasactionHome.java My question is how can I retrieve my Transaction objects that include all of the primary key data as well? Right now I can query for objects, but not for primary ...

86. Issue select query based on composite user type    forum.hibernate.org

I have a composite user type Currency with 2 columns: amount and currency_code. I'm trying to select all records where amount is greater than 0 regardless of currency_code - and I don't see any way to do that. I tried this query: "select * from Product where cost.amount > 0" as well as Criteria query: crit.add(Restrictions.gt("cost.amount", 0)) and both failed with ...

87. Problem on HQL Select query with composite-id?    forum.hibernate.org

Author Message mumbaimuru Post subject: Problem on HQL Select query with composite-id? Posted: Sun Nov 30, 2008 2:10 pm Beginner Joined: Wed Nov 19, 2008 6:39 am Posts: 44 Location: Mumbai, India Hi, I have two tables with following structure in MySQL database and following codes. I want to select the payment details where payerid=1. I am trying to ...

88. Problem creating query involving a composite key    forum.hibernate.org

Hello, I'm having trouble writing a simple join query between two tables. Note that I inherited a db with composite keys on all tables that include: int id in classId So all of my entity classes start out like this: Code: @Entity @Table(name = "rp.batch") public class HBatch { private HBatchId key; public HBatch() ...

89. Problem querying on the composite key columns    forum.hibernate.org

Newbie Joined: Sun Apr 05, 2009 9:28 pm Posts: 3 Hibernate version: 3.3.1.GA Mapping documents: ...

90. parametrized query with composite PK    forum.hibernate.org

Hello, I'm using Java Persistence and Jboss. I have an entity with a composite primary key (pk.root, pk.extension) and when I try to query for multiple istances of the pk I get a "java.sql.sqlexception: No value specified for parameter 4" error. The EJBQL query has the following where clause: WHERE Entity.pk = ?1 or Entity.pk = ?2 Then I set the ...