Untitled
unknown
java
3 years ago
6.9 kB
23
Indexable
### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "c" Position: 1442 ### The error may exist in com/iberdrola/ctlges/colaterales/mapper/ice/IceMapper.xml ### The error may involve com.iberdrola.ctlges.colaterales.mapper.ice.IceMapper.getListadoContratosSinAgruparMaturitySpot-Inline ### The error occurred while setting parameters ### SQL: SELECT c.id, c.id_divisa as idDivisa, c.id_tipo_operacion as idTipoOperacion, o.descripcion as descOperacion, c.nombre, c.fecha_inicio as fechaIni, c.fecha_fin as fechaFin, c.cantidad, c.unidad, c.precio, c.id_producto as idProducto, p.nombre as descProducto, p.id_cotiz as codProductoCotiz, p.desc_clearer as descProductoClearer, c.id_matriz as idMatriz, m.descripcion as descMatriz, c.portfolio, c.fecha_firma as fechaFirma, c.precio_clearer as precioClearer, c.precio_mercado as precioMercado, c.existe_producto as existeProducto, c.validado as validado, c.d_mes_anio as dMesAnio, c.fecha_mercado as fechaMercado, c.ote_clearer as oteClearer, c.fecha_consulta as fechaConsulta, contraparte.descripcion as descContraparte, cuenta.descripcion as descCuenta, d.descripcion as descDuracion, tipo as tipo, cierre, market_fee as marketFee, execution_fee as executionFee, clearing_fee as clearingFee, maturity_date as maturityDate, delivery_date as deliveryDate, trade_price as precioTrade, precio_anterior as precioAnterior, variation_margin_clearer as variationMarginClearer, cuenta_clearer as cuentaClearer, valoracion as valoracion, variation_margin as variationMargin, valoracion_clearer as cantidadClearer c.ote_clearer_total as oteClearerTotal, c.variation_margin_clearer_total as variationMarginClearerTotal, c.total_equity_clearer as totalEquityClearer, c.im_requirement_clearer as imRequirementClearer, c.margin_call_clearer as marginCallClearer, c.pnl_clearer as pnlClearer, c.market_fee_clearer as marketFeeClearer, c.execution_fee_clearer as executionFeeClearer, c.clearing_fee_clearer as clearingFeeClearer, c.interest_amount_clearer as interestAmountClearer FROM col_contratos_ice c LEFT JOIN col_tipo_operacion o ON o.id = c.id_tipo_operacion LEFT JOIN col_productos_ice p ON p.id = c.id_producto LEFT JOIN col_matrices m ON m.id = c.id_matriz LEFT JOIN col_cuentas_ice cuenta ON c.id_cuenta = cuenta.id LEFT JOIN col_contrapartes_ice contraparte ON c.id_contraparte = contraparte.id LEFT JOIN col_duracion_contrato d ON c.id_duracion = d.id WHERE c.id_divisa = ? AND TO_CHAR(CAST(c.fecha_consulta AS DATE), 'DD/MM/YYYY') = TO_CHAR(CAST(? AS DATE), 'DD/MM/YYYY') AND c.tipo IN ('MATURITY', 'SPOT') ### Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "c" Position: 1442 ; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near "c" Position: 1442 org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "c" Position: 1442 ### The error may exist in com/iberdrola/ctlges/colaterales/mapper/ice/IceMapper.xml ### The error may involve com.iberdrola.ctlges.colaterales.mapper.ice.IceMapper.getListadoContratosSinAgruparMaturitySpot-Inline ### The error occurred while setting parameters ### SQL: SELECT c.id, c.id_divisa as idDivisa, c.id_tipo_operacion as idTipoOperacion, o.descripcion as descOperacion, c.nombre, c.fecha_inicio as fechaIni, c.fecha_fin as fechaFin, c.cantidad, c.unidad, c.precio, c.id_producto as idProducto, p.nombre as descProducto, p.id_cotiz as codProductoCotiz, p.desc_clearer as descProductoClearer, c.id_matriz as idMatriz, m.descripcion as descMatriz, c.portfolio, c.fecha_firma as fechaFirma, c.precio_clearer as precioClearer, c.precio_mercado as precioMercado, c.existe_producto as existeProducto, c.validado as validado, c.d_mes_anio as dMesAnio, c.fecha_mercado as fechaMercado, c.ote_clearer as oteClearer, c.fecha_consulta as fechaConsulta, contraparte.descripcion as descContraparte, cuenta.descripcion as descCuenta, d.descripcion as descDuracion, tipo as tipo, cierre, market_fee as marketFee, execution_fee as executionFee, clearing_fee as clearingFee, maturity_date as maturityDate, delivery_date as deliveryDate, trade_price as precioTrade, precio_anterior as precioAnterior, variation_margin_clearer as variationMarginClearer, cuenta_clearer as cuentaClearer, valoracion as valoracion, variation_margin as variationMargin, valoracion_clearer as cantidadClearer c.ote_clearer_total as oteClearerTotal, c.variation_margin_clearer_total as variationMarginClearerTotal, c.total_equity_clearer as totalEquityClearer, c.im_requirement_clearer as imRequirementClearer, c.margin_call_clearer as marginCallClearer, c.pnl_clearer as pnlClearer, c.market_fee_clearer as marketFeeClearer, c.execution_fee_clearer as executionFeeClearer, c.clearing_fee_clearer as clearingFeeClearer, c.interest_amount_clearer as interestAmountClearer FROM col_contratos_ice c LEFT JOIN col_tipo_operacion o ON o.id = c.id_tipo_operacion LEFT JOIN col_productos_ice p ON p.id = c.id_producto LEFT JOIN col_matrices m ON m.id = c.id_matriz LEFT JOIN col_cuentas_ice cuenta ON c.id_cuenta = cuenta.id LEFT JOIN col_contrapartes_ice contraparte ON c.id_contraparte = contraparte.id LEFT JOIN col_duracion_contrato d ON c.id_duracion = d.id WHERE c.id_divisa = ? AND TO_CHAR(CAST(c.fecha_consulta AS DATE), 'DD/MM/YYYY') = TO_CHAR(CAST(? AS DATE), 'DD/MM/YYYY') AND c.tipo IN ('MATURITY', 'SPOT') ### Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "c" Position: 1442 ; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near "c" Position: 1442 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:447) at com.sun.proxy.$Proxy43.selectList(Unknown Source)
Editor is loading...