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 ” + “…
Tag: mysql
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 …
Java common JDBC SQL Query strategy for Unit Test using HSQLDB and runtime using MySQL
I am developing Java Vert.x 3 application. I use HSQLDB for testing with in-memory DB and MySQL 8.0.20 for runtime. When the vertx verticle is deployed, it initializes the db and tables. Since this is …