Questions tagged as 'jpql'

Tagged questions
1
answer

How to use SQL instead of JPQL?

This week I had a problem, I was able to build a Java API using JPQL , but my Java API is not yet complete and I can already predict that in the future my project will need reporting, imagine doing in JPQL? It's going to be a hell of a lot!...
asked by 09.03.2018 / 13:37
0
answers

Change JPA / JPQL record [closed]

I'm doing my first WEB project and I have a question about using JPA / JPQL / MERGE. The question is: I need to change a record of a table, I've created a dataTable that returns me a list of Open Tickets. This table is populated by my V...
asked by 14.12.2017 / 02:55
1
answer

query model.vo a solution with jpql and subqueryes

I have the following query in MySQL wanting to pass to JPQL and I am doubtful in the syntax: SELECT a2.produto , a2.descricao, a2.quantidade_recente, Soma from (SELECT p.codigoProduto, sum(p.quantidad...
asked by 30.06.2017 / 19:58
1
answer

JPQL query help

I am trying to return a group query along with the product entity returning all the data from the product table and the sum of the quantity. I get an error that is as follows: Exception in thread "main" java.lang.IllegalArgumentException: Type...
asked by 27.06.2017 / 18:46
1
answer

How to bring a List in a JPQL query with constructor

Good afternoon, I am doing a jpql query to bring a VO (Value Object) with some information, one of which is a List . This list is in the opCambio object, however, it is returning this error: Log: [ERROR] - 01/04/2017 19:16:26 - Run...
asked by 20.03.2017 / 17:31
0
answers

How to do query involving more than one table (JPA) using JPQL

Hello, I have a query using SQL, I am now changing the project using JPA and would like to change queries consistently with JPA. public void gerarConsulta() { jTResultado.getColumnModel().getColumn(0).setMaxWidth(50); jTResultado.g...
asked by 31.03.2016 / 08:30
0
answers

Use SELECT NEW JPQL to populate DTO in an @OneToMany relationship

Talk to people !! I'm trying to popular my DTO object, whose main object has a OneToMany relationship. Here is the code for your observations: ## Mapped Object: public class Usuario implements Serializable, EntidadeBase { private static...
asked by 24.04.2016 / 14:31
1
answer

Error with unexpected token JPQL

I made a select JPQL but I'm having this error: Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: where near line 1, column 151 [select pes, pEnd from digifred.model.global.Pessoas pes, digifred.model.global.Pes...
asked by 12.01.2018 / 17:16
1
answer

JPQL Query - SQL

Good evening. I have a bean, which has an init () method. One of the goals of this init is to bring the cycle that was opened according to the course of that user, ie If there is no cycle or evaluation process involved with the course of that...
asked by 31.10.2015 / 03:27
1
answer

SQL / JPQL Query

Friends, good afternoon. I have a table in the database called Questao Inside the table I have two columns that are ID and Question . I have a filter that I can not specifically bring only code and asks because the method return is an ob...
asked by 13.10.2015 / 21:06