HSQLDB user lacks privilege or object not found error when making select statements in Spring Boot

Question

I have gone through Stack overflow existing scenarios of why we are getting this error. I have just simple person class and a service for which I am writing a test case using embedded database. There is no problem in the code but it is not creating database.

Answer 1

I had the same problem and when I started to read the logs, I saw that, it couldn't create a table, because one of my string fields was annotated with @Column(columnDefinition = "TEXT").

So, most of the cases it can't create/select from a table, not because you don't have access to it. Just read your logs, and see what is the problem with creating/selection the table.