jdbc executeUpdate with Statement.RETURN_GENERATED_KEYS set throws error 10220

Even if it is required to go through "LAST_INSERT_ID()" to get the value of the identity or auto_increment column the JDBC adapter should allow the RETURN_GENERATED_KEYS flag to be set or provide documentation as to why the flag is not supported. Very difficult to troubleshoot the failure as the only error was "[Vertica][10220] - Driver Not Capable"

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file