Spring Data JPA findAll() returns empty list from MySQL db

Question

I am newbie in Spring.I am trying to get some data from a MYSQL database. Unfortunately spring data jpa returns empty list. But one record exist in db: How can I access this record?

libraryRepository.java

public interface LibraryRepository extends JpaRepository<Library, String>,LibraryRespositoryCustom{

}

LibraryController.java

@RestController
public class LibraryController {

@Autowired
LibraryRepository repository;

@Autowired
LibraryService libraryService;

@GetMapping("/getAllBooks")
public ResponseEntity<List<Library>> getAllBooks(){
    return ResponseEntity.ok(repository.findAll());
}

application.properties

# Datasource
spring.datasource.url=jdbc:mysql://localhost:3306/APIDevelopSpringBoot?useSSL=false&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root
#spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

#com.mysql.jdbc.Driver




spring.jpa.generate-ddl=true

# Jpa/Hibernate :
spring.jpa.show-sql=true
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5InnoDBDialect

#spring.jpa.database-platform = org.hibernate.dialect.MySQL5Dialect
spring.jpa.hibernate.ddl-auto = update
spring.test.database.replace=none



#Generate Logs
logging.file.name=log/application.log

#spring.profiles.active=dev

spring.main.allow-circular-references: true

Library.java

@Data
@Entity
@Table(name="LibraryDemo")
public class Library {
    
    @Column(name="book_name")
    private String book_name;
    @Id
    @Column(name="id")
    private String id;
    @Column(name="isbn")
    private String isbn;
    @Column(name="aisle")
    private int aisle;
    @Column(name="author")
    private String author;

}

Select query gives one record table has data @Tim Biegeleisen — Denisa
– Denisa, Commented Feb 27, 2022 at 14:11
You have spring.jpa.show-sql=true, so the real query that JPA sends to db must be in the log. Please try to run this query directly in the db, do you see your record there? — Vladimir.V.Bvn
– Vladimir.V.Bvn, Commented Feb 27, 2022 at 15:04
Hibernate: select library0_.id as id1_0_, library0_.aisle as aisle2_0_, library0_.author as author3_0_, library0_.book_name as book_nam4_0_, library0_.isbn as isbn5_0_ from library_demo library0_ Yes, @Vladimir.V.Bvn — Denisa
– Denisa, Commented Feb 27, 2022 at 16:35

Ajaypal Singh Gill · Accepted Answer · 2022-03-02 11:10:22Z

2

select library0_.id as id1_0_, library0_.aisle as aisle2_0_, library0_.author as author3_0_, library0_.book_name as book_nam4_0_, library0_.isbn as isbn5_0_ from library_demo library0_

As we can see in this query, it is querying on the table library_demo but you have a table named LibraryDemo. So, you have to change the name to library_demo.

answered Mar 2, 2022 at 11:10

Ajaypal Singh Gill

915 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

rishi · Accepted Answer · 2022-07-20 16:49:36Z

1

You need to have the table name as library_demo for that to work. Whatever name you give, it gets replaced with _ format.

Try this

@Entity
@Table(name = "library_demo")
public class Library {...}

answered Jul 20, 2022 at 16:49

rishi

111 bronze badge

Collectives™ on Stack Overflow

Spring Data JPA findAll() returns empty list from MySQL db

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related