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 = …
Tag: mysql
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: As well as created an application.properties file: I have also created a VPC inbounds group for the db to allow incoming traffic from my IP address. My Issue is th…
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 the data like this {“groom_Bride”:”groom”,”ageFrom”:”18″,R…
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 orders table, I need to delete the related records from payments table based on the order_id field. So, af…
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 Purchase in a PurchaseState.IDLE state (a field on the entity). A purchase is IDLE when first created. I have a …
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 initialized it correctly. Please help me to find out what’s wrong. Here’s my code: MainActivity: ListAd…
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 when I check the table I see that NULL values are inserted in table. Can you please help me prevent inse…
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 a common code and there are differing SQL syntax between HSQLDB and MySQL and more ridiculously, the HSQLDB c…
Execute query with MySQL GET_LOCK function in Hibernate
My application uses Hibernate as ORM. I am trying to execute few mysql locking function within my application like GET_LOCK, IS_FREE_LOCK, RELEASE_LOCK (https://dev.mysql.com/doc/refman/5.6/en/locking-functions.html). However I am running into following issue: Here is my Dao code: I am not sure how to execute…