You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/08/02 15:52:25 UTC

[GitHub] [shardingsphere] sandynz commented on issue #5432: 4.1.0 Use PgSql +Jpa Error accessing table metadata

sandynz commented on issue #5432:
URL: https://github.com/apache/shardingsphere/issues/5432#issuecomment-667690901


   Hi, I'd like try to solve it.
   
   From masankin's description, part of the sql is : SELECT NULL AS TABLE_CAT, looks the problem is caused by column name is uppercased, I reproduced this problem with H2 database, sql: SELECT user_id AS USER_ID FROM t_order LIMIT 1 .
   
   After reading MySQL/PostgreSQL/H2 implementation of java.sql.ResultSet.findColumn(columnLabel), they are different and every one is complicated than DatabaseMetaDataResultSet's implementation, columnLabelIndexMap is not enough to implement findColumn.
   
   A possible solution : Delegate DatabaseMetaDataResultSet.findColumn to underlying resultSet.findColumn .
   


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org