Re: PreparedStatement does not work with multiple values Insert

[David Wynter]

I should clarify what I mean by 'multiple values' in an Insert PreparedStatement. Like this:

INSERT INTO table (id, col2, col3) values (?, ?, ?), (?, ?, ?)

I first tried with a 38 column table with 20 value sets. Thinking this may exceed some internal limit scaled that back to 4 sets of the 38 column values.

Specific error is S1009 message is "Statement pararmeter 1 not set". When I inspect the ServerPreparedStatement none of the bindings seem to have values (i,e, null). This is despite me checking that the relevant setNull or SetString or set* methods had been called for each of the columns.

David