You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@geronimo.apache.org by "Gianny Damour (JIRA)" <de...@geronimo.apache.org> on 2005/10/08 02:11:47 UTC

[jira] Created: (GERONIMO-1052) By default finders and selects should retrieve all CMP fields not mapped to LOB columns

By default finders and selects should retrieve all CMP fields not mapped to LOB columns
---------------------------------------------------------------------------------------

         Key: GERONIMO-1052
         URL: http://issues.apache.org/jira/browse/GERONIMO-1052
     Project: Geronimo
        Type: Improvement
    Versions: 1.0-M5, 1.0-M4, 1.0-M3, 1.0-M2, 1.0-M1    
    Reporter: Gianny Damour
 Assigned to: Gianny Damour 
     Fix For: 1.0


By default, finders and selects return the primary key fields of the queried CMP. This default behaviour is problematic in the following scenario, which seems to be rather common (e.g. dayTrader):
1. start a transaction;
2. execute a finder or select;
3. read CMP fields; and
4.  commit transaction.

At step 2, returned entities are associated to the transactional context. However, only their primary key fields are loaded. At step 3, each accessed CMP field needs to be initialized. In other words, a SQL query is executed for each CMP field.

I think that by default, all the CMP fields, which are not mapped to LOB columns should be loaded.

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


[jira] Closed: (GERONIMO-1052) By default finders and selects should retrieve all CMP fields not mapped to LOB columns

Posted by "Gianny Damour (JIRA)" <de...@geronimo.apache.org>.
     [ http://issues.apache.org/jira/browse/GERONIMO-1052?page=all ]
     
Gianny Damour closed GERONIMO-1052:
-----------------------------------

    Resolution: Fixed

This is now fixed. This was actually a TranQL SIR.

> By default finders and selects should retrieve all CMP fields not mapped to LOB columns
> ---------------------------------------------------------------------------------------
>
>          Key: GERONIMO-1052
>          URL: http://issues.apache.org/jira/browse/GERONIMO-1052
>      Project: Geronimo
>         Type: Improvement
>     Versions: 1.0-M5, 1.0-M4, 1.0-M3, 1.0-M2, 1.0-M1
>     Reporter: Gianny Damour
>     Assignee: Gianny Damour
>      Fix For: 1.0

>
> By default, finders and selects return the primary key fields of the queried CMP. This default behaviour is problematic in the following scenario, which seems to be rather common (e.g. dayTrader):
> 1. start a transaction;
> 2. execute a finder or select;
> 3. read CMP fields; and
> 4.  commit transaction.
> At step 2, returned entities are associated to the transactional context. However, only their primary key fields are loaded. At step 3, each accessed CMP field needs to be initialized. In other words, a SQL query is executed for each CMP field.
> I think that by default, all the CMP fields, which are not mapped to LOB columns should be loaded.

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