Hi Claudio
Our team is investigating this and will follow up when we have more information for you
Regards
Isomorphic Software
-
implicitSequence problem
Hello, I'm trying the implicitSequence feature, but I think I found a problem.
This is my dataSource:
Code:<DataSource xmlns:fmt="WEB-INF/" xmlns="http://www.smartclient.com/schema" ID="IMA_TIPI_ABBONAMENTO" tableName="IMA_TIPI_ABBONAMENTO" schema="DBSALES" dbName="dbJpcEP" serverType="sql" sequenceMode="jdbcDriver" dropExtraFields="false" quoteColumnNames="true" > <fmt:bundle basename="i18nMessages" encoding="utf-8"/> <fields> <field sqlType="decimal" primaryKey="true" name="ID_REC" type="sequence" implicitSequence="true"/> <field sqlType="decimal" name="ID_PRODOTTO" type="integer"/> <field sqlType="decimal" name="ID_PRODOTTO_ALL_MATCHES" type="integer"/> <field name="DESCRIZIONE" type="text" length="200" sqlLength="200" sqlType="varchar" required="true"/> <field name="DESCRIZIONE_LISTICKET" type="text" length="200" sqlLength="200" sqlType="varchar"/> <field name="ID_STAGIONE_FK" type="integer" foreignKey="JPC_STAGIONI.ID_REC"/> <field name="STAGIONE" type="text" includeFrom="JPC_STAGIONI.DESCRIZIONE" title="Stagione" customSQL="true"/> <field name="CODICE" type="text" length="200" sqlLength="200" sqlType="varchar" required="true"> <validators> <validator type="isUnique" criteriaFields="ID_STAGIONE_FK" errorMessage="Codice già utilizzato per la stagione selezionata" /> </validators> </field> <field name="PG_SESSION_ID" type="trimText"> <validators> <validator type="isUnique" criteriaFields="ID_STAGIONE_FK" errorMessage="Session ID già utilizzato per la stagione selezionata" /> </validators> </field> <field name="IS_MINI_ABBONAMENTO" type="boolean" sqlStorageStrategy="singleCharTF"/> <field name="DATA_INIZIO" type="datetime"/> <field name="DATA_FINE" type="datetime"/> </fields> <operationBindings> <operationBinding operationType="fetch" customFields="STAGIONE"> <orderClause>IMA_TIPI_ABBONAMENTO.ID_STAGIONE_FK desc</orderClause> </operationBinding> <operationBinding operationType="add" serverMethod="addOrUpdateTipoAbbonamento"> <serverObject lookupStyle="new" className="com.juve.ima.ElencaAbbonamentiDMI"/> </operationBinding> </operationBindings> </DataSource> [B][/B]
This is the log when *not* using ANSI joins:
2023-07-28T10:58:37,832 INFO DSRequest Executing gestioneAbbonamentiGridAbbonamenti->IMA_TIPI_ABBONAMENTO.add with
criteria: {}
values: {ID_PRODOTTO:13, ID_PRODOTTO_ALL_MATCHES:13, ID_STAGIONE_FK:8681749, DESCRIZIONE:"MINI ABBONAMENTO 2",
CODICE:"asdasdas", DATA_INIZIO:new Date(1685952000000), abbonamentoTicketing:15517,
DATA_FINE:new Date(1723759200000), PG_SESSION_ID:"15517",
DESCRIZIONE_LISTICKET:"2023-2024 SERIE A TIM | PARTITA 11"}
2023-07-28T10:58:37,833 DEBUG DeclarativeSecurity Processing security checks for DataSource null, field null
2023-07-28T10:58:37,833 DEBUG DeclarativeSecurity DataSource IMA_TIPI_ABBONAMENTO is not in the pre-checked list, processing...
2023-07-28T10:58:37,835 DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
2023-07-28T10:58:37,835 DEBUG AppBase No public zero-argument method named '_IMA_TIPI_ABBONAMENTO_add' found, performing generic datasource operation
2023-07-28T10:58:37,837 INFO SQLValuesClause Ignored data for non-existent or included columns: [abbonamentoTicketing]
2023-07-28T10:58:37,842 DEBUG SQLValuesClause Sequences: {ID_REC=__default}
2023-07-28T10:58:37,850 INFO SQLDriver Executing SQL query on 'dbJpcEP' using connection '1996941818': INSERT INTO DBSALES.IMA_TIPI_ABBONAMENTO ("CODICE", "DATA_FINE", "DATA_INIZIO", "DESCRIZIONE", "DESCRIZIONE_LISTICKET", "ID_PRODOTTO", "ID_PRODOTTO_ALL_MATCHES", "ID_STAGIONE_FK", "PG_SESSION_ID") VALUES ('asdasdas', TO_DATE('2024-08-16 00:00:00','YYYY-MM-DD HH24:MI:SS'), TO_DATE('2023-06-05 10:00:00','YYYY-MM-DD HH24:MI:SS'), 'MINI ABBONAMENTO 2', '2023-2024 SERIE A TIM | PARTITA 11', 13, 13, 8681749, '15517')
2023-07-28T10:58:37,900 DEBUG SQLDriver Found 1 sequence(s)/autoGenerated PK field(s): [ID_REC]
2023-07-28T10:58:37,902 DEBUG PoolableDataSourceFactory Activated DataSource 1647 of type 'IMA_TIPI_ABBONAMENTO' with hashCode '682471216'
2023-07-28T10:58:37,921 INFO SQLWhereClause empty condition
2023-07-28T10:58:37,923 INFO SQLDataSource derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause AND $defaultJoinWhereClause ORDER BY IMA_TIPI_ABBONAMENTO.ID_STAGIONE_FK desc
2023-07-28T10:58:37,931 DEBUG SQLDriver Executing ROWID query: SELECT IMA_TIPI_ABBONAMENTO."ID_REC", IMA_TIPI_ABBONAMENTO."ID_PRODOTTO", IMA_TIPI_ABBONAMENTO."ID_PRODOTTO_ALL_MATCHES", IMA_TIPI_ABBONAMENTO."DESCRIZIONE", IMA_TIPI_ABBONAMENTO."DESCRIZIONE_LISTICKET", IMA_TIPI_ABBONAMENTO."ID_STAGIONE_FK", IMA_TIPI_ABBONAMENTO."CODICE", IMA_TIPI_ABBONAMENTO."PG_SESSION_ID", IMA_TIPI_ABBONAMENTO."IS_MINI_ABBONAMENTO", IMA_TIPI_ABBONAMENTO."DATA_INIZIO", IMA_TIPI_ABBONAMENTO."DATA_FINE", JPC_STAGIONI.DESCRIZIONE AS STAGIONE FROM DBSALES.IMA_TIPI_ABBONAMENTO, DBSALES.JPC_STAGIONI WHERE ROWID = 'AAASXBAAbAAAASuAAC'
2023-07-28T10:58:38,009 WARN SQLDriver Exception thrown during saveGeneratedKeys()
java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1276) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366) ~[ojdbc8.jar:12.2.0.1.0]
at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202]
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc.jar:?]
at com.sun.proxy.$Proxy67.executeQuery(Unknown Source) ~[?:?]
at com.isomorphic.sql.SQLDriver.fetchSequenceValues(SQLDriver.java:2178) ~[isomorphic-sql-13.0-p20221116.jar:?]
at com.isomorphic.sql.SQLDriver.saveGeneratedKeys(SQLDriver.java:2013) ~[isomorphic-sql-13.0-p20221116.jar:?]
at com.isomorphic.sql.SQLDriver.doUpdate(SQLDriver.java:1495) [isomorphic-sql-13.0-p20221116.jar:?]
at com.isomorphic.sql.SQLDriver.update(SQLDriver.java:1393) [isomorphic-sql-13.0-p20221116.jar:?]
at com.isomorphic.sql.SQLDriver.executeUpdate(SQLDriver.java:1579) [isomorphic-sql-13.0-p20221116.jar:?]
at com.isomorphic.sql.SQLDataSource.executeNativeUpdate(SQLDataSource.java:606) [isomorphic-sql-13.0-p20221116.jar:?]
at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:2104) [isomorphic-sql-13.0-p20221116.jar:?]
at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:449) [isomorphic-sql-13.0-p20221116.jar:?]
at com.isomorphic.sql.SQLDataSource.executeAdd(SQLDataSource.java:402) [isomorphic-sql-13.0-p20221116.jar:?]
at com.isomorphic.datasource.DataSource.execute(DataSource.java:2798) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:658) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:555) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.application.AppBase.execute(AppBase.java:498) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:3211) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.juve.ima.ElencaAbbonamentiDMI.addOrUpdateTipoAbbonamento(ElencaAbbonamentiDMI.java:93) [classes/:build]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_202]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_202]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202]
at com.isomorphic.base.Reflection._invokeMethod(Reflection.java:581) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:896) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:434) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:64) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:3196) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:226) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:183) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:148) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.servlet.IDACall._processRequest(IDACall.java:119) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.servlet.IDACall.doPost(IDACall.java:79) [isomorphic-core-rpc-13.0-p20221116.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.0-p20221116.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.39]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.39]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.39]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
at com.isomorphic.servlet.CompressionFilter._doFilter(CompressionFilter.java:263) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.servlet.BaseFilter.doFilter(BaseFilter.java:91) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.39]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
at com.juve.jtk.filter.JuventusCustomCORSFilter.doFilter(JuventusCustomCORSFilter.java:38) [classes/:build]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.39]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
at com.juve.utils.Log4j2SessionFilter.doFilter(Log4j2SessionFilter.java:72) [classes/:build]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.39]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:337) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:122) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:116) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:109) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at com.juve.azure.auth.AzureADAuthFilter.doFilterInternal(AzureADAuthFilter.java:118) [classes/:build]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) [spring-web-5.3.23.jar:5.3.23]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) [spring-web-5.3.23.jar:5.3.23]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:112) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:82) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) [spring-web-5.3.23.jar:5.3.23]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:133) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.session.DisableEncodeUrlFilter.doFilterInternal(DisableEncodeUrlFilter.java:42) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) [spring-web-5.3.23.jar:5.3.23]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:221) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:186) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) [spring-web-5.3.23.jar:5.3.23]
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) [spring-web-5.3.23.jar:5.3.23]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.39]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) [spring-web-5.3.23.jar:5.3.23]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) [spring-web-5.3.23.jar:5.3.23]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.39]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) [catalina.jar:8.5.39]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:8.5.39]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) [catalina.jar:8.5.39]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) [catalina.jar:8.5.39]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [catalina.jar:8.5.39]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660) [catalina.jar:8.5.39]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [catalina.jar:8.5.39]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:8.5.39]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798) [tomcat-coyote.jar:8.5.39]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-coyote.jar:8.5.39]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806) [tomcat-coyote.jar:8.5.39]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) [tomcat-coyote.jar:8.5.39]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.39]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.39]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202]
Caused by: oracle.jdbc.OracleDatabaseException: ORA-00918: column ambiguously defined
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ~[ojdbc8.jar:12.2.0.1.0]
... 128 more
2023-07-28T10:58:38,046 INFO SQLDataSource primaryKeys: {}
2023-07-28T10:58:38,047 INFO SQLDataSource dbJpcEP getLastRow(): using default operationBinding
2023-07-28T10:58:38,054 INFO DSRequest Executing IMA_TIPI_ABBONAMENTO.fetch rows: 0->-1 with
criteria: {}
2023-07-28T10:58:38,055 DEBUG DeclarativeSecurity Processing security checks for DataSource null, field null
2023-07-28T10:58:38,055 DEBUG DeclarativeSecurity DataSource IMA_TIPI_ABBONAMENTO is not in the pre-checked list, processing...
2023-07-28T10:58:38,056 DEBUG DeclarativeSecurity Processing security checks for DataSource JPC_STAGIONI, field ID_REC
2023-07-28T10:58:38,056 DEBUG DeclarativeSecurity DataSource JPC_STAGIONI is not in the pre-checked list, processing...
2023-07-28T10:58:38,057 DEBUG DeclarativeSecurity Processing security checks for DataSource JPC_STAGIONI, field DESCRIZIONE
2023-07-28T10:58:38,057 DEBUG DeclarativeSecurity DataSource JPC_STAGIONI is not in the pre-checked list, processing...
2023-07-28T10:58:38,060 DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
2023-07-28T10:58:38,060 DEBUG AppBase No public zero-argument method named '_null' found, performing generic datasource operation
2023-07-28T10:58:38,064 INFO SQLWhereClause empty condition
2023-07-28T10:58:38,067 INFO SQLDataSource derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause AND $defaultJoinWhereClause ORDER BY IMA_TIPI_ABBONAMENTO.ID_STAGIONE_FK desc
2023-07-28T10:58:38,423 INFO DSResponse DSResponse: List with 1 items
2023-07-28T10:58:38,424 INFO DSResponse DSResponse: List with 1 items
2023-07-28T10:58:52,952 INFO DSResponse DSResponse: List with 1 items
2023-07-28T10:58:52,955 DEBUG RPCManager Content type for RPC transaction: text/plain; charset=UTF-8
2023-07-28T10:58:52,957 DEBUG SQLTransaction Committing dbJpcEP transaction "1996941818"
2023-07-28T10:58:52,992 DEBUG RPCManager DMI response, dropExtraFields: false
2023-07-28T10:58:53,000 DEBUG PoolableDataSourceFactory Tried to create DataSource of type 'trimText' but null was returned
2023-07-28T10:58:53,000 DEBUG PoolableDataSourceFactory Created DataSource null of type 'trimText' with hashCode 'null' in the pooling flow
2023-07-28T10:58:53,013 DEBUG SQLTransaction getConnection() looked for transactional connection for dbJpcEP: hashcode "1996941818"
2023-07-28T10:58:53,013 DEBUG SQLTransaction Ending dbJpcEP transaction "1996941818"
2023-07-28T10:58:53,049 DEBUG SQLConnectionManager About to close $Proxy66 with hashcode "1996941818"
2023-07-28T10:58:53,088 DEBUG PoolableDataSourceFactory Cleared and passivated DataSource 61 of type 'JPC_STAGIONI_BASE' with hashCode '412209681'
2023-07-28T10:58:53,088 DEBUG PoolableDataSourceFactory Cleared and passivated DataSource 60 of type 'JPC_STAGIONI' with hashCode '822562278'
2023-07-28T10:58:53,088 DEBUG PoolableDataSourceFactory Cleared and passivated DataSource 1228 of type 'IMA_TIPI_ABBONAMENTO' with hashCode '23198399'
2023-07-28T10:58:53,088 DEBUG SQLTransaction getConnection() looked for transactional connection for dbJpcEP: (connection is null)
2023-07-28T10:58:53,090 DEBUG SQLTransaction getConnection() looked for transactional connection for dbJpcEP: (connection is null)
2023-07-28T10:58:53,092 INFO Compression /Jtk/isomorphic/IDACall: 476 -> 342
and this when using ANSI joins:
2023-07-28T10:53:51,234 INFO DSRequest Executing gestioneAbbonamentiGridAbbonamenti->IMA_TIPI_ABBONAMENTO.add with
criteria: {}
values: {ID_PRODOTTO:13, ID_PRODOTTO_ALL_MATCHES:13, ID_STAGIONE_FK:8681749, DESCRIZIONE:"MINI ABBONAMENTO 3",
CODICE:"asdasd", DATA_INIZIO:new Date(1685952000000), abbonamentoTicketing:15357,
DATA_FINE:new Date(1723759200000), PG_SESSION_ID:"15357",
DESCRIZIONE_LISTICKET:"2023-2024 SERIE A TIM | PARTITA 3"}
2023-07-28T10:53:51,234 DEBUG DeclarativeSecurity Processing security checks for DataSource null, field null
2023-07-28T10:53:51,235 DEBUG DeclarativeSecurity DataSource IMA_TIPI_ABBONAMENTO is not in the pre-checked list, processing...
2023-07-28T10:53:51,236 DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
2023-07-28T10:53:51,237 DEBUG AppBase No public zero-argument method named '_IMA_TIPI_ABBONAMENTO_add' found, performing generic datasource operation
2023-07-28T10:53:51,238 INFO SQLValuesClause Ignored data for non-existent or included columns: [abbonamentoTicketing]
2023-07-28T10:53:51,242 DEBUG SQLValuesClause Sequences: {ID_REC=__default}
2023-07-28T10:53:51,250 INFO SQLDriver Executing SQL query on 'dbJpcEP' using connection '1541337976': INSERT INTO DBSALES.IMA_TIPI_ABBONAMENTO ("CODICE", "DATA_FINE", "DATA_INIZIO", "DESCRIZIONE", "DESCRIZIONE_LISTICKET", "ID_PRODOTTO", "ID_PRODOTTO_ALL_MATCHES", "ID_STAGIONE_FK", "PG_SESSION_ID") VALUES ('asdasd', TO_DATE('2024-08-16 00:00:00','YYYY-MM-DD HH24:MI:SS'), TO_DATE('2023-06-05 10:00:00','YYYY-MM-DD HH24:MI:SS'), 'MINI ABBONAMENTO 3', '2023-2024 SERIE A TIM | PARTITA 3', 13, 13, 8681749, '15357')
2023-07-28T10:53:51,300 DEBUG SQLDriver Found 1 sequence(s)/autoGenerated PK field(s): [ID_REC]
2023-07-28T10:53:51,313 DEBUG PoolableDataSourceFactory Activated DataSource 80 of type 'JPC_STAGIONI' with hashCode '571966713'
2023-07-28T10:53:51,314 DEBUG PoolableDataSourceFactory Activated DataSource 81 of type 'JPC_STAGIONI_BASE' with hashCode '1675010042'
2023-07-28T10:53:51,316 DEBUG PoolableDataSourceFactory Created DataSource 1222 of type 'IMA_TIPI_ABBONAMENTO' with hashCode '1432256417' and assigned it to thread https-jsse-nio-8443-exec-3
2023-07-28T10:53:51,316 DEBUG PoolableDataSourceFactory Created DataSource 1222 of type 'IMA_TIPI_ABBONAMENTO' with hashCode '1432256417' in the pooling flow
2023-07-28T10:53:51,316 DEBUG PoolableDataSourceFactory Activated DataSource 1222 of type 'IMA_TIPI_ABBONAMENTO' with hashCode '1432256417'
2023-07-28T10:53:51,331 INFO SQLWhereClause empty condition
2023-07-28T10:53:51,333 INFO SQLDataSource derived query: SELECT $defaultSelectClause FROM $defaultTableClause $defaultAnsiJoinClause WHERE $defaultWhereClause ORDER BY IMA_TIPI_ABBONAMENTO.ID_STAGIONE_FK desc
2023-07-28T10:53:51,340 DEBUG SQLDriver Executing ROWID query: SELECT IMA_TIPI_ABBONAMENTO."ID_REC", IMA_TIPI_ABBONAMENTO."ID_PRODOTTO", IMA_TIPI_ABBONAMENTO."ID_PRODOTTO_ALL_MATCHES", IMA_TIPI_ABBONAMENTO."DESCRIZIONE", IMA_TIPI_ABBONAMENTO."DESCRIZIONE_LISTICKET", IMA_TIPI_ABBONAMENTO."ID_STAGIONE_FK", IMA_TIPI_ABBONAMENTO."CODICE", IMA_TIPI_ABBONAMENTO."PG_SESSION_ID", IMA_TIPI_ABBONAMENTO."IS_MINI_ABBONAMENTO", IMA_TIPI_ABBONAMENTO."DATA_INIZIO", IMA_TIPI_ABBONAMENTO."DATA_FINE", JPC_STAGIONI.DESCRIZIONE AS STAGIONE FROM DBSALES.IMA_TIPI_ABBONAMENTO JOIN DBSALES.JPC_STAGIONI ON IMA_TIPI_ABBONAMENTO."ID_STAGIONE_FK" = JPC_STAGIONI.ID_REC WHERE ROWID = 'AAASXBAAbAAAASvAAF'
2023-07-28T10:53:51,428 WARN SQLDriver Exception thrown during saveGeneratedKeys()
java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1276) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366) ~[ojdbc8.jar:12.2.0.1.0]
at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202]
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc.jar:?]
at com.sun.proxy.$Proxy67.executeQuery(Unknown Source) ~[?:?]
at com.isomorphic.sql.SQLDriver.fetchSequenceValues(SQLDriver.java:2178) ~[isomorphic-sql-13.0-p20221116.jar:?]
at com.isomorphic.sql.SQLDriver.saveGeneratedKeys(SQLDriver.java:2013) ~[isomorphic-sql-13.0-p20221116.jar:?]
at com.isomorphic.sql.SQLDriver.doUpdate(SQLDriver.java:1495) [isomorphic-sql-13.0-p20221116.jar:?]
at com.isomorphic.sql.SQLDriver.update(SQLDriver.java:1393) [isomorphic-sql-13.0-p20221116.jar:?]
at com.isomorphic.sql.SQLDriver.executeUpdate(SQLDriver.java:1579) [isomorphic-sql-13.0-p20221116.jar:?]
at com.isomorphic.sql.SQLDataSource.executeNativeUpdate(SQLDataSource.java:606) [isomorphic-sql-13.0-p20221116.jar:?]
at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:2104) [isomorphic-sql-13.0-p20221116.jar:?]
at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:449) [isomorphic-sql-13.0-p20221116.jar:?]
at com.isomorphic.sql.SQLDataSource.executeAdd(SQLDataSource.java:402) [isomorphic-sql-13.0-p20221116.jar:?]
at com.isomorphic.datasource.DataSource.execute(DataSource.java:2798) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:658) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:555) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.application.AppBase.execute(AppBase.java:498) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:3211) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.juve.ima.ElencaAbbonamentiDMI.addOrUpdateTipoAbbonamento(ElencaAbbonamentiDMI.java:93) [classes/:build]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_202]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_202]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202]
at com.isomorphic.base.Reflection._invokeMethod(Reflection.java:581) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:896) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:434) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:64) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:3196) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:226) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:183) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:148) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.servlet.IDACall._processRequest(IDACall.java:119) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.servlet.IDACall.doPost(IDACall.java:79) [isomorphic-core-rpc-13.0-p20221116.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.0-p20221116.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.39]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.39]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.39]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
at com.isomorphic.servlet.CompressionFilter._doFilter(CompressionFilter.java:263) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at com.isomorphic.servlet.BaseFilter.doFilter(BaseFilter.java:91) [isomorphic-core-rpc-13.0-p20221116.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.39]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
at com.juve.jtk.filter.JuventusCustomCORSFilter.doFilter(JuventusCustomCORSFilter.java:38) [classes/:build]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.39]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
at com.juve.utils.Log4j2SessionFilter.doFilter(Log4j2SessionFilter.java:72) [classes/:build]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.39]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:337) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:122) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:116) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:109) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at com.juve.azure.auth.AzureADAuthFilter.doFilterInternal(AzureADAuthFilter.java:118) [classes/:build]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) [spring-web-5.3.23.jar:5.3.23]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) [spring-web-5.3.23.jar:5.3.23]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:112) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:82) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) [spring-web-5.3.23.jar:5.3.23]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:133) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.session.DisableEncodeUrlFilter.doFilterInternal(DisableEncodeUrlFilter.java:42) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) [spring-web-5.3.23.jar:5.3.23]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:221) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:186) [spring-security-web-5.7.5.jar:5.7.5]
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) [spring-web-5.3.23.jar:5.3.23]
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) [spring-web-5.3.23.jar:5.3.23]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.39]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) [spring-web-5.3.23.jar:5.3.23]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) [spring-web-5.3.23.jar:5.3.23]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.39]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.39]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) [catalina.jar:8.5.39]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:8.5.39]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) [catalina.jar:8.5.39]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) [catalina.jar:8.5.39]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [catalina.jar:8.5.39]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660) [catalina.jar:8.5.39]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [catalina.jar:8.5.39]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:8.5.39]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798) [tomcat-coyote.jar:8.5.39]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-coyote.jar:8.5.39]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806) [tomcat-coyote.jar:8.5.39]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) [tomcat-coyote.jar:8.5.39]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.39]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.39]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202]
Caused by: oracle.jdbc.OracleDatabaseException: ORA-00918: column ambiguously defined
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ~[ojdbc8.jar:12.2.0.1.0]
... 128 more
2023-07-28T10:53:51,494 INFO SQLDataSource primaryKeys: {}
2023-07-28T10:53:51,495 INFO SQLDataSource dbJpcEP getLastRow(): using default operationBinding
2023-07-28T10:53:51,502 INFO DSRequest Executing IMA_TIPI_ABBONAMENTO.fetch rows: 0->-1 with
criteria: {}
2023-07-28T10:53:51,503 DEBUG DeclarativeSecurity Processing security checks for DataSource null, field null
2023-07-28T10:53:51,504 DEBUG DeclarativeSecurity DataSource IMA_TIPI_ABBONAMENTO is not in the pre-checked list, processing...
2023-07-28T10:53:51,504 DEBUG DeclarativeSecurity Processing security checks for DataSource JPC_STAGIONI, field ID_REC
2023-07-28T10:53:51,504 DEBUG DeclarativeSecurity DataSource JPC_STAGIONI is not in the pre-checked list, processing...
2023-07-28T10:53:51,505 DEBUG DeclarativeSecurity Processing security checks for DataSource JPC_STAGIONI, field DESCRIZIONE
2023-07-28T10:53:51,505 DEBUG DeclarativeSecurity DataSource JPC_STAGIONI is not in the pre-checked list, processing...
2023-07-28T10:53:51,508 DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
2023-07-28T10:53:51,509 DEBUG AppBase No public zero-argument method named '_null' found, performing generic datasource operation
2023-07-28T10:53:51,513 INFO SQLWhereClause empty condition
2023-07-28T10:53:51,516 INFO SQLDataSource derived query: SELECT $defaultSelectClause FROM $defaultTableClause $defaultAnsiJoinClause WHERE $defaultWhereClause ORDER BY IMA_TIPI_ABBONAMENTO.ID_STAGIONE_FK desc
2023-07-28T10:53:51,891 INFO DSResponse DSResponse: List with 1 items
2023-07-28T10:53:51,893 INFO DSResponse DSResponse: List with 1 items
2023-07-28T10:54:42,240 INFO DSResponse DSResponse: List with 1 items
2023-07-28T10:54:42,264 DEBUG RPCManager Content type for RPC transaction: text/plain; charset=UTF-8
2023-07-28T10:54:42,267 DEBUG SQLTransaction Committing dbJpcEP transaction "1541337976"
2023-07-28T10:54:42,325 DEBUG RPCManager DMI response, dropExtraFields: false
2023-07-28T10:54:42,334 DEBUG PoolableDataSourceFactory Tried to create DataSource of type 'trimText' but null was returned
2023-07-28T10:54:42,334 DEBUG PoolableDataSourceFactory Created DataSource null of type 'trimText' with hashCode 'null' in the pooling flow
2023-07-28T10:54:42,342 DEBUG SQLTransaction getConnection() looked for transactional connection for dbJpcEP: hashcode "1541337976"
2023-07-28T10:54:42,342 DEBUG SQLTransaction Ending dbJpcEP transaction "1541337976"
2023-07-28T10:54:42,372 DEBUG SQLConnectionManager About to close $Proxy66 with hashcode "1541337976"
2023-07-28T10:54:42,424 DEBUG PoolableDataSourceFactory Cleared and passivated DataSource 73 of type 'JPC_STAGIONI_BASE' with hashCode '299163946'
2023-07-28T10:54:42,425 DEBUG PoolableDataSourceFactory Cleared and passivated DataSource 72 of type 'JPC_STAGIONI' with hashCode '1321630524'
2023-07-28T10:54:42,425 DEBUG PoolableDataSourceFactory Cleared and passivated DataSource 1221 of type 'IMA_TIPI_ABBONAMENTO' with hashCode '448922286'
2023-07-28T10:54:42,425 DEBUG SQLTransaction getConnection() looked for transactional connection for dbJpcEP: (connection is null)
2023-07-28T10:54:42,425 DEBUG SQLTransaction getConnection() looked for transactional connection for dbJpcEP: (connection is null)
2023-07-28T10:54:42,427 INFO Compression /Jtk/isomorphic/IDACall: 472 -> 336
In both cases the "ROWID" query lacks the table name before ROWID. Without ANSI join, it also lacks the join where clause.
the SmartClient version in my application is v13.0p_2022-11-16/Enterprise Deployment, but I've just tested v13.0p_2023-07-23/Enterprise Deployment and the result is the same.
Please let me know if you need more details.
Leave a comment: