pkainulainen / spring-data-jpa-examples

Test With Spring Course

If you are struggling to write good automated tests for Spring web applications, you are not alone! I have launched a video course that describes how you can write automated tests which embrace change and help you to save your time (and nerves).

Spring Data JPA Tutorial

This repository contains the example applications of my Spring Data JPA tutorial. The READMEs of the examples provide more information about the application in question.

spring-data-jpa-examples's Issues

No qualifying bean of type [net.petrikainulainen.spring.datajpa.repository.PersonRepository]

Hello,

I am getting the following error:
Caused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type [net.petrikainulainen.spring.datajpa.repository.PersonRepository]

It is caused at RepositoryPersonService at line 26-27

@resource
private PersonRepository personRepository;

The bean with concrete class of interface PersonRepository is available in the Bean-container.

how to use Auditing in JPQL

Hello, I am always looking for how to use the @LastModifiedDate annotation of the spring-boot-jpa auditing function when using @query to execute modify SQL statements, but I have not found a solution. If you have a good solution, I hope you can help answer it. Thank you

CsrfHeaderFilter class name

The name of file CSRFHeaderFilter.java but in it, the class declaration, CsrfHeaderFilter is used. I couldn't compile&run query-method project. I renamed the file name CSRF.... to Csrf and it works.

how to deal with N+1 problems.

When they are one-to-many or one-to-one association, I can deal with it with 'join fetch' or 'EntityGraph'. While I created entities without these association,like the following two classes:
class A{ private long aid;private long bid }
class B{ private long bid..}
A is not containing B object,they are associated with property just like views of database tables.
In this case,how can I avoid the N+1 scenario.
as the following jpql:
'select new com.fooww.recommend.individual.sz.mysql.entity.dto.UserHouseAndHouseRentDTO(cu,hr,chr) from CompanyUser cu join UserHouseRent chr on cu.pkUser = chr.pkUser join HouseRent hr on hr.pkHouse = chr.pkHouse'

Where can I find "findDistinctByTitle"

Nice article and example.

I can't find distinct that you wrote on your blog with "findDistinctByTitle".

Thanks

how to pass jpa-named-queries.properties location from command project, rather default meta-inf

Hello,

How can we pass jpa-named-queries.properties location from command prompt? for example, we are able to pass spring boot configuration file using this property --spring.config.location. Like that, anyway to pass jpa-named-queries.properties location

Qperson

Where is Qperson modal occurring error

Fix RepositoryPersonServiceTest

spring-data-jpa-examples/tutorial-part-eight/src/test/java/net/petrikainulainen/spring/datajpa/service/RepositoryPersonServiceTest.java

Line 156 in 05e1e36

assertEquals(expected.getLastName(), expected.getLastName());

Should be assertEquals(excepted.getLasName(), actual.getLastName());

How to used repository classes for same method twice

Lets say I've following method. Supposed I may have many record for single UserId?

public interface StudentRepository extends CrudRepository<Student, String> {   
   List<Student> findByStudentId(String StudentId); // used generic purposes
   List<Student> findByStudentId(String StudentId); // for getting last updated record for this StudentId
}