terrymanu commented on issue #28978:
URL:
https://github.com/apache/shardingsphere/issues/28978#issuecomment-3621557323
• Understanding: On ShardingSphere-Proxy (5.4.2-SNAPSHOT from a 2022 dirty
build), inserting multiple rows with an integer[] column via JDBC fails with
“Can not find JDBC type 2003 in PostgreSQL column type”.
Root Cause: 2003 is Types.ARRAY. In that old build, the PostgreSQL
protocol adapter lacks a mapping for Types.ARRAY in
PostgreSQLColumnType.valueOfJDBCType, so binding an array parameter throws the
exception.
Analysis: The mapping table JDBC_TYPE_AND_COLUMN_TYPE_MAP did not include
Types.ARRAY, so prepared statements with array parameters (e.g., integer[])
cannot be handled. A later commit (acaf38e2ebc0, 2024-09-13, #32845 “support
array type prepared param in PostgreSQL”)
adds Types.ARRAY -> TEXT_ARRAY and array parsers. That fix is already in
master and released in tags 5.5.1 and 5.5.2.
Conclusion: This was a known defect in older snapshots; master is fixed.
Please retest with an official release >=5.5.1 or current master instead of the
2022 snapshot. If it still fails, share the exact ShardingSphere version,
proxy/backend DB versions, proxy logs, and
the executed SQL for further diagnosis.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
