Skip to Main Content

Java and JavaScript in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JPA error in java stored procedure with Oracle 19

User_751MBNov 18 2021

We've been using JPA in java stored procedures (using loadjava) for a long time now. The code works in Oracle 12.1 and 12.2 DBs, it works when it's tested in the IDE. In Oracle 19 however we're getting errors whenever the EntityManager tries to access an entity class. The errors are
Unknown entity bean class: class <classname>, please verify that this class has been marked with the @Entity annotation.
or
An exception occurred while creating a query in EntityManager:
Exception Description: Error compiling the query [SELECT f FROM LpsDllparamfile f WHERE f.dllId = ?1]. Unknown entity type [LpsDllparamfile].
It seems, that the entity classes can't be found at runtime. Checking sys.all_objects, the classes are there and they're valid. I would be grateful for any hints about what could cause this problem and how to solve it.

Comments

Post Details

Added on Nov 18 2021
3 comments
465 views