Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    Datasource used for two selectitem with different fetch operations works unexpectedly

    Hi,

    I have two selectitems. One depicting the month and other year. Both need to be fetched from database depending on what months user have subscribed.

    I have a datasource which have two fetch operations one to fetch list of years and the other to fetch the months available for one of the years in the year selectitem. The rows are very minimal, not more than 10 and I would want it to funtion as local. I haven't implemented the other functionality like changing the months when year changes etc.

    I see when I initially fetch available years to populate the year selectitem and then fetch available months for one of the year in the months selectiem, but when I try using the year dropdown and then try using month dropdown it goes for another fetch operation. It keeps happening while I try between these components. Using one causes other to make a fresh fetch request.

    Can somebody demistify why this behavior.

    Code:
     final SelectItem fromYear = new SelectItem();
            final SelectItem fromMonth = new SelectItem();
    
    fromYear.setName("fromYear");
            fromYear.setTitle("From");
            fromYear.setDefaultToFirstOption(true);
            fromYear.setWidth(75);
            fromYear.setWrapTitle(false);
            fromYear.setColSpan(1);
            fromYear.setOptionDataSource(DataSource.get("dateRange"));
            fromYear.setOptionOperationId("dateRangeYear");
            fromYear.setValueField("YEAR_NUM");
            fromYear.setFilterLocally(true);
    
      fromMonth.setName("fromMonth");
            fromMonth.setShowTitle(false);
            fromMonth.setType("comboBox");
            fromMonth.setWidth(75);
            fromMonth.setDefaultToFirstOption(true);
            fromMonth.setWrapTitle(false);
            fromMonth.setColSpan(1);
            fromMonth.setOptionDataSource(DataSource.get("dateRange"));
            fromMonth.setOptionOperationId("dateRangeMonth");
            fromMonth.setValueField("MONTH_SHORT_NAME");
            fromMonth.setFilterLocally(true);
    DS.XML FILE

    Code:
    <DataSource ID="dateRange" table="CLIENT_VALID_DATES" serverType="sql" dbName="Oracle" showPrompt="false"
                qualifyColumnNames="false">
        <fields>
            <field name="CLIENT_ID" type="number" required="false" title="CLIENT_ID"/>
            <field name="YEAR_NUM" type="number" required="true" title="YEAR_NUM"/>
            <field name="MONTH_NUM" type="number" required="false" title="MONTH_NUM"/>
            <field name="MONTH_SHORT_NAME" type="text" required="false" title="MONTH_SHORT_NAME"/>
            <field name="MONTH_ID" type="number" required="false" title="MONTH_ID"/>
            <field name="QUARTER_ID" type="number" required="false" title="QUARTER_ID"/>
            <field name="PRODUCT_ID" type="text" required="false" title="PRODUCT_ID"/>
        </fields>
    
    <operationBindings>
            
            <operationBinding operationType="fetch" operationId="dateRangeYear">
                <selectClause>
                    DISTINCT YEAR_NUM
                </selectClause>
                <tableClause>
                    CLIENT_VALID_DATES
                </tableClause>
                <whereClause>
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB'
                </whereClause>
                <orderClause>
                    YEAR_NUM DESC
                </orderClause>
            </operationBinding>
            <operationBinding operationType="fetch" operationId="dateRangeMonth">
                <selectClause>
                    DISTINCT MONTH_NUM,MONTH_SHORT_NAME
                </selectClause>
                <tableClause>
                    CLIENT_VALID_DATES
                </tableClause>
                <whereClause>
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB' AND YEAR_NUM=2011
                </whereClause>
                <orderClause>
                    MONTH_NUM ASC
                </orderClause>
            </operationBinding>
        </operationBindings>
    
    </DataSource>
    THANKS.

    #2
    Please find the log for this:

    Code:
    
    === 2011-11-19 00:27:32,424 [l0-0] DEBUG XML - Parsed XML from C:\Users\sg0209257\.IntelliJIdea10\system\gwt\mi-implementation.mi-implementatione2829505\mi-implementation.c3fae748\run\www\ds\dateRange.ds.xml: 4ms
    === 2011-11-19 00:28:35,338 [l0-0] INFO  RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
    === 2011-11-19 00:28:35,385 [l0-0] DEBUG XML - Parsed XML from (in memory stream): 4ms
    === 2011-11-19 00:28:35,391 [l0-0] DEBUG XML - Parsed XML from C:\Users\sg0209257\.IntelliJIdea10\system\gwt\mi-implementation.mi-implementatione2829505\mi-implementation.c3fae748\run\www\MarketIntelligence\sc\system\schema\List.ds.xml: 3ms
    === 2011-11-19 00:28:35,401 [l0-0] DEBUG RPCManager - Processing 1 requests.
    === 2011-11-19 00:28:35,465 [l0-0] DEBUG RPCManager - Request #1 (DSRequest) payload: {
        criteria:{
        },
        operationConfig:{
            dataSource:"dateRange",
            operationType:"fetch",
            textMatchStyle:"startsWith"
        },
        componentId:"isc_PickListMenu_0",
        appID:"builtinApplication",
        operation:"dateRangeYear",
        oldValues:null
    }
    === 2011-11-19 00:28:35,489 [l0-0] INFO  IDACall - Performing 1 operation(s)
    === 2011-11-19 00:28:35,529 [l0-0] DEBUG AppBase - [builtinApplication.dateRangeYear] No userTypes defined, allowing anyone access to all operations for this application
    === 2011-11-19 00:28:35,529 [l0-0] DEBUG AppBase - [builtinApplication.dateRangeYear] No public zero-argument method named '_dateRangeYear' found, performing generic datasource operation
    === 2011-11-19 00:28:35,530 [l0-0] INFO  SQLDataSource - [builtinApplication.dateRangeYear] Performing fetch operation with
    	criteria: {}	values: {}
    === 2011-11-19 00:28:35,587 [l0-0] INFO  SQLWhereClause - [builtinApplication.dateRangeYear] empty condition
    === 2011-11-19 00:28:35,588 [l0-0] INFO  SQLDataSource - [builtinApplication.dateRangeYear] derived query: SELECT 
                    DISTINCT YEAR_NUM
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB'
                 ORDER BY 
                    YEAR_NUM DESC
                
    === 2011-11-19 00:28:35,843 [l0-3] INFO  RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
    === 2011-11-19 00:28:35,867 [l0-0] INFO  SQLDataSource - [builtinApplication.dateRangeYear] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT YEAR_NUM
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB'
                 ORDER BY 
                    YEAR_NUM DESC
                
    === 2011-11-19 00:28:35,980 [l0-3] DEBUG XML - Parsed XML from (in memory stream): 135ms
    === 2011-11-19 00:28:35,983 [l0-3] DEBUG RPCManager - Processing 1 requests.
    === 2011-11-19 00:28:35,985 [l0-3] DEBUG RPCManager - Request #1 (DSRequest) payload: {
        criteria:{
        },
        operationConfig:{
            dataSource:"dateRange",
            operationType:"fetch",
            textMatchStyle:"startsWith"
        },
        componentId:"isc_PickListMenu_0",
        appID:"builtinApplication",
        operation:"dateRangeMonth",
        oldValues:null
    }
    === 2011-11-19 00:28:35,985 [l0-3] INFO  IDACall - Performing 1 operation(s)
    === 2011-11-19 00:28:36,025 [l0-3] DEBUG AppBase - [builtinApplication.dateRangeMonth] No userTypes defined, allowing anyone access to all operations for this application
    === 2011-11-19 00:28:36,025 [l0-3] DEBUG AppBase - [builtinApplication.dateRangeMonth] No public zero-argument method named '_dateRangeMonth' found, performing generic datasource operation
    === 2011-11-19 00:28:36,026 [l0-3] INFO  SQLDataSource - [builtinApplication.dateRangeMonth] Performing fetch operation with
    	criteria: {}	values: {}
    === 2011-11-19 00:28:36,026 [l0-3] INFO  SQLWhereClause - [builtinApplication.dateRangeMonth] empty condition
    === 2011-11-19 00:28:36,026 [l0-3] INFO  SQLDataSource - [builtinApplication.dateRangeMonth] derived query: SELECT 
                    DISTINCT MONTH_NUM,MONTH_SHORT_NAME
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB' AND YEAR_NUM=2011
                 ORDER BY 
                    MONTH_NUM ASC
                
    === 2011-11-19 00:28:36,027 [l0-3] INFO  SQLDataSource - [builtinApplication.dateRangeMonth] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT MONTH_NUM,MONTH_SHORT_NAME
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB' AND YEAR_NUM=2011
                 ORDER BY 
                    MONTH_NUM ASC
                
    === 2011-11-19 00:28:36,190 [l0-0] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRangeYear] Initializing SQL config for 'Oracle' from system config - using DataSource:  oracle.jdbc.pool.OracleDataSource
    === 2011-11-19 00:28:39,913 [l0-3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRangeMonth] Returning pooled Connection
    === 2011-11-19 00:28:40,710 [l0-3] INFO  SQLDriver - [builtinApplication.dateRangeMonth] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT MONTH_NUM,MONTH_SHORT_NAME
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB' AND YEAR_NUM=2011
                 ORDER BY 
                    MONTH_NUM ASC
                
    === 2011-11-19 00:28:41,458 [l0-3] INFO  DSResponse - [builtinApplication.dateRangeMonth] DSResponse: List with 8 items
    === 2011-11-19 00:28:41,777 [l0-3] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
    === 2011-11-19 00:28:41,781 [l0-3] DEBUG RPCManager - non-DMI response, dropExtraFields: false
    === 2011-11-19 00:28:42,365 [l0-0] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRangeYear] Returning pooled Connection
    === 2011-11-19 00:28:42,968 [l0-0] INFO  SQLDriver - [builtinApplication.dateRangeYear] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT YEAR_NUM
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB'
                 ORDER BY 
                    YEAR_NUM DESC
                
    === 2011-11-19 00:28:43,574 [l0-0] INFO  DSResponse - [builtinApplication.dateRangeYear] DSResponse: List with 3 items
    === 2011-11-19 00:28:43,878 [l0-0] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
    === 2011-11-19 00:28:43,881 [l0-0] DEBUG RPCManager - non-DMI response, dropExtraFields: false
    === 2011-11-19 00:29:32,471 [l0-6] INFO  Download - Returning 304: Not modified on conditional get of: C:\Users\sg0209257\.IntelliJIdea10\system\gwt\mi-implementation.mi-implementatione2829505\mi-implementation.c3fae748\run\www\MarketIntelligence\sc\skins\Enterprise\load_skin.js
    === 2011-11-19 00:29:33,421 [l0-3] INFO  Download - Returning 304: Not modified on conditional get of: C:\Users\sg0209257\.IntelliJIdea10\system\gwt\mi-implementation.mi-implementatione2829505\mi-implementation.c3fae748\run\www\MarketIntelligence\sc\skins\Enterprise\skin_styles.css
    === 2011-11-19 00:29:39,306 [l0-3] INFO  RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
    === 2011-11-19 00:29:39,310 [l0-3] DEBUG XML - Parsed XML from (in memory stream): 3ms
    === 2011-11-19 00:29:39,313 [l0-3] DEBUG RPCManager - Processing 1 requests.
    === 2011-11-19 00:29:39,314 [l0-3] DEBUG RPCManager - Request #1 (DSRequest) payload: {
        criteria:{
        },
        operationConfig:{
            dataSource:"dateRange",
            operationType:"fetch",
            textMatchStyle:"startsWith"
        },
        componentId:"isc_PickListMenu_0",
        appID:"builtinApplication",
        operation:"dateRangeYear",
        oldValues:null
    }
    === 2011-11-19 00:29:39,314 [l0-3] INFO  IDACall - Performing 1 operation(s)
    === 2011-11-19 00:29:39,314 [l0-3] DEBUG AppBase - [builtinApplication.dateRangeYear] No userTypes defined, allowing anyone access to all operations for this application
    === 2011-11-19 00:29:39,314 [l0-3] DEBUG AppBase - [builtinApplication.dateRangeYear] No public zero-argument method named '_dateRangeYear' found, performing generic datasource operation
    === 2011-11-19 00:29:39,314 [l0-3] INFO  SQLDataSource - [builtinApplication.dateRangeYear] Performing fetch operation with
    	criteria: {}	values: {}
    === 2011-11-19 00:29:39,315 [l0-3] INFO  SQLWhereClause - [builtinApplication.dateRangeYear] empty condition
    === 2011-11-19 00:29:39,315 [l0-3] INFO  SQLDataSource - [builtinApplication.dateRangeYear] derived query: SELECT 
                    DISTINCT YEAR_NUM
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB'
                 ORDER BY 
                    YEAR_NUM DESC
                
    === 2011-11-19 00:29:39,315 [l0-3] INFO  SQLDataSource - [builtinApplication.dateRangeYear] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT YEAR_NUM
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB'
                 ORDER BY 
                    YEAR_NUM DESC
                
    === 2011-11-19 00:29:40,026 [l0-4] INFO  RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
    === 2011-11-19 00:29:40,030 [l0-4] DEBUG XML - Parsed XML from (in memory stream): 3ms
    === 2011-11-19 00:29:40,032 [l0-4] DEBUG RPCManager - Processing 1 requests.
    === 2011-11-19 00:29:40,034 [l0-4] DEBUG RPCManager - Request #1 (DSRequest) payload: {
        criteria:{
        },
        operationConfig:{
            dataSource:"dateRange",
            operationType:"fetch",
            textMatchStyle:"startsWith"
        },
        componentId:"isc_PickListMenu_0",
        appID:"builtinApplication",
        operation:"dateRangeMonth",
        oldValues:null
    }
    === 2011-11-19 00:29:40,034 [l0-4] INFO  IDACall - Performing 1 operation(s)
    === 2011-11-19 00:29:40,034 [l0-4] DEBUG AppBase - [builtinApplication.dateRangeMonth] No userTypes defined, allowing anyone access to all operations for this application
    === 2011-11-19 00:29:40,034 [l0-4] DEBUG AppBase - [builtinApplication.dateRangeMonth] No public zero-argument method named '_dateRangeMonth' found, performing generic datasource operation
    === 2011-11-19 00:29:40,034 [l0-4] INFO  SQLDataSource - [builtinApplication.dateRangeMonth] Performing fetch operation with
    	criteria: {}	values: {}
    === 2011-11-19 00:29:40,034 [l0-4] INFO  SQLWhereClause - [builtinApplication.dateRangeMonth] empty condition
    === 2011-11-19 00:29:40,035 [l0-4] INFO  SQLDataSource - [builtinApplication.dateRangeMonth] derived query: SELECT 
                    DISTINCT MONTH_NUM,MONTH_SHORT_NAME
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB' AND YEAR_NUM=2011
                 ORDER BY 
                    MONTH_NUM ASC
                
    === 2011-11-19 00:29:40,035 [l0-4] INFO  SQLDataSource - [builtinApplication.dateRangeMonth] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT MONTH_NUM,MONTH_SHORT_NAME
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB' AND YEAR_NUM=2011
                 ORDER BY 
                    MONTH_NUM ASC
                
    === 2011-11-19 00:29:42,362 [l0-3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRangeYear] Returning pooled Connection
    === 2011-11-19 00:29:42,816 [l0-4] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRangeMonth] Returning pooled Connection
    === 2011-11-19 00:29:42,964 [l0-3] INFO  SQLDriver - [builtinApplication.dateRangeYear] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT YEAR_NUM
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB'
                 ORDER BY 
                    YEAR_NUM DESC
                
    === 2011-11-19 00:29:43,422 [l0-4] INFO  SQLDriver - [builtinApplication.dateRangeMonth] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT MONTH_NUM,MONTH_SHORT_NAME
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB' AND YEAR_NUM=2011
                 ORDER BY 
                    MONTH_NUM ASC
                
    === 2011-11-19 00:29:43,570 [l0-3] INFO  DSResponse - [builtinApplication.dateRangeYear] DSResponse: List with 3 items
    === 2011-11-19 00:29:43,876 [l0-3] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
    === 2011-11-19 00:29:43,879 [l0-3] DEBUG RPCManager - non-DMI response, dropExtraFields: false
    === 2011-11-19 00:29:44,028 [l0-4] INFO  DSResponse - [builtinApplication.dateRangeMonth] DSResponse: List with 8 items
    === 2011-11-19 00:29:44,330 [l0-4] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
    === 2011-11-19 00:29:44,331 [l0-4] DEBUG RPCManager - non-DMI response, dropExtraFields: false
    === 2011-11-19 00:29:58,692 [l0-5] INFO  Download - Returning 304: Not modified on conditional get of: 
    === 2011-11-19 00:30:14,163 [l0-4] INFO  RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
    === 2011-11-19 00:30:14,167 [l0-4] DEBUG XML - Parsed XML from (in memory stream): 3ms
    === 2011-11-19 00:30:14,170 [l0-4] DEBUG RPCManager - Processing 1 requests.
    === 2011-11-19 00:30:14,172 [l0-4] DEBUG RPCManager - Request #1 (DSRequest) payload: {
        criteria:{
        },
        operationConfig:{
            dataSource:"dateRange",
            operationType:"fetch",
            textMatchStyle:"startsWith"
        },
        componentId:"isc_PickListMenu_0",
        appID:"builtinApplication",
        operation:"dateRangeYear",
        oldValues:null
    }
    === 2011-11-19 00:30:14,172 [l0-4] INFO  IDACall - Performing 1 operation(s)
    === 2011-11-19 00:30:14,173 [l0-4] DEBUG AppBase - [builtinApplication.dateRangeYear] No userTypes defined, allowing anyone access to all operations for this application
    === 2011-11-19 00:30:14,173 [l0-4] DEBUG AppBase - [builtinApplication.dateRangeYear] No public zero-argument method named '_dateRangeYear' found, performing generic datasource operation
    === 2011-11-19 00:30:14,173 [l0-4] INFO  SQLDataSource - [builtinApplication.dateRangeYear] Performing fetch operation with
    	criteria: {}	values: {}
    === 2011-11-19 00:30:14,173 [l0-4] INFO  SQLWhereClause - [builtinApplication.dateRangeYear] empty condition
    === 2011-11-19 00:30:14,173 [l0-4] INFO  SQLDataSource - [builtinApplication.dateRangeYear] derived query: SELECT 
                    DISTINCT YEAR_NUM
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB'
                 ORDER BY 
                    YEAR_NUM DESC
                
    === 2011-11-19 00:30:14,174 [l0-4] INFO  SQLDataSource - [builtinApplication.dateRangeYear] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT YEAR_NUM
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB'
                 ORDER BY 
                    YEAR_NUM DESC
                
    === 2011-11-19 00:30:17,066 [l0-4] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRangeYear] Returning pooled Connection
    === 2011-11-19 00:30:17,670 [l0-4] INFO  SQLDriver - [builtinApplication.dateRangeYear] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT YEAR_NUM
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB'
                 ORDER BY 
                    YEAR_NUM DESC
                
    === 2011-11-19 00:30:18,274 [l0-4] INFO  DSResponse - [builtinApplication.dateRangeYear] DSResponse: List with 3 items
    === 2011-11-19 00:30:18,582 [l0-4] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
    === 2011-11-19 00:30:18,585 [l0-4] DEBUG RPCManager - non-DMI response, dropExtraFields: false
    === 2011-11-19 00:30:25,537 [l0-4] INFO  Download - Returning 304: Not modified on conditional get of: C:\Users\sg0209257\.IntelliJIdea10\system\gwt\mi-implementation.mi-implementatione2829505\mi-implementation.c3fae748\run\www\MarketIntelligence\sc\skins\Enterprise\images\ListGrid\row_Over_Selected.png
    === 2011-11-19 00:30:46,513 [l0-7] INFO  RequestContext - URL: '/MarketIntelligence/sc/skins/Enterprise/load_skin.js', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
    === 2011-11-19 00:30:46,603 [l0-7] INFO  Download - done streaming: C:/Users/sg0209257/.IntelliJIdea10/system/gwt/mi-implementation.mi-implementatione2829505/mi-implementation.c3fae748/run/www/MarketIntelligence/sc/skins/Enterprise/load_skin.js
    === 2011-11-19 00:30:47,045 [l0-7] INFO  RequestContext - URL: '/MarketIntelligence/sc/skins/Enterprise/skin_styles.css', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
    === 2011-11-19 00:30:47,048 [l0-7] INFO  Download - done streaming: C:/Users/sg0209257/.IntelliJIdea10/system/gwt/mi-implementation.mi-implementatione2829505/mi-implementation.c3fae748/run/www/MarketIntelligence/sc/skins/Enterprise/skin_styles.css
    === 2011-11-19 00:30:52,301 [l0-0] INFO  RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
    === 2011-11-19 00:30:52,306 [l0-0] DEBUG XML - Parsed XML from (in memory stream): 4ms
    === 2011-11-19 00:30:52,310 [l0-0] DEBUG RPCManager - Processing 1 requests.
    === 2011-11-19 00:30:52,311 [l0-0] DEBUG RPCManager - Request #1 (DSRequest) payload: {
        criteria:{
        },
        operationConfig:{
            dataSource:"dateRange",
            operationType:"fetch",
            textMatchStyle:"startsWith"
        },
        componentId:"isc_PickListMenu_0",
        appID:"builtinApplication",
        operation:"dateRangeYear",
        oldValues:null
    }
    === 2011-11-19 00:30:52,312 [l0-0] INFO  IDACall - Performing 1 operation(s)
    === 2011-11-19 00:30:52,312 [l0-0] DEBUG AppBase - [builtinApplication.dateRangeYear] No userTypes defined, allowing anyone access to all operations for this application
    === 2011-11-19 00:30:52,312 [l0-0] DEBUG AppBase - [builtinApplication.dateRangeYear] No public zero-argument method named '_dateRangeYear' found, performing generic datasource operation
    === 2011-11-19 00:30:52,312 [l0-0] INFO  SQLDataSource - [builtinApplication.dateRangeYear] Performing fetch operation with
    	criteria: {}	values: {}
    === 2011-11-19 00:30:52,312 [l0-0] INFO  SQLWhereClause - [builtinApplication.dateRangeYear] empty condition
    === 2011-11-19 00:30:52,312 [l0-0] INFO  SQLDataSource - [builtinApplication.dateRangeYear] derived query: SELECT 
                    DISTINCT YEAR_NUM
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB'
                 ORDER BY 
                    YEAR_NUM DESC
                
    === 2011-11-19 00:30:52,313 [l0-0] INFO  SQLDataSource - [builtinApplication.dateRangeYear] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT YEAR_NUM
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB'
                 ORDER BY 
                    YEAR_NUM DESC
                
    === 2011-11-19 00:30:52,323 [l0-4] INFO  RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
    === 2011-11-19 00:30:52,326 [l0-4] DEBUG XML - Parsed XML from (in memory stream): 2ms
    === 2011-11-19 00:30:52,329 [l0-4] DEBUG RPCManager - Processing 1 requests.
    === 2011-11-19 00:30:52,330 [l0-4] DEBUG RPCManager - Request #1 (DSRequest) payload: {
        criteria:{
        },
        operationConfig:{
            dataSource:"dateRange",
            operationType:"fetch",
            textMatchStyle:"startsWith"
        },
        componentId:"isc_PickListMenu_0",
        appID:"builtinApplication",
        operation:"dateRangeMonth",
        oldValues:null
    }
    === 2011-11-19 00:30:52,330 [l0-4] INFO  IDACall - Performing 1 operation(s)
    === 2011-11-19 00:30:52,330 [l0-4] DEBUG AppBase - [builtinApplication.dateRangeMonth] No userTypes defined, allowing anyone access to all operations for this application
    === 2011-11-19 00:30:52,330 [l0-4] DEBUG AppBase - [builtinApplication.dateRangeMonth] No public zero-argument method named '_dateRangeMonth' found, performing generic datasource operation
    === 2011-11-19 00:30:52,330 [l0-4] INFO  SQLDataSource - [builtinApplication.dateRangeMonth] Performing fetch operation with
    	criteria: {}	values: {}
    === 2011-11-19 00:30:52,331 [l0-4] INFO  SQLWhereClause - [builtinApplication.dateRangeMonth] empty condition
    === 2011-11-19 00:30:52,331 [l0-4] INFO  SQLDataSource - [builtinApplication.dateRangeMonth] derived query: SELECT 
                    DISTINCT MONTH_NUM,MONTH_SHORT_NAME
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB' AND YEAR_NUM=2011
                 ORDER BY 
                    MONTH_NUM ASC
                
    === 2011-11-19 00:30:52,331 [l0-4] INFO  SQLDataSource - [builtinApplication.dateRangeMonth] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT MONTH_NUM,MONTH_SHORT_NAME
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB' AND YEAR_NUM=2011
                 ORDER BY 
                    MONTH_NUM ASC
                
    === 2011-11-19 00:30:55,116 [l0-0] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRangeYear] Returning pooled Connection
    === 2011-11-19 00:30:55,119 [l0-4] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRangeMonth] Returning pooled Connection
    === 2011-11-19 00:30:55,726 [l0-0] INFO  SQLDriver - [builtinApplication.dateRangeYear] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT YEAR_NUM
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB'
                 ORDER BY 
                    YEAR_NUM DESC
                
    === 2011-11-19 00:30:55,732 [l0-4] INFO  SQLDriver - [builtinApplication.dateRangeMonth] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT MONTH_NUM,MONTH_SHORT_NAME
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB' AND YEAR_NUM=2011
                 ORDER BY 
                    MONTH_NUM ASC
                
    === 2011-11-19 00:30:56,337 [l0-0] INFO  DSResponse - [builtinApplication.dateRangeYear] DSResponse: List with 3 items
    === 2011-11-19 00:30:56,339 [l0-4] INFO  DSResponse - [builtinApplication.dateRangeMonth] DSResponse: List with 8 items
    === 2011-11-19 00:30:56,640 [l0-0] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
    === 2011-11-19 00:30:56,642 [l0-4] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
    === 2011-11-19 00:30:56,643 [l0-0] DEBUG RPCManager - non-DMI response, dropExtraFields: false
    === 2011-11-19 00:30:56,644 [l0-4] DEBUG RPCManager - non-DMI response, dropExtraFields: false
    sg0209257/.IntelliJIdea10/system/gwt/mi-implementation.mi-implementatione2829505/mi-implementation.c3fae748/run/www/MarketIntelligence/sc/skins/Enterprise/images/Tab/top/tab_Selected_Over_start.png
    === 2011-11-19 00:31:11,668 [l0-3] INFO  RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
    === 2011-11-19 00:31:11,671 [l0-3] DEBUG XML - Parsed XML from (in memory stream): 3ms
    === 2011-11-19 00:31:11,674 [l0-3] DEBUG RPCManager - Processing 1 requests.
    === 2011-11-19 00:31:11,675 [l0-3] DEBUG RPCManager - Request #1 (DSRequest) payload: {
        criteria:{
        },
        operationConfig:{
            dataSource:"dateRange",
            operationType:"fetch",
            textMatchStyle:"startsWith"
        },
        componentId:"isc_PickListMenu_0",
        appID:"builtinApplication",
        operation:"dateRangeYear",
        oldValues:null
    }
    === 2011-11-19 00:31:11,675 [l0-3] INFO  IDACall - Performing 1 operation(s)
    === 2011-11-19 00:31:11,675 [l0-3] DEBUG AppBase - [builtinApplication.dateRangeYear] No userTypes defined, allowing anyone access to all operations for this application
    === 2011-11-19 00:31:11,676 [l0-3] DEBUG AppBase - [builtinApplication.dateRangeYear] No public zero-argument method named '_dateRangeYear' found, performing generic datasource operation
    === 2011-11-19 00:31:11,676 [l0-3] INFO  SQLDataSource - [builtinApplication.dateRangeYear] Performing fetch operation with
    	criteria: {}	values: {}
    === 2011-11-19 00:31:11,676 [l0-3] INFO  SQLWhereClause - [builtinApplication.dateRangeYear] empty condition
    === 2011-11-19 00:31:11,676 [l0-3] INFO  SQLDataSource - [builtinApplication.dateRangeYear] derived query: SELECT 
                    DISTINCT YEAR_NUM
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB'
                 ORDER BY 
                    YEAR_NUM DESC
                
    === 2011-11-19 00:31:11,676 [l0-3] INFO  SQLDataSource - [builtinApplication.dateRangeYear] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT YEAR_NUM
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB'
                 ORDER BY 
                    YEAR_NUM DESC
                
    === 2011-11-19 00:31:11,915 [l0-8] INFO  RequestContext - URL: '/MarketIntelligence/sc/system/reference/skin/images/server_client_exchange.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
    === 2011-11-19 00:31:11,915 [l0-8] INFO  Download - File 
    === 2011-11-19 00:31:14,476 [l0-3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRangeYear] Returning pooled Connection
    === 2011-11-19 00:31:15,083 [l0-3] INFO  SQLDriver - [builtinApplication.dateRangeYear] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT YEAR_NUM
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB'
                 ORDER BY 
                    YEAR_NUM DESC
                
    === 2011-11-19 00:31:15,689 [l0-3] INFO  DSResponse - [builtinApplication.dateRangeYear] DSResponse: List with 3 items
    === 2011-11-19 00:31:15,993 [l0-3] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
    === 2011-11-19 00:31:15,995 [l0-3] DEBUG RPCManager - non-DMI response, dropExtraFields: false
    === 2011-11-19 00:31:16,261 [l0-3] INFO  RequestContext - URL: '/MarketIntelligence/sc/system/reference/skin/images/server_client_exchange.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
    === 2011-11-19 00:31:19,860 [l0-3] DEBUG XML - Parsed XML from (in memory stream): 2ms
    === 2011-11-19 00:31:19,862 [l0-3] DEBUG RPCManager - Processing 1 requests.
    === 2011-11-19 00:31:19,865 [l0-3] DEBUG RPCManager - Request #1 (DSRequest) payload: {
        criteria:{
        },
        operationConfig:{
            dataSource:"dateRange",
            operationType:"fetch",
            textMatchStyle:"startsWith"
        },
        componentId:"isc_PickListMenu_0",
        appID:"builtinApplication",
        operation:"dateRangeMonth",
        oldValues:null
    }
    === 2011-11-19 00:31:19,865 [l0-3] INFO  IDACall - Performing 1 operation(s)
    === 2011-11-19 00:31:19,865 [l0-3] DEBUG AppBase - [builtinApplication.dateRangeMonth] No userTypes defined, allowing anyone access to all operations for this application
    === 2011-11-19 00:31:19,865 [l0-3] DEBUG AppBase - [builtinApplication.dateRangeMonth] No public zero-argument method named '_dateRangeMonth' found, performing generic datasource operation
    === 2011-11-19 00:31:19,865 [l0-3] INFO  SQLDataSource - [builtinApplication.dateRangeMonth] Performing fetch operation with
    	criteria: {}	values: {}
    === 2011-11-19 00:31:19,866 [l0-3] INFO  SQLWhereClause - [builtinApplication.dateRangeMonth] empty condition
    === 2011-11-19 00:31:19,866 [l0-3] INFO  SQLDataSource - [builtinApplication.dateRangeMonth] derived query: SELECT 
                    DISTINCT MONTH_NUM,MONTH_SHORT_NAME
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB' AND YEAR_NUM=2011
                 ORDER BY 
                    MONTH_NUM ASC
                
    === 2011-11-19 00:31:19,866 [l0-3] INFO  SQLDataSource - [builtinApplication.dateRangeMonth] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT MONTH_NUM,MONTH_SHORT_NAME
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB' AND YEAR_NUM=2011
                 ORDER BY 
                    MONTH_NUM ASC
                
    === 2011-11-19 00:31:20,098 [l0-8] INFO  RequestContext - URL: '/MarketIntelligence/sc/system/reference/skin/images/server_client_exchange.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
    
    === 2011-11-19 00:31:22,690 [l0-3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRangeMonth] Returning pooled Connection
    === 2011-11-19 00:31:23,300 [l0-3] INFO  SQLDriver - [builtinApplication.dateRangeMonth] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT MONTH_NUM,MONTH_SHORT_NAME
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB' AND YEAR_NUM=2011
                 ORDER BY 
                    MONTH_NUM ASC
                
    === 2011-11-19 00:31:23,917 [l0-3] INFO  DSResponse - [builtinApplication.dateRangeMonth] DSResponse: List with 8 items
    === 2011-11-19 00:31:24,224 [l0-3] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
    === 2011-11-19 00:31:24,227 [l0-3] DEBUG RPCManager - non-DMI response, dropExtraFields: false
    
    === 2011-11-19 00:31:29,885 [l0-3] INFO  RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
    === 2011-11-19 00:31:29,888 [l0-3] DEBUG XML - Parsed XML from (in memory stream): 2ms
    === 2011-11-19 00:31:29,892 [l0-3] DEBUG RPCManager - Processing 1 requests.
    === 2011-11-19 00:31:29,893 [l0-3] DEBUG RPCManager - Request #1 (DSRequest) payload: {
        criteria:{
        },
        operationConfig:{
            dataSource:"dateRange",
            operationType:"fetch",
            textMatchStyle:"startsWith"
        },
        componentId:"isc_PickListMenu_0",
        appID:"builtinApplication",
        operation:"dateRangeYear",
        oldValues:null
    }
    === 2011-11-19 00:31:29,893 [l0-3] INFO  IDACall - Performing 1 operation(s)
    === 2011-11-19 00:31:29,893 [l0-3] DEBUG AppBase - [builtinApplication.dateRangeYear] No userTypes defined, allowing anyone access to all operations for this application
    === 2011-11-19 00:31:29,893 [l0-3] DEBUG AppBase - [builtinApplication.dateRangeYear] No public zero-argument method named '_dateRangeYear' found, performing generic datasource operation
    === 2011-11-19 00:31:29,894 [l0-3] INFO  SQLDataSource - [builtinApplication.dateRangeYear] Performing fetch operation with
    	criteria: {}	values: {}
    === 2011-11-19 00:31:29,894 [l0-3] INFO  SQLWhereClause - [builtinApplication.dateRangeYear] empty condition
    === 2011-11-19 00:31:29,894 [l0-3] INFO  SQLDataSource - [builtinApplication.dateRangeYear] derived query: SELECT 
                    DISTINCT YEAR_NUM
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB'
                 ORDER BY 
                    YEAR_NUM DESC
                
    === 2011-11-19 00:31:29,894 [l0-3] INFO  SQLDataSource - [builtinApplication.dateRangeYear] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT YEAR_NUM
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB'
                 ORDER BY 
                    YEAR_NUM DESC
                
    === 2011-11-19 00:31:30,004 [l0-8] INFO  RequestContext - URL: '/MarketIntelligence/sc/system/reference/skin/images/server_client_exchange.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
    === 2011-11-19 00:31:30,004 [l0-8] INFO  Download - File 
    === 2011-11-19 00:31:32,674 [l0-3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRangeYear] Returning pooled Connection
    === 2011-11-19 00:31:33,277 [l0-3] INFO  SQLDriver - [builtinApplication.dateRangeYear] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT YEAR_NUM
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB'
                 ORDER BY 
                    YEAR_NUM DESC
                
    === 2011-11-19 00:31:33,884 [l0-3] INFO  DSResponse - [builtinApplication.dateRangeYear] DSResponse: List with 3 items
    === 2011-11-19 00:31:34,190 [l0-3] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
    === 2011-11-19 00:31:34,193 [l0-3] DEBUG RPCManager - non-DMI response, dropExtraFields: false
    === 2011-11-19 00:31:34,446 [l0-3] INFO  RequestContext - URL: '/MarketIntelligence/sc/system/reference/skin/images/server_client_exchange.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
    
    === 2011-11-19 00:31:36,774 [l0-3] INFO  RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
    === 2011-11-19 00:31:36,780 [l0-3] DEBUG XML - Parsed XML from (in memory stream): 2ms
    === 2011-11-19 00:31:36,782 [l0-3] DEBUG RPCManager - Processing 1 requests.
    === 2011-11-19 00:31:36,784 [l0-3] DEBUG RPCManager - Request #1 (DSRequest) payload: {
        criteria:{
        },
        operationConfig:{
            dataSource:"dateRange",
            operationType:"fetch",
            textMatchStyle:"startsWith"
        },
        componentId:"isc_PickListMenu_0",
        appID:"builtinApplication",
        operation:"dateRangeMonth",
        oldValues:null
    }
    === 2011-11-19 00:31:36,784 [l0-3] INFO  IDACall - Performing 1 operation(s)
    === 2011-11-19 00:31:36,784 [l0-3] DEBUG AppBase - [builtinApplication.dateRangeMonth] No userTypes defined, allowing anyone access to all operations for this application
    === 2011-11-19 00:31:36,784 [l0-3] DEBUG AppBase - [builtinApplication.dateRangeMonth] No public zero-argument method named '_dateRangeMonth' found, performing generic datasource operation
    === 2011-11-19 00:31:36,784 [l0-3] INFO  SQLDataSource - [builtinApplication.dateRangeMonth] Performing fetch operation with
    	criteria: {}	values: {}
    === 2011-11-19 00:31:36,785 [l0-3] INFO  SQLWhereClause - [builtinApplication.dateRangeMonth] empty condition
    === 2011-11-19 00:31:36,785 [l0-3] INFO  SQLDataSource - [builtinApplication.dateRangeMonth] derived query: SELECT 
                    DISTINCT MONTH_NUM,MONTH_SHORT_NAME
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB' AND YEAR_NUM=2011
                 ORDER BY 
                    MONTH_NUM ASC
                
    === 2011-11-19 00:31:36,785 [l0-3] INFO  SQLDataSource - [builtinApplication.dateRangeMonth] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT MONTH_NUM,MONTH_SHORT_NAME
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB' AND YEAR_NUM=2011
                 ORDER BY 
                    MONTH_NUM ASC
                
    
    === 2011-11-19 00:31:39,557 [l0-3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRangeMonth] Returning pooled Connection
    === 2011-11-19 00:31:40,162 [l0-3] INFO  SQLDriver - [builtinApplication.dateRangeMonth] Executing SQL query on 'Oracle': SELECT 
                    DISTINCT MONTH_NUM,MONTH_SHORT_NAME
                 FROM 
                    CLIENT_VALID_DATES
                 WHERE 
                    CLIENT_ID=99 and PRODUCT_ID='NA_ADB' AND YEAR_NUM=2011
                 ORDER BY 
                    MONTH_NUM ASC
                
    === 2011-11-19 00:31:40,779 [l0-3] INFO  DSResponse - [builtinApplication.dateRangeMonth] DSResponse: List with 8 items
    === 2011-11-19 00:31:41,085 [l0-3] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
    === 2011-11-19 00:31:41,088 [l0-3] DEBUG RPCManager - non-DMI response, dropExtraFields: false
    === 2011-11-19 00:31:41,355 [l0-3] INFO  RequestContext - URL: '/MarketIntelligence/sc/system/reference/skin/images/server_client_exchange.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header

    Comment


      #3
      Why is this behavior surprising? You haven't got any settings which would tell the framework to cache. If you want caching, one way is DataSource.cacheAllData:true.

      Comment

      Working...
      X