I am using H2 2.1.214 and facing this problem:
part of SQL Select statement:
...
+ "where events.mstb_recno in (select mstb_recno from events
where events.mstb_edate >= ? and events.mstb_edate <= ?) and "
+ "mstb_etypenum in (?) and "
...
this statement can be prepared without errors. To supply the values for
mstb_etypenum I have:
ArrayList<Integer> types ...
java.sql.Array typeArray =
pstmtGetEventsByCityMultipleTypes.getConnection()
.createArrayOf("INT", types.toArray());
pstmtGetEventsByCityMultipleTypes.setArray(4, typeArray);
...
Executing this query leads to the following error:
org.h2.jdbc.JdbcSQLDataException: Datenumwandlungsfehler beim Umwandeln von
"ARRAY to BIGINT"
Data conversion error converting "ARRAY to BIGINT"; SQL statement:
select distinct on (events.mstb_recno) events.*, tagtypes.mstb_etypenum as
tt_etypenum, tagtypes.mstb_etypename as tt_etypename,
tagtypes.mstb_properties as tt_properties, tagtypes.mstb_tsentence as
tt_sentence, tagtypes.mstb_prinrole as tt_principalrole,
tagtypes.mstb_witrole as tt_witnessrole, tagtypes.mstb_witdisp as
tt_witnessdisp, tagtypes.mstb_gedcom_tag as tt_gedcomtag,
tagtypes.mstb_etypenum as tt_etypenum, tagtypes.mstb_tsentence as
tt_tsentence, witnesses.mstb_primary as wt_primary, witnesses.mstb_role as
wt_role, witnesses.mstb_eper as wt_eper from events inner join placedict on
placepv.mstb_uid = placedict.mstb_uid and placepv.mstb_type = ? inner join
placepv on events.mstb_placenum = placepv.mstb_recno inner join tagtypes on
events.mstb_etype = tagtypes.mstb_etypenum inner join witnesses on
events.mstb_recno = witnesses.mstb_gnum where events.mstb_recno in (select
mstb_recno from events where events.mstb_edate >= ? and events.mstb_edate
<= ?) and mstb_etypenum in (?) and placedict.mstb_value = ? order by
events.mstb_srtdate [22018-214]
Question:
Does H2 support arrays with PreparedStatement ? If yes, what is the correct
handling?
Note:
excuting the basic SQL with
...
where mstb_etypenum in (2,3,4,5)
...
runs ok.
Thanks and regards
--
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/5292e1e4-361a-43b2-81ae-5ccf6e4e4c3an%40googlegroups.com.
