[ https://issues.apache.org/jira/browse/OPENJPA-2845?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17250977#comment-17250977 ]
Romain Manni-Bucau commented on OPENJPA-2845: --------------------------------------------- Without a reproducer it will be hard or even almost impossible but some caching - either actual cache or reuse of some JPA component instances - can make the resultset partially bypassed in some particular configurations. Without more information it is the main cause I can think about. > JPA intermittently giving null resultset even DB has value > ---------------------------------------------------------- > > Key: OPENJPA-2845 > URL: https://issues.apache.org/jira/browse/OPENJPA-2845 > Project: OpenJPA > Issue Type: Bug > Reporter: Deepesh > Priority: Critical > > Data is getting fetched from Oracle DB but while mapping it back to JPA > object, it gets null. This can be seen through Dynatrace that SQL returns row > result but JPA resultset is getting null. > Query is quite simple and just fetching the record based on primary key. > Although another field is being passed in where clause with primary key but > it returns single row. > Also, same jpa query provides results (same input) several times before. > We enabled jpa logs and see query runs fine on DB. > Is there any thresold due to which JPA not working as expected? Any > suggestions to handle this ? -- This message was sent by Atlassian Jira (v8.3.4#803005)