[jira] [Commented] (OPENJPA-2845) JPA intermittently giving null resultset even DB has value

["Mark Struberg (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OPENJPA-2845?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17310267#comment-17310267 ] 

Mark Struberg commented on OPENJPA-2845:
----------------------------------------

[~Mundra] I fear this is caused by some special data scenario. e.g. If you say the same query sometimes returns results, sometimes not, then this might be because the selected data is different. Is this a plain table, or a clustered one, or a view?

> 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)