[ http://issues.apache.org/jira/browse/GERONIMO-985?page=all ]
Gianny Damour closed GERONIMO-985:
----------------------------------
Fix Version: 1.0-M5
Resolution: Fixed
Assign To: Gianny Damour
By default, i.e. when no prefetching group is specified for a given CMP, all
the CMP fields mapped to non LOB columns are now faulted in memory.
> 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
> Assignee: Gianny Damour
> Fix For: 1.0-M5
>
> 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
