jpql

相关标签：javascript jquery android 多少钱 iPhone

query.setMaxResults() causes problems on toplink

I am using JPA (toplink) and trying to restrict开发者_开发问答 the number of rows returned by a JPQL query, so I\'ve used Query.setMaxResults method, but It throws the following error:[详细]

2023-01-29 15:46 分类：问答
Adding IN clause List to a JPA Query

I have built a NamedQuery that looks like this: @NamedQuery(name = \"EventLog.viewDatesInclude\", query = \"SELECT el FROM EventLog el WHERE el.timeMark >= :dateFrom AND \"[详细]

2023-01-29 12:27 分类：问答
How to write Order by expression in JPQL

PostgreSQL and MySQL offers to write expression into ORDER BY clause in SQL query. It allows to sort items by some column but the special values are on the top. The SQL looks like this one. ( works in[详细]

2023-01-29 12:26 分类：问答
Hibernate/HQL/JPQL: what's wrong with a CASE WHEN ... THEN NULL ELSE ... END (ClassCastException)?

I have the following JPQL/HQL snippet in a SELECT ... MAX(CASE WHEN scf.finalScore = 20 OR scf.finalScore = 0 THEN NULL ELSE scf.finalScore END) AS hi,[详细]

2023-01-29 04:14 分类：问答
Need help on Hibernate and JPQL syntax

I am new to play framework and hibernate , I have a simple problem that I am unable to solve public static void listMembers(int page,int pageSize,String[] fields,String[] values) {[详细]

2023-01-29 01:36 分类：问答
Hibernate JPQL/HQL: bug with aggregate functions showing results of wrong table/entity joined twice (using HSQLDB only)?

I have the following tables: CREATE TABLE Rosters ( id INTEGER NOT NULL, club_abbr VARCHAR(10) NOT NULL, ordinal_nbr SMALLINT,[详细]

2023-01-29 01:35 分类：问答
multiple IN conditions in JPQL

How can I express the following SQL in JPQL: select * fr开发者_Go百科om table where ( ( table.col1 , table.col2) in[详细]

2023-01-28 16:35 分类：问答
EJB/JPA: Is it called JPQL or EJBQL?

Is the JPA query language called JPQL or EJBQL? 开发者_C百科I keep reading about them here and there, JPQL seems to appear slightly more often, but frameworks like JBoss Seam use EJBQL everywhere, so[详细]

2023-01-28 11:28 分类：问答
Jpql selecting the one maximum row from each group

I am relatively new to JPA and I would like to solve the following problem using jpql exclusively (note that the implementation I am using is Datanucleus): I have a table of versioned entities, and I[详细]

2023-01-27 02:39 分类：问答
OpenJPA: how to construct a GROUP BY query with a group count

In JPQL I want to construct the equivalent query to this: select *, count(*) as finger_count from page_delta_summary[详细]

2023-01-26 17:53 分类：问答