Hi all
I was recently surprised to find that PgJDBC doesn't accept Java arrays as parameters to prepared statements.
For example:
PreparedStatement.setObject(1, new String[]{"a"}).
will fail with:
[ERROR] Internal Exception: org.postgresql.util.PSQLException: Can't infer a SQL
type to use for an instance of [Ljava.lang.String;.
Use setObject () with an explicit Types value to specify the type to use.
... which I've verified with the 902 driver in git.
After reading the spec I can't see anywhere the JDBC driver is required to accept native Java arrays, but at least EclipseLink seems to want to do it anyway. Is this reasonable to support? There's one par in the JDBC spec that suggests it might be supposed to work, but I'm not convinced it's more than bad phrasing. In §16.5.4 the JDBC4.2 draft spec reads:
A Java array may be passed as an input parameter by calling the method
PreparedSatement.setObject.
Thoughts? Opinions? Any idea what other DBs drivers do when they get passed a raw Java array to setObject() ?
Source:
http://stackoverflow.com/questions/12042181/how-can-i-set-a-string-parameter-to-a-native-query/12065537#12065537 --
Craig Ringer