You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@camel.apache.org by "ldrozdo (via GitHub)" <gi...@apache.org> on 2023/04/06 12:19:14 UTC
[GitHub] [camel-quarkus] ldrozdo opened a new issue, #4750: camel-quarkus-jdbc: using named parameters fails for postgresql db kind
ldrozdo opened a new issue, #4750:
URL: https://github.com/apache/camel-quarkus/issues/4750
Using [named parameters](https://camel.apache.org/components/3.20.x/jdbc-component.html#_using_named_parameters) in jdbc integration tests fails for **postgresql** database kind. Other database kinds are ok.
There are two tests which are failing:
1. [Named parameters test](https://github.com/apache/camel-quarkus/blob/main/integration-tests/jdbc/src/test/java/org/apache/camel/quarkus/component/jdbc/CamelJdbcTest.java#L119)
2. [Named parameters map test](https://github.com/apache/camel-quarkus/blob/main/integration-tests/jdbc/src/test/java/org/apache/camel/quarkus/component/jdbc/CamelJdbcTest.java#L129)
[This query](https://github.com/apache/camel-quarkus/blob/main/integration-tests/jdbc/src/main/java/org/apache/camel/quarkus/component/jdbc/CamelResource.java#L153) is used in the tests.
The error message:
`Caused by: [CIRCULAR REFERENCE: org.postgresql.util.PSQLException: ERROR: operator does not exist: integer < character varying
Hint: No operator matches the given name and argument types. You might need to add explicit type casts.`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@camel.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [camel-quarkus] ldrozdo commented on issue #4750: camel-quarkus-jdbc: using named parameters fails for postgresql db kind
Posted by "ldrozdo (via GitHub)" <gi...@apache.org>.
ldrozdo commented on issue #4750:
URL: https://github.com/apache/camel-quarkus/issues/4750#issuecomment-1499109902
@jamesnetherton that actually works, thanks! I'm closing this and I will rewrite the tests.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@camel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [camel-quarkus] jamesnetherton commented on issue #4750: camel-quarkus-jdbc: using named parameters fails for postgresql db kind
Posted by "jamesnetherton (via GitHub)" <gi...@apache.org>.
jamesnetherton commented on issue #4750:
URL: https://github.com/apache/camel-quarkus/issues/4750#issuecomment-1498980443
Just a guess, does it work if you pass `3` as an `int` instead of `String`?
Otherwise I guess you have to do type [casting](https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-cast/).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@camel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [camel-quarkus] ldrozdo closed issue #4750: camel-quarkus-jdbc: using named parameters fails for postgresql db kind
Posted by "ldrozdo (via GitHub)" <gi...@apache.org>.
ldrozdo closed issue #4750: camel-quarkus-jdbc: using named parameters fails for postgresql db kind
URL: https://github.com/apache/camel-quarkus/issues/4750
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@camel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org