Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
Clear All
new posts
Previous template Next
  • claudiobosticco
    replied
    SmartClient Version: v12.1p_2021-01-15/Enterprise Deployment (built 2021-01-15)

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

    Leave a comment:

  • Isomorphic
    replied
    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.

    Leave a comment:

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

    Leave a comment:

  • claudiobosticco
    replied
    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"

    Leave a comment:

  • claudiobosticco
    replied
    Hello, may i ask if you see the problem?

    Leave a comment:

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

    Leave a comment:

  • claudiobosticco
    replied
    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.

    Leave a comment:

  • claudiobosticco
    started a topic SequenceMode is not JDBC_DRIVER, skipping search for generated values 

    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
    Tags: None
Previous template Next
Working...
X