Spring Boot :Deleting a blog posts shared tag only when the last post that has it is deleted

i have a dilemma trying to get a solution for this issue. I am having 2(can be any number) blog posts that share the same tag. I have a set of tags for each added post so duplicate tags are not …

Spring Data JPA Distinct Returning Duplicate Values

In my Spring boot application I have a query which should return a distinct List of Focus’ (works perfectly in MySQL) @Query(value = “SELECT DISTINCT * FROM Focus F ” + “…

Filtering Table using BETWEEN but data are not showing up [closed]

I am trying to filter my table by Month using combobox but whenever I select October nothing shows up even the timestamp from my database is October. Here is my code: String monthSelection = …

Communications link failure connecting spring boot app to aws aurora

I am trying to connect the spring boot application I have created locally to an aws serverless aurora database. I have added the maven dependency: mysql&…

How to search in table using multiple key and value?

I am trying to implement multiple select search using angular and spring boot. I got the select data form frontend in key and value pair. How can i write query to get the data from table? I am getting …

In Jooq, how to make the “delete” statement return the deleted records?

In my project, there are 2 tables, orders and order_payments. The latter is a join table with 2 columns, order_id and payment_id. I didn’t use FK for efficiency sake. When I delete some orders from …

Concurrent requests transaction to prevent unwanted persistence

I am trying to get my head around how to approach what initially seems a “simple” problem. I have UserAccounts that can have MANY Purcahses BUT business logic dictates can only have one …

Spring Data JPA @Convert throws Operations Not Allowed exception

I am using @Convert annotation to encrypt and decrypt certain columns. @Data @Entity @Table( name = “tlp_task_comment” ) public class TaskCommentModel implements Serializable { @Id @…

Data parsed correctly from server but Android recyclerview is empty

I made an online music player with PHP code server and I have no problem fetching data in JSON format. I have a problem with the Android side where no data is shown in my recyclerview although I …

JPA repository save method inserts NULL values in MySQL instead of values provided by json request

I’m new to spring. I want to add a row in MySQL database by a post request using POSTMAN via Spring boot project. I send a post request with a json body providing neccessary values for the table. but …