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 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/3bd02bc0-5625-4bc7-9045-a12caeb7d16fn%40googlegroups.com.
