Unfortunately, this does not solve my problem. there is no table or column named BIGINT. The error seems to happen within H2 when it should the Array typeArray as an arry of values to be used in the IN clause. It seems to try to convert the Array to a single BIGINT value for whatever reason (which must fail).
I get the values for mstb_etypenum from an external source, not from a SQL statement. Therefor, I cannot use your approach. Am 06.12.2022 um 09:21 schrieb Noel Grandin:
You can do something like: final Long[] messageIds = ... final String sqlQuery = "SELECT * FROM FROM FOO WHERE FOO.MessageID IN (SELECT ID FROM TABLE(ID BIGINT=?))"; PreparedStatement ps = conn.prepareStatement(sSqlQuery); ps.setObject(1, messageIds );
-- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/4b2cedfe-658c-f074-e98d-5621d30a863d%40gmx.at.
begin:vcard fn:Helmut Leininger n:Leininger;Helmut email;internet:[email protected] x-mozilla-html:TRUE version:2.1 end:vcard
