Hi,
In our next attempt to move our code from ACF to Lucee, we have stumbled
over another obstacle. We’re making use of PostgreSQLs array data type in a
couple of places, namely arrays of text[] and arrays of int[]. ACF didn’t
have any problems dealing with these as ordinary arrays, so we could for
example do this
In Lucee this fails with the error message
“this method is no longer supported, use instead get(int,Object)”.
When I dump the query, local.qryGetIntArray.myintegerarray has the type “Native
Array (java.lang.Integer[])”.
The quick and dirty hack around this is to ArrayMerge the returned value
with an empty array like so:
Apparently this copies the values from the native Java int[]-Array into the
shape that Lucee can deal with.
But this is fugly as hell, so I wonder if there was something I was missing
here? I’m very hesitant to refactor our code to incorporate a hack such as
this, it would be preferrable if Lucee would deal with Native Arrays
seamlessly, as does ACF.
It’s not an issue of the JDBC driver - I did try both the 8.3.0.jdbc4
driver that ships with Lucee and brewed my own PostgreSQL extension with
the more current 9.4.1209.jdbc41 driver, it doesn’t make a
difference. Lucee version is 5.0.0.252.
Should this be filed as a bug?
Kind regards
Markus