matthiasblaesing commented on issue #8505:
URL: https://github.com/apache/netbeans/issues/8505#issuecomment-2895304236
The problem is, that the statement generator has to guess what is the right
thing to do for identifiers. What happens here is:
- NetBeans tries to extract the catalog, schema and table name from the
resultset
- Oracle does not provide that data
- NetBeans now guesses the data from the SQL
- NetBeans then checks if the identifier needs to be quoted and in this case
based on difference between identifier casing and "should" casing, decides to
quote
- Oracle does not like the quoted value and errors out
Quite frankly: Every non-trivial query/update with this will fail on Oracle,
but that should be discussed with oracle. They could fix the metadata for a
resultset. I'll let this stay open, but don't plan to further work on this.
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists