jpql
Make JPA aware of database changes
I have two Entities, Transaction and Entry. Transaction has some own data and a list of one or several Entries which consists of a debit and a credit amount. In one part of the application I n开发者_P[详细]
2023-02-04 15:06 分类:问答hibernate unexpected end of subtree when dealing with collection of basics
i have the following entity: @Entity public class AnalysisPolicy extends PersistentEntity{ private Set nodeIds;[详细]
2023-02-02 02:20 分类:问答JPA optimistic lock - setting @Version to entity class cause query to include VERSION as column
I\'m using JPA Toplink Essential, Netbean6.8, GlassFish v3 In my Entity class I added @Version annotation to enable optimistic locking at transaction commit however after I added the annotation, my q[详细]
2023-02-01 23:39 分类:问答Is it possible to convert JPQL query result with multiple Object types into JSON format automatically?
I\'m using JPA Toplink, JAX-RS, NetBean6.9 So far I successfully convert JPQL query result which is List with one object type into JSON.[详细]
2023-02-01 05:49 分类:问答Is there any JPQL analyzer?
I developed app using JPA Toplink which uses JPQL. According to my research JPA will call more SQL than what JPQL statement look like.[详细]
2023-02-01 01:57 分类:问答JPQL Order By Average from a second table
Background I have two objects persisted using Hibernate. Product and Vote. The Product object contains a list of votes, such as[详细]
2023-01-31 19:36 分类:问答Java Persistence Query Language JOIN
I have two tables : A(bigint id, ...) B(bigint id, varchar name, bigint id_A) and now I want get all rows from A which exists in B (and those rows in B have name eg Andy)[详细]
2023-01-31 10:23 分类:问答JPA native query generation with COUNT (DISTINCT obj)
please help me with JPQL Query on OpenJPA 1.2.x Here is the text of my query: select count (distinct evt) from Event[详细]
2023-01-30 15:02 分类:问答Selecting unique logins in a given time period
My SQL is a little rusty and JPQL is entirely new to me. I have a table with recorded login events, which have a user id and a time. I\'m trying to select the unique number of user id\'s present in a[详细]
2023-01-30 13:39 分类:问答Doing a query for each day in a period, turning it into one query
I have this: public Map<Day,Integer> getUniqueLogins(long fromTime, long toTime) { EntityManager em = emf.createEntityManager();[详细]
2023-01-30 12:18 分类:问答