Metadata on a prepared statement return upper case column names
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-24-2024 05:31 AM
Hello,
Using the JDBC Driver , when I check the metadata of a prepared statement, the column names names are all uppercase . This does not happen when running a DESCRIBE on the same select.
Any properties to set , or it is a known issue ? or a workaround ?
SELECT `ColumnName` will return COLUMNNAME if I check PreparedStatement.getMetadata()
DESCRIBE SELECT `ColumnName` returns ColumnName
thanks for your help
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-24-2024 09:51 AM
Looks like a bug. Can you try using double quotes? SELECT "ColumnName" instead of backticks?
~
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2024 12:47 AM
Hello, thanks for answering
Sadly, changing the quoting does not change the result. Still uppercase with double quotes

