Tag: jpa

How to improve JPA Query performance and response time on multiple Join tables and conditions

I am very fresh java beginner and I am trying to implement possibility to review documents. User, who belongs to a certain group can review documents of particular types that are assigned to that …

@Where with @SecondaryTable does not work with Hibernate

hibernate informix java jpa sql

There is a one-to-many relationship in my model, where the child entity is stored in two tables. @Entity @Table(name = “child1”) @SecondaryTable(name = “child2”, pkJoinColumns = { @…

how to fetch data from two tables in JPA

hibernate java jpa mysql sql

I am not able to fetch all records from two tables using the below query I have tried this but I am getting a result from one table only. I want a result of both the tables i.e, …

JPA distinct inner join with Condition on joined table

java jpa jpql oracle sql

I have two tables below: I want to get the college object with list of students of a specific department. The SQL query is below: So far I have tried the below JPA query but it is returning multiple College objects. How to return a single college object with list of students with filtered department? NOTE: I can’t alter the

How should I pass values into JPQL query?

hibernate java jpa jpql sql

I’m working on test, that will check if object had been saved into database. Test will save object with unique values and after that I want to fetch this object from database and check if it is not …

Hibernate not allowing to increment by 5 in sequence

hibernate java jpa spring-data-jpa sql

I have following db sequence Java However with Hibernate I am getting following error which says hibernate is expecting increment by 50. Why is so? Edit1 Added java code. Answer The error message is quite clear. You have enabled (or not disabled) schema validation, so when the application starts Hibernate is comparing the database with what it expects from annotations

MSSql server jpa spatial exception

hibernate java jpa spatial sql

Is it possible to use sql spatial data in jpa? I ve MS SQL Server 2014 Express Edition. I m trying to use spatial data as follows; maven (pom.xml) dependencies; db dialect; spring.jpa.hibernate.dialect=org.hibernate.spatial.dialect.sqlserver.SqlServer2008SpatialDialect entity definition; @Column(columnDefinition = “Geometry”) private Point location; creation of data; SampleEntity se = new SampleEntity(); se.setName(“Sample1”); se.setAge(30); GeometryFactory gf = new GeometryFactory(new PrecisionModel(), 4326); Point location1