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 ext…
Tag: mysql
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 “…
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 pe…
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…
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 …
Access denied for user ‘root ‘@’localhost’ ” when connecting to mysql
I try to connect to a mysql database in a spring project and error occurred. The configuration in application.properties is In pom.xml is I’m sure the password is correct. And in cmd I tried following command and it work. So what’s the possible reason? Thx. Answer Remove the spaces on the sides of…
@Transactional – rollback on Exception not working
I am using aurora mysql for one of my project, wanted to rollback db update in update2 method in case of any exception. If I add transaction on update, getting this error Access denied for user ‘root’@’localhost’ (using password: NO). Without transactional annotation, I’m able to…
java.lang.StackOverflowError: null [Spring Boot, Hibernate]
I have two classes User.java and Address.java and there is a one-to-one bi-directional mapping between them. But when I try to get the address using the User class I get an “java.lang.StackOverflowError: null” exception. The same thing happens when I try to get the User from the Address class. Use…
How do I fix an error in Java which states that variable cannot be resolved?
I am developing a web application where there are different types of users stored in different tables of the database. I am trying to implement login validation, where the email and password are accepted. When I run the attached code, the error states that the variable rs1 cannot be resolved. I am a beginner …
Mysql problem ,cant resolve it, cant somebody help, i using java
Yoo coderrs, have problem connect and write table to my online free database. Problem is hereUnable to create requested service and Unable to make JDBC Connection 1class package sk.hibernate; 2.class persistence.xml POM Answer I just accessed your database with the following URL: (I masked the credentials). S…