Thank you very much for this hint. It does the trick.
Am 06.12.2022 um 10:55 schrieb Evgenij Ryazanov:
Your code actually constructs something like mstb_etypenum IN (ARRAY[2, 3, 4, 5]) instead of mstb_etypenum IN (2, 3, 4, 5). In SQL statements from JDBC (unlike in JPQL from JPA) you cannot pass parameters in that way. One parameter always creates one value. You can use mstb_etypenum = ANY(?) instead, see *Prepared Statements and IN(...)* section in documentation for an example: https://h2database.com/html/performance.html#database_performance_tuning -- You received this message because you are subscribed to a topic in the Google Groups "H2 Database" group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/h2-database/GRmSbAQzwJk/unsubscribe. To unsubscribe from this group and all its topics, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/3bd02bc0-5625-4bc7-9045-a12caeb7d16fn%40googlegroups.com <https://groups.google.com/d/msgid/h2-database/3bd02bc0-5625-4bc7-9045-a12caeb7d16fn%40googlegroups.com?utm_medium=email&utm_source=footer>.
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/245899a1-54ed-f28d-59d6-e99daddd925c%40gmx.at.
begin:vcard fn:Helmut Leininger n:Leininger;Helmut email;internet:hl...@gmx.at x-mozilla-html:TRUE version:2.1 end:vcard