snowflake-jdbc: Bug related to snowflake changes the column name to capital case and jdbc driver doesn't support it
Hi,
In snowflake if I fire any sql with an alias or without alias the result column names are automatically converted to capital case.
Due to the above capitalization, this method will throw the exception for the column name which is correct from java side
`@Override public int findColumn(String columnLabel) throws SQLException { logger.debug( “public int findColumn(String columnLabel)”);
int columnIndex = resultSetMetaData.getColumnIndex(columnLabel);
if (columnIndex == -1)
{
throw new SQLException("Column not found: " + columnLabel);
}
else
{
return ++columnIndex;
}
} `
About this issue
- Original URL
- State: closed
- Created 6 years ago
- Comments: 18 (6 by maintainers)
@smtakeda @howryu I feel there should be different way need to be provided by the jdbc client to override this.
@smtakeda I will work to provide a sample application code. Because currently i started working on real prod app