Database error with Java Spring boot Project

Question

I am trying to run a Java Spring Boot survey project (Maven Architecture) in my local machine by following steps --

mvn clean package
connect to created jar file

java -jar target/filename.jar

Open browser and browse to localhost:8080

Project is running ok, I can input survey data, but I am getting following error while trying to show result data from database --

Although I have found that the table "stressresult" already exist in database --

What's wrong here? Can anybody kindly help?

Local Machine -->
OS: Debian 11.x 64-bit
Database: MariaDB 10.6.5
Web server: nginx
Java: Oracle JDK 17

Do any of the answers to this question help: https://stackoverflow.com/questions/7759170/mysql-table-doesnt-exist-but-it-does-or-it-should ? — Luke Woodward, Jan 01 '22 at 13:02
No, none of the thing suggested in that post solved my issue — Abhi D., Jan 01 '22 at 17:26

score 0 · Accepted Answer · answered Jan 01 '22 at 23:13

MariaDB is case-sensitive for table names by default. From your screenshot it looks like your query is trying to access STRESS.STRESSRESULT instead of stress.stressresult.

There is an option to lower-case all table names by default:

Try putting this in your config:

[mariadb]
lower_case_table_names=1

That should fix your issue.

Detailed info about this parameter can be found here: https://mariadb.com/kb/en/server-system-variables/#lower_case_table_names

This solved the issue, thanks – Abhi D. Jan 03 '22 at 03:06 — Abhi D., Jan 03 '22 at 03:06

Database error with Java Spring boot Project

1 Answers1