Announcement

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

    Listgrif: setCriteria, add, fetch and filter

    (My version: v9.1p_2014-07-09/Enterprise Deployment (built 2014-07-09))

    I am using smartgwt 4.1 in Firefox.

    I have a listgrid where I set some criteria in the constructor, so that the list is always opened with that initial criteria.

    Code:
    AdvancedCriteria criteria = new AdvancedCriteria();
    			criteria.setOperator(OperatorId.EQUALS);
    			criteria.addCriteria(DBConstants.SCENARIOROWLABEL, OperatorId.EQUALS, this.scenario);
    			listGrid.setCriteria(criteria);
    My problem:

    1 - I open the listgrid, data is fetched correctly, all is fine.
    2 - I add a row, filling in the data.
    3 - After the add, the listgrid is automatically updated with a lot of additional records that should not be there.
    4 - If I immediately filter on some column (I have a filterEditor)... data is normal back again.

    (3 is the issue here)

    The log:

    Code:
    === 2014-07-24 16:58:56,970 [2-33] INFO  RequestContext - URL: '/simgui/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:24.0) Gecko/20100101 Firefox/24.0': Moz (Gecko) with Accept-Encoding header
    === 2014-07-24 16:58:56,973 [2-33] DEBUG XML - Parsed XML from (in memory stream): 2ms
    === 2014-07-24 16:58:56,973 [2-33] DEBUG ISCKeyedObjectPool - Borrowing object for 'transaction'
    === 2014-07-24 16:58:56,973 [2-33] DEBUG ISCKeyedObjectPool - Borrowing object for 'Object'
    === 2014-07-24 16:58:56,973 [2-33] DEBUG ISCKeyedObjectPool - Borrowing object for 'List'
    === 2014-07-24 16:58:56,973 [2-33] DEBUG ISCKeyedObjectPool - Borrowing object for 'elem'
    === 2014-07-24 16:58:56,974 [2-33] DEBUG RPCManager - Processing 1 requests.
    === 2014-07-24 16:58:56,974 [2-33] DEBUG ISCKeyedObjectPool - Borrowing object for 'WFPLANDB_engineers'
    === 2014-07-24 16:58:56,974 [2-33] DEBUG DSRequest - Caching instance 20 of DS WFPLANDB_engineers from DSRequest.getDataSource()
    === 2014-07-24 16:58:56,975 [2-33] DEBUG RPCManager - Request #1 (DSRequest) payload: {
        criteria:{
            _constructor:"AdvancedCriteria",
            operator:"and",
            criteria:[
                {
                    fieldName:"ScenariosPool_ScenarioID",
                    operator:"equals",
                    value:1014
                }
            ]
        },
        operationConfig:{
            dataSource:"WFPLANDB_engineers",
            operationType:"fetch",
            textMatchStyle:"substring"
        },
        startRow:324,
        endRow:370,
        componentId:"isc_ListGrid_2",
        appID:"builtinApplication",
        operation:"WFPLANDB_engineers_fetch",
        oldValues:{
            _constructor:"AdvancedCriteria",
            operator:"and",
            criteria:[
                {
                    fieldName:"ScenariosPool_ScenarioID",
                    operator:"equals",
                    value:1014
                }
            ]
        }
    }
    === 2014-07-24 16:58:56,975 [2-33] INFO  IDACall - Performing 1 operation(s)
    === 2014-07-24 16:58:56,975 [2-33] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
    === 2014-07-24 16:58:56,975 [2-33] DEBUG DeclarativeSecurity - DataSource WFPLANDB_engineers is not in the pre-checked list, processing...
    === 2014-07-24 16:58:56,975 [2-33] DEBUG AppBase - [builtinApplication.WFPLANDB_engineers_fetch] No userTypes defined, allowing anyone access to all operations for this application
    === 2014-07-24 16:58:56,975 [2-33] DEBUG AppBase - [builtinApplication.WFPLANDB_engineers_fetch] No public zero-argument method named '_WFPLANDB_engineers_fetch' found, performing generic datasource operation
    === 2014-07-24 16:58:56,975 [2-33] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_fetch] Performing fetch operation with
    	criteria: {criteria:[{fieldName:"ScenariosPool_ScenarioID",operator:"equals",value:1014}],operator:"and",_constructor:"AdvancedCriteria"}	values: {criteria:[{fieldName:"ScenariosPool_ScenarioID",operator:"equals",value:1014}],operator:"and",_constructor:"AdvancedCriteria"}
    === 2014-07-24 16:58:56,976 [2-33] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_fetch] derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause
    === 2014-07-24 16:58:56,976 [2-33] DEBUG SQLDataSource - [builtinApplication.WFPLANDB_engineers_fetch] Executing row count query: SELECT COUNT(*) FROM $defaultTableClause WHERE $defaultWhereClause
    === 2014-07-24 16:58:56,976 [2-33] DEBUG SQLDataSource - [builtinApplication.WFPLANDB_engineers_fetch] Eval'd row count query: SELECT COUNT(*) FROM EngineerScenario WHERE ((EngineerScenario.ScenariosPool_ScenarioID = 1014 AND EngineerScenario.ScenariosPool_ScenarioID IS NOT NULL))
    === 2014-07-24 16:58:56,976 [2-33] DEBUG PoolableSQLConnectionFactory - [builtinApplication.WFPLANDB_engineers_fetch] Connection was already closed in validateObject - returning false
    === 2014-07-24 16:58:56,977 [2-33] DEBUG PoolableSQLConnectionFactory - [builtinApplication.WFPLANDB_engineers_fetch] DriverManager fetching connection for SQLServer via jdbc url jdbc:sqlserver://127.0.0.1:1433;DatabaseName=WFPLANDB;User=root;
    === 2014-07-24 16:58:56,977 [2-33] DEBUG PoolableSQLConnectionFactory - [builtinApplication.WFPLANDB_engineers_fetch] Passing JDBC URL only to getConnection
    === 2014-07-24 16:58:56,988 [2-33] DEBUG PoolableSQLConnectionFactory - [builtinApplication.WFPLANDB_engineers_fetch] makeObject() created a pooled Connection '229728709'
    === 2014-07-24 16:58:56,988 [2-33] DEBUG SQLConnectionManager - [builtinApplication.WFPLANDB_engineers_fetch] Borrowed connection '229728709'
    === 2014-07-24 16:58:56,988 [2-33] DEBUG SQLDriver - [builtinApplication.WFPLANDB_engineers_fetch] About to execute SQL query in 'SQLServer' using connection '229728709'
    === 2014-07-24 16:58:56,988 [2-33] INFO  SQLDriver - [builtinApplication.WFPLANDB_engineers_fetch] Executing SQL query on 'SQLServer': SELECT COUNT(*) FROM EngineerScenario WHERE ((EngineerScenario.ScenariosPool_ScenarioID = 1014 AND EngineerScenario.ScenariosPool_ScenarioID IS NOT NULL))
    === 2014-07-24 16:58:56,989 [2-33] DEBUG SQLDataSource - [builtinApplication.WFPLANDB_engineers_fetch] Using SQL Limit query
    === 2014-07-24 16:58:56,989 [2-33] DEBUG SQLServerDriver - [builtinApplication.WFPLANDB_engineers_fetch] Using PK as default sorter: com.isomorphic.sql.SQLOrderClause@7889d388
    === 2014-07-24 16:58:56,990 [2-33] DEBUG SQLDataSource - [builtinApplication.WFPLANDB_engineers_fetch] SQL windowed select rows 324->370, result size 46. Query: SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ScenariosPool_ScenarioID, EngineerNumber) AS rowID FROM (SELECT TOP 100 PERCENT  EngineerScenario.AllowCM, EngineerScenario.CompensationInFullWeeks, EngineerScenario.DedicatedFSE, EngineerScenario.District, EngineerScenario.DistrictName, EngineerScenario.Efficiency, EngineerScenario.EngineerName, EngineerScenario.EngineerNumber, EngineerScenario.FTEFieldWork, EngineerScenario.HolidaysInFullWeeks, EngineerScenario.OfHolidays, EngineerScenario.OfSicknessDays, EngineerScenario.OfTimeCompensationInFullWeeks, EngineerScenario.OfTrainingDays_classroomOnly, EngineerScenario.Plant, EngineerScenario.PostalCode, EngineerScenario.ScenariosPool_ScenarioID, EngineerScenario.TrainingDaysInFullWeeks, EngineerScenario.ValidFrom, EngineerScenario.ValidUntil, EngineerScenario.meetingDays FROM EngineerScenario WHERE ((EngineerScenario.ScenariosPool_ScenarioID = 1014 AND EngineerScenario.ScenariosPool_ScenarioID IS NOT NULL))) x) y WHERE y.rowID BETWEEN 325 AND 370
    === 2014-07-24 16:58:56,990 [2-33] DEBUG SQLDataSource - [builtinApplication.WFPLANDB_engineers_fetch] SQL windowed select rows 324->370, result size 46. Query: SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ScenariosPool_ScenarioID, EngineerNumber) AS rowID FROM (SELECT TOP 100 PERCENT  EngineerScenario.AllowCM, EngineerScenario.CompensationInFullWeeks, EngineerScenario.DedicatedFSE, EngineerScenario.District, EngineerScenario.DistrictName, EngineerScenario.Efficiency, EngineerScenario.EngineerName, EngineerScenario.EngineerNumber, EngineerScenario.FTEFieldWork, EngineerScenario.HolidaysInFullWeeks, EngineerScenario.OfHolidays, EngineerScenario.OfSicknessDays, EngineerScenario.OfTimeCompensationInFullWeeks, EngineerScenario.OfTrainingDays_classroomOnly, EngineerScenario.Plant, EngineerScenario.PostalCode, EngineerScenario.ScenariosPool_ScenarioID, EngineerScenario.TrainingDaysInFullWeeks, EngineerScenario.ValidFrom, EngineerScenario.ValidUntil, EngineerScenario.meetingDays FROM EngineerScenario WHERE ((EngineerScenario.ScenariosPool_ScenarioID = 1014 AND EngineerScenario.ScenariosPool_ScenarioID IS NOT NULL))) x) y WHERE y.rowID BETWEEN 325 AND 370
    === 2014-07-24 16:58:57,007 [2-33] INFO  DSResponse - [builtinApplication.WFPLANDB_engineers_fetch] DSResponse: List with 46 items
    === 2014-07-24 16:58:57,008 [2-33] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
    === 2014-07-24 16:58:57,008 [2-33] DEBUG RPCManager - non-DMI response, dropExtraFields: false
    === 2014-07-24 16:58:57,015 [2-33] DEBUG SQLDriver - Freeing SQLDriver dbConnection 229728709
    === 2014-07-24 16:58:57,015 [2-33] DEBUG SQLConnectionManager - About to close ISCPoolableConnection with hashcode "229728709"
    === 2014-07-24 16:59:11,658 [2-29] INFO  RequestContext - URL: '/simgui/sc/skins/Enterprise/images/DynamicForm/checked.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:24.0) Gecko/20100101 Firefox/24.0': Moz (Gecko) with Accept-Encoding header
    === 2014-07-24 16:59:11,659 [2-29] INFO  Download - done streaming: D:/DEV/WORKSPACES/PHILIPS/philips/PhilipsWebApp/war/simgui/sc/skins/Enterprise/images/DynamicForm/checked.png
    === 2014-07-24 16:59:13,158 [2-29] DEBUG IDACall - Header Name:Value pair: Cookie:JSESSIONID=i1ag28px11tu126xd5r9fcjuj; GLog=%7B%0D%20%20%20%20left%3A168%2C%20%0D%20%20%20%20top%3A40%2C%20%0D%20%20%20%20width%3A638%2C%20%0D%20%20%20%20height%3A479%2C%20%0D%20%20%20%20priorityDefaults%3A%7B%0D%20%20%20%20%20%20%20%20Log%3A4%0D%20%20%20%20%7D%2C%20%0D%20%20%20%20defaultPriority%3A3%0D%7D; sid=i1ag28px11tu126xd5r9fcjuj
    === 2014-07-24 16:59:13,158 [2-29] DEBUG IDACall - Header Name:Value pair: DNT:0
    === 2014-07-24 16:59:13,158 [2-29] DEBUG IDACall - Header Name:Value pair: Host:127.0.0.1:8888
    === 2014-07-24 16:59:13,158 [2-29] DEBUG IDACall - Header Name:Value pair: Accept:text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    === 2014-07-24 16:59:13,158 [2-29] DEBUG IDACall - Header Name:Value pair: Content-Length:1585
    === 2014-07-24 16:59:13,158 [2-29] DEBUG IDACall - Header Name:Value pair: Content-Type:application/x-www-form-urlencoded; charset=UTF-8
    === 2014-07-24 16:59:13,158 [2-29] DEBUG IDACall - Header Name:Value pair: Accept-Language:en-US,en;q=0.5
    === 2014-07-24 16:59:13,158 [2-29] DEBUG IDACall - Header Name:Value pair: Pragma:no-cache
    === 2014-07-24 16:59:13,158 [2-29] DEBUG IDACall - Header Name:Value pair: Connection:keep-alive
    === 2014-07-24 16:59:13,159 [2-29] DEBUG IDACall - Header Name:Value pair: Referer:http://127.0.0.1:8888/SIMGUI.html?gwt.codesvr=127.0.0.1:9997
    === 2014-07-24 16:59:13,159 [2-29] DEBUG IDACall - Header Name:Value pair: User-Agent:Mozilla/5.0 (Windows NT 6.3; WOW64; rv:24.0) Gecko/20100101 Firefox/24.0
    === 2014-07-24 16:59:13,159 [2-29] DEBUG IDACall - Header Name:Value pair: Cache-Control:no-cache
    === 2014-07-24 16:59:13,159 [2-29] DEBUG IDACall - Header Name:Value pair: Accept-Encoding:gzip, deflate
    === 2014-07-24 16:59:13,159 [2-29] DEBUG IDACall - session exists: i1ag28px11tu126xd5r9fcjuj
    === 2014-07-24 16:59:13,159 [2-29] DEBUG IDACall - remote user: null
    === 2014-07-24 16:59:13,159 [2-29] INFO  RequestContext - URL: '/simgui/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:24.0) Gecko/20100101 Firefox/24.0': Moz (Gecko) with Accept-Encoding header
    === 2014-07-24 16:59:13,162 [2-29] DEBUG XML - Parsed XML from (in memory stream): 2ms
    === 2014-07-24 16:59:13,162 [2-29] DEBUG ISCKeyedObjectPool - Borrowing object for 'transaction'
    === 2014-07-24 16:59:13,162 [2-29] DEBUG ISCKeyedObjectPool - Borrowing object for 'Object'
    === 2014-07-24 16:59:13,163 [2-29] DEBUG ISCKeyedObjectPool - Borrowing object for 'List'
    === 2014-07-24 16:59:13,163 [2-29] DEBUG ISCKeyedObjectPool - Borrowing object for 'elem'
    === 2014-07-24 16:59:13,164 [2-29] DEBUG RPCManager - Processing 1 requests.
    === 2014-07-24 16:59:13,164 [2-29] DEBUG ISCKeyedObjectPool - Borrowing object for 'WFPLANDB_engineers'
    === 2014-07-24 16:59:13,164 [2-29] DEBUG DSRequest - Caching instance 20 of DS WFPLANDB_engineers from DSRequest.getDataSource()
    === 2014-07-24 16:59:13,164 [2-29] DEBUG RPCManager - Request #1 (DSRequest) payload: {
        values:{
            ScenariosPool_ScenarioID:1014,
            Plant:"DE93",
            EngineerNumber:222222,
            Efficiency:1,
            AllowCM:true
        },
        operationConfig:{
            dataSource:"WFPLANDB_engineers",
            operationType:"add",
            textMatchStyle:"exact"
        },
        componentId:"isc_ListGrid_2",
        appID:"builtinApplication",
        operation:"WFPLANDB_engineers_add",
        oldValues:{
            ScenariosPool_ScenarioID:1014,
            Plant:"DE93",
            EngineerNumber:222222,
            Efficiency:1,
            AllowCM:true
        },
        criteria:{
        }
    }
    === 2014-07-24 16:59:13,164 [2-29] INFO  IDACall - Performing 1 operation(s)
    === 2014-07-24 16:59:13,165 [2-29] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
    === 2014-07-24 16:59:13,165 [2-29] DEBUG DeclarativeSecurity - DataSource WFPLANDB_engineers is not in the pre-checked list, processing...
    === 2014-07-24 16:59:13,165 [2-29] DEBUG AppBase - [builtinApplication.WFPLANDB_engineers_add] No userTypes defined, allowing anyone access to all operations for this application
    === 2014-07-24 16:59:13,165 [2-29] DEBUG AppBase - [builtinApplication.WFPLANDB_engineers_add] No public zero-argument method named '_WFPLANDB_engineers_add' found, performing generic datasource operation
    === 2014-07-24 16:59:13,166 [2-29] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_add] Performing add operation with
    	criteria: {ScenariosPool_ScenarioID:1014,Plant:"DE93",EngineerNumber:222222,Efficiency:1,AllowCM:true}	values: {ScenariosPool_ScenarioID:1014,Plant:"DE93",EngineerNumber:222222,Efficiency:1.0,AllowCM:true}
    === 2014-07-24 16:59:13,168 [2-29] DEBUG SQLValuesClause - [builtinApplication.WFPLANDB_engineers_add] Sequences: {}
    === 2014-07-24 16:59:13,171 [2-29] DEBUG PoolableSQLConnectionFactory - [builtinApplication.WFPLANDB_engineers_add] Connection was already closed in validateObject - returning false
    === 2014-07-24 16:59:13,172 [2-29] DEBUG PoolableSQLConnectionFactory - [builtinApplication.WFPLANDB_engineers_add] DriverManager fetching connection for SQLServer via jdbc url jdbc:sqlserver://127.0.0.1:1433;DatabaseName=WFPLANDB;User=root;
    === 2014-07-24 16:59:13,172 [2-29] DEBUG PoolableSQLConnectionFactory - [builtinApplication.WFPLANDB_engineers_add] Passing JDBC URL only to getConnection
    === 2014-07-24 16:59:13,182 [2-29] DEBUG PoolableSQLConnectionFactory - [builtinApplication.WFPLANDB_engineers_add] makeObject() created a pooled Connection '1009549541'
    === 2014-07-24 16:59:13,182 [2-29] DEBUG SQLConnectionManager - [builtinApplication.WFPLANDB_engineers_add] Borrowed connection '1009549541'
    === 2014-07-24 16:59:13,183 [2-29] DEBUG SQLTransaction - [builtinApplication.WFPLANDB_engineers_add] Started new SQLServer transaction "1009549541"
    === 2014-07-24 16:59:13,183 [2-29] DEBUG SQLDriver - [builtinApplication.WFPLANDB_engineers_add] About to execute SQL update in 'SQLServer' using connection'1009549541'
    === 2014-07-24 16:59:13,183 [2-29] INFO  SQLDriver - [builtinApplication.WFPLANDB_engineers_add] Executing SQL update on 'SQLServer': INSERT INTO EngineerScenario (AllowCM, Efficiency, EngineerNumber, Plant, ScenariosPool_ScenarioID) VALUES ('true', 1.0, 222222, 'DE93', 1014)
    === 2014-07-24 16:59:13,194 [2-29] DEBUG SQLDriver - [builtinApplication.WFPLANDB_engineers_add] Discovered multiple generated keys via JDBC: {}
    === 2014-07-24 16:59:13,196 [2-29] DEBUG SQLDataSource - [builtinApplication.WFPLANDB_engineers_add] add operation affected 1 rows
    === 2014-07-24 16:59:13,197 [2-29] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_add] primaryKeys: {}
    === 2014-07-24 16:59:13,197 [2-29] DEBUG DeclarativeSecurity - [builtinApplication.WFPLANDB_engineers_add] Processing security checks for DataSource null, field null
    === 2014-07-24 16:59:13,197 [2-29] DEBUG DeclarativeSecurity - [builtinApplication.WFPLANDB_engineers_add] DataSource WFPLANDB_engineers is not in the pre-checked list, processing...
    === 2014-07-24 16:59:13,198 [2-29] DEBUG AppBase - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] No userTypes defined, allowing anyone access to all operations for this application
    === 2014-07-24 16:59:13,198 [2-29] DEBUG AppBase - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] No public zero-argument method named '_null' found, performing generic datasource operation
    === 2014-07-24 16:59:13,198 [2-29] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] Performing fetch operation with
    	criteria: {}	values: {}
    === 2014-07-24 16:59:13,198 [2-29] INFO  SQLWhereClause - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] empty condition
    === 2014-07-24 16:59:13,199 [2-29] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause
    === 2014-07-24 16:59:13,199 [2-29] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] 20: Executing SQL query on 'SQLServer': SELECT EngineerScenario.AllowCM, EngineerScenario.CompensationInFullWeeks, EngineerScenario.DedicatedFSE, EngineerScenario.District, EngineerScenario.DistrictName, EngineerScenario.Efficiency, EngineerScenario.EngineerName, EngineerScenario.EngineerNumber, EngineerScenario.FTEFieldWork, EngineerScenario.HolidaysInFullWeeks, EngineerScenario.OfHolidays, EngineerScenario.OfSicknessDays, EngineerScenario.OfTimeCompensationInFullWeeks, EngineerScenario.OfTrainingDays_classroomOnly, EngineerScenario.Plant, EngineerScenario.PostalCode, EngineerScenario.ScenariosPool_ScenarioID, EngineerScenario.TrainingDaysInFullWeeks, EngineerScenario.ValidFrom, EngineerScenario.ValidUntil, EngineerScenario.meetingDays FROM EngineerScenario WHERE ('1'='1')
    === 2014-07-24 16:59:13,199 [2-29] DEBUG SQLDriver - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] About to execute SQL query in 'SQLServer' using connection '1009549541'
    === 2014-07-24 16:59:13,199 [2-29] INFO  SQLDriver - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] Executing SQL query on 'SQLServer': SELECT EngineerScenario.AllowCM, EngineerScenario.CompensationInFullWeeks, EngineerScenario.DedicatedFSE, EngineerScenario.District, EngineerScenario.DistrictName, EngineerScenario.Efficiency, EngineerScenario.EngineerName, EngineerScenario.EngineerNumber, EngineerScenario.FTEFieldWork, EngineerScenario.HolidaysInFullWeeks, EngineerScenario.OfHolidays, EngineerScenario.OfSicknessDays, EngineerScenario.OfTimeCompensationInFullWeeks, EngineerScenario.OfTrainingDays_classroomOnly, EngineerScenario.Plant, EngineerScenario.PostalCode, EngineerScenario.ScenariosPool_ScenarioID, EngineerScenario.TrainingDaysInFullWeeks, EngineerScenario.ValidFrom, EngineerScenario.ValidUntil, EngineerScenario.meetingDays FROM EngineerScenario WHERE ('1'='1')
    === 2014-07-24 16:59:13,535 [2-29] INFO  DSResponse - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] DSResponse: List with 8445 items
    === 2014-07-24 16:59:13,539 [2-29] INFO  DSResponse - [builtinApplication.WFPLANDB_engineers_add] DSResponse: List with 8445 items
    === 2014-07-24 16:59:13,542 [2-29] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
    === 2014-07-24 16:59:13,543 [2-29] DEBUG SQLTransaction - Committing SQLServer transaction "1009549541"
    === 2014-07-24 16:59:13,544 [2-29] DEBUG RPCManager - non-DMI response, dropExtraFields: false
    === 2014-07-24 16:59:14,018 [2-29] DEBUG SQLTransaction - getConnection() found transactional connection for SQLServer with hashcode "1009549541"
    === 2014-07-24 16:59:14,018 [2-29] DEBUG SQLTransaction - Ending SQLServer transaction "1009549541"
    === 2014-07-24 16:59:14,018 [2-29] DEBUG SQLConnectionManager - About to close ISCPoolableConnection with hashcode "1009549541"
    === 2014-07-24 16:59:25,255 [2-47] DEBUG IDACall - Header Name:Value pair: Cookie:JSESSIONID=i1ag28px11tu126xd5r9fcjuj; GLog=%7B%0D%20%20%20%20left%3A168%2C%20%0D%20%20%20%20top%3A40%2C%20%0D%20%20%20%20width%3A638%2C%20%0D%20%20%20%20height%3A479%2C%20%0D%20%20%20%20priorityDefaults%3A%7B%0D%20%20%20%20%20%20%20%20Log%3A4%0D%20%20%20%20%7D%2C%20%0D%20%20%20%20defaultPriority%3A3%0D%7D; sid=i1ag28px11tu126xd5r9fcjuj
    === 2014-07-24 16:59:25,255 [2-47] DEBUG IDACall - Header Name:Value pair: DNT:0
    === 2014-07-24 16:59:25,255 [2-47] DEBUG IDACall - Header Name:Value pair: Host:127.0.0.1:8888
    === 2014-07-24 16:59:25,255 [2-47] DEBUG IDACall - Header Name:Value pair: Accept:text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    === 2014-07-24 16:59:25,255 [2-47] DEBUG IDACall - Header Name:Value pair: Content-Length:2091
    === 2014-07-24 16:59:25,255 [2-47] DEBUG IDACall - Header Name:Value pair: Content-Type:application/x-www-form-urlencoded; charset=UTF-8
    === 2014-07-24 16:59:25,256 [2-47] DEBUG IDACall - Header Name:Value pair: Accept-Language:en-US,en;q=0.5
    === 2014-07-24 16:59:25,256 [2-47] DEBUG IDACall - Header Name:Value pair: Pragma:no-cache
    === 2014-07-24 16:59:25,256 [2-47] DEBUG IDACall - Header Name:Value pair: Connection:keep-alive
    === 2014-07-24 16:59:25,256 [2-47] DEBUG IDACall - Header Name:Value pair: Referer:http://127.0.0.1:8888/SIMGUI.html?gwt.codesvr=127.0.0.1:9997
    === 2014-07-24 16:59:25,256 [2-47] DEBUG IDACall - Header Name:Value pair: User-Agent:Mozilla/5.0 (Windows NT 6.3; WOW64; rv:24.0) Gecko/20100101 Firefox/24.0
    === 2014-07-24 16:59:25,256 [2-47] DEBUG IDACall - Header Name:Value pair: Cache-Control:no-cache
    === 2014-07-24 16:59:25,256 [2-47] DEBUG IDACall - Header Name:Value pair: Accept-Encoding:gzip, deflate
    === 2014-07-24 16:59:25,256 [2-47] DEBUG IDACall - session exists: i1ag28px11tu126xd5r9fcjuj
    === 2014-07-24 16:59:25,256 [2-47] DEBUG IDACall - remote user: null
    === 2014-07-24 16:59:25,256 [2-47] INFO  RequestContext - URL: '/simgui/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:24.0) Gecko/20100101 Firefox/24.0': Moz (Gecko) with Accept-Encoding header
    === 2014-07-24 16:59:25,259 [2-47] DEBUG XML - Parsed XML from (in memory stream): 2ms
    === 2014-07-24 16:59:25,260 [2-47] DEBUG ISCKeyedObjectPool - Borrowing object for 'transaction'
    === 2014-07-24 16:59:25,260 [2-47] DEBUG ISCKeyedObjectPool - Borrowing object for 'Object'
    === 2014-07-24 16:59:25,260 [2-47] DEBUG ISCKeyedObjectPool - Borrowing object for 'List'
    === 2014-07-24 16:59:25,260 [2-47] DEBUG ISCKeyedObjectPool - Borrowing object for 'elem'
    === 2014-07-24 16:59:25,261 [2-47] DEBUG RPCManager - Processing 1 requests.
    === 2014-07-24 16:59:25,262 [2-47] DEBUG ISCKeyedObjectPool - Borrowing object for 'WFPLANDB_engineers'
    === 2014-07-24 16:59:25,262 [2-47] DEBUG DSRequest - Caching instance 20 of DS WFPLANDB_engineers from DSRequest.getDataSource()
    === 2014-07-24 16:59:25,263 [2-47] DEBUG RPCManager - Request #1 (DSRequest) payload: {
        criteria:{
            _constructor:"AdvancedCriteria",
            operator:"and",
            criteria:[
                {
                    fieldName:"ScenariosPool_ScenarioID",
                    operator:"equals",
                    value:1014
                },
                {
                    fieldName:"Plant",
                    operator:"iContains",
                    value:"DE93"
                }
            ]
        },
        operationConfig:{
            dataSource:"WFPLANDB_engineers",
            operationType:"fetch",
            textMatchStyle:"substring"
        },
        startRow:323,
        endRow:398,
        componentId:"isc_ListGrid_2",
        appID:"builtinApplication",
        operation:"WFPLANDB_engineers_fetch",
        oldValues:{
            _constructor:"AdvancedCriteria",
            operator:"and",
            criteria:[
                {
                    fieldName:"ScenariosPool_ScenarioID",
                    operator:"equals",
                    value:1014
                },
                {
                    fieldName:"Plant",
                    operator:"iContains",
                    value:"DE93"
                }
            ]
        }
    }
    === 2014-07-24 16:59:25,263 [2-47] INFO  IDACall - Performing 1 operation(s)
    === 2014-07-24 16:59:25,263 [2-47] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
    === 2014-07-24 16:59:25,263 [2-47] DEBUG DeclarativeSecurity - DataSource WFPLANDB_engineers is not in the pre-checked list, processing...
    === 2014-07-24 16:59:25,264 [2-47] DEBUG AppBase - [builtinApplication.WFPLANDB_engineers_fetch] No userTypes defined, allowing anyone access to all operations for this application
    === 2014-07-24 16:59:25,264 [2-47] DEBUG AppBase - [builtinApplication.WFPLANDB_engineers_fetch] No public zero-argument method named '_WFPLANDB_engineers_fetch' found, performing generic datasource operation
    === 2014-07-24 16:59:25,265 [2-47] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_fetch] Performing fetch operation with
    	criteria: {criteria:[{fieldName:"ScenariosPool_ScenarioID",operator:"equals",value:1014},{fieldName:"Plant",operator:"iContains",value:"DE93"}],operator:"and",_constructor:"AdvancedCriteria"}	values: {criteria:[{fieldName:"ScenariosPool_ScenarioID",operator:"equals",value:1014},{fieldName:"Plant",operator:"iContains",value:"DE93"}],operator:"and",_constructor:"AdvancedCriteria"}
    === 2014-07-24 16:59:25,267 [2-47] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_fetch] derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause
    === 2014-07-24 16:59:25,268 [2-47] DEBUG SQLDataSource - [builtinApplication.WFPLANDB_engineers_fetch] Executing row count query: SELECT COUNT(*) FROM $defaultTableClause WHERE $defaultWhereClause
    === 2014-07-24 16:59:25,268 [2-47] DEBUG SQLDataSource - [builtinApplication.WFPLANDB_engineers_fetch] Eval'd row count query: SELECT COUNT(*) FROM EngineerScenario WHERE ((EngineerScenario.ScenariosPool_ScenarioID = 1014 AND EngineerScenario.ScenariosPool_ScenarioID IS NOT NULL) AND (LOWER(EngineerScenario.Plant) LIKE LOWER('%de93%') {ESCAPE '\'} AND EngineerScenario.Plant IS NOT NULL))
    === 2014-07-24 16:59:25,269 [2-47] DEBUG PoolableSQLConnectionFactory - [builtinApplication.WFPLANDB_engineers_fetch] Connection was already closed in validateObject - returning false
    === 2014-07-24 16:59:25,270 [2-47] DEBUG PoolableSQLConnectionFactory - [builtinApplication.WFPLANDB_engineers_fetch] DriverManager fetching connection for SQLServer via jdbc url jdbc:sqlserver://127.0.0.1:1433;DatabaseName=WFPLANDB;User=root;
    === 2014-07-24 16:59:25,270 [2-47] DEBUG PoolableSQLConnectionFactory - [builtinApplication.WFPLANDB_engineers_fetch] Passing JDBC URL only to getConnection
    === 2014-07-24 16:59:25,280 [2-47] DEBUG PoolableSQLConnectionFactory - [builtinApplication.WFPLANDB_engineers_fetch] makeObject() created a pooled Connection '32548791'
    === 2014-07-24 16:59:25,280 [2-47] DEBUG SQLConnectionManager - [builtinApplication.WFPLANDB_engineers_fetch] Borrowed connection '32548791'
    === 2014-07-24 16:59:25,280 [2-47] DEBUG SQLDriver - [builtinApplication.WFPLANDB_engineers_fetch] About to execute SQL query in 'SQLServer' using connection '32548791'
    === 2014-07-24 16:59:25,280 [2-47] INFO  SQLDriver - [builtinApplication.WFPLANDB_engineers_fetch] Executing SQL query on 'SQLServer': SELECT COUNT(*) FROM EngineerScenario WHERE ((EngineerScenario.ScenariosPool_ScenarioID = 1014 AND EngineerScenario.ScenariosPool_ScenarioID IS NOT NULL) AND (LOWER(EngineerScenario.Plant) LIKE LOWER('%de93%') {ESCAPE '\'} AND EngineerScenario.Plant IS NOT NULL))
    === 2014-07-24 16:59:25,329 [2-47] DEBUG SQLDataSource - [builtinApplication.WFPLANDB_engineers_fetch] Using SQL Limit query
    === 2014-07-24 16:59:25,330 [2-47] DEBUG SQLServerDriver - [builtinApplication.WFPLANDB_engineers_fetch] Using PK as default sorter: com.isomorphic.sql.SQLOrderClause@5e92e05f
    === 2014-07-24 16:59:25,330 [2-47] DEBUG SQLDataSource - [builtinApplication.WFPLANDB_engineers_fetch] SQL windowed select rows 323->398, result size 75. Query: SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ScenariosPool_ScenarioID, EngineerNumber) AS rowID FROM (SELECT TOP 100 PERCENT  EngineerScenario.AllowCM, EngineerScenario.CompensationInFullWeeks, EngineerScenario.DedicatedFSE, EngineerScenario.District, EngineerScenario.DistrictName, EngineerScenario.Efficiency, EngineerScenario.EngineerName, EngineerScenario.EngineerNumber, EngineerScenario.FTEFieldWork, EngineerScenario.HolidaysInFullWeeks, EngineerScenario.OfHolidays, EngineerScenario.OfSicknessDays, EngineerScenario.OfTimeCompensationInFullWeeks, EngineerScenario.OfTrainingDays_classroomOnly, EngineerScenario.Plant, EngineerScenario.PostalCode, EngineerScenario.ScenariosPool_ScenarioID, EngineerScenario.TrainingDaysInFullWeeks, EngineerScenario.ValidFrom, EngineerScenario.ValidUntil, EngineerScenario.meetingDays FROM EngineerScenario WHERE ((EngineerScenario.ScenariosPool_ScenarioID = 1014 AND EngineerScenario.ScenariosPool_ScenarioID IS NOT NULL) AND (LOWER(EngineerScenario.Plant) LIKE LOWER('%de93%') {ESCAPE '\'} AND EngineerScenario.Plant IS NOT NULL))) x) y WHERE y.rowID BETWEEN 324 AND 398
    === 2014-07-24 16:59:25,330 [2-47] DEBUG SQLDataSource - [builtinApplication.WFPLANDB_engineers_fetch] SQL windowed select rows 323->398, result size 75. Query: SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ScenariosPool_ScenarioID, EngineerNumber) AS rowID FROM (SELECT TOP 100 PERCENT  EngineerScenario.AllowCM, EngineerScenario.CompensationInFullWeeks, EngineerScenario.DedicatedFSE, EngineerScenario.District, EngineerScenario.DistrictName, EngineerScenario.Efficiency, EngineerScenario.EngineerName, EngineerScenario.EngineerNumber, EngineerScenario.FTEFieldWork, EngineerScenario.HolidaysInFullWeeks, EngineerScenario.OfHolidays, EngineerScenario.OfSicknessDays, EngineerScenario.OfTimeCompensationInFullWeeks, EngineerScenario.OfTrainingDays_classroomOnly, EngineerScenario.Plant, EngineerScenario.PostalCode, EngineerScenario.ScenariosPool_ScenarioID, EngineerScenario.TrainingDaysInFullWeeks, EngineerScenario.ValidFrom, EngineerScenario.ValidUntil, EngineerScenario.meetingDays FROM EngineerScenario WHERE ((EngineerScenario.ScenariosPool_ScenarioID = 1014 AND EngineerScenario.ScenariosPool_ScenarioID IS NOT NULL) AND (LOWER(EngineerScenario.Plant) LIKE LOWER('%de93%') {ESCAPE '\'} AND EngineerScenario.Plant IS NOT NULL))) x) y WHERE y.rowID BETWEEN 324 AND 398
    === 2014-07-24 16:59:25,345 [2-47] INFO  DSResponse - [builtinApplication.WFPLANDB_engineers_fetch] DSResponse: List with 48 items
    === 2014-07-24 16:59:25,345 [2-47] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
    === 2014-07-24 16:59:25,345 [2-47] DEBUG RPCManager - non-DMI response, dropExtraFields: false
    === 2014-07-24 16:59:25,346 [2-47] DEBUG SQLDriver - Freeing SQLDriver dbConnection 32548791
    My datasource:

    Code:
    <DataSource ID="WFPLANDB_engineers" serverType="sql"
    	tableName="EngineerScenario"
    	tableForChangeColumns="EngineerScenario">
    
    	<fields>
    		<field name="ScenariosPool_ScenarioID" primaryKey="true" type="integer" hidden="true" />
    		<field name="Plant" type="text" canEditGridCell="false" />
    		<field name="EngineerNumber" primaryKey="true" type="integer" title="FSE ID" canEditGridCell="false" />
    		<field name="EngineerName" type="text" canEditGridCell="false" title="FSE Name" />
    		<field name="District" type="text" title="District" />
    		<field name="DistrictName" type="text" title="District Name" />
    		<field name="PostalCode" type="text" title="Postal Code" />
    		<field name="DedicatedFSE" type="text" title="Dedicated FSE?" />
    		<field name="FTEFieldWork" type="double" title="FTE Field Work" />
    		<field name="ValidFrom" type="date" title="Valid From" />
    		<field name="ValidUntil" type="date" title="Valid Until" />
    		<field name="meetingDays" type="integer" title="# meeting Days" />
    		<field name="OfTrainingDays_classroomOnly" type="integer"
    			title="# Of Training Days (class-room only)" />
    		<field name="TrainingDaysInFullWeeks" type="double"
    			title="% Training Days In Full Weeks" />
    		<field name="OfHolidays" type="integer" title="# Of Vacation Days" />
    		<field name="HolidaysInFullWeeks" type="double"
    			title="% Of Vacation Days in Full Weeks" />
    		<field name="OfSicknessDays" type="integer" title="# Of Sickness Days" />
    		<field name="OfTimeCompensationInFullWeeks" type="integer"
    			title="# Of Time Compensation Days" />
    		<field name="CompensationInFullWeeks" type="double"
    			title="# Of Time Compensation Days in Full Weeks" />
    		<field name="Efficiency" type="double" title="Efficiency %" allowNull="false" />
    		<field name="AllowCM" type="boolean" title="Allow CM work" allowNull="false" />
    	</fields>
    
    </DataSource>
    So, as seen in the log, the problem is that after the Add, there is an automatic fetch with no criteria (1=1) which fetches a bunch of data that should not be visible.
    After filtering, the criteria is back, (as set in the listGrid).

    So, it all comes down to this automatic fetch after an add...

    Can you help?
    Last edited by Macomi; 24 Jul 2014, 08:22.

    #2
    Hi Macomi,

    seems to be related to the cacheSync after the add:

    See this part of the log:
    Code:
    === 2014-07-24 16:59:13,194 [2-29] DEBUG SQLDriver - [builtinApplication.WFPLANDB_engineers_add] Discovered multiple generated keys via JDBC: {}
    === 2014-07-24 16:59:13,196 [2-29] DEBUG SQLDataSource - [builtinApplication.WFPLANDB_engineers_add] add operation affected 1 rows
    === 2014-07-24 16:59:13,197 [2-29] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_add] primaryKeys: {}
    It seems JDBC can't figure out the newly generated PK. Any idea why this is?
    Is
    Code:
    <field name="ScenariosPool_ScenarioID" primaryKey="true" type="integer" hidden="true" />
    really correct? Are other PKs in your .ds.xml defined the same way?

    Best regards,
    Blama
    Last edited by Blama; 24 Jul 2014, 07:37.

    Comment


      #3
      Hi Blama,

      thanks for your reply.

      To complete the information, the primary key consistes of two fields:

      1)
      Code:
      <field name="ScenariosPool_ScenarioID" primaryKey="true" type="integer" hidden="true" />
      which, when adding a new row, I set in:
      Code:
      Map<String, Integer> defaultvalues = new HashMap<String, Integer>();
      defaultvalues.put(DBConstants.SCENARIOROWLABEL, scenario);
      listGrid.startEditingNew(defaultvalues);
      2)
      Code:
      <field name="EngineerNumber" primaryKey="true" type="integer" title="FSE ID" canEditGridCell="false" />
      this one is inputted by the user.

      Comment


        #4
        Hi Macomi,

        that's one for Isomorphic.
        I'd guess that this is a bug. As both your PK fields are integer (no autoincrement/identity or sequence), no lookup for the in the JBDC driver should be necessary. The SQLDriver tries it nevertheless.

        As warning: You did not strip out your Password information from the logs.

        Best regards,
        Blama

        Comment


          #5
          Ahahahah! Thanks :)

          It's a development and not production password, but I stripped it out anyway, thanks for the heads up!
          Last edited by Macomi; 24 Jul 2014, 08:26.

          Comment


            #6
            Running the same code, with smargwtpro 3.1 (our previous license), all is fine:

            Code:
            === 2014-07-25 15:21:03,764 [8-26] INFO  IDACall - Performing 1 operation(s)
            === 2014-07-25 15:21:03,764 [8-26] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
            === 2014-07-25 15:21:03,764 [8-26] DEBUG DeclarativeSecurity - DataSource WFPLANDB_engineers is not in the pre-checked list, processing...
            === 2014-07-25 15:21:03,764 [8-26] DEBUG AppBase - [builtinApplication.WFPLANDB_engineers_add] No userTypes defined, allowing anyone access to all operations for this application
            === 2014-07-25 15:21:03,764 [8-26] DEBUG AppBase - [builtinApplication.WFPLANDB_engineers_add] No public zero-argument method named '_WFPLANDB_engineers_add' found, performing generic datasource operation
            === 2014-07-25 15:21:03,765 [8-26] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_add] Performing add operation with
            	criteria: {ScenariosPool_ScenarioID:1017,Plant:"DE93",EngineerNumber:123456,Efficiency:1,AllowCM:true}	values: {ScenariosPool_ScenarioID:1017,Plant:"DE93",EngineerNumber:123456,Efficiency:1.0,AllowCM:true}
            === 2014-07-25 15:21:03,767 [8-26] DEBUG SQLValuesClause - [builtinApplication.WFPLANDB_engineers_add] Sequences: {}
            === 2014-07-25 15:21:03,768 [8-26] DEBUG SQLConnectionManager - [builtinApplication.WFPLANDB_engineers_add] Returning borrowed connection '396717050'
            === 2014-07-25 15:21:03,768 [8-26] DEBUG SQLDriver - [builtinApplication.WFPLANDB_engineers_add] About to execute SQL update in 'SQLServer' using connection'396717050'
            === 2014-07-25 15:21:03,769 [8-26] INFO  SQLDriver - [builtinApplication.WFPLANDB_engineers_add] Executing SQL update on 'SQLServer': INSERT INTO EngineerScenario (AllowCM, Efficiency, EngineerNumber, Plant, ScenariosPool_ScenarioID) VALUES ('true', 1.0, 123456, 'DE93', 1017)
            === 2014-07-25 15:21:03,798 [8-26] DEBUG SQLDataSource - [builtinApplication.WFPLANDB_engineers_add] add operation affected 1 rows
            === 2014-07-25 15:21:03,798 [8-26] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_add] primaryKeys: {EngineerNumber=123456, ScenariosPool_ScenarioID=1017}
            === 2014-07-25 15:21:03,798 [8-26] DEBUG DeclarativeSecurity - [builtinApplication.WFPLANDB_engineers_add] Processing security checks for DataSource null, field null
            === 2014-07-25 15:21:03,798 [8-26] DEBUG DeclarativeSecurity - [builtinApplication.WFPLANDB_engineers_add] DataSource WFPLANDB_engineers is not in the pre-checked list, processing...
            === 2014-07-25 15:21:03,799 [8-26] DEBUG AppBase - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] No userTypes defined, allowing anyone access to all operations for this application
            === 2014-07-25 15:21:03,799 [8-26] DEBUG AppBase - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] No public zero-argument method named '_null' found, performing generic datasource operation
            === 2014-07-25 15:21:03,799 [8-26] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] Performing fetch operation with
            	criteria: {EngineerNumber:123456,ScenariosPool_ScenarioID:1017}	values: {EngineerNumber:123456,ScenariosPool_ScenarioID:1017}
            === 2014-07-25 15:21:03,799 [8-26] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause
            === 2014-07-25 15:21:03,799 [8-26] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] Executing SQL query on 'SQLServer': SELECT EngineerScenario.AllowCM, EngineerScenario.CompensationInFullWeeks, EngineerScenario.DedicatedFSE, EngineerScenario.District, EngineerScenario.DistrictName, EngineerScenario.Efficiency, EngineerScenario.EngineerName, EngineerScenario.EngineerNumber, EngineerScenario.FTEFieldWork, EngineerScenario.HolidaysInFullWeeks, EngineerScenario.OfHolidays, EngineerScenario.OfSicknessDays, EngineerScenario.OfTimeCompensationInFullWeeks, EngineerScenario.OfTrainingDays_classroomOnly, EngineerScenario.Plant, EngineerScenario.PostalCode, EngineerScenario.ScenariosPool_ScenarioID, EngineerScenario.TrainingDaysInFullWeeks, EngineerScenario.ValidFrom, EngineerScenario.ValidUntil, EngineerScenario.meetingDays FROM EngineerScenario WHERE (EngineerScenario.EngineerNumber=123456 AND EngineerScenario.ScenariosPool_ScenarioID=1017)
            === 2014-07-25 15:21:03,799 [8-26] DEBUG SQLDriver - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] About to execute SQL query in 'SQLServer' using connection '396717050'
            === 2014-07-25 15:21:03,799 [8-26] INFO  SQLDriver - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] Executing SQL query on 'SQLServer': SELECT EngineerScenario.AllowCM, EngineerScenario.CompensationInFullWeeks, EngineerScenario.DedicatedFSE, EngineerScenario.District, EngineerScenario.DistrictName, EngineerScenario.Efficiency, EngineerScenario.EngineerName, EngineerScenario.EngineerNumber, EngineerScenario.FTEFieldWork, EngineerScenario.HolidaysInFullWeeks, EngineerScenario.OfHolidays, EngineerScenario.OfSicknessDays, EngineerScenario.OfTimeCompensationInFullWeeks, EngineerScenario.OfTrainingDays_classroomOnly, EngineerScenario.Plant, EngineerScenario.PostalCode, EngineerScenario.ScenariosPool_ScenarioID, EngineerScenario.TrainingDaysInFullWeeks, EngineerScenario.ValidFrom, EngineerScenario.ValidUntil, EngineerScenario.meetingDays FROM EngineerScenario WHERE (EngineerScenario.EngineerNumber=123456 AND EngineerScenario.ScenariosPool_ScenarioID=1017)
            === 2014-07-25 15:21:03,806 [8-26] INFO  DSResponse - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] DSResponse: List with 1 items
            === 2014-07-25 15:21:03,806 [8-26] DEBUG SQLConnectionManager - [builtinApplication.WFPLANDB_engineers_add] About to close PoolableConnection with hashcode "396717050"
            === 2014-07-25 15:21:03,807 [8-26] INFO  DSResponse - [builtinApplication.WFPLANDB_engineers_add] DSResponse: List with 1 items
            === 2014-07-25 15:21:03,807 [8-26] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
            === 2014-07-25 15:21:03,807 [8-26] DEBUG RPCManager - non-DMI response, dropExtraFields: false
            Isomorphic?

            Comment


              #7
              By the way, on the 4.1 version, I tried to set sequenceMode="none" on my dataSource and to set a cacheSyncOperation that uses the correct primary keys. That solves the problem of fetching only the added row :)

              However, adding is still different on the GUI.
              Unlike 3.1, the added row does not stay blue waiting for the insert and resumes it there.
              On 4.1, the row just disappears (although it is there if you scroll down).

              Comment


                #8
                Hmmmm, I see that the last point relates to this:

                http://forums.smartclient.com/showthread.php?t=29977

                http://forums.smartclient.com/showth...666#post121666

                So, I should update to a nightly build > 17 July.

                I confirmed that all is ok in our deployed app, so those threads apply to me.

                So, the solution to the initial problem is to simply to set the dataSource to sequenceMode="none" and make a cacheSyncOperation.

                Comment


                  #9
                  Hi Macomi,

                  did you try if it is enough just to set the sequenceMode="none"?
                  Once the PK-discovery works, the built-in default cacheSync should work as expected, shouldn't it?

                  Best regards,
                  Blama

                  Comment


                    #10
                    Yes, it does work without the cacheSyncOperation, you are right... I was just blindly following the documentation.

                    However, I have to say this feels like a workaround. First because it is not needed in 3.1. Second, because in 4.1, it is not needed for updates, only for adds :(

                    Comment


                      #11
                      Hi Macomi,

                      of course it is only needed for add. When updating, the PK is known in all cases. For add, it might be unknown at insert-time (when using a sequence or identity column), but can be discovered after the INSERT.
                      Your case is a special case I'd say.
                      Perhaps the setting sequenceMode="none" is new with 4.0/4.1? Did you check the 3.1 docs for it?

                      For more details, Isomorphic has to jump in.

                      Best regards,
                      Blama

                      Comment


                        #12
                        You are both right: sequenceMode is new in 4.1, and it is misbehaviing in this case - the workaround of setting sequenceMode="none" should not be necessary.

                        We have fixed this now - fix will be in nightly 4.1 and 5.0 builds as of tomorrow, July 30.

                        Comment


                          #13
                          Thanks, Isomorphic!

                          I will reset my datasource files tomorrow then.

                          Comment


                            #14
                            It works, without the sequenceMode=none

                            Thanks!

                            Comment

                            Working...
                            X