I am trying to set up a Criteria according to the Doctrine Docs. Unfortunately they don't tell you how to access attributes of an related Object. Let me give you an example. I have an ArrayCollec...

I have an entity where I have a field of type integer array. class User { @ElementCollection @Column(name = "`location_ids`", columnDefinition = "int[]") @Type(ListArrayType...

I am currently using criteria to retrieve the details of a user, but when trying to query the details object with the right user, I get a ClassCastException. My Criteria Code; Criteria criteria ...

I have a Criteria with: Criteria criteria= session.createCriteria(Libro.class).addOrder( Order.asc("ID") ); However, when I want to get the rowcount fail: criteria.setProjection(Projections.row...

i have a hibernate query that is dynamically put together using the criteria api. it generates queries that are unbearably slow, if executed as-is. but i have noted they are about 1000% faster if ...

Summarizing, I Have 3 entities, the main one is the entity named "Rac". It contains a List of "RacNatureza", which contain a attribute "Natureza". Rac @Entity @Table(name = "rac") public class...

I'd like to use Hibernate's criteria api to formulate a particular query that joins two entities. Let's say I have two entities, Pet and Owner with a owner having many pets, but crucially that asso...

Can someone please suggest me how to build up the following query using JPA Criteria builder API? SELECT id, name, date, version FROM public.upgradeTable order by (CAST(replace(version, '.', '')AS...

I am using the averageifs function, and have one column where I need to calculate the average if either of the criteria are true. I have tried using the OR function, and tried the curly brackets, ...

I have 2 POJO classes in Java, Answer and Collaborator, in a many-to-many relationship. class Answer { @ManyToMany(cascade = CascadeType.ALL) @JoinTable(name = "ANSWERS_COLLABORATORS", joinColum...

In MS Access 2010, I have a Query which quotes the following in the Criteria; [Forms]![frm_Add_Item_Subform].[ActiveControl].[Caption] This lets me use the "Caption" text of a Button within the ...

Is it somehow possible to create a criteria query that performs an outer join on another entity if that entity is not mapped? I know that an inner join is possible when you do a cross join and add ...

Is there a way to get the (to-be-generated) SQL from a Hibernate Criteria? Ideally, I would have something like: Criteria criteria = session.createCriteria(Operator.class); ... build up the crit...

Is it possible to query "UNION" in JPA and even "Criteria Builder"? I'm looking for examples, but so far i got no result. Does anyone have any examples of how to use it? Or would that be with na...

How do you add NOLOCK when using nhibernate? (criteria query)

Which are the fundamental criterias for using supervised or unsupervised learning? When is one better than the other? Is there specific cases when you can only use one of them? Thanks

I have been using Hibernate Restrictions in JPA 1.0 ( Hibernate driver ). There is defined Restrictions.ilike("column","keyword", MatchMode.ANYWHERE) which tests if the keyword matching the column ...

I have below table temp_tbl (postgres): ID(int) NAME(TEXT) LINKS(jsonb) -------- ---------- ------------------- 1 Name1 ["1","23","3", "32] 2 Name2 ["11","3","31", "2] 3 Name3 ["21","13","3",...

I have a query that I want to translate to Criteria API. A query select a, b, c from myTable t where t.e = ANY(?1) After java processes it (native sql query) the final query looks like this select...

I'm trying to find all entities that have some nested elements and nested elemens have collections of elements, and I need to find it by property of those collections. It would be something like t...

Consider the following JPQL query: SELECT foo FROM Foo foo INNER JOIN FETCH foo.bar bar WHERE bar.baz = :baz I'm trying to translate this into a Criteria query. This is as far as I have gotten: va...

What are the pros and cons of using Criteria or HQL? The Criteria API is a nice object-oriented way to express queries in Hibernate, but sometimes Criteria Queries are more difficult to understand/...

I’m using JPA 2.0, Hibernate 4.1.0.Final and MySQL 5.5.37. I have the following two entities … @Entity @Table(name = "msg") public class Message { @Id @NotNull @GeneratedValue(generator = "uui...

I have a question about Subquery class in jpa. I need to create subquery with two custom field, but subquery doesn't have multiselect method and select method has Expression input parameter(In quer...

I have a spring app with the user entity and the users table. I would like to get a number of all users grouped by certain fields (not per group but in total). In sql It would be: select count(*) ...