Hey
I’ve migrated my application from Spring Boot 2.7 to 3.2 and therefore hibernate was migrated from 5.6 to 6.3. I’ve adapted code accordingly to migration documentation, I’ve also updated dialect as per documentation:
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.OracleDialect
Now when I start my application, on the first connection I get exception:
java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
https://docs.oracle.com/error-help/db/ora-01031/
but then application works fine.
From the trace logs I see that there is a query to SYS.PROPS$
SELECT VALUE$ FROM SYS.PROPS$ WHERE NAME = 'OGG_TRIGGER_OPTIMIZATION'
which fails as this account is not granted to execute selects on that object.
Any hints why this query is executed?
Thanks
Bartek