geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matt Hogstrom (JIRA)" <...@geronimo.apache.org>
Subject [jira] Created: (GERONIMO-985) CMP FBPK Yields an individual SELECT per column
Date Thu, 08 Sep 2005 06:36:30 GMT
CMP FBPK Yields an individual SELECT per column
-----------------------------------------------

         Key: GERONIMO-985
         URL: http://issues.apache.org/jira/browse/GERONIMO-985
     Project: Geronimo
        Type: Bug
    Versions: 1.0-M5    
 Environment: Geronimo w/Derby
    Reporter: Matt Hogstrom


I'm testing the DayTrader Application and it appears that FBPK finds are executing a single
SELECT per field in the CMP field.  Here are the SELECTs making up a single OrderEJB.findByPrimaryKey().
 This should be broken down into a single SELECT for the entity.

SELECT Q.symbol FROM QuoteEJB Q WHERE Q.symbol = s:153
SELECT Q.symbol FROM QuoteEJB Q WHERE Q.symbol = s:153
SELECT Q.companyName FROM QuoteEJB Q WHERE Q.symbol = s:153
SELECT Q.volume FROM QuoteEJB Q WHERE Q.symbol = s:153
SELECT Q.price FROM QuoteEJB Q WHERE Q.symbol = s:153
SELECT Q.open1 FROM QuoteEJB Q WHERE Q.symbol = s:153
SELECT Q.low FROM QuoteEJB Q WHERE Q.symbol = s:153
SELECT Q.high FROM QuoteEJB Q WHERE Q.symbol = s:153
SELECT Q.change1 FROM QuoteEJB Q WHERE Q.symbol = s:153




-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message