Version v12.1p_2021-11-02/Enterprise Deployment (2021-11-02)
Hello, I've got a sql dataSource where in an operation binding I use both groupBy with summaryFunctions and customSQL with groupClause:
it seems to work in the generated select count(*), but when it generates the actual select it seems that the groupClause is ignored, so I get an error.
I wonder if it's actually supported or is a bug?
Here's the log:
Hello, I've got a sql dataSource where in an operation binding I use both groupBy with summaryFunctions and customSQL with groupClause:
Code:
<DataSource xmlns:fmt="WEB-INF/" xmlns="http://www.smartclient.com/schema"
ID="JOFC_V_POSTI_E_RICHIESTE_EV_BO"
tableName="JOFC_V_POSTI_E_RICHIESTE_EV"
schema="DBJOFC"
dbName="DBJOFC"
serverType="sql"
requiresAuthentication="true"
>
<fmt:bundle basename="i18nMessages" encoding="utf-8"/>
<fields>
<field name="ID_CLUB_FK" type="integer" foreignKey="JOFC_CLUB.ID_REC"/>
<field name="ID_EVENTO_FK" type="integer" foreignKey="JPC_LISTINI.ID_REC"/>
<field name="ID_SETTORE_VENDITA_FK" type="integer" foreignKey="JTK_SETTORI_VENDITA.ID_REC"/>
<field name="ID_PARENT_FK" type="integer" includeFrom="JTK_SETTORI_VENDITA.ID_PARENT_FK"/>
<field name="NVL_ID_PARENT" type="integer" customSelectExpression="NVL(JTK_SETTORI_VENDITA.ID_PARENT_FK,JTK_SETTORI_VENDITA.ID_REC)" />
<field name="NOME_FAN_CLUB" type="text" includeFrom="JOFC_CLUB.NOME_FAN_CLUB"/>
<field name="SETTORE_VENDITA" type="text" includeFrom="JTK_SETTORI_VENDITA.DESCRIZIONE"/>
<field name="SETTORE_VENDITA_PARENT" type="text" includeFrom="JTK_SETTORI_VENDITA.SETTORE_VENDITA_PARENT"/>
<field name="SETTORE_VENDITA_COMPLETO" type="text" includeFrom="JTK_SETTORI_VENDITA.SETTORE_VENDITA_COMPLETO"/>
<field name="POSTI_ASSEGNATI" type="integer"/>
<field name="POSTI_RICHIESTI" type="integer"/>
<field name="POSTI_UTILIZZATI" type="integer"/>
<field name="POSTI_IMA_UTILIZZATI" type="integer"/>
<field name="POSTI_DA_ATTRIBUIRE" type="integer"/>
<field name="POSTI_CONFERMATI" type="integer"/>
<field name="TOT_POSTI_IMA_UTILIZZATI" type="integer"/>
</fields>
<operationBindings>
<operationBinding operationType="fetch" requires="true"/>
<operationBinding operationType="fetch"
requires="true"
operationId="fetchRaggruppatoMacroarea"
customFields="NVL_ID_PARENT"
groupBy="ID_CLUB_FK,ID_EVENTO_FK,NVL_ID_PARENT,NOME_FAN_CLUB">
<summaryFunctions>
<POSTI_ASSEGNATI>sum</POSTI_ASSEGNATI>
<POSTI_RICHIESTI>sum</POSTI_RICHIESTI>
<POSTI_UTILIZZATI>sum</POSTI_UTILIZZATI>
<POSTI_IMA_UTILIZZATI>sum</POSTI_IMA_UTILIZZATI>
<POSTI_DA_ATTRIBUIRE>sum</POSTI_DA_ATTRIBUIRE>
<POSTI_CONFERMATI>sum</POSTI_CONFERMATI>
<TOT_POSTI_IMA_UTILIZZATI>sum</TOT_POSTI_IMA_UTILIZZATI>
</summaryFunctions>
<selectClause>
$defaultSelectClause,
DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE, SETT_VEN_PARENT.DESCRIZIONE) AS SETTORE_VENDITA
</selectClause>
<tableClause>
$defaultTableClause
LEFT JOIN DBSALES.JTK_SETTORI_VENDITA ON JOFC_V_POSTI_E_RICHIESTE_EV.ID_SETTORE_VENDITA_FK = JTK_SETTORI_VENDITA.ID_REC
LEFT JOIN DBSALES.JTK_SETTORI_VENDITA SETT_VEN_PARENT ON JTK_SETTORI_VENDITA.ID_PARENT_FK = SETT_VEN_PARENT.ID_REC
</tableClause>
<groupClause>
$defaultGroupClause,
DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE,
SETT_VEN_PARENT.DESCRIZIONE)
</groupClause>
</operationBinding>
<operationBinding operationType="add" requires="false"/>
<operationBinding operationType="update" requires="true"/>
<operationBinding operationType="remove" requires="false"/>
</operationBindings>
</DataSource>
I wonder if it's actually supported or is a bug?
Here's the log:
Code:
2021-11-03T12:29:49,024 DEBUG PoolableDataSourceFactory Activated DataSource 2876 of type 'JOFC_V_POSTI_E_RICHIESTE_EV_BO'
2021-11-03T12:29:49,031 DEBUG DSRequest Caching instance 2876 of DS 'JOFC_V_POSTI_E_RICHIESTE_EV_BO' from DSRequest.getDataSource()
2021-11-03T12:29:49,031 DEBUG DSRequest Caching instance 2876 of DS JOFC_V_POSTI_E_RICHIESTE_EV_BO
2021-11-03T12:29:49,032 DEBUG RPCManager Request #1 (DSRequest) payload: {
criteria:{
operator:"and",
_constructor:"AdvancedCriteria",
criteria:[
{
fieldName:"ID_EVENTO_FK",
operator:"equals",
value:7370908
},
{
fieldName:"ID_EVENTO_FK",
operator:"notNull"
}
]
},
operationConfig:{
dataSource:"JOFC_V_POSTI_E_RICHIESTE_EV_BO",
repo:null,
operationType:"fetch",
textMatchStyle:"exact"
},
startRow:0,
endRow:74,
componentId:"gestioneBigliettiBOListGridRichieste",
appID:"builtinApplication",
operation:"fetchRaggruppatoMacroarea",
oldValues:{
operator:"and",
_constructor:"AdvancedCriteria",
criteria:[
{
fieldName:"ID_EVENTO_FK",
operator:"equals",
value:7370908
},
{
fieldName:"ID_EVENTO_FK",
operator:"notNull"
}
]
}
}
2021-11-03T12:29:49,032 INFO SecureIDACall Performing 1 operation(s) [UA: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.69 Safari/537.36]
2021-11-03T12:29:49,034 INFO DSRequest Executing gestioneBigliettiBOListGridRichieste->JOFC_V_POSTI_E_RICHIESTE_EV_BO.fetch[fetchRaggruppatoMacroarea] rows: 0->74 with
criteria: {
operator:"and",
_constructor:"AdvancedCriteria",
criteria:[
{fieldName:"ID_EVENTO_FK", operator:"equals", value:7370908},
{fieldName:"ID_EVENTO_FK", operator:"notNull"}
]
}
2021-11-03T12:29:49,034 DEBUG PoolableDataSourceFactory Activated DataSource 1544 of type 'JOFC_CLUB'
2021-11-03T12:29:49,034 DEBUG Relation Caching instance of toDS 'JOFC_CLUB' in the DSRequest map
2021-11-03T12:29:49,034 DEBUG BasicDataSource Looking up superDS of DataSource JOFC_CLUB: 'JOFC_CLUB_BASE'
2021-11-03T12:29:49,034 DEBUG PoolableDataSourceFactory Activated DataSource 2878 of type 'JOFC_CLUB_BASE'
2021-11-03T12:29:49,034 DEBUG DeclarativeSecurity Processing security checks for DataSource null, field null
2021-11-03T12:29:49,034 DEBUG DeclarativeSecurity DataSource JOFC_V_POSTI_E_RICHIESTE_EV_BO is not in the pre-checked list, processing...
2021-11-03T12:29:49,035 DEBUG DeclarativeSecurity Processing security checks for DataSource JOFC_CLUB, field ID_REC
2021-11-03T12:29:49,035 DEBUG DeclarativeSecurity DataSource JOFC_CLUB is not in the pre-checked list, processing...
2021-11-03T12:29:49,035 DEBUG DeclarativeSecurity Processing security checks for DataSource JOFC_CLUB, field NOME_FAN_CLUB
2021-11-03T12:29:49,035 DEBUG DeclarativeSecurity DataSource JOFC_CLUB is not in the pre-checked list, processing...
2021-11-03T12:29:49,035 DEBUG AppBase No userTypes defined, allowing anyone access to all operations for this application
2021-11-03T12:29:49,036 DEBUG AppBase No public zero-argument method named '_fetchRaggruppatoMacroarea' found, performing generic datasource operation
2021-11-03T12:29:49,041 INFO SQLDataSource derived query: SELECT
$defaultSelectClause,
DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE, SETT_VEN_PARENT.DESCRIZIONE) AS SETTORE_VENDITA
FROM
$defaultTableClause
LEFT JOIN DBSALES.JTK_SETTORI_VENDITA ON JOFC_V_POSTI_E_RICHIESTE_EV.ID_SETTORE_VENDITA_FK = JTK_SETTORI_VENDITA.ID_REC
LEFT JOIN DBSALES.JTK_SETTORI_VENDITA SETT_VEN_PARENT ON JTK_SETTORI_VENDITA.ID_PARENT_FK = SETT_VEN_PARENT.ID_REC
$defaultAnsiJoinClause WHERE $defaultWhereClause GROUP BY JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK, JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK, NVL(JTK_SETTORI_VENDITA.ID_PARENT_FK,JTK_SETTORI_VENDITA.ID_REC), JOFC_CLUB.NOME_FAN_CLUB
2021-11-03T12:29:49,042 DEBUG SQLDataSource Executing row count query: SELECT COUNT(*) FROM (SELECT
$defaultSelectClause,
DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE, SETT_VEN_PARENT.DESCRIZIONE) AS SETTORE_VENDITA
FROM
$defaultTableClause
LEFT JOIN DBSALES.JTK_SETTORI_VENDITA ON JOFC_V_POSTI_E_RICHIESTE_EV.ID_SETTORE_VENDITA_FK = JTK_SETTORI_VENDITA.ID_REC
LEFT JOIN DBSALES.JTK_SETTORI_VENDITA SETT_VEN_PARENT ON JTK_SETTORI_VENDITA.ID_PARENT_FK = SETT_VEN_PARENT.ID_REC
$defaultAnsiJoinClause WHERE $defaultWhereClause GROUP BY
$defaultGroupClause,
DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE,
SETT_VEN_PARENT.DESCRIZIONE)
) work
2021-11-03T12:29:49,043 DEBUG SQLDataSource Eval'd row count query: SELECT COUNT(*) FROM (SELECT
JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK, JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK, NVL(JTK_SETTORI_VENDITA.ID_PARENT_FK,JTK_SETTORI_VENDITA.ID_REC) AS NVL_ID_PARENT, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_ASSEGNATI) AS POSTI_ASSEGNATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_RICHIESTI) AS POSTI_RICHIESTI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_UTILIZZATI) AS POSTI_UTILIZZATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_IMA_UTILIZZATI) AS POSTI_IMA_UTILIZZATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_DA_ATTRIBUIRE) AS POSTI_DA_ATTRIBUIRE, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_CONFERMATI) AS POSTI_CONFERMATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.TOT_POSTI_IMA_UTILIZZATI) AS TOT_POSTI_IMA_UTILIZZATI, JOFC_CLUB.NOME_FAN_CLUB,
DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE, SETT_VEN_PARENT.DESCRIZIONE) AS SETTORE_VENDITA
FROM
DBJOFC.JOFC_V_POSTI_E_RICHIESTE_EV
LEFT JOIN DBSALES.JTK_SETTORI_VENDITA ON JOFC_V_POSTI_E_RICHIESTE_EV.ID_SETTORE_VENDITA_FK = JTK_SETTORI_VENDITA.ID_REC
LEFT JOIN DBSALES.JTK_SETTORI_VENDITA SETT_VEN_PARENT ON JTK_SETTORI_VENDITA.ID_PARENT_FK = SETT_VEN_PARENT.ID_REC
JOIN DBJOFC.JOFC_CLUB ON JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK = JOFC_CLUB.ID_REC WHERE ((JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK = 7370908 AND JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK IS NOT NULL) AND (JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK IS NOT NULL)) GROUP BY
JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK, JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK, NVL(JTK_SETTORI_VENDITA.ID_PARENT_FK,JTK_SETTORI_VENDITA.ID_REC), JOFC_CLUB.NOME_FAN_CLUB,
DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE,
SETT_VEN_PARENT.DESCRIZIONE)
) work
2021-11-03T12:29:49,065 DEBUG PoolableSQLConnectionFactory makeObject() created an unpooled Connection '1349159953'
2021-11-03T12:29:49,065 DEBUG SQLConnectionManager Borrowed connection '1349159953'
2021-11-03T12:29:49,065 DEBUG SQLTransaction Started new DBJOFC transaction "1349159953"
2021-11-03T12:29:49,065 DEBUG SQLDataSource Setting DSRequest as being part of a transaction
2021-11-03T12:29:49,065 INFO SQLDriver Executing SQL query on 'DBJOFC' using connection '1349159953': SELECT COUNT(*) FROM (SELECT
JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK, JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK, NVL(JTK_SETTORI_VENDITA.ID_PARENT_FK,JTK_SETTORI_VENDITA.ID_REC) AS NVL_ID_PARENT, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_ASSEGNATI) AS POSTI_ASSEGNATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_RICHIESTI) AS POSTI_RICHIESTI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_UTILIZZATI) AS POSTI_UTILIZZATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_IMA_UTILIZZATI) AS POSTI_IMA_UTILIZZATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_DA_ATTRIBUIRE) AS POSTI_DA_ATTRIBUIRE, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_CONFERMATI) AS POSTI_CONFERMATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.TOT_POSTI_IMA_UTILIZZATI) AS TOT_POSTI_IMA_UTILIZZATI, JOFC_CLUB.NOME_FAN_CLUB,
DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE, SETT_VEN_PARENT.DESCRIZIONE) AS SETTORE_VENDITA
FROM
DBJOFC.JOFC_V_POSTI_E_RICHIESTE_EV
LEFT JOIN DBSALES.JTK_SETTORI_VENDITA ON JOFC_V_POSTI_E_RICHIESTE_EV.ID_SETTORE_VENDITA_FK = JTK_SETTORI_VENDITA.ID_REC
LEFT JOIN DBSALES.JTK_SETTORI_VENDITA SETT_VEN_PARENT ON JTK_SETTORI_VENDITA.ID_PARENT_FK = SETT_VEN_PARENT.ID_REC
JOIN DBJOFC.JOFC_CLUB ON JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK = JOFC_CLUB.ID_REC WHERE ((JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK = 7370908 AND JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK IS NOT NULL) AND (JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK IS NOT NULL)) GROUP BY
JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK, JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK, NVL(JTK_SETTORI_VENDITA.ID_PARENT_FK,JTK_SETTORI_VENDITA.ID_REC), JOFC_CLUB.NOME_FAN_CLUB,
DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE,
SETT_VEN_PARENT.DESCRIZIONE)
) work
2021-11-03T12:29:49,126 DEBUG SQLDataSource JDBC driver windowed select rows 0->74, result size 74. Query: SELECT
JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK, JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK, NVL(JTK_SETTORI_VENDITA.ID_PARENT_FK,JTK_SETTORI_VENDITA.ID_REC) AS NVL_ID_PARENT, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_ASSEGNATI) AS POSTI_ASSEGNATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_RICHIESTI) AS POSTI_RICHIESTI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_UTILIZZATI) AS POSTI_UTILIZZATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_IMA_UTILIZZATI) AS POSTI_IMA_UTILIZZATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_DA_ATTRIBUIRE) AS POSTI_DA_ATTRIBUIRE, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.POSTI_CONFERMATI) AS POSTI_CONFERMATI, SUM(JOFC_V_POSTI_E_RICHIESTE_EV.TOT_POSTI_IMA_UTILIZZATI) AS TOT_POSTI_IMA_UTILIZZATI, JOFC_CLUB.NOME_FAN_CLUB,
DECODE(JTK_SETTORI_VENDITA.ID_PARENT_FK, NULL, JTK_SETTORI_VENDITA.DESCRIZIONE, SETT_VEN_PARENT.DESCRIZIONE) AS SETTORE_VENDITA
FROM
DBJOFC.JOFC_V_POSTI_E_RICHIESTE_EV
LEFT JOIN DBSALES.JTK_SETTORI_VENDITA ON JOFC_V_POSTI_E_RICHIESTE_EV.ID_SETTORE_VENDITA_FK = JTK_SETTORI_VENDITA.ID_REC
LEFT JOIN DBSALES.JTK_SETTORI_VENDITA SETT_VEN_PARENT ON JTK_SETTORI_VENDITA.ID_PARENT_FK = SETT_VEN_PARENT.ID_REC
JOIN DBJOFC.JOFC_CLUB ON JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK = JOFC_CLUB.ID_REC WHERE ((JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK = 7370908 AND JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK IS NOT NULL) AND (JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK IS NOT NULL)) GROUP BY JOFC_V_POSTI_E_RICHIESTE_EV.ID_CLUB_FK, JOFC_V_POSTI_E_RICHIESTE_EV.ID_EVENTO_FK, NVL(JTK_SETTORI_VENDITA.ID_PARENT_FK,JTK_SETTORI_VENDITA.ID_REC), JOFC_CLUB.NOME_FAN_CLUB
2021-11-03T12:29:49,126 DEBUG SQLDataSource Setting DSRequest as being part of a transaction
2021-11-03T12:29:49,168 DEBUG DSRequest freeOnExecute is false for request of type fetch on DataSource JOFC_V_POSTI_E_RICHIESTE_EV_BO - not freeing resources!
03-Nov-2021 12:29:49.166 SEVERE [https-jsse-nio-8443-exec-2] oracle.jdbc.driver.T4CTTIoer.processError 46F3B210 Throwing SQLException: ORA-00979: not a GROUP BY expression
979
2021-11-03T12:29:49,168 WARN RequestContext dsRequest.execute() failed:
java.sql.SQLSyntaxErrorException: ORA-00979: not a GROUP BY expression
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:459) ~[ojdbc6_g.jar:11.2.0.3.0]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:400) ~[ojdbc6_g.jar:11.2.0.3.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:999) ~[ojdbc6_g.jar:11.2.0.3.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:539) ~[ojdbc6_g.jar:11.2.0.3.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:235) ~[ojdbc6_g.jar:11.2.0.3.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:543) ~[ojdbc6_g.jar:11.2.0.3.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:199) ~[ojdbc6_g.jar:11.2.0.3.0]
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:1216) ~[ojdbc6_g.jar:11.2.0.3.0]
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1500) ~[ojdbc6_g.jar:11.2.0.3.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1717) ~[ojdbc6_g.jar:11.2.0.3.0]
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:8872) ~[ojdbc6_g.jar:11.2.0.3.0]
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:9090) ~[ojdbc6_g.jar:11.2.0.3.0]
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:2020) ~[ojdbc6_g.jar:11.2.0.3.0]
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:1709) ~[ojdbc6_g.jar:11.2.0.3.0]
at sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_281]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_281]
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc.jar:?]
at com.sun.proxy.$Proxy81.executeQuery(Unknown Source) ~[?:?]
at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDataSource.java:2770) ~[isomorphic_sql.jar:?]
at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1817) ~[isomorphic_sql.jar:?]
at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:441) ~[isomorphic_sql.jar:?]
at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:386) ~[isomorphic_sql.jar:?]
at com.isomorphic.datasource.DataSource.execute(DataSource.java:2499) ~[isomorphic_core_rpc.jar:?]
at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:658) ~[isomorphic_core_rpc.jar:?]
at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:555) ~[isomorphic_core_rpc.jar:?]
at com.isomorphic.application.AppBase.execute(AppBase.java:498) ~[isomorphic_core_rpc.jar:?]
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:3071) ~[isomorphic_core_rpc.jar:?]
at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:226) [isomorphic_core_rpc.jar:?]
at com.juve.jofc.SecureIDACall.handleDSRequest(SecureIDACall.java:95) [classes/:?]
at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:183) [isomorphic_core_rpc.jar:?]
at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:148) [isomorphic_core_rpc.jar:?]
at com.isomorphic.servlet.IDACall._processRequest(IDACall.java:119) [isomorphic_core_rpc.jar:?]
at com.isomorphic.servlet.IDACall.doPost(IDACall.java:79) [isomorphic_core_rpc.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.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 net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:200) [javamelody-1.58.0.jar:?]
at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:178) [javamelody-1.58.0.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.isomorphic.servlet.CompressionFilter._doFilter(CompressionFilter.java:263) [isomorphic_core_rpc.jar:?]
at com.isomorphic.servlet.BaseFilter.doFilter(BaseFilter.java:91) [isomorphic_core_rpc.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.jofc.auth.FrameOriginFilter.doFilter(FrameOriginFilter.java:35) [classes/:?]
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.Log4jSessionFilter.doFilter(Log4jSessionFilter.java:85) [classes/:?]
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:320) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.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.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:97) [cas-client-core-3.5.1.jar:3.5.1]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:124) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.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.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.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.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.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.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:157) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178) [spring-security-web-5.1.5.RELEASE.jar:5.1.5.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.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: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.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_281]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_281]
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_281]
Comment