I have a problem with this error and I don't understand what is this.

[kindred dagger]

Hibernate: select t1_0.id,t1_0.amount,t1_0.category_id,t1_0.date,t1_0.description,t1_0.created_at,t1_0.type from transactions t1_0 where t1_0.id=?
2026-05-06T15:32:16.210+07:00 WARN 29612 --- [nio-8080-exec-1] .m.m.a.ExceptionHandlerExceptionResolver : Resolved [com.example.newfinancetracker.Exception.RecordNotFound: Id Not Found 2]

I tried to test my controller in Postman but it's always resulted in 404. I have the data and there's no issue with the controller or the url

[devout herald]

⌛ This post has been reserved for your question.

Hey @kindred dagger! Please use /close or the Close Post button above when your problem is solved. Please remember to follow the help guidelines. This post will be automatically marked as dormant after 720 minutes of inactivity.

TIP: Narrow down your issue to simple and precise questions to maximize the chance that others will reply in here.

[median sleet]

I don't know what kind of response you expect by giving this little detail

show repository / entity code, show factual db layout

[kindred dagger]

package com.example.newfinancetracker.Transaction;

import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.math.BigDecimal;
import java.time.LocalDate;

public interface TransactionRepository extends JpaRepository<Transaction, Long> {

Page<Transaction> findByType(TransactionType type, Pageable pageable);
Page<Transaction> findByCategoryId(Long categoryId, Pageable pageable);

@Query("SELECT t FROM Transaction t WHERE t.type = :type AND t.date BETWEEN :startDate" +
        " AND :endDate")
Page<Transaction> findByDateBetween(
        @Param("type")TransactionType type,
        @Param("startDate")LocalDate startDate,
        @Param("endDate")LocalDate endDate,
        Pageable pageable);

@Query("SELECT SUM(t.amount) FROM Transaction t WHERE t.type = :type " +
        "AND YEAR(t.date) = :year AND MONTH(t.date) = :month")
BigDecimal monthlySummary(
        @Param("type")TransactionType type,
        @Param("year")int year,
        @Param("month")int month
);

}

[devout herald]

Please format your code to make it more readable.
For java, it should look like this:
```​​​`​java
public void foo() {

}
​​​`​```

[kindred dagger]

this is my repo

INSERT INTO transactions
(id, amount, description, type, date, created_at, category_id)
VALUES
(1,13363900,'Monthly salary','INCOME','2026-04-21','2026-04-21 20:25:12',8),
(2,57098,'Grocery Alfamart','EXPENSE','2026-04-17','2026-03-29 20:25:12',1),
(3,38434,'Supermarket','EXPENSE','2026-03-29','2026-03-24 20:25:12',1),
(4,96482,'Lunch at warung Padang','EXPENSE','2026-04-03','2026-04-08 20:25:12',1),
(5,30622,'Grab ride to office','EXPENSE','2026-04-15','2026-04-14 20:25:12',2),
(6,279951,'GoJek trip','EXPENSE','2026-04-21','2026-04-04 20:25:12',2),
(7,185363,'YouTube premium','EXPENSE','2026-04-08','2026-04-14 20:25:12',3),

this is the db

[kindred dagger]

I'm sorry this is my first time asking in a forum so I clearly didn't know what to prepare. Please let me know if you need any other thing

[median sleet]

show Transaction class

[honest arch]

package com.example.newfinancetracker.Transaction;

import com.example.newfinancetracker.Category.Category;
import jakarta.persistence.*;
import jakarta.validation.constraints.Positive;
import lombok.Data;

import java.math.BigDecimal;
import java.time.LocalDate;
import java.time.LocalDateTime;

@Entity
@Data
@Table(name = "transactions") ```java

public class Transaction {

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;

@Positive
private BigDecimal amount;

private String description;

@Enumerated(EnumType.STRING)
private TransactionType type;

private LocalDate date;

@Column(name = "created_at")
private LocalDateTime timeStamp;

@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "category_id")
private Category category;

} ```

This message has been formatted automatically. You can disable this using /preferences.

[kindred dagger]

please check it

[median sleet]

looks ok at glance

[median sleet]

how are you running this bit

and more pointedly, are you sure you've done commit afterwards

[kindred dagger]

when I ran the spring boot everything is ok, no error but when I want to try to test it using postman the result always return 404
do you need the yml and docker-compose as well? or maybe the logs when it runs?

[median sleet]

I meant, how is this insert sql statement specifically is being executed

[kindred dagger]

I use spring-boot data.sql auto-execution and executes it during the startup

[median sleet]

and if you connect to DB using a DB client you see it all present?

[kindred dagger]

ooff I haven't tried that. Give a minute to check with pgAdmin and will return to you

[kindred dagger]

I have checked it with pgAdmin, and the data is not exist

I have the entities but no data

[median sleet]

can't tell you why data.sql isn't executing properly, not something I ever use
google tells me you might need spring.sql.init.mode=always in your properties

imo just run the insert from db client or alternatively complete rest api for saving data, and test once you have full crud in place

[kindred dagger]

thank you, let me try each of these and let you know again

[devout herald]

If you are finished with your post, please close it.
If you are not, please ignore this message.
Note that you will not be able to send further messages here after this post have been closed but you will be able to create new posts.

[kindred dagger]

@median sleet Thank you for your help it is fixed. The issue here my data.sql is actually in src/main/resources/db/data.sql by default spring boot only look for the data.sql inside resources folder so i need to move it to resources and and add the spring.sql.init.mode=always

[devout herald]

If you are finished with your post, please close it.
If you are not, please ignore this message.
Note that you will not be able to send further messages here after this post have been closed but you will be able to create new posts.