We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


jdbc executeUpdate with Statement.RETURN_GENERATED_KEYS set throws error 10220 — Vertica Forum

jdbc executeUpdate with Statement.RETURN_GENERATED_KEYS set throws error 10220

Brandon_DewittBrandon_Dewitt
in General Discussion
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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...