Announcement

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

    ORA-00932 with clob column

    SmartClient Version: SNAPSHOT_v13.1d_2024-08-27/Enterprise Deployment (built 2024-08-27)

    Hello, I'm encountering an ORA-00932 error with a CLOB column, which declared in the dataSource as:
    Code:
    <field name="MESSAGE_TEXT" type="text"/>
    When filtering or sorting a grid, it produces queries like:
    Code:
    SELECT MY_TABLE.MESSAGE_TEXT
    FROM DBJFRAME.MY_TABLE
    WHERE (LOWER(MY_TABLE.ID_APP) = 'myapp')
    ORDER BY MY_TABLE.MESSAGE_TEXT
    I've found threads discussing the behavior of CLOB fields during inserts and updates, but nothing about filtering or sorting. I recall that this was working before, but I might be mistaken.

    My dataBase is Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0
    Last edited by claudiobosticco; 28 Aug 2024, 01:42.

    #2
    Hi Claudio
    Can you share the DataSource request that produces this error, and also the details of the DataSource itself? Ideally the whole ds.xml source, or if that isn't practical a list of the attributes that are specified

    Thanks

    Comment


      #3
      SmartClient Version: SNAPSHOT_v13.1d_2024-09-03/Enterprise Deployment (built 2024-09-03)

      Hello, yes, this is the dataSource:

      Code:
      <DataSource xmlns="http://www.smartclient.com/schema"
                  ID="I18N"
                  dataFormat="iscServer"
                  serverType="sql"
                  dbName="dbJFrame"
                  schema="DBJFRAME"
                  tableName="I18N"
                  requiresAuthentication="true"
                  requiresRole="ROLE_ADMIN">
          <fields>
              <field primaryKey="true" name="ID_REC" type="sequence" hidden="true">
                  <sequenceName>SEQUENCE_REC</sequenceName>
              </field>
              <field name="MESSAGE_ID" type="text" required="true" length="255"/>
              <field name="MESSAGE_TEXT" type="text">
                  <validators>
                      <validator type="isUnique" criteriaFields="ID_APP,MESSAGE_TEXT"
                                 errorMessage="Esiste già il messaggio"/>
                  </validators>
              </field>
              <field name="ID_APP" type="text" required="true" length="20" hidden="true"/>
          </fields>
          <operationBindings>
              <operationBinding operationType="fetch">
                  <criteria fieldName="ID_APP" value="Jat"/>
              </operationBinding>
          </operationBindings>
      </DataSource>
      this is an add where fails the fetch for a isUnique validation:

      Code:
      set 03, 2024 10:32:29 PM org.apache.catalina.core.StandardWrapperValve invoke
      INFORMAZIONI: 2024-09-03T22:32:29,043 DEBUG RPCManager Starting request parsing
      2024-09-03T22:32:29,096 DEBUG PoolManager Invalidating null object for key 'transaction
      2024-09-03T22:32:29,096 DEBUG PoolManager Invalidating null object for key 'elem
      2024-09-03T22:32:29,096 DEBUG RPCManager Done request parsing
      2024-09-03T22:32:29,096 DEBUG RPCManager Processing 1 requests.
      2024-09-03T22:32:29,097 DEBUG RPCManager Request #1 (DSRequest) payload: {
          values:{
              MESSAGE_ID:"Visita",
              MESSAGE_TEXT:"Visita"
          },
          operationConfig:{
              dataSource:"I18N",
              repo:null,
              operationType:"add",
              textMatchStyle:"exact"
          },
          componentId:"configurazioneI18nGrid",
          appID:"builtinApplication",
          operation:"I18N_add",
          oldValues:{
              MESSAGE_ID:"Visita",
              MESSAGE_TEXT:"Visita"
          },
          tenantId:null,
          criteria:{
          }
      }
      2024-09-03T22:32:29,097 INFO IDACall Performing 1 operation(s) [UA: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:129.0) Gecko/20100101 Firefox/129.0]
      2024-09-03T22:32:29,097 INFO DSRequest Executing configurazioneI18nGrid->I18N.add with
      criteria: {}
      values: {MESSAGE_ID:"Visita", MESSAGE_TEXT:"Visita"}
      2024-09-03T22:32:29,098 DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
      2024-09-03T22:32:29,098 DEBUG AppBase No public zero-argument method named '_I18N_add' found, performing generic datasource operation
      2024-09-03T22:32:29,101 INFO DSRequest Executing I18N.fetch rows: 0->-1 with
      outputs: [ID_REC, MESSAGE_TEXT]
      criteria: {MESSAGE_TEXT:"Visita"}
      2024-09-03T22:32:29,102 DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
      2024-09-03T22:32:29,102 DEBUG AppBase No public zero-argument method named '_null' found, performing generic datasource operation
      2024-09-03T22:32:29,104 WARN SQLExpressions Missing expression for the 'ID_APP' field of the 'I18N' DataSource.
      java.lang.Exception: null
          at com.isomorphic.sql.SQLExpressions.getExpression(SQLExpressions.java:156) [isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLWhereClause.getFieldInfo(SQLWhereClause.java:593) [isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLWhereClause.buildExpression(SQLWhereClause.java:676) [isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLWhereClause.getOutput(SQLWhereClause.java:355) [isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLWhereClause.buildCompoundExpression(SQLWhereClause.java:507) [isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLWhereClause.getOutput(SQLWhereClause.java:361) [isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLWhereClause.toString(SQLWhereClause.java:284) [isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLWhereClause.getSQLString(SQLWhereClause.java:290) [isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.getClausesContext(SQLDataSource.java:4320) [isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1839) [isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1739) [isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:509) [isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:453) [isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.DataSource.execute(DataSource.java:3234) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:658) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:555) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.application.AppBase.execute(AppBase.java:498) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:4368) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.util.DefaultValidators$isUnique.validate(DefaultValidators.java:2190) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.util.DefaultValidators.processValidator(DefaultValidators.java:379) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.util.DefaultValidators.validateField(DefaultValidators.java:333) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.SimpleType.validateValue(SimpleType.java:119) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.SimpleType.create(SimpleType.java:85) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.BasicDataSource.validateFieldValue(BasicDataSource.java:3032) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.BasicDataSource.validateFieldValue(BasicDataSource.java:2920) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.BasicDataSource.toRecord(BasicDataSource.java:2063) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.BasicDataSource.toRecords(BasicDataSource.java:1927) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.BasicDataSource.toRecords(BasicDataSource.java:1888) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.DataSource.validateDSRequest(DataSource.java:5118) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.DataSource.validateDSRequest(DataSource.java:5063) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.DataSource.execute(DataSource.java:3217) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:658) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:555) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.application.AppBase.execute(AppBase.java:498) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:4368) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:249) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:206) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:153) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall._processRequest(IDACall.java:123) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall.doPost(IDACall.java:79) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) [servlet-api.jar:?]
          at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:178) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) [servlet-api.jar:?]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at com.juve.spring.FrameOriginFilter.doFilter(FrameOriginFilter.java:36) [classes/:?]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at com.juve.utils.Log4j2SessionFilter.doFilter(Log4j2SessionFilter.java:72) [classes/:?]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at com.isomorphic.servlet.CompressionFilter._doFilter(CompressionFilter.java:263) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.BaseFilter.doFilter(BaseFilter.java:91) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.ui.DefaultLogoutPageGeneratingFilter.doFilterInternal(DefaultLogoutPageGeneratingFilter.java:52) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:206) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:157) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:185) [catalina.jar:8.5.23]
          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:8.5.23]
          at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) [catalina.jar:8.5.23]
          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) [catalina.jar:8.5.23]
          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [catalina.jar:8.5.23]
          at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) [catalina.jar:8.5.23]
          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [catalina.jar:8.5.23]
          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) [catalina.jar:8.5.23]
          at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) [tomcat-coyote.jar:8.5.23]
          at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-coyote.jar:8.5.23]
          at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote.jar:8.5.23]
          at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) [tomcat-coyote.jar:8.5.23]
          at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.23]
          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
          at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.23]
          at java.lang.Thread.run(Thread.java:829) [?:?]
      2024-09-03T22:32:29,105 DEBUG SQLExpressions Missing expression request.queryFields: null
      2024-09-03T22:32:29,105 DEBUG SQLExpressions Missing expression request.expressionFields: [
          "ID_REC",
          "MESSAGE_TEXT"
      ]
      2024-09-03T22:32:29,105 DEBUG SQLExpressions Missing expression generated sqlExpressions.keySet: [
          "ID_REC",
          "MESSAGE_TEXT"
      ]
      2024-09-03T22:32:29,106 DEBUG SQL 1341: Executing SQL query on 'dbJFrame': SELECT I18N.ID_REC, I18N.MESSAGE_TEXT FROM DBJFRAME.I18N WHERE (('1'='1') AND LOWER(I18N.MESSAGE_TEXT)='visita')
      2024-09-03T22:32:29,402 DEBUG PoolableSQLConnectionFactory makeObject() created an unpooled Connection '1109028873'
      2024-09-03T22:32:29,403 DEBUG SQLConnectionManager Borrowed connection '1109028873' from DBCP
      2024-09-03T22:32:29,403 DEBUG SQLTransaction Started new dbJFrame transaction "1109028873"
      2024-09-03T22:32:29,403 INFO SQL Executing SQL query on 'dbJFrame': SELECT I18N.ID_REC, I18N.MESSAGE_TEXT FROM DBJFRAME.I18N WHERE (('1'='1') AND LOWER(I18N.MESSAGE_TEXT)='visita')
      2024-09-03T22:32:29,609 DEBUG SQL_ERROR Failed to execute query: SELECT I18N.ID_REC, I18N.MESSAGE_TEXT FROM DBJFRAME.I18N WHERE (('1'='1') AND LOWER(I18N.MESSAGE_TEXT)='visita'), SQL error: ORA-00932: tipi di dati incoerenti: previsto -, ottenuto CLOB
      
      2024-09-03T22:32:29,609 WARN DefaultValidators Field MESSAGE_TEXT - 'isUnique' validation encountered unexpected exception.
      java.sql.SQLSyntaxErrorException: ORA-00932: tipi di dati incoerenti: previsto -, ottenuto CLOB
      
          at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:896) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1172) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1101) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1426) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1309) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1713) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:394) ~[ojdbc8.jar:21.5.0.0.0]
          at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:210) ~[tomcat-dbcp.jar:8.5.23]
          at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:210) ~[tomcat-dbcp.jar:8.5.23]
          at com.isomorphic.sql.SQLDriver.executeStatement(SQLDriver.java:3210) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:1244) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDriver.executeQuery(SQLDriver.java:1728) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.executeNativeQuery(SQLDataSource.java:669) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.executeNativeQuery(SQLDataSource.java:663) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1922) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1739) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:509) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:453) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.DataSource.execute(DataSource.java:3234) ~[isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:658) ~[isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:555) ~[isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.application.AppBase.execute(AppBase.java:498) ~[isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:4368) ~[isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.util.DefaultValidators$isUnique.validate(DefaultValidators.java:2190) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.util.DefaultValidators.processValidator(DefaultValidators.java:379) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.util.DefaultValidators.validateField(DefaultValidators.java:333) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.SimpleType.validateValue(SimpleType.java:119) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.SimpleType.create(SimpleType.java:85) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.BasicDataSource.validateFieldValue(BasicDataSource.java:3032) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.BasicDataSource.validateFieldValue(BasicDataSource.java:2920) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.BasicDataSource.toRecord(BasicDataSource.java:2063) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.BasicDataSource.toRecords(BasicDataSource.java:1927) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.BasicDataSource.toRecords(BasicDataSource.java:1888) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.DataSource.validateDSRequest(DataSource.java:5118) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.DataSource.validateDSRequest(DataSource.java:5063) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.DataSource.execute(DataSource.java:3217) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:658) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:555) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.application.AppBase.execute(AppBase.java:498) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:4368) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:249) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:206) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:153) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall._processRequest(IDACall.java:123) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall.doPost(IDACall.java:79) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) [servlet-api.jar:?]
          at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:178) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) [servlet-api.jar:?]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at com.juve.spring.FrameOriginFilter.doFilter(FrameOriginFilter.java:36) [classes/:?]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at com.juve.utils.Log4j2SessionFilter.doFilter(Log4j2SessionFilter.java:72) [classes/:?]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at com.isomorphic.servlet.CompressionFilter._doFilter(CompressionFilter.java:263) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.BaseFilter.doFilter(BaseFilter.java:91) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.ui.DefaultLogoutPageGeneratingFilter.doFilterInternal(DefaultLogoutPageGeneratingFilter.java:52) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:206) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:157) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:185) [catalina.jar:8.5.23]
          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:8.5.23]
          at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) [catalina.jar:8.5.23]
          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) [catalina.jar:8.5.23]
          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [catalina.jar:8.5.23]
          at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) [catalina.jar:8.5.23]
          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [catalina.jar:8.5.23]
          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) [catalina.jar:8.5.23]
          at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) [tomcat-coyote.jar:8.5.23]
          at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-coyote.jar:8.5.23]
          at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote.jar:8.5.23]
          at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) [tomcat-coyote.jar:8.5.23]
          at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.23]
          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
          at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.23]
          at java.lang.Thread.run(Thread.java:829) [?:?]
      Caused by: oracle.jdbc.OracleDatabaseException: ORA-00932: tipi di dati incoerenti: previsto -, ottenuto CLOB
      
          at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637) ~[ojdbc8.jar:21.5.0.0.0]
          ... 129 more
      2024-09-03T22:32:29,614 INFO Validation Validation error: [
          {
              MESSAGE_TEXT:{
                  severity:"ERROR",
                  errorMessage:"ORA-00932: tipi di dati incoerenti: previsto -, ottenuto CLOB\n"
              },
              ID_APP:{
                  severity:"ERROR",
                  errorMessage:"Field is required"
              }
          }
      ]
      2024-09-03T22:32:29,615 DEBUG RPCManager Content type for RPC transaction: text/plain; charset=UTF-8
      2024-09-03T22:32:29,616 DEBUG SQLTransaction Rolling back dbJFrame transaction "1109028873"
      2024-09-03T22:32:29,649 DEBUG RPCManager non-DMI response, dropExtraFields: false
      2024-09-03T22:32:29,650 DEBUG SQLTransaction getConnection() looked for transactional connection for dbJFrame: hashcode "1109028873"
      2024-09-03T22:32:29,650 DEBUG SQLTransaction Ending dbJFrame transaction "1109028873"
      2024-09-03T22:32:29,662 DEBUG SQLConnectionManager About to close PoolGuardConnectionWrapper with hashcode "1109028873"
      this is a request with a sort:

      Code:
      2024-09-03T22:22:15,179 DEBUG RPCManager Request #1 (DSRequest) payload: {
          criteria:{
          },
          operationConfig:{
              dataSource:"I18N",
              repo:null,
              operationType:"fetch",
              textMatchStyle:"substring"
          },
          startRow:0,
          endRow:75,
          sortBy:[
              "MESSAGE_TEXT"
          ],
          componentId:"configurazioneI18nGrid",
          appID:"builtinApplication",
          operation:"I18N_fetch",
          oldValues:{
          },
          tenantId:null
      }
      2024-09-03T22:22:15,179 INFO IDACall Performing 1 operation(s) [UA: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:129.0) Gecko/20100101 Firefox/129.0]
      2024-09-03T22:22:15,180 INFO DSRequest Executing configurazioneI18nGrid->I18N.fetch rows: 0->75 with
      criteria: {}
      sortBy: [MESSAGE_TEXT]
      2024-09-03T22:22:15,180 DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
      2024-09-03T22:22:15,181 DEBUG AppBase No public zero-argument method named '_I18N_fetch' found, performing generic datasource operation
      2024-09-03T22:22:15,182 INFO SQLWhereClause empty condition
      2024-09-03T22:22:15,184 DEBUG SQL Executing row count query: SELECT COUNT(*) FROM $defaultTableClause
      2024-09-03T22:22:15,185 DEBUG PoolableSQLConnectionFactory makeObject() created an unpooled Connection '939799891'
      2024-09-03T22:22:15,185 DEBUG SQLConnectionManager Borrowed connection '939799891' from DBCP
      2024-09-03T22:22:15,185 DEBUG SQLTransaction Started new dbJFrame transaction "939799891"
      2024-09-03T22:22:15,185 INFO SQL Executing SQL query on 'dbJFrame': SELECT COUNT(*) FROM DBJFRAME.I18N
      2024-09-03T22:22:15,241 DEBUG SQL_ERROR Failed to execute query: SELECT I18N.ID_REC, I18N.MESSAGE_ID, I18N.MESSAGE_TEXT, I18N.ID_APP FROM DBJFRAME.I18N WHERE ('1'='1') ORDER BY I18N.MESSAGE_TEXT, SQL error: ORA-00932: tipi di dati incoerenti: previsto -, ottenuto CLOB
      
      2024-09-03T22:22:15,241 WARN RequestContext dsRequest.execute() failed:
      java.sql.SQLSyntaxErrorException: ORA-00932: tipi di dati incoerenti: previsto -, ottenuto CLOB
      
          at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:896) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1172) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1101) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1426) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1309) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:5139) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:5261) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1742) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:394) ~[ojdbc8.jar:21.5.0.0.0]
          at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:210) ~[tomcat-dbcp.jar:8.5.23]
          at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:210) ~[tomcat-dbcp.jar:8.5.23]
          at com.isomorphic.sql.SQLDriver.executeStatement(SQLDriver.java:3210) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDataSource.java:3494) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1905) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1739) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:509) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:453) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.DataSource.execute(DataSource.java:3234) ~[isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:658) ~[isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:555) ~[isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.application.AppBase.execute(AppBase.java:498) ~[isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:4368) ~[isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:249) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:206) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:153) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall._processRequest(IDACall.java:123) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall.doPost(IDACall.java:79) [isomorphic-core-rpc-13.1-d20240903.jar:?]
      and this is a fetch with equals operator (iContains works instead):

      Code:
      set 03, 2024 10:40:44 PM org.apache.catalina.core.StandardWrapperValve invoke
      INFORMAZIONI: 2024-09-03T22:40:43,949 DEBUG RPCManager Starting request parsing
      2024-09-03T22:40:44,134 DEBUG PoolManager Invalidating null object for key 'transaction
      2024-09-03T22:40:44,134 DEBUG PoolManager Invalidating null object for key 'elem
      2024-09-03T22:40:44,134 DEBUG RPCManager Done request parsing
      2024-09-03T22:40:44,134 DEBUG RPCManager Processing 1 requests.
      2024-09-03T22:40:44,135 DEBUG RPCManager Request #1 (DSRequest) payload: {
          criteria:{
              operator:"and",
              _constructor:"AdvancedCriteria",
              criteria:[
                  {
                      fieldName:"MESSAGE_TEXT",
                      operator:"equals",
                      value:"Visita",
                      _criterionId:1725395932636
                  }
              ],
              _criterionId:1725395932635
          },
          operationConfig:{
              dataSource:"I18N_BASE",
              repo:null,
              operationType:"fetch",
              textMatchStyle:"substring"
          },
          startRow:0,
          endRow:75,
          componentId:"configurazioneI18nJuveModuleGrid",
          appID:"builtinApplication",
          operation:"I18N_BASE_fetch",
          oldValues:{
              operator:"and",
              _constructor:"AdvancedCriteria",
              criteria:[
                  {
                      fieldName:"MESSAGE_TEXT",
                      operator:"equals",
                      value:"Visita",
                      _criterionId:1725395932636
                  }
              ],
              _criterionId:1725395932635
          },
          tenantId:null
      }
      2024-09-03T22:40:44,135 INFO IDACall Performing 1 operation(s) [UA: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:129.0) Gecko/20100101 Firefox/129.0]
      2024-09-03T22:40:44,135 INFO DSRequest Executing configurazioneI18nJuveModuleGrid->I18N_BASE.fetch rows: 0->75 with
      criteria: {
          operator:"and",
          _constructor:"AdvancedCriteria",
          criteria:[
              {fieldName:"MESSAGE_TEXT", operator:"equals", value:"Visita", _criterionId:1725395932636}
          ],
          _criterionId:1725395932635
      }
      2024-09-03T22:40:44,135 INFO AdvancedCriteria Criteria object:{
          fieldName:"MESSAGE_TEXT",
          operator:"equals",
          value:"Visita",
          _criterionId:1725395932636
      } not explicitly marked as AdvancedCriteria but treating as Advanced based on format.
      2024-09-03T22:40:44,137 DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
      2024-09-03T22:40:44,137 DEBUG AppBase No public zero-argument method named '_I18N_BASE_fetch' found, performing generic datasource operation
      2024-09-03T22:40:44,139 DEBUG SQL Executing row count query: SELECT COUNT(*) FROM $defaultTableClause WHERE $defaultWhereClause
      2024-09-03T22:40:44,332 DEBUG PoolableSQLConnectionFactory makeObject() created an unpooled Connection '1409096464'
      2024-09-03T22:40:44,332 DEBUG SQLConnectionManager Borrowed connection '1409096464' from DBCP
      2024-09-03T22:40:44,333 DEBUG SQLTransaction Started new dbJFrame transaction "1409096464"
      2024-09-03T22:40:44,333 INFO SQL Executing SQL query on 'dbJFrame': SELECT COUNT(*) FROM DBJFRAME.I18N WHERE ((I18N.MESSAGE_TEXT = 'Visita' AND I18N.MESSAGE_TEXT IS NOT NULL) AND (LOWER(I18N.ID_APP) LIKE LOWER('%\_base\_%') ESCAPE'\' AND I18N.ID_APP IS NOT NULL))
      2024-09-03T22:40:44,360 DEBUG SQL_ERROR Failed to execute query: SELECT COUNT(*) FROM DBJFRAME.I18N WHERE ((I18N.MESSAGE_TEXT = 'Visita' AND I18N.MESSAGE_TEXT IS NOT NULL) AND (LOWER(I18N.ID_APP) LIKE LOWER('%\_base\_%') ESCAPE'\' AND I18N.ID_APP IS NOT NULL)), SQL error: ORA-00932: tipi di dati incoerenti: previsto -, ottenuto CLOB
      
      2024-09-03T22:40:44,360 WARN RequestContext dsRequest.execute() failed:
      java.sql.SQLSyntaxErrorException: ORA-00932: tipi di dati incoerenti: previsto -, ottenuto CLOB
      
          at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:896) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1172) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1101) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1426) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1309) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1713) ~[ojdbc8.jar:21.5.0.0.0]
          at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:394) ~[ojdbc8.jar:21.5.0.0.0]
          at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:210) ~[tomcat-dbcp.jar:8.5.23]
          at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:210) ~[tomcat-dbcp.jar:8.5.23]
          at com.isomorphic.sql.SQLDriver.executeStatement(SQLDriver.java:3210) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:1244) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:1162) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:1155) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDriver.getScalarResult(SQLDriver.java:1409) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDriver.executeScalar(SQLDriver.java:1735) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.runRowCountQuery(SQLDataSource.java:3970) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDataSource.java:3075) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1905) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1739) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:509) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:453) ~[isomorphic-sql-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.DataSource.execute(DataSource.java:3234) ~[isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:658) ~[isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:555) ~[isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.application.AppBase.execute(AppBase.java:498) ~[isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:4368) ~[isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:249) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:206) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:153) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall._processRequest(IDACall.java:123) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.IDACall.doPost(IDACall.java:79) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) [servlet-api.jar:?]
          at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:178) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) [servlet-api.jar:?]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at com.juve.spring.FrameOriginFilter.doFilter(FrameOriginFilter.java:36) [classes/:?]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at com.juve.utils.Log4j2SessionFilter.doFilter(Log4j2SessionFilter.java:72) [classes/:?]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at com.isomorphic.servlet.CompressionFilter._doFilter(CompressionFilter.java:263) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at com.isomorphic.servlet.BaseFilter.doFilter(BaseFilter.java:91) [isomorphic-core-rpc-13.1-d20240903.jar:?]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.ui.DefaultLogoutPageGeneratingFilter.doFilterInternal(DefaultLogoutPageGeneratingFilter.java:52) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:206) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:157) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:185) [catalina.jar:8.5.23]
          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:8.5.23]
          at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) [catalina.jar:8.5.23]
          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) [catalina.jar:8.5.23]
          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [catalina.jar:8.5.23]
          at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) [catalina.jar:8.5.23]
          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [catalina.jar:8.5.23]
          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) [catalina.jar:8.5.23]
          at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) [tomcat-coyote.jar:8.5.23]
          at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-coyote.jar:8.5.23]
          at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote.jar:8.5.23]
          at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) [tomcat-coyote.jar:8.5.23]
          at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.23]
          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
          at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.23]
          at java.lang.Thread.run(Thread.java:829) [?:?]
      Caused by: oracle.jdbc.OracleDatabaseException: ORA-00932: tipi di dati incoerenti: previsto -, ottenuto CLOB
      
          at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637) ~[ojdbc8.jar:21.5.0.0.0]
          ... 115 more
      2024-09-03T22:40:44,362 DEBUG RPCManager Content type for RPC transaction: text/plain; charset=UTF-8
      2024-09-03T22:40:44,362 DEBUG SQLTransaction Rolling back dbJFrame transaction "1409096464"
      2024-09-03T22:40:44,382 DEBUG RPCManager non-DMI response, dropExtraFields: false
      2024-09-03T22:40:44,382 DEBUG SQLTransaction getConnection() looked for transactional connection for dbJFrame: hashcode "1409096464"
      2024-09-03T22:40:44,382 DEBUG SQLTransaction Ending dbJFrame transaction "1409096464"
      2024-09-03T22:40:44,394 DEBUG SQLConnectionManager About to close PoolGuardConnectionWrapper with hashcode "1409096464"

      Comment


        #4
        Somebody is assigned to look into this, we'll post back soon

        Comment


          #5
          Oracle does not support sorting on columns of type CLOB, so if this has appeared to work previously, either the column was of a different type, or the sort was not actually taking place . There is a workaround for this - instead of sorting by the CLOB column directly, we could use a substring function to retrieve the first n characters of the CLOB and sort on that instead. If you need this to be supported, consider sponsoring it as a feature; however, be aware that this is the only known workaround, and it is likely to be slow.

          As well as sorting, you also show an example where an attempt to filter on the MESSAGE_TEXT field is failing (your isUnique validator). This is for exactly the same reason, and the same workaround would work for filtering and joining as well, although it is more problematic. This is because sorting on the first few characters of a string is usually enough to give the desired result, so sorting on the first 1024 (say) characters is going to give the desired result in almost every conceivable circumstance.

          Filtering and joining are different - to take your isUnique validator, a single character difference in position 27,903 of the MESSAGE_TEXT should cause the isUnique validator to pass, but it would not because we are only comparing position 0 to 1023 (or whatever). So the isUnique check would be incorrect, but this also raises the question - is checking for uniqueness of a huge long string a useful thing to do in the first place, if the addition of a comma in the middle of the 18th paragraph is enough to make it unique?

          All in all, we would recommend that you either change to use a smaller VARCHAR2 column, or forego the idea of sorting or filtering by that value, or do something like retain the CLOB to hold the complete string, but also store the first n characters of it in a regular VARCHAR2 column in each row, for sorting (and possibly filtering) purposes.

          Finally, your server log includes a warning about a missing SQL Expression for field "ID_APP". We suspect this is because you are not sending that field from your client app, perhaps because it is being populated by something else - as a database default, perhaps. Could you please confirm this, or show us the client "add" request that leads to this warning?

          Comment


            #6
            Hello and thank you for the thorough response.

            Regarding the WARN, indeed, while I was running various tests, I must have removed the operationBinding with the <values> clause to populate that column.

            Actually, in my case, a VARCHAR column might be more than sufficient; this would solve the problem, especially for the isUnique check, which is the most important thing for me in this use case.

            Comment

            Working...
            X