Top "Nativequery" questions

JPA concept that allows queries in your native database syntax (instead of JPQL)

JPA passing list to IN clause in named native query

I know I can pass a list to named query in JPA, but how about NamedNativeQuery? I have tried many …

jpa arraylist in-clause nativequery
Conversion of java object to Date or DateTime

I have a query of inner join tables: List<Object[]> resultList = entityManager.createNativeQuery(SOME QUERY).getResultList(); When i …

java date datetime inner-join nativequery
How to truncate a table using Doctrine 2?

I assume that I need to build a native query to truncate a table using Doctine2. $emptyRsm = new \Doctrine\ORM\…

php mysql doctrine-orm nativequery
Spring Data JPA delete native query throwing exception

I have a User entity and a Role entity. The relationship is defined like this: @OneToMany @JoinTable(name="USER_ROLES", …

java jpa spring-data-jpa nativequery
How to get multiple columns from table using JPA?

For example I have a table as Student it's contain columns like id, name, age I am reverting particular column …

java hibernate jpa eclipselink nativequery
createNativeQuery set parameter

I have the following that contains a NativeQuery where i need to set a parameter but somothing is wrong beacause …

jpa parameter-passing nativequery
JPA Data Repositories with SqlResultSetMapping and native queries

I was stuck with the following situation: My entities are related to each other, but in such a way that …

java spring spring-data-jpa nativequery sqlresultsetmapping
Set list parameter to native query

I would like to set parameter to a native query, javax.persistence.EntityManager.createNativeQuery Something like that Query query = em.…

java sql jpa nativequery
jpa and native queries

I faced with a strange thing with native queries: If I'm trying to use named native query like the following @…

jpa nativequery
How can I use MySQL assign operator(:=) in hibernate native query?

I'm using Hibernate. I wrote some native query because I need to use sub select statement. Query looks like this: …

java mysql hibernate nativequery