Announcement

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

    SequenceMode is not JDBC_DRIVER, skipping search for generated values 

    Hello, I'm trying to update an application from
    SmartClient Enterprise v121d_2019-11-11
    to
    SmartClient Enterprise v121p_2020-09-18
    but I've got an issue, where in a DMI I have an insert, and then I need the pk of the inserted record, with the more recent build I see in the logs:

    Code:
    2020-09-22T17:12:05,573 DEBUG SQLDataSource Setting DSRequest as being part of a transaction
    2020-09-22T17:12:05,573 INFO  SQLDriver Executing SQL query on 'DBJOFC' using connection '1081512651': INSERT INTO DBJOFC.JOFC_ISCRIZIONE_SOCIO (CREATOR, CREATOR_TIMESTAMP, ID_CLUB_FK, ID_SOCIO_ELIMINATO_ABBONAMENTO, ID_SOCIO_FK, ID_STAGIONE_ISCRIZIONE_FK, IS_ABBONATO_BY_ANAG_ELIMINATA, MODIFIER, MODIFIER_TIMESTAMP, VALORE_QUOTA, ID_REC) VALUES ('foo.bar@fastwebnet.it', TO_DATE('2020-09-22 17:12:05','YYYY-MM-DD HH24:MI:SS'), 33122, NULL, 206576, 7158318, 'F', 'foo.bar@fastwebnet.it', TO_DATE('2020-09-22 17:12:05','YYYY-MM-DD HH24:MI:SS'), 18.0, DBJOFC.SEQUENCE_ID_JOFC.NextVal)
    2020-09-22T17:12:05,651 DEBUG SQLDriver SequenceMode is not JDBC_DRIVER, skipping search for generated values
    2020-09-22T17:12:05,653 INFO  SQLDataSource primaryKeys: {}
    2020-09-22T17:12:05,653 DEBUG SQLDataSource Gathered all keys.  lastPrimaryKeys is now {}
    2020-09-22T17:12:05,653 DEBUG SQLDataSource add operation affected 1 rows
    2020-09-22T17:12:05,653 INFO  SQLDataSource DBJOFC getLastRow(): using default operationBinding
    2020-09-22T17:12:05,654 DEBUG DSRequest Constructing DSRequest 1032630243
    2020-09-22T17:12:05,655 INFO  DSRequest Executing JOFC_ISCRIZIONE_SOCIO.fetch rows: 0->-1 with
    criteria: {}
    so I get a null for the pk, while with the older version, I get correctly the primary key:
    Code:
    2020-09-22T17:20:55,994 DEBUG SQLDataSource Setting DSRequest as being part of a transaction
    2020-09-22T17:20:55,994 INFO  SQLDriver Executing SQL query on 'DBJOFC'' using connection '2038309425': INSERT INTO DBJOFC.JOFC_ISCRIZIONE_SOCIO (CREATOR, CREATOR_TIMESTAMP, ID_CLUB_FK, ID_SOCIO_ELIMINATO_ABBONAMENTO, ID_SOCIO_FK, ID_STAGIONE_ISCRIZIONE_FK, IS_ABBONATO_BY_ANAG_ELIMINATA, MODIFIER, MODIFIER_TIMESTAMP, VALORE_QUOTA, ID_REC) VALUES ('foo.bar@fastwebnet.it', TO_DATE('2020-09-22 17:20:55','YYYY-MM-DD HH24:MI:SS'), 33122, NULL, 206576, 7158318, 'F', 'foo.bar@fastwebnet.it', TO_DATE('2020-09-22 17:20:55','YYYY-MM-DD HH24:MI:SS'), 18.0, DBJOFC.SEQUENCE_ID_JOFC.NextVal)
    2020-09-22T17:20:56,220 DEBUG SQLDriver SequenceMode is not JDBC_DRIVER, skipping search for generated values
    2020-09-22T17:20:56,221 DEBUG SQLDataSource Setting DSRequest as being part of a transaction
    2020-09-22T17:20:56,221 INFO  SQLDriver Executing SQL query on 'DBJOFC'' using connection '2038309425': SELECT DBJOFC.SEQUENCE_ID_JOFC.CurrVal FROM DUAL
    2020-09-22T17:20:56,419 INFO  SQLDataSource primaryKeys: {ID_REC=1155782}
    2020-09-22T17:20:56,419 DEBUG SQLDataSource Gathered all keys.  lastPrimaryKeys is now {ID_REC=1155782}
    2020-09-22T17:20:56,419 DEBUG SQLDataSource add operation affected 1 rows
    2020-09-22T17:20:56,419 INFO  SQLDataSource DBJOFC getLastRow(): using default operationBinding
    the only difference between those logs is the SmartClient version. The database is Oracle 12c Enterprise Edition Release 12.2.0.1.0 - 64bit, driver ojdbc8, the primary key is defined as:

    Code:
            <field sqlType="decimal" primaryKey="true" name="ID_REC" type="sequence" hidden="true">
                <sequenceName>SEQUENCE_ID_JOFC</sequenceName>
            </field>
    Last edited by claudiobosticco; 22 Sep 2020, 08:37. Reason: oracle and driver version

    #2
    SmartClient Version: v12.1p_2020-09-23/Enterprise Deployment (built 2020-09-23)

    Hello, I've put together a simple test case, and maybe I've discovered something useful - it seems related to dataSources which inherits from another dataSource.

    Code:
    <DataSource xmlns:fmt="WEB-INF/" xmlns="http://www.smartclient.com/schema"
                ID="JOFC_CALCOLO_QUOTA_BASE"
                tableName="JOFC_CALCOLO_QUOTA"
                schema="DBJOFC"
                dbName="DBJOFC"
                serverType="sql"
                requiresAuthentication="true"
    >
        <fmt:bundle basename="i18nMessages" encoding="utf-8"/>
        <fields>
            <field sqlType="decimal" primaryKey="true" name="ID_REC" type="sequence" hidden="true">
                <sequenceName>SEQUENCE_ID_JOFC</sequenceName>
            </field>
            <field name="QUOTA" type="localeFloat" format=",##0.00 €"/>
            <field name="HAS_MEMBERSHIP" type="boolean" sqlStorageStrategy="singleCharTF"/>
            <field name="IS_ABBONATO" type="boolean" sqlStorageStrategy="singleCharTF"/>
            <field name="IS_UNDER_16" type="boolean" sqlStorageStrategy="singleCharTF"/>
            <field name="IS_UNDER_6" type="boolean" sqlStorageStrategy="singleCharTF"/>
        </fields>
        <operationBindings>
            <operationBinding operationType="fetch" requires="false"/>
            <operationBinding operationType="add" requires="false"/>
            <operationBinding operationType="update" requires="false"/>
            <operationBinding operationType="remove" requires="false"/>
        </operationBindings>
    </DataSource>
    Code:
    <DataSource xmlns:fmt="WEB-INF/" xmlns="http://www.smartclient.com/schema"
                ID="JOFC_CALCOLO_QUOTA"
                tableName="JOFC_CALCOLO_QUOTA"
                schema="DBJOFC"
                dbName="DBJOFC"
                serverType="sql"
                requiresAuthentication="true"
                inheritsFrom="JOFC_CALCOLO_QUOTA_BASE"
    >
        <fmt:bundle basename="i18nMessages" encoding="utf-8"/>
    
        <operationBindings>
            <operationBinding operationType="fetch" requires="true"/>
            <operationBinding operationType="add" requires="false"/>
            <operationBinding operationType="update" requires="false"/>
            <operationBinding operationType="remove" requires="false"/>
        </operationBindings>
    </DataSource>
    If I execute an add using the 'inheriting' dataSource:

    Code:
            
            DSRequest dsRequest1 = new DSRequest("JOFC_CALCOLO_QUOTA", "add", rpcManager);
            dsRequest1.setValues(DataTools.buildMap("HAS_MEMBERSHIP", true, "QUOTA", 10));
            DSResponse dsResponse1 = dsRequest1.execute();
            Map record1 = dsResponse1.getDataMap();
    you may see (in bold) that the primary key of the inserted record isn't gathered:

    Code:
    2020-09-23T16:03:33,137 DEBUG DSRequest Constructing DSRequest 2129175468
    2020-09-23T16:03:33,144 DEBUG XML Parsed XML from /Users/bosticco/iscSDK/tools/visualBuilder/workspace/JOFC/out/artifacts/JOFC_war_exploded/shared/ds/JOFC_CALCOLO_QUOTA.ds.xml: 5ms
    2020-09-23T16:03:33,155 [ ] DEBUG FileDownload Registered expires mapping - text/javascript: 31104000 seconds
    2020-09-23T16:03:33,155 [ ] DEBUG FileDownload Registered expires mapping - image/gif: 31104000 seconds
    2020-09-23T16:03:33,155 [ ] DEBUG FileDownload Registered expires mapping - image/png: 31104000 seconds
    2020-09-23T16:03:33,155 [ ] DEBUG FileDownload Registered expires mapping - image/jpeg: 31104000 seconds
    2020-09-23T16:03:33,155 [ ] DEBUG FileDownload Registered expires mapping - image/x-icon: 31104000 seconds
    2020-09-23T16:03:33,155 [ ] DEBUG FileDownload Registered expires mapping - text/css: 31104000 seconds
    2020-09-23T16:03:33,156 [ ] INFO  RequestContext URL: '/JOFC/isomorphic/skins/Stratus/images/DynamicForm/default_formItem_icon.png', User-Agent: 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36': Safari with Accept-Encoding header
    2020-09-23T16:03:33,162 DEBUG BasicDataSource undefined multipleStorage was set to 'simpleString' for field groups
    2020-09-23T16:03:33,162 DEBUG BasicDataSource undefined multipleStorage was set to 'simpleString' for field patternMultiWildcard
    2020-09-23T16:03:33,162 DEBUG BasicDataSource undefined multipleStorage was set to 'simpleString' for field patternSingleWildcard
    2020-09-23T16:03:33,162 DEBUG BasicDataSource undefined multipleStorage was set to 'simpleString' for field projectFileLocations
    2020-09-23T16:03:33,163 DEBUG PoolableDataSourceFactory Created DataSource 42 of type 'DataSource' and assigned it to thread https-jsse-nio-8445-exec-4
    2020-09-23T16:03:33,163 DEBUG PoolableDataSourceFactory Created DataSource 42 of type 'DataSource' in the pooling flow
    2020-09-23T16:03:33,163 DEBUG PoolableDataSourceFactory Activated DataSource 42 of type 'DataSource'
    2020-09-23T16:03:33,164 DEBUG BasicDataSource Validating a 'DataSource' at path ''
    2020-09-23T16:03:33,168 DEBUG PoolableDataSourceFactory Created DataSource 43 of type 'Object' and assigned it to thread https-jsse-nio-8445-exec-4
    2020-09-23T16:03:33,168 DEBUG PoolableDataSourceFactory Created DataSource 43 of type 'Object' in the pooling flow
    2020-09-23T16:03:33,168 DEBUG PoolableDataSourceFactory Activated DataSource 43 of type 'Object'
    2020-09-23T16:03:33,168 DEBUG BasicDataSource Validating a 'Object' at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA]'
    2020-09-23T16:03:33,169 DEBUG PoolableDataSourceFactory Tried to create DataSource  of type 'fmt:bundle' but null was returned
    2020-09-23T16:03:33,169 DEBUG PoolableDataSourceFactory Created DataSource null of type 'fmt:bundle' in the pooling flow
    2020-09-23T16:03:33,174 DEBUG BasicDataSource undefined multipleStorage was set to 'simpleString' for field groupBy
    2020-09-23T16:03:33,174 [ ] INFO  Download done streaming: /Users/bosticco/iscSDK/tools/visualBuilder/workspace/JOFC/out/artifacts/JOFC_war_exploded/isomorphic/skins/Stratus/images/DynamicForm/default_formItem_icon.png
    2020-09-23T16:03:33,174 DEBUG PoolableDataSourceFactory Created DataSource 44 of type 'OperationBinding' and assigned it to thread https-jsse-nio-8445-exec-4
    2020-09-23T16:03:33,175 DEBUG PoolableDataSourceFactory Created DataSource 44 of type 'OperationBinding' in the pooling flow
    2020-09-23T16:03:33,175 DEBUG PoolableDataSourceFactory Activated DataSource 44 of type 'OperationBinding'
    2020-09-23T16:03:33,175 DEBUG BasicDataSource Validating 4 'OperationBinding's at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA]/operationBindings'
    2020-09-23T16:03:33,175 DEBUG BasicDataSource Validating a 'OperationBinding' at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA]/operationBindings/0'
    2020-09-23T16:03:33,176 DEBUG PoolableDataSourceFactory Tried to create DataSource  of type 'operationBinding' but null was returned
    2020-09-23T16:03:33,176 DEBUG PoolableDataSourceFactory Created DataSource null of type 'operationBinding' in the pooling flow
    2020-09-23T16:03:33,178 DEBUG BasicDataSource Validating a 'OperationBinding' at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA]/operationBindings/1'
    2020-09-23T16:03:33,179 DEBUG BasicDataSource Validating a 'OperationBinding' at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA]/operationBindings/2'
    2020-09-23T16:03:33,179 DEBUG BasicDataSource Validating a 'OperationBinding' at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA]/operationBindings/3'
    2020-09-23T16:03:33,180 DEBUG BasicDataSource Done validating 4 'OperationBinding's at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA]/operationBindings': 5ms (avg 1)
    2020-09-23T16:03:33,182 DEBUG BasicDataSource Done validating a 'DataSource' at path '': 18ms
    2020-09-23T16:03:33,184 DEBUG BasicDataSource Looking up superDS of DataSource JOFC_CALCOLO_QUOTA: 'JOFC_CALCOLO_QUOTA_BASE'
    2020-09-23T16:03:33,188 DEBUG XML Parsed XML from /Users/bosticco/iscSDK/tools/visualBuilder/workspace/JOFC/out/artifacts/JOFC_war_exploded/shared/ds/base/JOFC_CALCOLO_QUOTA_BASE.ds.xml: 4ms
    2020-09-23T16:03:33,213 DEBUG BasicDataSource undefined multipleStorage was set to 'simpleString' for field groups
    2020-09-23T16:03:33,214 DEBUG BasicDataSource undefined multipleStorage was set to 'simpleString' for field patternMultiWildcard
    2020-09-23T16:03:33,214 DEBUG BasicDataSource undefined multipleStorage was set to 'simpleString' for field patternSingleWildcard
    2020-09-23T16:03:33,214 DEBUG BasicDataSource undefined multipleStorage was set to 'simpleString' for field projectFileLocations
    2020-09-23T16:03:33,214 DEBUG PoolableDataSourceFactory Created DataSource 46 of type 'DataSource' and assigned it to thread https-jsse-nio-8445-exec-4
    2020-09-23T16:03:33,214 DEBUG PoolableDataSourceFactory Created DataSource 46 of type 'DataSource' in the pooling flow
    2020-09-23T16:03:33,214 DEBUG PoolableDataSourceFactory Activated DataSource 46 of type 'DataSource'
    2020-09-23T16:03:33,214 DEBUG BasicDataSource Validating a 'DataSource' at path ''
    2020-09-23T16:03:33,217 DEBUG PoolableDataSourceFactory Created DataSource 47 of type 'Object' and assigned it to thread https-jsse-nio-8445-exec-4
    2020-09-23T16:03:33,217 DEBUG PoolableDataSourceFactory Created DataSource 47 of type 'Object' in the pooling flow
    2020-09-23T16:03:33,217 DEBUG PoolableDataSourceFactory Activated DataSource 47 of type 'Object'
    2020-09-23T16:03:33,217 DEBUG BasicDataSource Validating a 'Object' at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA_BASE]'
    2020-09-23T16:03:33,218 DEBUG PoolableDataSourceFactory Tried to create DataSource  of type 'fmt:bundle' but null was returned
    2020-09-23T16:03:33,218 DEBUG PoolableDataSourceFactory Created DataSource null of type 'fmt:bundle' in the pooling flow
    2020-09-23T16:03:33,224 DEBUG PoolableDataSourceFactory Created DataSource 48 of type 'DataSourceField' and assigned it to thread https-jsse-nio-8445-exec-4
    2020-09-23T16:03:33,224 DEBUG PoolableDataSourceFactory Created DataSource 48 of type 'DataSourceField' in the pooling flow
    2020-09-23T16:03:33,224 DEBUG PoolableDataSourceFactory Activated DataSource 48 of type 'DataSourceField'
    2020-09-23T16:03:33,225 DEBUG BasicDataSource Validating 6 'DataSourceField's at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA_BASE]/fields'
    2020-09-23T16:03:33,225 DEBUG BasicDataSource Validating a 'DataSourceField' at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA_BASE]/fields/0'
    2020-09-23T16:03:33,226 DEBUG BasicDataSource Validating a 'DataSourceField' at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA_BASE]/fields/1'
    2020-09-23T16:03:33,227 DEBUG BasicDataSource Validating a 'DataSourceField' at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA_BASE]/fields/2'
    2020-09-23T16:03:33,228 DEBUG BasicDataSource Validating a 'DataSourceField' at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA_BASE]/fields/3'
    2020-09-23T16:03:33,229 DEBUG BasicDataSource Validating a 'DataSourceField' at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA_BASE]/fields/4'
    2020-09-23T16:03:33,229 DEBUG BasicDataSource Validating a 'DataSourceField' at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA_BASE]/fields/5'
    2020-09-23T16:03:33,230 DEBUG BasicDataSource Done validating 6 'DataSourceField's at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA_BASE]/fields': 5ms (avg 0)
    2020-09-23T16:03:33,237 DEBUG BasicDataSource undefined multipleStorage was set to 'simpleString' for field groupBy
    2020-09-23T16:03:33,237 DEBUG PoolableDataSourceFactory Created DataSource 49 of type 'OperationBinding' and assigned it to thread https-jsse-nio-8445-exec-4
    2020-09-23T16:03:33,237 DEBUG PoolableDataSourceFactory Created DataSource 49 of type 'OperationBinding' in the pooling flow
    2020-09-23T16:03:33,237 DEBUG PoolableDataSourceFactory Activated DataSource 49 of type 'OperationBinding'
    2020-09-23T16:03:33,238 DEBUG BasicDataSource Validating 4 'OperationBinding's at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA_BASE]/operationBindings'
    2020-09-23T16:03:33,238 DEBUG BasicDataSource Validating a 'OperationBinding' at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA_BASE]/operationBindings/0'
    2020-09-23T16:03:33,239 DEBUG PoolableDataSourceFactory Tried to create DataSource  of type 'operationBinding' but null was returned
    2020-09-23T16:03:33,239 DEBUG PoolableDataSourceFactory Created DataSource null of type 'operationBinding' in the pooling flow
    2020-09-23T16:03:33,240 DEBUG BasicDataSource Validating a 'OperationBinding' at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA_BASE]/operationBindings/1'
    2020-09-23T16:03:33,240 DEBUG BasicDataSource Validating a 'OperationBinding' at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA_BASE]/operationBindings/2'
    2020-09-23T16:03:33,241 DEBUG BasicDataSource Validating a 'OperationBinding' at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA_BASE]/operationBindings/3'
    2020-09-23T16:03:33,241 DEBUG BasicDataSource Done validating 4 'OperationBinding's at path '/DataSource[@ID=JOFC_CALCOLO_QUOTA_BASE]/operationBindings': 3ms (avg 0)
    2020-09-23T16:03:33,241 DEBUG BasicDataSource Done validating a 'DataSource' at path '': 27ms
    2020-09-23T16:03:33,245 DEBUG PoolableDataSourceFactory Created DataSource 50 of type 'JOFC_CALCOLO_QUOTA_BASE' and assigned it to thread https-jsse-nio-8445-exec-4
    2020-09-23T16:03:33,245 DEBUG PoolableDataSourceFactory Created DataSource 50 of type 'JOFC_CALCOLO_QUOTA_BASE' in the pooling flow
    2020-09-23T16:03:33,245 DEBUG PoolableDataSourceFactory Activated DataSource 50 of type 'JOFC_CALCOLO_QUOTA_BASE'
    2020-09-23T16:03:33,246 DEBUG PoolableDataSourceFactory Created DataSource 45 of type 'JOFC_CALCOLO_QUOTA' and assigned it to thread https-jsse-nio-8445-exec-4
    2020-09-23T16:03:33,246 DEBUG PoolableDataSourceFactory Created DataSource 45 of type 'JOFC_CALCOLO_QUOTA' in the pooling flow
    2020-09-23T16:03:33,246 DEBUG PoolableDataSourceFactory Activated DataSource 45 of type 'JOFC_CALCOLO_QUOTA'
    2020-09-23T16:03:33,246 DEBUG DSRequest Caching instance 45 of DS 'JOFC_CALCOLO_QUOTA' from DSRequest.getDataSource()
    2020-09-23T16:03:33,247 DEBUG DataSource JOFC_CALCOLO_QUOTAisSandboxEligible?: false
    2020-09-23T16:03:33,247 DEBUG DataSource JOFC_CALCOLO_QUOTA isCacheable?: true
    2020-09-23T16:03:33,247 DEBUG DSRequest Caching instance 45 of DS JOFC_CALCOLO_QUOTA
    2020-09-23T16:03:33,249 INFO  DSRequest Executing JOFC_CALCOLO_QUOTA.add with
    criteria: {}
    values: {HAS_MEMBERSHIP:true, QUOTA:10}
    2020-09-23T16:03:33,249 DEBUG DeclarativeSecurity Processing security checks for DataSource null, field null
    2020-09-23T16:03:33,249 DEBUG DeclarativeSecurity Request is not a client request, ignoring security checks.
    2020-09-23T16:03:33,255 DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
    2020-09-23T16:03:33,255 DEBUG AppBase No public zero-argument method named '_null' found, performing generic datasource operation
    2020-09-23T16:03:33,256 DEBUG BasicDataSource Validating 1 'JOFC_CALCOLO_QUOTA's at path ''
    2020-09-23T16:03:33,256 DEBUG BasicDataSource Validating a 'JOFC_CALCOLO_QUOTA' at path ''
    2020-09-23T16:03:33,261 DEBUG BasicDataSource Done validating 1 'JOFC_CALCOLO_QUOTA's at path '': 5ms (avg 5)
    2020-09-23T16:03:33,262 DEBUG DataSource post-validation valueSet: [
        {
            HAS_MEMBERSHIP:true,
            QUOTA:10.0
        }
    ]
    2020-09-23T16:03:33,307 DEBUG SQLDriver DBJOFC: Initializing SQL config via JNDI
    2020-09-23T16:03:33,372 DEBUG SQLDriver DBJOFC: Database metadata: {
        databaseProductString:"Oracle Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production",
        driverName:"Oracle JDBC driver",
        driverMajorVersion:12,
        driverMinorVersion:2,
        databaseProductName:"Oracle",
        databaseProductVersion:"Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production",
        databaseMinorVersion:2,
        databaseMajorVersion:12,
        JDBCMinorVersion:2,
        driverVersion:"12.2.0.1.0",
        JDBCMajorVersion:4
    }
    2020-09-23T16:03:33,423 DEBUG SQLDataSource DataSource 45 acquired SQLDriver instance 1187560524 during initialization
    2020-09-23T16:03:33,424 DEBUG SQLValuesClause Sequences: {ID_REC=SEQUENCE_ID_JOFC}
    2020-09-23T16:03:33,458 INFO  PoolManager SmartClient pooling disabled for 'DBJOFC' objects
    2020-09-23T16:03:33,494 DEBUG PoolableSQLConnectionFactory makeObject() created an unpooled Connection '463841394'
    2020-09-23T16:03:33,495 DEBUG SQLConnectionManager Borrowed connection '463841394'
    2020-09-23T16:03:33,495 DEBUG SQLTransaction Started new DBJOFC transaction "463841394"
    2020-09-23T16:03:33,495 DEBUG SQLDataSource Setting DSRequest as being part of a transaction
    2020-09-23T16:03:33,498 INFO  SQLDriver Executing SQL query on 'DBJOFC' using connection '463841394': INSERT INTO DBJOFC.JOFC_CALCOLO_QUOTA (HAS_MEMBERSHIP, QUOTA, ID_REC) VALUES ('T', 10.0, DBJOFC.SEQUENCE_ID_JOFC.NextVal)
    2020-09-23T16:03:36,958 DEBUG SQLDriver SequenceMode is not JDBC_DRIVER, skipping search for generated values
    2020-09-23T16:03:36,964 INFO  [B]SQLDataSource primaryKeys: {}[/B]
    2020-09-23T16:03:36,964 DEBUG [B]SQLDataSource Gathered all keys.  lastPrimaryKeys is now {}[/B]
    2020-09-23T16:03:36,964 DEBUG SQLDataSource add operation affected 1 rows
    2020-09-23T16:03:36,964 INFO  SQLDataSource DBJOFC getLastRow(): using default operationBinding
    2020-09-23T16:03:36,965 DEBUG DSRequest Constructing DSRequest 132516351
    2020-09-23T16:03:36,968 INFO  DSRequest Executing JOFC_CALCOLO_QUOTA.fetch rows: 0->-1 with
    criteria: {}
    2020-09-23T16:03:36,968 DEBUG DeclarativeSecurity Processing security checks for DataSource null, field null
    2020-09-23T16:03:36,968 DEBUG DeclarativeSecurity Request is not a client request, ignoring security checks.
    2020-09-23T16:03:36,970 DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
    2020-09-23T16:03:36,970 DEBUG AppBase No public zero-argument method named '_null' found, performing generic datasource operation
    2020-09-23T16:03:37,018 INFO  SQLWhereClause empty condition
    2020-09-23T16:03:37,023 DEBUG SQLDataSource JDBC driver windowed select rows 0->-1, result size 1. Query: SELECT JOFC_CALCOLO_QUOTA.ID_REC, JOFC_CALCOLO_QUOTA.QUOTA, JOFC_CALCOLO_QUOTA.HAS_MEMBERSHIP, JOFC_CALCOLO_QUOTA.IS_ABBONATO, JOFC_CALCOLO_QUOTA.IS_UNDER_16, JOFC_CALCOLO_QUOTA.IS_UNDER_6 FROM DBJOFC.JOFC_CALCOLO_QUOTA WHERE ('1'='1')
    2020-09-23T16:03:37,023 DEBUG SQLDataSource Setting DSRequest as being part of a transaction
    2020-09-23T16:03:37,128 DEBUG SQLDataSource Using paging strategy 'jdbcScroll' - scrolling to absolute position 1
    2020-09-23T16:03:37,128 DEBUG SQLDataSource Scrolling / positioning took 0ms
    2020-09-23T16:03:37,525 INFO  DSResponse DSResponse: List with 1 items
    2020-09-23T16:03:37,525 DEBUG DSRequest freeOnExecute is false for request of type fetch on DataSource JOFC_CALCOLO_QUOTA - not freeing resources!
    2020-09-23T16:03:37,525 INFO  DSResponse DSResponse: List with 1 items
    2020-09-23T16:03:37,525 DEBUG DSRequest freeOnExecute is false for request of type add on DataSource JOFC_CALCOLO_QUOTA - not freeing resources!
    instead if I execute an add using the 'base' dataSource:

    Code:
            DSRequest dsRequest2 = new DSRequest("JOFC_CALCOLO_QUOTA_BASE", "add", rpcManager);
            dsRequest2.setValues(DataTools.buildMap("HAS_MEMBERSHIP", true, "QUOTA", 11));
            DSResponse dsResponse2 = dsRequest2.execute();
            Map record2 = dsResponse2.getDataMap();
    the pk is correctly gathered and used to fetch the inserted record:

    Code:
    2020-09-23T16:04:37,428 DEBUG DSRequest Constructing DSRequest 1403631704
    2020-09-23T16:04:37,439 DEBUG PoolableDataSourceFactory Created DataSource 51 of type 'JOFC_CALCOLO_QUOTA_BASE' and assigned it to thread https-jsse-nio-8445-exec-4
    2020-09-23T16:04:37,439 DEBUG PoolableDataSourceFactory Created DataSource 51 of type 'JOFC_CALCOLO_QUOTA_BASE' in the pooling flow
    2020-09-23T16:04:37,439 DEBUG PoolableDataSourceFactory Activated DataSource 51 of type 'JOFC_CALCOLO_QUOTA_BASE'
    2020-09-23T16:04:37,439 DEBUG DSRequest Caching instance 51 of DS 'JOFC_CALCOLO_QUOTA_BASE' from DSRequest.getDataSource()
    2020-09-23T16:04:37,439 DEBUG DataSource JOFC_CALCOLO_QUOTA_BASEisSandboxEligible?: false
    2020-09-23T16:04:37,439 DEBUG DataSource JOFC_CALCOLO_QUOTA_BASE isCacheable?: true
    2020-09-23T16:04:37,439 DEBUG DSRequest Caching instance 51 of DS JOFC_CALCOLO_QUOTA_BASE
    2020-09-23T16:04:37,441 INFO  DSRequest Executing JOFC_CALCOLO_QUOTA_BASE.add with
    criteria: {}
    values: {HAS_MEMBERSHIP:true, QUOTA:11}
    2020-09-23T16:04:37,441 DEBUG DeclarativeSecurity Processing security checks for DataSource null, field null
    2020-09-23T16:04:37,441 DEBUG DeclarativeSecurity Request is not a client request, ignoring security checks.
    2020-09-23T16:04:37,442 DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
    2020-09-23T16:04:37,442 DEBUG AppBase No public zero-argument method named '_null' found, performing generic datasource operation
    2020-09-23T16:04:37,442 DEBUG BasicDataSource Validating 1 'JOFC_CALCOLO_QUOTA_BASE's at path ''
    2020-09-23T16:04:37,442 DEBUG BasicDataSource Validating a 'JOFC_CALCOLO_QUOTA_BASE' at path ''
    2020-09-23T16:04:37,442 DEBUG BasicDataSource Done validating 1 'JOFC_CALCOLO_QUOTA_BASE's at path '': 0ms (avg 0)
    2020-09-23T16:04:37,443 DEBUG DataSource post-validation valueSet: [
        {
            HAS_MEMBERSHIP:true,
            QUOTA:11.0
        }
    ]
    2020-09-23T16:04:37,448 DEBUG SQLDataSource DataSource 51 acquired SQLDriver instance 1445175873 during initialization
    2020-09-23T16:04:37,448 DEBUG SQLValuesClause Sequences: {ID_REC=SEQUENCE_ID_JOFC}
    2020-09-23T16:04:37,451 DEBUG SQLDataSource Setting DSRequest as being part of a transaction
    2020-09-23T16:04:37,451 INFO  SQLDriver Executing SQL query on 'DBJOFC' using connection '463841394': INSERT INTO DBJOFC.JOFC_CALCOLO_QUOTA (HAS_MEMBERSHIP, QUOTA, ID_REC) VALUES ('T', 11.0, DBJOFC.SEQUENCE_ID_JOFC.NextVal)
    2020-09-23T16:04:43,549 DEBUG SQLDriver SequenceMode is not JDBC_DRIVER, skipping search for generated values
    2020-09-23T16:04:43,550 DEBUG SQLDataSource Setting DSRequest as being part of a transaction
    2020-09-23T16:04:43,550 INFO  SQLDriver Executing SQL query on 'DBJOFC' using connection '463841394': SELECT DBJOFC.SEQUENCE_ID_JOFC.CurrVal FROM DUAL
    2020-09-23T16:04:43,618 INFO  [B]SQLDataSource primaryKeys: {ID_REC=1155797}[/B]
    2020-09-23T16:04:43,619 DEBUG [B]SQLDataSource Gathered all keys.  lastPrimaryKeys is now {ID_REC=1155797}[/B]
    2020-09-23T16:04:43,619 DEBUG SQLDataSource add operation affected 1 rows
    2020-09-23T16:04:43,619 INFO  SQLDataSource DBJOFC getLastRow(): using default operationBinding
    2020-09-23T16:04:43,619 DEBUG DSRequest Constructing DSRequest 1313972767
    2020-09-23T16:04:43,620 INFO  DSRequest Executing JOFC_CALCOLO_QUOTA_BASE.fetch rows: 0->-1 with
    criteria: {ID_REC:"1155797"}
    2020-09-23T16:04:43,620 DEBUG DeclarativeSecurity Processing security checks for DataSource null, field null
    2020-09-23T16:04:43,620 DEBUG DeclarativeSecurity Request is not a client request, ignoring security checks.
    2020-09-23T16:04:43,621 DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
    2020-09-23T16:04:43,621 DEBUG AppBase No public zero-argument method named '_null' found, performing generic datasource operation
    2020-09-23T16:04:43,624 DEBUG SQLDataSource JDBC driver windowed select rows 0->-1, result size 1. Query: SELECT JOFC_CALCOLO_QUOTA.ID_REC, JOFC_CALCOLO_QUOTA.QUOTA, JOFC_CALCOLO_QUOTA.HAS_MEMBERSHIP, JOFC_CALCOLO_QUOTA.IS_ABBONATO, JOFC_CALCOLO_QUOTA.IS_UNDER_16, JOFC_CALCOLO_QUOTA.IS_UNDER_6 FROM DBJOFC.JOFC_CALCOLO_QUOTA WHERE (JOFC_CALCOLO_QUOTA.ID_REC=1155797)
    2020-09-23T16:04:43,624 DEBUG SQLDataSource Setting DSRequest as being part of a transaction
    2020-09-23T16:04:43,666 DEBUG SQLDataSource Using paging strategy 'jdbcScroll' - scrolling to absolute position 1
    2020-09-23T16:04:43,666 DEBUG SQLDataSource Scrolling / positioning took 0ms
    2020-09-23T16:04:43,667 INFO  DSResponse DSResponse: List with 1 items
    2020-09-23T16:04:43,667 DEBUG DSRequest freeOnExecute is false for request of type fetch on DataSource JOFC_CALCOLO_QUOTA_BASE - not freeing resources!
    2020-09-23T16:04:43,667 INFO  DSResponse DSResponse: List with 1 items
    2020-09-23T16:04:43,667 DEBUG DSRequest freeOnExecute is false for request of type add on DataSource JOFC_CALCOLO_QUOTA_BASE - not freeing resources!
    Last edited by claudiobosticco; 29 Sep 2020, 23:41.

    Comment


      #3
      Hello, after some more testing, it seems that:
      v121p_2020-07-11 was working
      v121p_2020-07-15 doesn't work

      Comment


        #4
        Hello, may i ask if you see the problem?

        Comment


          #5
          Hello, I don't know if my support is already reactivated...but I see the this problem is still there: "v12.1p_2020-12-16/Enterprise Deployment"

          Comment


            #6
            Apologies for the delay. Thank you for the information, we're looking into this and will follow up shortly.

            Comment


              #7
              Apologies once again for the delay. The issue is fixed and will be available in nightly build since Jan 15 (tomorrow). Thank you for detailed and accurate issue report - it was indeed related to inherited DataSource.

              Comment


                #8
                SmartClient Version: v12.1p_2021-01-15/Enterprise Deployment (built 2021-01-15)

                Hello, I can confirm it's fixed, thank you very much.

                Comment

                Working...
                X