Legacy issue: baztian/jaydebeapi#156
Tier: P2 — new-db-support
Request to insert ARRAY types via executemany. The legacy error is setObject() having no matching overload for Python lists. Our codebase uses add_pyarrow_batches_to_statement() for parameter binding through Arrow, with a fallback path that currently raises NotSupportedError for list parameters.
Current Behavior
Passing a Python list as a parameter raises:
NotSupportedError: ARRAY type parameter binding is not supported.
Expected Behavior
Python list parameters should be converted to java.sql.Array objects and bound via PreparedStatement.setArray().
Legacy issue: baztian/jaydebeapi#156
Tier: P2 — new-db-support
Request to insert ARRAY types via executemany. The legacy error is setObject() having no matching overload for Python lists. Our codebase uses add_pyarrow_batches_to_statement() for parameter binding through Arrow, with a fallback path that currently raises NotSupportedError for list parameters.
Current Behavior
Passing a Python list as a parameter raises:
Expected Behavior
Python list parameters should be converted to
java.sql.Arrayobjects and bound viaPreparedStatement.setArray().