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: notifications-unsubscr...@netbeans.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscr...@netbeans.apache.org
For additional commands, e-mail: notifications-h...@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists

Reply via email to