openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "garpinc (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OPENJPA-2265) An unnecessary select statement appears to be occurring on primary key table
Date Fri, 21 Sep 2012 18:37:08 GMT

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

garpinc commented on OPENJPA-2265:
----------------------------------

Can you clarify? 

1) First of all the Key's @Id value is null so that should indicate that it's new and also
if since the object hasn't been been retrieved from db then also it's new right?
2) Are you considering this a bug and providing me with a workaround or is this the final
solution?


                
> An unnecessary select statement appears to be occurring on primary key table
> ----------------------------------------------------------------------------
>
>                 Key: OPENJPA-2265
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2265
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc
>    Affects Versions: 2.2.0
>            Reporter: garpinc
>         Attachments: testselect0.zip
>
>
> This issue pertains to http://openjpa.208410.n2.nabble.com/Can-someone-explain-this-OpenJPA-trace-td7580862.html
> Basically I'm seeing an unnecessary select statement of the form:
> 1487  test  TRACE  [main] openjpa.jdbc.SQL - <t 1920940938, conn 488448102> executing
prepstmnt 163450945 SELECT t0.otherField1, t0.uniqueField1 FROM KeyClass t0 WHERE t0.pk =
? [params=(long) 0]
> My application does millions of these so performance is suffering. I'll be attaching
a test case to illustrate. testselect0.zip

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message