HSQL database user lacks privilege or object not found error

by

As said by a previous response there is many possible causes. One of them is that the table isn’t created because of syntax incompatibility. If specific DB vendor syntax or specific capability is used, HSQLDB will not recognize it. Then while the creation code is executed you could see that the table is not created for this syntax reason. For exemple if the entity is annoted with @Column(columnDefinition = "TEXT") the creation of the table will fail.

There is a work around which tell to HSQLDB to be in a compatible mode
for pgsl you should append your connection url with that

"spring.datasource.url=jdbc:hsqldb:mem:testdb;sql.syntax_pgs=true"

and for mysql with

"spring.datasource.url=jdbc:hsqldb:mem:testdb;sql.syntax_mys=true"

oracle

"spring.datasource.url=jdbc:hsqldb:mem:testdb;sql.syntax_ora=true"

note there is variant depending on your configuration
it could be hibernate.connection.url= or spring.datasource.url=
for those who don’t use the hibernate schema creation but a SQL script you should use this kind of syntax in your script

SET DATABASE SQL SYNTAX ORA TRUE;

It will also fix issues due to vendor specific syntax in SQL request such as array_agg for posgresql

Nota bene : The the problem occurs very early when the code parse the model to create the schema and then is hidden in many lines of logs, then the unitTested code crash with a confusing and obscure exception “user lacks privilege or object not found error” which does not point the real problem at all. So make sure to read all the trace from the beginning and fix all possible issues

Related Contents:

  1. Spring – @Transactional – What happens in background?
  2. Spring Boot default H2 jdbc connection (and H2 console)
  3. JPA vs Spring JdbcTemplate [closed]
  4. Spring JDBC Template for calling Stored Procedures
  5. NamedParameterJdbcTemplate vs JdbcTemplate
  6. Spring Security circular bean dependency
  7. Difference between and
  8. When using Spring Security, what is the proper way to obtain current username (i.e. SecurityContext) information in a bean?
  9. Unable to find a @SpringBootConfiguration when doing a JpaTest
  10. intellij incorrectly saying no beans of type found for autowired repository
  11. How to get active user’s UserDetails
  12. Difference between Interceptor and Filter in Spring MVC
  13. Is it possible to have empty RequestParam values use the defaultValue?
  14. How to manage REST API versioning with spring?
  15. Spring get current ApplicationContext
  16. Spring 4 vs Jersey for REST web services
  17. Overriding beans in Integration tests
  18. Where can I download Spring Framework jars without using Maven?
  19. @Cacheable key on multiple method arguments
  20. Spring cron expression for every after 30 minutes
  21. Auto-wiring a List using util schema gives NoSuchBeanDefinitionException
  22. What is the best way to return different types of ResponseEntity in Spring-Boot (Error Handling for REST with Spring)
  23. SpringBoot – making jar files – No auto configuration classes found in META-INF/spring.factories
  24. JPA: update only specific fields
  25. Why use/develop Guice, when You have Spring and Dagger? [closed]
  26. Should you set up database connection properties in server.xml or context.xml
  27. How to get access to job parameters from ItemReader, in Spring Batch?
  28. Mockito, JUnit and Spring
  29. What’s the difference between fixed rate and fixed delay in Spring Scheduled annotation?
  30. Websocket Authentication and Authorization in Spring
  31. Utility class in Spring application – should I use static methods or not?
  32. How do I get a HttpServletRequest in my spring beans?
  33. How to query data out of the box using Spring data JPA by both Sort and Pageable?
  34. How can I make Spring WebServices log all SOAP requests?
  35. Spring Boot, logback and logging.config property
  36. Get UserDetails object from Security Context in Spring MVC controller
  37. Spring MVC PATCH method: partial updates
  38. identity from sql insert via jdbctemplate
  39. Javascript long integer
  40. Spring 3.2 @value annotation with pure java configuration does not work, but Environment.getProperty works
  41. Springs XmlBeanFactory is deprecated
  42. How to enable LockModeType.PESSIMISTIC_WRITE when looking up entities with Spring Data JPA?
  43. How to disable spring-security login screen?
  44. Cannot Autowire Service in HandlerInterceptorAdapter [duplicate]
  45. Ensure that Spring Quartz job execution doesn’t overlap
  46. How to prevent overlapping schedules in Spring?
  47. In Spring what is the difference between @Profile and @ActiveProfiles
  48. Spring Boot: how to use multiple yml files
  49. Add my custom http header to Spring RestTemplate request / extend RestTemplate
  50. What is the issue with the runtime discovery algorithm of Apache Commons Logging

Leave a Comment