I have a function to prepare secret key for encryption and decryption using Java: However, for the old records from database, I would like to manually encrypt using a MySQL query. I have tried using the query below, but the result is different from the result by the Java application. Anyone can advise? or is there any other method to
Tag: mysql
Can’t create one_to_one relationship: Unknown mappedBy in
I try to create an OneToOne relationship between two tables but I receive errors. I used a lot of tutorials but nothing helps. For example baeldung tutorial: Project structure: The error: Gradle: application.properties: Answer You need to use a field name for mappedby, not a column name. In you case, it should be @OneToOne(mappedBy = “personalData”).
Difference between generating UUID in Java and MySQL
I need to insert random id into one table and add that id to another table as foreign key. So I am not sure how to save UUID() if I generated it in MySQL but if I generate it in Java I can just save it into a variable. I wonder are there any drawbacks if I generate it in
Check if any value in list satisfies a condition
Suppose I have the following table called Seasons: … start_month end_month … 2 6 … 3 4 … … … I need to write a query which, for a given list of months, returns all the Seasons that satisfy the condition where at least 1 month in the list is: start_month <= month <= end_month. I’ve written this query as
Universal solution to insert Userinput values in MySQL database with a priori unknown columns with Java and for example PreparedStatements
I want to insert a whole set of values in my table in MySQL (e.g. This works in MySQL Workbench 8.0 but not in my Java Code. I read the JavaDoc about prepared Statements but I didn’t find any clues on inserting values if I don’t know the type a priori. My Java code looks like this: I tried many
Error while querying tables using hibernate
I am trying to query a table called student in MySQL. This is the structure: Here is the java code which I use to query: This is the error message: Here is the image of the referenced libraries: Insertion into table is working correctly. Only querying isn’t. What is the error here? Please comment if extra information is needed. UPDATE:
Spring Boot: How to find name by a case sensitive parameter in a MySQL database
I make simple database of names. There are only three names: Adam , Arnold and Matin. And I want to get all names that contains letter “a”. I have in my repository this method: Let String letter = “a”; It returns all names(List of names), because it find some “a” or “A” in all of names. But I want to
How to change id column type already registered in the database
I’m trying to change my Id column type from int to bigInt because the records are too big and I’m getting an error if I try to store more records but I’m not sure if it’s safe to just alter the table like this: I’m using Java Springboot to create the entities and Hibernate for persistence. What’s the best way
Spring SQL: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement “; expected “identifier”, when using INSERT INTO
I am working on a Spring Web Application. I am using mysql database, but for my unit tests, I want to run them in H2 database. Test specific application properties: As you can see, my database is in MODE=MYSQL, since my data.sql is in MySQL dialect. But during initialization of of data.sql I get this error: I suppose from this
Many to many relationship doesn’t add new Entity into the table
I have two entities Book and BookTag. They are connect by many to many relationship. I try to add to the set of bookTags new BookTag entity using such service method But it doesn’t work, after I saved an entity into the mysql database it work correctly view of books_tags table after inserting a new tag to the book After