Untitled
unknown
java
3 years ago
6.9 kB
24
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...