SmartClient Version: v13.1p_2025-01-25/Enterprise Deployment (built 2025-01-25)
and
SmartClient Version: v13.0p_2025-01-25/Enterprise Deployment (built 2025-01-25)
Hello, in the latest 13.0 and 13.1, when executing a server side update with allowMultiUpdate=true, after the update I see a select (which I think wasn't made previously), and this select lacks the criteria:
and
SmartClient Version: v13.0p_2025-01-25/Enterprise Deployment (built 2025-01-25)
Hello, in the latest 13.0 and 13.1, when executing a server side update with allowMultiUpdate=true, after the update I see a select (which I think wasn't made previously), and this select lacks the criteria:
Code:
2025-01-28T14:35:38,285 DEBUG PoolableSQLConnectionFactory makeObject() created an unpooled Connection '1936853216'
2025-01-28T14:35:38,285 DEBUG SQLConnectionManager Borrowed connection '1936853216' from DBCP
2025-01-28T14:35:38,287 DEBUG SQLTransaction Started new dbJas transaction "1936853216"
2025-01-28T14:35:38,287 DEBUG SQLDataSource Setting DSRequest as being part of a transaction on connection 1936853216
2025-01-28T14:35:38,288 INFO SQL Executing SQL query on 'dbJas' using connection '1936853216': UPDATE DBJAS.SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI SET GIUDIZIO=6, MODIFIER='me@mycompany.com', MODIFIER_TIMESTAMP=TO_DATE('2025-01-28 14:35:37','YYYY-MM-DD HH24:MI:SS') WHERE (SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI.ID_ATTIVITA_FK=9145623)
2025-01-28T14:35:38,304 INFO DSRequest Switching cacheSyncTiming to 'immediate' because this request is associated with an RPCManager (dataSource is 'SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI')
2025-01-28T14:35:38,304 INFO DSRequest primaryKeys: {}
2025-01-28T14:35:38,304 DEBUG SQLDataSource Gathered all keys. lastPrimaryKeys is now {}
2025-01-28T14:35:38,304 DEBUG SQLDataSource update operation affected 7 rows
2025-01-28T14:35:38,304 INFO SQLRefetchStrategy SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI: using default operationBinding
2025-01-28T14:35:38,304 WARN SQLRefetchStrategy SQLRefetchStrategy - missing key value for field ID_RECin DataSource SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI
2025-01-28T14:35:38,304 DEBUG SQLDataSource In getSchemaName(); for DataSource SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI
2025-01-28T14:35:38,304 DEBUG SQLDataSource 'schema' retrieved from config is 'DBJAS'
2025-01-28T14:35:38,305 DEBUG SQLDataSource About to clear SQLDriver state for DS instance 546
2025-01-28T14:35:38,305 WARN DSRequest A DataSource was already loaded for this DSRequest (e.g. during construction). Setting a new tenant ID now forcse the DataSource to be reloaded, and the base name 'SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI' to be recached. To avoid, either pass an RPCManager with the authenticated tenant ID to the DSRequet constructor (if you're not now), or make sure this DataSource cannot be loaded as a non-multi-tenant DataSource.
2025-01-28T14:35:38,305 INFO DSRequest Executing SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI.fetch rows: 0->-1 with
criteria: {}
2025-01-28T14:35:38,306 DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
2025-01-28T14:35:38,306 DEBUG AppBase No public zero-argument method named '_null' found, performing generic datasource operation
2025-01-28T14:35:38,306 DEBUG Alias Aliases field SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI.IMPIANTO includes SC_TIPI_IMPIANTI.DESCRIZIONE using alias IMPIANTI
2025-01-28T14:35:38,306 DEBUG Alias Aliases relation SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI -> SC_TIPI_IMPIANTI AS IMPIANTI, FK fields [ID_IMPIANTO_FK] -> [ID_REC]
2025-01-28T14:35:38,306 DEBUG Alias Aliases field SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI.STRUTTURA includes SC_TIPI_STRUTTURA.DESCRIZIONE using alias STRUTTURE
2025-01-28T14:35:38,306 DEBUG Alias Aliases relation SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI -> SC_TIPI_STRUTTURA AS STRUTTURE, FK fields [ID_STRUTTURA_FK] -> [ID_REC]
2025-01-28T14:35:38,306 DEBUG Alias Aliases field SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI.NUMERABILE includes SC_TIPI_IMPIANTI.NUMERABILE using alias IMPIANTI
2025-01-28T14:35:38,306 DEBUG Alias Aliases relation SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI -> SC_TIPI_IMPIANTI AS IMPIANTI, FK fields [ID_IMPIANTO_FK] -> [ID_REC]
2025-01-28T14:35:38,312 DEBUG SQLOrderClause no data; returning empty string
2025-01-28T14:35:38,313 DEBUG SQLDataSource In getSchemaName(); for DataSource SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI
2025-01-28T14:35:38,313 DEBUG SQLDataSource 'schema' retrieved from config is 'DBJAS'
2025-01-28T14:35:38,314 INFO SQLWhereClause empty condition
2025-01-28T14:35:38,314 DEBUG SQLDataSource In getSchemaName(); for DataSource SC_TIPI_IMPIANTI
2025-01-28T14:35:38,314 DEBUG SQLDataSource 'schema' retrieved from config is 'DBJAS'
2025-01-28T14:35:38,314 DEBUG SQLDataSource In getSchemaName(); for DataSource SC_TIPI_IMPIANTI
2025-01-28T14:35:38,314 DEBUG SQLDataSource 'schema' retrieved from config is 'DBJAS'
2025-01-28T14:35:38,314 DEBUG SQLDataSource In getSchemaName(); for DataSource SC_TIPI_STRUTTURA
2025-01-28T14:35:38,314 DEBUG SQLDataSource 'schema' retrieved from config is 'DBJAS'
2025-01-28T14:35:38,314 DEBUG SQLDataSource In getSchemaName(); for DataSource SC_TIPI_STRUTTURA
2025-01-28T14:35:38,315 DEBUG SQLDataSource 'schema' retrieved from config is 'DBJAS'
2025-01-28T14:35:38,315 INFO SQLDataSource derived query: SELECT $defaultSelectClause FROM $defaultTableClause $defaultAnsiJoinClause WHERE $defaultWhereClause ORDER BY ORDINAMENTO
2025-01-28T14:35:38,318 DEBUG SQLDataSource JDBC driver windowed select rows 0->-1, result size 1. Query: SELECT SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI.ID_REC, SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI.ID_ATTIVITA_FK, SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI.ID_IMPIANTO_FK, SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI.ID_STRUTTURA_FK, SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI.ORDINAMENTO, SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI.NUMEROSITA, SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI.GIUDIZIO, SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI.CREATOR, SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI.CREATOR_TIMESTAMP, SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI.MODIFIER, SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI.MODIFIER_TIMESTAMP, IMPIANTI.DESCRIZIONE AS IMPIANTO, STRUTTURE.DESCRIZIONE AS STRUTTURA, IMPIANTI.NUMERABILE AS NUMERABILE FROM DBJAS.SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI JOIN DBJAS.SC_TIPI_IMPIANTI IMPIANTI ON SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI.ID_IMPIANTO_FK = IMPIANTI.ID_REC LEFT OUTER JOIN DBJAS.SC_TIPI_STRUTTURA STRUTTURE ON SC_REPORT_ATTIVITA_DETTAGLI_IMPIANTI.ID_STRUTTURA_FK = STRUTTURE.ID_REC WHERE ('1'='1') ORDER BY ORDINAMENTO
2025-01-28T14:35:38,318 DEBUG SQLDataSource Setting DSRequest as being part of a transaction on connection 1936853216
2025-01-28T14:35:38,357 DEBUG SQLDataSource Using paging strategy 'jdbcScroll' - scrolling to absolute position 1
2025-01-28T14:35:38,357 DEBUG SQLDataSource Scrolling / positioning took 0ms
2025-01-28T14:35:38,634 DEBUG SQLDataSource Paged fetch returned 1 records
2025-01-28T14:35:38,635 INFO DSResponse DSResponse: List with 1 items
2025-01-28T14:35:38,635 INFO DSResponse DSResponse: List with 1 items
2025-01-28T14:35:38,636 DEBUG SQLDataSource DataSource 541 acquired SQLDriver instance 1270101353 during initialization
2025-01-28T14:35:38,638 DEBUG RPCManager Content type for RPC transaction: text/plain; charset=UTF-8
2025-01-28T14:35:38,639 DEBUG SQLTransaction Committing dbJas transaction "1936853216"
2025-01-28T14:35:38,653 DEBUG RPCManager DMI response, dropExtraFields: false
2025-01-28T14:35:38,664 DEBUG SQLDataSource About to clear SQLDriver state for DS instance 548
2025-01-28T14:35:38,665 DEBUG SQLDataSource About to clear SQLDriver state for DS instance 546
2025-01-28T14:35:38,665 DEBUG SQLDataSource About to clear SQLDriver state for DS instance 547
2025-01-28T14:35:38,666 DEBUG SQLDataSource About to clear SQLDriver state for DS instance 541
2025-01-28T14:35:38,666 DEBUG SQLTransaction getConnection() looked for transactional connection for dbJas: hashcode "1936853216"
2025-01-28T14:35:38,666 DEBUG SQLTransaction Ending dbJas transaction "1936853216"
2025-01-28T14:35:38,685 DEBUG SQLConnectionManager About to close PoolGuardConnectionWrapper with hashcode "1936853216"
2025-01-28T14:35:38,700 DEBUG SQLDataSource About to clear SQLDriver state for DS instance 546
Comment