SQLExpressions warnings in 13.1 - SmartClient Forums

claudiobosticco replied

22 Sep 2025, 05:48
SmartClient Version: v13.1p_2025-09-21/Enterprise Deployment (built 2025-09-21)

Hi, I confirm that the issue is now resolved, thank you very much
Leave a comment:
Isomorphic replied

21 Sep 2025, 23:43
Thank you for the detailed test case. This has been fixed and is available in the latest nightly builds.
Leave a comment:
claudiobosticco replied

12 Sep 2025, 04:47
I forgot to confirm that this test case works with build v13.1p_2025-06-11, while it doesn’t work with v13.1p_2025-06-12 (when using an AdvancedCriteria).
Leave a comment:

claudiobosticco replied

11 Sep 2025, 13:45

SmartClient Version: v13.1p_2025-09-09/Enterprise Deployment (built 2025-09-09)

Hi, this turned out to be trickier than I first thought.
The problem is triggered by a fetch using an AdvancedCriteria:

Code:

AUTH_MENU_ROLES_PERMISSIONS.fetchData({
        operator:"and",
        criteria:[
            {
                fieldName:"ID_APP",
                operator:"equals",
                value:"JcaAuth"
            }
        ]
    })

However, it works if I use a simple criteria:

Code:

AUTH_MENU_ROLES_PERMISSIONS.fetchData({ID_APP: "JcaAuth"})

Here are the dataSources:

Code:

<DataSource xmlns:fmt="WEB-INF/" xmlns="http://www.smartclient.com/schema"
            ID="AUTH_MENU_ROLES_PERMISSIONS"
            dataFormat="iscServer"
            serverType="sql"
            dbName="dbJFrame"
            schema="DBJFRAME"
            tableName="TREE_MENU"
            dropExtraFields="false"
            useAnsiJoins="true"
>
    <fields>
        <field name="ID_REC" primaryKey="true" type="sequence" sequenceName="SEQUENCE_REC"/>
        <field name="ID_APP" type="text" required="true" length="20"/>
        <field name="ID_ROLE_FK" type="integer" customSelectExpression="MENU_ROLES.ID_ROLE_FK" customSQL="true"/>
        <field name="ID_ROLES" type="text" customSelectExpression="MENU_ROLES.ID_ROLE_FK" customSQL="true"/>
    </fields>
    <operationBindings>
        <operationBinding operationType="fetch"
                          customCriteriaFields="ID_ROLE_FK">
            <scriptImport>com.isomorphic.criteria.*</scriptImport>
            <scriptImport>com.isomorphic.criteria.criterion.*</scriptImport>
            <script language="groovy">
                dsRequest.addToCriteria(
                    new AdvancedCriteria(DefaultOperators.Or,
                            new SetCriterion("ID_PERMISSION_FK", DefaultOperators.InSet, DataTools.buildList(3, 4)),
                            new SetCriterion("ID_ROLE_FK", DefaultOperators.InSet, DataTools.buildList(1, 2))
                    )
                );
                return dsRequest.execute();
            </script>
            <tableClause>
                $defaultTableClause
                LEFT JOIN DBJFRAME.AUTH_MENU_ROLES MENU_ROLES ON TREE_MENU.ID_REC = MENU_ROLES.ID_MENU_FK
                LEFT JOIN DBJFRAME.AUTH_ROLES ROLES ON MENU_ROLES.ID_ROLE_FK = ROLES.ID_REC
            </tableClause>
            <summaryFunctions>
                <ID_ROLES>concat</ID_ROLES>
            </summaryFunctions>
        </operationBinding>
    </operationBindings>
</DataSource>

<DataSource xmlns:fmt="WEB-INF/" xmlns="http://www.smartclient.com/schema"
            ID="AUTH_MENU_ROLES"
            serverType="sql"
            dbName="dbJFrame"
            schema="DBJFRAME"
            tableName="AUTH_MENU_ROLES"
            allowAdvancedCriteria="true"
            useAnsiJoins="true"
            dropExtraFields="false"
>
    <fields>
        <field name="ID_REC" primaryKey="true" type="sequence" hidden="true" sequenceName="SEQUENCE_AUTH"/>
        <field name="ID_MENU_FK" type="integer" foreignKey="TREE_MENU.ID_REC" relatedTableAlias="MENU" required="true"/>
        <field name="ID_ROLE_FK" type="integer" foreignKey="AUTH_ROLES.ID_REC" relatedTableAlias="ROLES" required="true"/>
    </fields>
</DataSource>

<DataSource xmlns:fmt="WEB-INF/" xmlns="http://www.smartclient.com/schema"
            ID="AUTH_ROLES"
            serverType="sql"
            dbName="dbJFrame"
            schema="DBJFRAME"
            tableName="AUTH_ROLES"
            allowAdvancedCriteria="true"
            useAnsiJoins="true"
            dropExtraFields="false"
>
    <fields>
        <field name="ID_REC" primaryKey="true" type="sequence" hidden="true" sequenceName="SEQUENCE_AUTH"/>
        <field name="ROLE" type="trimText" length="200" required="true"/>
    </fields>
</DataSource>

Note that in the server script there’s a SetCriterion for ID_PERMISSION_FK, which was present in the real use case. It also had fields, joins, and summary functions similar to ID_ROLE_FK and ID_ROLES.
I removed them to simplify the test case, since I saw the issue was still there without them (anyway I’ll also include the dataSource including them at the bottom of the post).
But in the end, I noticed that if I remove that criterion, it works.

In the log produced by the fetch with the AdvancedCriteria, you can see that the criterion for ID_ROLE_FK is missing:

Code:

DEBUG RPCManager Starting request parsing
DEBUG RPCManager Done request parsing
DEBUG RPCManager Processing 1 requests.
DEBUG RPCManager Request #1 (DSRequest) payload: {
    criteria:{
        _constructor:"AdvancedCriteria",
        operator:"and",
        criteria:[
            {
                fieldName:"ID_APP",
                operator:"equals",
                value:"JcaAuth"
            }
        ]
    },
    operationConfig:{
        dataSource:"AUTH_MENU_ROLES_PERMISSIONS",
        repo:null,
        operationType:"fetch",
        textMatchStyle:"exact"
    },
    appID:"builtinApplication",
    operation:"AUTH_MENU_ROLES_PERMISSIONS_fetch",
    oldValues:{
        _constructor:"AdvancedCriteria",
        operator:"and",
        criteria:[
            {
                fieldName:"ID_APP",
                operator:"equals",
                value:"JcaAuth"
            }
        ]
    },
    tenantId:null
}
INFO IDACall Performing 1 operation(s) [UA: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36]
INFO DSRequest Executing AUTH_MENU_ROLES_PERMISSIONS.fetch rows: 0->-1 with
criteria: {
    _constructor:"AdvancedCriteria",
    operator:"and",
    criteria:[
        {fieldName:"ID_APP", operator:"equals", value:"JcaAuth"}
    ]
}
DEBUG PoolableSQLConnectionFactory Executing pingTest 'select 1 from dual' on connection 1415690804
DEBUG SQLConnectionManager Borrowed connection '1415690804' from DBCP
DEBUG SQLTransaction Started new dbJFrame transaction "1415690804"
INFO DSRequest Executing AUTH_MENU_ROLES_PERMISSIONS.fetch rows: 0->-1 with
criteria: {
    _constructor:"AdvancedCriteria",
    criteria:[
        {fieldName:"ID_APP", __normalized:true, value:"JcaAuth", operator:"equals"},
        {
            _constructor:"AdvancedCriteria",
            criteria:[
                {
                    fieldName:"ID_PERMISSION_FK",
                    value:[3, 4],
                    operator:"inSet"
                },
                {
                    fieldName:"ID_ROLE_FK",
                    value:[1, 2],
                    operator:"inSet"
                }
            ],
            __normalized:true,
            operator:"or"
        }
    ],
    __normalized:true,
    operator:"and"
}
DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
DEBUG AppBase No public zero-argument method named '_AUTH_MENU_ROLES_PERMISSIONS_fetch' found, performing generic datasource operation
WARN SQLSelectClause SQLSelectClause is null or zero size, remap and conversions won't work!
DEBUG SQLOrderClause no data; returning empty string
WARN SQLExpressions Missing expression for the 'ID_PERMISSION_FK' field of the 'AUTH_MENU_ROLES_PERMISSIONS' DataSource.
WARN SQLExpressions Missing expression for the 'ID_ROLE_FK' field of the 'AUTH_MENU_ROLES_PERMISSIONS' DataSource.
INFO SQLWhereClause empty condition
INFO SQLDataSource derived query: SELECT $defaultSelectClause FROM
                $defaultTableClause
                LEFT JOIN DBJFRAME.AUTH_MENU_ROLES MENU_ROLES ON TREE_MENU.ID_REC = MENU_ROLES.ID_MENU_FK
                LEFT JOIN DBJFRAME.AUTH_ROLES ROLES ON MENU_ROLES.ID_ROLE_FK = ROLES.ID_REC
             WHERE $defaultWhereClause HAVING (('1'='1'))
DEBUG SQL 625: Executing SQL query on 'dbJFrame': SELECT * FROM
                DBJFRAME.TREE_MENU
                LEFT JOIN DBJFRAME.AUTH_MENU_ROLES MENU_ROLES ON TREE_MENU.ID_REC = MENU_ROLES.ID_MENU_FK
                LEFT JOIN DBJFRAME.AUTH_ROLES ROLES ON MENU_ROLES.ID_ROLE_FK = ROLES.ID_REC
             WHERE ((TREE_MENU.ID_APP = 'JcaAuth' AND TREE_MENU.ID_APP IS NOT NULL) AND (('1'='1') OR ('1'='1'))) HAVING (('1'='1'))
INFO SQL Executing SQL query on 'dbJFrame': SELECT * FROM
                DBJFRAME.TREE_MENU
                LEFT JOIN DBJFRAME.AUTH_MENU_ROLES MENU_ROLES ON TREE_MENU.ID_REC = MENU_ROLES.ID_MENU_FK
                LEFT JOIN DBJFRAME.AUTH_ROLES ROLES ON MENU_ROLES.ID_ROLE_FK = ROLES.ID_REC
             WHERE ((TREE_MENU.ID_APP = 'JcaAuth' AND TREE_MENU.ID_APP IS NOT NULL) AND (('1'='1') OR ('1'='1'))) HAVING (('1'='1'))
INFO DSResponse DSResponse: List with 17 items
INFO DSResponse DSResponse: List with 17 items
DEBUG RPCManager Content type for RPC transaction: text/plain; charset=UTF-8
DEBUG SQLTransaction Committing dbJFrame transaction "1415690804"
DEBUG RPCManager DMI response, dropExtraFields: false
DEBUG SQLTransaction getConnection() looked for transactional connection for dbJFrame: hashcode "1415690804"
DEBUG SQLTransaction Ending dbJFrame transaction "1415690804"
DEBUG SQLConnectionManager About to close connection with hashcode "1415690804"
DEBUG PoolableSQLConnectionFactory Executing pingTest 'select 1 from dual' on connection 1415690804

While with the simple criteria it is present:

Code:

DEBUG RPCManager Starting request parsing
DEBUG RPCManager Done request parsing
DEBUG RPCManager Processing 1 requests.
DEBUG RPCManager Request #1 (DSRequest) payload: {
    criteria:{
        ID_APP:"JcaAuth"
    },
    operationConfig:{
        dataSource:"AUTH_MENU_ROLES_PERMISSIONS",
        repo:null,
        operationType:"fetch",
        textMatchStyle:"exact"
    },
    appID:"builtinApplication",
    operation:"AUTH_MENU_ROLES_PERMISSIONS_fetch",
    oldValues:{
        ID_APP:"JcaAuth"
    },
    tenantId:null
}
INFO IDACall Performing 1 operation(s) [UA: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36]
INFO DSRequest Executing AUTH_MENU_ROLES_PERMISSIONS.fetch rows: 0->-1 with
criteria: {ID_APP:"JcaAuth"}
DEBUG PoolableSQLConnectionFactory Executing pingTest 'select 1 from dual' on connection 520471221
DEBUG SQLConnectionManager Borrowed connection '520471221' from DBCP
DEBUG SQLTransaction Started new dbJFrame transaction "520471221"
INFO DSRequest Executing AUTH_MENU_ROLES_PERMISSIONS.fetch rows: 0->-1 with
criteria: {
    _constructor:"AdvancedCriteria",
    criteria:[
        {fieldName:"ID_APP", value:"JcaAuth", operator:"iEquals"},
        {
            criteria:[
                {
                    fieldName:"ID_PERMISSION_FK",
                    value:[3, 4],
                    operator:"inSet"
                },
                {
                    fieldName:"ID_ROLE_FK",
                    value:[1, 2],
                    operator:"inSet"
                }
            ],
            operator:"or"
        }
    ],
    operator:"and"
}
DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
DEBUG AppBase No public zero-argument method named '_AUTH_MENU_ROLES_PERMISSIONS_fetch' found, performing generic datasource operation
WARN SQLSelectClause SQLSelectClause is null or zero size, remap and conversions won't work!
DEBUG SQLOrderClause no data; returning empty string
WARN SQLExpressions Missing expression for the 'ID_PERMISSION_FK' field of the 'AUTH_MENU_ROLES_PERMISSIONS' DataSource.
INFO SQLWhereClause empty condition
INFO SQLDataSource derived query: SELECT $defaultSelectClause FROM
                $defaultTableClause
                LEFT JOIN DBJFRAME.AUTH_MENU_ROLES MENU_ROLES ON TREE_MENU.ID_REC = MENU_ROLES.ID_MENU_FK
                LEFT JOIN DBJFRAME.AUTH_ROLES ROLES ON MENU_ROLES.ID_ROLE_FK = ROLES.ID_REC
             WHERE $defaultWhereClause HAVING (('1'='1'))
DEBUG SQL 625: Executing SQL query on 'dbJFrame': SELECT * FROM
                DBJFRAME.TREE_MENU
                LEFT JOIN DBJFRAME.AUTH_MENU_ROLES MENU_ROLES ON TREE_MENU.ID_REC = MENU_ROLES.ID_MENU_FK
                LEFT JOIN DBJFRAME.AUTH_ROLES ROLES ON MENU_ROLES.ID_ROLE_FK = ROLES.ID_REC
             WHERE ((LOWER(TREE_MENU.ID_APP)=LOWER('jcaauth') AND TREE_MENU.ID_APP IS NOT NULL) AND (('1'='1') OR ((MENU_ROLES.ID_ROLE_FK IN (1, 2)) AND MENU_ROLES.ID_ROLE_FK IS NOT NULL))) HAVING (('1'='1'))
INFO SQL Executing SQL query on 'dbJFrame': SELECT * FROM
                DBJFRAME.TREE_MENU
                LEFT JOIN DBJFRAME.AUTH_MENU_ROLES MENU_ROLES ON TREE_MENU.ID_REC = MENU_ROLES.ID_MENU_FK
                LEFT JOIN DBJFRAME.AUTH_ROLES ROLES ON MENU_ROLES.ID_ROLE_FK = ROLES.ID_REC
             WHERE ((LOWER(TREE_MENU.ID_APP)=LOWER('jcaauth') AND TREE_MENU.ID_APP IS NOT NULL) AND (('1'='1') OR ((MENU_ROLES.ID_ROLE_FK IN (1, 2)) AND MENU_ROLES.ID_ROLE_FK IS NOT NULL))) HAVING (('1'='1'))
INFO DSResponse DSResponse: List with 17 items
INFO DSResponse DSResponse: List with 17 items
DEBUG RPCManager Content type for RPC transaction: text/plain; charset=UTF-8
DEBUG SQLTransaction Committing dbJFrame transaction "520471221"
DEBUG RPCManager DMI response, dropExtraFields: false
DEBUG SQLTransaction getConnection() looked for transactional connection for dbJFrame: hashcode "520471221"
DEBUG SQLTransaction Ending dbJFrame transaction "520471221"
DEBUG SQLConnectionManager About to close connection with hashcode "520471221"
DEBUG PoolableSQLConnectionFactory Executing pingTest 'select 1 from dual' on connection 520471221

If you prefer (or need it), here’s the dataSource with both customCriteriaFields:

Code:

<DataSource xmlns:fmt="WEB-INF/" xmlns="http://www.smartclient.com/schema"
            ID="AUTH_MENU_ROLES_PERMISSIONS"
            dataFormat="iscServer"
            serverType="sql"
            dbName="dbJFrame"
            schema="DBJFRAME"
            tableName="TREE_MENU"
            dropExtraFields="false"
            useAnsiJoins="true"
>
    <fields>
        <field name="ID_REC" primaryKey="true" type="sequence" sequenceName="SEQUENCE_REC"/>
        <field name="ID_APP" type="text" required="true" length="20"/>
        <field name="ID_ROLE_FK" type="integer" customSelectExpression="MENU_ROLES.ID_ROLE_FK" customSQL="true"/>
        <field name="ID_ROLES" type="text" customSelectExpression="MENU_ROLES.ID_ROLE_FK" customSQL="true"/>
        <field name="ID_PERMISSION_FK" type="integer" customSelectExpression="MENU_PERMISSIONS.ID_PERMISSION_FK" customSQL="true"/>
        <field name="ID_PERMISSIONS" type="integer" customSelectExpression="MENU_PERMISSIONS.ID_PERMISSION_FK" customSQL="true"/>
    </fields>
    <operationBindings>
        <operationBinding operationType="fetch"
                          customCriteriaFields="ID_ROLE_FK,ID_PERMISSION_FK">
            <scriptImport>com.isomorphic.criteria.*</scriptImport>
            <scriptImport>com.isomorphic.criteria.criterion.*</scriptImport>
            <script language="groovy">
                dsRequest.addToCriteria(
                    new AdvancedCriteria(DefaultOperators.Or,
                            new SetCriterion("ID_PERMISSION_FK", DefaultOperators.InSet, DataTools.buildList(3, 4)),
                            new SetCriterion("ID_ROLE_FK", DefaultOperators.InSet, DataTools.buildList(1, 2))
                    )
                );
                return dsRequest.execute();
            </script>
            <tableClause>
                $defaultTableClause
                LEFT JOIN DBJFRAME.AUTH_MENU_ROLES MENU_ROLES ON TREE_MENU.ID_REC = MENU_ROLES.ID_MENU_FK
                LEFT JOIN DBJFRAME.AUTH_ROLES ROLES ON MENU_ROLES.ID_ROLE_FK = ROLES.ID_REC
                LEFT JOIN DBJFRAME.AUTH_MENU_PERMISSIONS MENU_PERMISSIONS ON TREE_MENU.ID_REC = MENU_PERMISSIONS.ID_MENU_FK
                  LEFT JOIN DBJFRAME.AUTH_PERMISSIONS PERMISSIONS ON MENU_PERMISSIONS.ID_PERMISSION_FK = PERMISSIONS.ID_REC
            </tableClause>
            <summaryFunctions>
                <ID_ROLES>concat</ID_ROLES>
                <ID_PERMISSIONS>concat</ID_PERMISSIONS>
            </summaryFunctions>
        </operationBinding>
    </operationBindings>
</DataSource>

This gives the same result: with a simple criteria I see both customCriteriaFields in the where clause, while with an AdvancedCriteria both are omitted.

Leave a comment:

Isomorphic replied

5 Sep 2025, 03:29
Thanks for the clarification. Adding criteria for customCriteriaFields in a DMI via dsRequest.addToCriteria() is a supported approach and should work.

We’ve specifically retested this scenario in the latest 13.1 build — both with initial client-sent criteria and with none (so the DMI adds the only criteria) — and in all cases the criteria were applied as expected with no warnings.

Please share a minimal test case so we can investigate.
Leave a comment:
claudiobosticco replied

4 Sep 2025, 07:42
Hi, after a closer analysis, I see that this is not the same error as before.

This time, the error is related to the fact that the criteria for the customCriteriaFields are being added in a DMI using dsRequest.addToCriteria().

By doing so, I get the following WARN for the customCriteriaField:

Code:

WARN SQLExpressions Missing expression for the 'ID_ROLE_FK' field of the 'AUTH_MENU_ROLES_PERMISSIONS' DataSource.

and in the WHERE clause I only see '1'='1'.

I tried sending, from the client, a criteria for one of those customCriteriaFields, and in that case I don’t see the WARN, and in the WHERE clause I can see both the client-sent criteria and the server-added one.

Before putting effort into creating a test case, I’d like to be sure that I’m not doing something unsupported by adding a criteria on customCriteriaFields in the DMI.

Is this a supported approach, or should I be using a different method?
Last edited by claudiobosticco; 4 Sep 2025, 12:02.
Leave a comment:
Isomorphic replied

4 Sep 2025, 06:30
Thanks for the report. We’ve re-checked both the builds you mentioned and the latest 13.1p (2025-09-02), but haven’t been able to reproduce the regression — customCriteriaFields are working as expected here.

Since you mentioned the symptoms match the earlier issue from post #13, could you provide reproducible details for the current case so we can confirm we’re looking at the same problem?
Leave a comment:
claudiobosticco replied

1 Sep 2025, 02:51
SmartClient Version: v13.1p_2025-08-30/Enterprise Deployment (built 2025-08-30)

Hello, there’s a regression in the 13.1 build.
The bug related to customCriteriaFields being ignored (mentioned in post #13, and fixed in build v13.1p_2024-11-16) has reappeared.
The last working build is v13.1p_2025-06-11, while v13.1p_2025-06-12 no longer works.

Last edited by claudiobosticco; 1 Sep 2025, 04:52. Reason: edited for clarity
Leave a comment:
claudiobosticco replied

18 Nov 2024, 03:11
SmartClient Version: v13.1p_2024-11-16/Enterprise Deployment (built 2024-11-16)

I see it's fixed, thank you very much.
Leave a comment:
Isomorphic replied

15 Nov 2024, 10:03
Hi Claudio, sorry for the delay on this one. Refactoring to introduce a major new feature (AdvancedCriteria subqueries) broke this particular interaction.

In tomorrow's builds (11/15 and later) you should find this fixed.
Leave a comment:
claudiobosticco replied

14 Nov 2024, 08:30
Hello, any news about this issue?
Leave a comment:
Isomorphic replied

25 Oct 2024, 09:21
Hi Claudio
This is currently with a developer for analysis. Nothing to report yet but we'll get you a proper status update when we have one

Regards
Isomorphic Software
Leave a comment:
claudiobosticco replied

25 Oct 2024, 00:13
Hello, please let me know if you see the problem or if you need more details (or if I'm missing something obvious)
Leave a comment:

claudiobosticco replied

21 Oct 2024, 08:06

Hello, it seems that it's actually ignoring customCriteriaFields. Last build working seems to be SmartClient Version: SNAPSHOT_v13.1d_2024-08-05/Enterprise Deployment (built 2024-08-05), it doesn't work since 2024-08-07 (actually I can't download 2024-08-06 with maven right now)

I've reduced my ds to:

Code:

<DataSource xmlns:fmt="WEB-INF/" xmlns="http://www.smartclient.com/schema"
            ID="AUTH_MENU_ROLES_PERMISSIONS"
            dataFormat="iscServer"
            serverType="sql"
            dbName="dbJFrame"
            schema="DBJFRAME"
            tableName="TREE_MENU"
            useAnsiJoins="true"
>
    <fields>
        <field name="ID_REC" primaryKey="true" type="sequence" hidden="true" sequenceName="SEQUENCE_REC"/>
        <field name="ID_APP" type="text" required="true" length="20" hidden="true"/>
        <field name="ID_ROLE_FK" type="integer" customSQL="true"/>
    </fields>
    <operationBindings>
        <operationBinding operationType="fetch" customCriteriaFields="ID_ROLE_FK">
        </operationBinding>
    </operationBindings>
</DataSource>

and with a fetch like this:

Code:

AUTH_MENU_ROLES_PERMISSIONS.fetchData({
        operator:"and",
        criteria:[
            {
                fieldName:"ID_ROLE_FK",
                operator:"equals",
                value:16544
            },
            {
                fieldName:"ID_APP",
                operator:"equals",
                value:"Jat"
            }
        ]
    })

I got this log with SmartClient Version: SNAPSHOT_v13.1d_2024-08-07/Enterprise Deployment (built 2024-08-07) :

Code:

ott 21, 2024 5:56:07 PM org.apache.catalina.core.StandardWrapperValve invoke
INFORMAZIONI: 2024-10-21T17:56:07,215 DEBUG RPCManager Starting request parsing
2024-10-21T17:56:07,229 DEBUG PoolManager Invalidating null object for key 'transaction
2024-10-21T17:56:07,232 DEBUG PoolManager Invalidating null object for key 'elem
2024-10-21T17:56:07,233 DEBUG RPCManager Done request parsing
2024-10-21T17:56:07,233 DEBUG RPCManager Processing 1 requests.
2024-10-21T17:56:07,237 DEBUG RPCManager Request #1 (DSRequest) payload: {
    criteria:{
        operator:"and",
        criteria:[
            {
                fieldName:"ID_ROLE_FK",
                operator:"equals",
                value:16544
            },
            {
                fieldName:"ID_APP",
                operator:"equals",
                value:"Jat"
            }
        ]
    },
    operationConfig:{
        dataSource:"AUTH_MENU_ROLES_PERMISSIONS",
        repo:null,
        operationType:"fetch",
        textMatchStyle:"exact"
    },
    appID:"builtinApplication",
    operation:"fetchMenuPerGestioneUtenti",
    oldValues:{
        operator:"and",
        criteria:[
            {
                fieldName:"ID_ROLE_FK",
                operator:"equals",
                value:16544
            },
            {
                fieldName:"ID_APP",
                operator:"equals",
                value:"Jat"
            }
        ]
    },
    tenantId:null
}
2024-10-21T17:56:07,238 INFO IDACall Performing 1 operation(s) [UA: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:131.0) Gecko/20100101 Firefox/131.0]
2024-10-21T17:56:07,239 INFO DSRequest Executing AUTH_MENU_ROLES_PERMISSIONS.fetch rows: 0->-1 with
criteria: {
    operator:"and",
    criteria:[
        {fieldName:"ID_ROLE_FK", operator:"equals", value:16544},
        {fieldName:"ID_APP", operator:"equals", value:"Jat"}
    ]
}
2024-10-21T17:56:07,240 INFO AdvancedCriteria Criteria object:{
    operator:"and",
    criteria:[
        {
            fieldName:"ID_ROLE_FK",
            operator:"equals",
            value:16544
        },
        {
            fieldName:"ID_APP",
            operator:"equals",
            value:"Jat"
        }
    ]
} not explicitly marked as AdvancedCriteria but treating as Advanced based on format.
2024-10-21T17:56:07,240 INFO AdvancedCriteria Criteria object:{
    operator:"and",
    criteria:[
        {
            fieldName:"ID_ROLE_FK",
            operator:"equals",
            value:16544
        },
        {
            fieldName:"ID_APP",
            operator:"equals",
            value:"Jat"
        }
    ]
} not explicitly marked as AdvancedCriteria but treating as Advanced based on format.
2024-10-21T17:56:07,243 INFO DataSourceDMI operationBinding for DataSource: AUTH_MENU_ROLES_PERMISSIONS with operationType: fetch, operationId: fetchMenuPerGestioneUtenti does not have a <serverObject> in force and does not specify any operationBinding settings that could affect its behavior. This operation will almost certainly give the same result as a default operation, and so is almost certainly unnecessary
2024-10-21T17:56:07,244 DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
2024-10-21T17:56:07,244 DEBUG AppBase No public zero-argument method named '_fetchMenuPerGestioneUtenti' found, performing generic datasource operation
2024-10-21T17:56:07,248 WARN SQLExpressions Missing expression for the 'ID_ROLE_FK' field of the 'AUTH_MENU_ROLES_PERMISSIONS' DataSource.
2024-10-21T17:56:07,255 DEBUG SQL 666: Executing SQL query on 'dbJFrame': SELECT TREE_MENU.ID_REC, TREE_MENU.ID_APP FROM DBJFRAME.TREE_MENU WHERE (('1'='1') AND (TREE_MENU.ID_APP = 'Jat' AND TREE_MENU.ID_APP IS NOT NULL))
2024-10-21T17:56:07,259 DEBUG PoolableSQLConnectionFactory Executing pingTest 'select 1 from dual' on connection 139334260
2024-10-21T17:56:07,273 DEBUG SQLConnectionManager Borrowed connection '139334260' from DBCP
2024-10-21T17:56:07,273 DEBUG SQLTransaction Started new dbJFrame transaction "139334260"
2024-10-21T17:56:07,273 INFO SQL Executing SQL query on 'dbJFrame': SELECT TREE_MENU.ID_REC, TREE_MENU.ID_APP FROM DBJFRAME.TREE_MENU WHERE (('1'='1') AND (TREE_MENU.ID_APP = 'Jat' AND TREE_MENU.ID_APP IS NOT NULL))
2024-10-21T17:56:07,459 INFO DSResponse DSResponse: List with 397 items
2024-10-21T17:56:07,461 DEBUG RPCManager Content type for RPC transaction: text/plain; charset=UTF-8
2024-10-21T17:56:07,461 DEBUG SQLTransaction Committing dbJFrame transaction "139334260"
2024-10-21T17:56:07,466 DEBUG RPCManager non-DMI response, dropExtraFields: false
2024-10-21T17:56:07,477 DEBUG SQLTransaction getConnection() looked for transactional connection for dbJFrame: hashcode "139334260"
2024-10-21T17:56:07,478 DEBUG SQLTransaction Ending dbJFrame transaction "139334260"
2024-10-21T17:56:07,482 DEBUG SQLConnectionManager About to close connection with hashcode "139334260"
2024-10-21T17:56:07,482 DEBUG PoolableSQLConnectionFactory Executing pingTest 'select 1 from dual' on connection 139334260

while with SmartClient Version: SNAPSHOT_v13.1d_2024-10-18/Enterprise Deployment (built 2024-10-18)

there's some extra logs:

Code:

ott 21, 2024 6:02:35 PM org.apache.catalina.core.StandardWrapperValve invoke
INFORMAZIONI: 2024-10-21T18:02:35,458 DEBUG RPCManager Starting request parsing
2024-10-21T18:02:35,463 DEBUG PoolManager Invalidating null object for key 'transaction
2024-10-21T18:02:35,464 DEBUG PoolManager Invalidating null object for key 'elem
2024-10-21T18:02:35,464 DEBUG RPCManager Done request parsing
2024-10-21T18:02:35,464 DEBUG RPCManager Processing 1 requests.
2024-10-21T18:02:35,468 DEBUG PoolManager Invalidating null object for key 'operationBinding
2024-10-21T18:02:35,471 DEBUG RPCManager Request #1 (DSRequest) payload: {
    criteria:{
        operator:"and",
        criteria:[
            {
                fieldName:"ID_ROLE_FK",
                operator:"equals",
                value:16544
            },
            {
                fieldName:"ID_APP",
                operator:"equals",
                value:"Jat"
            }
        ]
    },
    operationConfig:{
        dataSource:"AUTH_MENU_ROLES_PERMISSIONS",
        repo:null,
        operationType:"fetch",
        textMatchStyle:"exact"
    },
    appID:"builtinApplication",
    operation:"fetchMenuPerGestioneUtenti",
    oldValues:{
        operator:"and",
        criteria:[
            {
                fieldName:"ID_ROLE_FK",
                operator:"equals",
                value:16544
            },
            {
                fieldName:"ID_APP",
                operator:"equals",
                value:"Jat"
            }
        ]
    },
    tenantId:null
}
2024-10-21T18:02:35,471 INFO IDACall Performing 1 operation(s) [UA: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:131.0) Gecko/20100101 Firefox/131.0]
2024-10-21T18:02:35,472 INFO DSRequest Executing AUTH_MENU_ROLES_PERMISSIONS.fetch rows: 0->-1 with
criteria: {
    operator:"and",
    criteria:[
        {fieldName:"ID_ROLE_FK", operator:"equals", value:16544},
        {fieldName:"ID_APP", operator:"equals", value:"Jat"}
    ]
}
2024-10-21T18:02:35,473 INFO AdvancedCriteria Criteria object:{
    operator:"and",
    criteria:[
        {
            fieldName:"ID_ROLE_FK",
            operator:"equals",
            value:16544
        },
        {
            fieldName:"ID_APP",
            operator:"equals",
            value:"Jat"
        }
    ]
} not explicitly marked as AdvancedCriteria but treating as Advanced based on format.
2024-10-21T18:02:35,473 INFO AdvancedCriteria Criteria object:{
    operator:"and",
    criteria:[
        {
            fieldName:"ID_ROLE_FK",
            operator:"equals",
            value:16544
        },
        {
            fieldName:"ID_APP",
            operator:"equals",
            value:"Jat"
        }
    ]
} not explicitly marked as AdvancedCriteria but treating as Advanced based on format.
2024-10-21T18:02:35,475 INFO DataSourceDMI operationBinding for DataSource: AUTH_MENU_ROLES_PERMISSIONS with operationType: fetch, operationId: fetchMenuPerGestioneUtenti does not have a <serverObject> in force and does not specify any operationBinding settings that could affect its behavior. This operation will almost certainly give the same result as a default operation, and so is almost certainly unnecessary
2024-10-21T18:02:35,475 DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
2024-10-21T18:02:35,475 DEBUG AppBase No public zero-argument method named '_fetchMenuPerGestioneUtenti' found, performing generic datasource operation
2024-10-21T18:02:35,477 WARN SQLExpressions Missing expression for the 'ID_ROLE_FK' field of the 'AUTH_MENU_ROLES_PERMISSIONS' DataSource.
2024-10-21T18:02:35,478 DEBUG SQLExpressions Missing expression request.expressionFields: [
    "ID_REC",
    "ID_APP",
    "ID_ROLE_FK"
]
2024-10-21T18:02:35,478 DEBUG SQLExpressions Missing expression generated sqlExpressions.keySet: [
    "ID_REC",
    "ID_APP"
]
2024-10-21T18:02:35,479 DEBUG SQLExpressions Missing expression stack: java.lang.Throwable
    at com.isomorphic.sql.SQLExpressions.getExpression(SQLExpressions.java:185)
    at com.isomorphic.sql.SQLWhereClause.buildAdvancedExpression(SQLWhereClause.java:1029)
    at com.isomorphic.sql.SQLWhereClause.getOutput(SQLWhereClause.java:419)
    at com.isomorphic.sql.SQLWhereClause.buildCompoundExpression(SQLWhereClause.java:507)
    at com.isomorphic.sql.SQLWhereClause.getOutput(SQLWhereClause.java:407)
    at com.isomorphic.sql.SQLWhereClause.toString(SQLWhereClause.java:284)
    at com.isomorphic.sql.SQLWhereClause.getSQLString(SQLWhereClause.java:290)
    at com.isomorphic.sql.SQLDataSource.getClausesContext(SQLDataSource.java:4351)
    at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1845)
    at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1745)
2024-10-21T18:02:35,482 DEBUG SQL 655: Executing SQL query on 'dbJFrame': SELECT TREE_MENU.ID_REC, TREE_MENU.ID_APP FROM DBJFRAME.TREE_MENU WHERE (('1'='1') AND (TREE_MENU.ID_APP = 'Jat' AND TREE_MENU.ID_APP IS NOT NULL))
2024-10-21T18:02:35,482 DEBUG PoolableSQLConnectionFactory Executing pingTest 'select 1 from dual' on connection 1010252117
2024-10-21T18:02:35,487 DEBUG SQLConnectionManager Borrowed connection '1010252117' from DBCP
2024-10-21T18:02:35,487 DEBUG SQLTransaction Started new dbJFrame transaction "1010252117"
2024-10-21T18:02:35,487 INFO SQL Executing SQL query on 'dbJFrame': SELECT TREE_MENU.ID_REC, TREE_MENU.ID_APP FROM DBJFRAME.TREE_MENU WHERE (('1'='1') AND (TREE_MENU.ID_APP = 'Jat' AND TREE_MENU.ID_APP IS NOT NULL))
2024-10-21T18:02:35,662 INFO DSResponse DSResponse: List with 397 items
2024-10-21T18:02:35,663 DEBUG RPCManager Content type for RPC transaction: text/plain; charset=UTF-8
2024-10-21T18:02:35,663 DEBUG SQLTransaction Committing dbJFrame transaction "1010252117"
2024-10-21T18:02:35,666 DEBUG RPCManager non-DMI response, dropExtraFields: false
2024-10-21T18:02:35,674 DEBUG SQLTransaction getConnection() looked for transactional connection for dbJFrame: hashcode "1010252117"
2024-10-21T18:02:35,674 DEBUG SQLTransaction Ending dbJFrame transaction "1010252117"
2024-10-21T18:02:35,678 DEBUG SQLConnectionManager About to close connection with hashcode "1010252117"
2024-10-21T18:02:35,678 DEBUG PoolableSQLConnectionFactory Executing pingTest 'select 1 from dual' on connection 1010252117

Announcement

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment: