JPA concept that allows queries in your native database syntax (instead of JPQL)
Related links
Questions tagged [nativequery]
355 questions
0
votes
1 answer
Native query - how retrive only specific colums from DB for Entity
In my DB I nave a table Subject with columns
id (long)
name (String)
ifActive (0 or 1)
text (very long String)
In my web page I must display list of names of Active Subjects. So I declare the following native query in xml…
nik
- 365
- 1
- 4
- 15
0
votes
1 answer
Column type not valid with NATIVE query jpql
this is my repository:
@Repository
public interface EventRepository extends JpaRepository, JpaSpecificationExecutor{
@Query(value=" SELECT DISTINCT event.EVENT_ID "
+ "FROM EVENTS event "
+…
Innet
- 459
- 3
- 5
- 18
0
votes
1 answer
Oracle: ORA-00911: invalid character
In my code I have the following query string:
private static final String QUERY = format(
" SELECT t2.address " +
" FROM schema.table1 t1 ," +
" schema.table2 t2 ," +
…
java123999
- 6,974
- 36
- 77
- 121
0
votes
0 answers
derived table in Hibernate native query
I have a native MySQL query with several join tables, including a derived table and Hibernate is failing to parse it.
SELECT
0
votes
1 answer
Different result for @SQLResultSetMapping+Joins on multiple entities | JPA
I am running a NativeQuery with JPA that gives different results compared to running the query in an sql tool. Probably I missunderstand s.th. within the concept of @SQLResultSetMapping.
--- Overview ---
I am mapping the result to two entities, so I…
mararn1618
- 437
- 6
- 16
0
votes
0 answers
about JPA's transaction for create table and drop table with native query
anyone can help me. this is a problem i've spent much
time on it. I'm using JTA'S BMT transaction, and I'm going to execute
3 steps in same transaction:
Insert one row to a table with entitymanager;
Drop a table if it exists with native…
Jianspf
- 11
- 4
0
votes
2 answers
Paramertized Native Query returning empty resultset [parameter as comma separated string] (Using JPA)
I am trying to execute the native query using JPA 2.0.I have defined my native query in the orm.xml
Orm.xml
mhasan
- 3,703
- 1
- 18
- 37
0
votes
1 answer
How to map a NamedNativeQuery in a class that doesn't correspond to a single table
I've got a legacy SQL Server database, and they've given to me a query, which does some join between several tables.
SELECT TipoDia, ServBus, Instante, Evento, [VistaHorariosActivos].Linea, Coche, [VistaHorariosActivos].Sublinea,…
joninx
- 1,775
- 6
- 31
- 59
0
votes
1 answer
how to send a json object as a parameter to a native query calling a procedure?
hi guys my dout is i got a jsonobject and im sending this object as a parameter to a nativeQuery:
Query query = entityManager
.createNativeQuery("{call myprocedure(?)} ");
query.setParameter(1, myjson);
i got the error…
Ronaldo
- 11
- 9
0
votes
0 answers
Update native query is too slow
I am using Hibernate with native query to update a field in a table with 17000 rows in Oracle.
When I execute the query on Toad, it takes 0.5s to be executed and with the below code no finish ever.
Query query = em.createNativeQuery("UPDATE table…
Javier Oliver
- 63
- 1
- 10
0
votes
2 answers
Java native query - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
I get following error: "com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Card.findPrefix'"
for:
…
mondayguy
- 973
- 2
- 12
- 34
0
votes
0 answers
File SQL to persistence nativequery UTF8
I create a file sql from multiple query and I run file into my app, but the special character encoding fail!
My code:
InputStream fis = Main.class.getResourceAsStream("/myapp/patch/file.sql");
String sql =…
Diogo Pinto
- 11
0
votes
2 answers
Join external column to Hibernate entity using native SQL
I have a (simplified) table structure that looks something like that:
customer table:
id name
-------------------
1 customer1
alias table:
customer_id alias
-------------------------------
1 customer one
1 …
Avi
- 21,182
- 26
- 82
- 121
0
votes
1 answer
MongoDB Aggregation using NativeQuery
I'm trying to do a simple aggregation in mongoDB using NativeQuery. Is it possible? I made many tests but I can't find a solution.
The query is :
String query = "{ $match :
{ dateTimestamp :
{…
CLA_IT
- 1
0
votes
2 answers
How to make a working SQL query a native query in spring data
I created an SQL query:
SELECT ORDER_NUM, STUFF2, STUFF3 FROM table1 t1 WHERE (STUFF3 = 'poor')
AND NOT EXISTS
(SELECT ORDER_NUM FROM table2 t2 WHERE t1.ORDER_NUM = t2.ORDER_NUM)
The query works correctly and I get the desired result; However, I…
jcthomas113
- 392
- 1
- 4
- 21