Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Get auto generated ID after insert using JDBC

I'm trying to get the auto incremented id of my insert statement using JDBC. But everything i get is the following Error: (10220) Driver not capable.

This is the JDBC call:

preparedStatement = connection.prepareStatement("INSERT INTO ...",Statement.RETURN_GENERATED_KEYS);

Is there a work around to use RETURN_GENERATED_KEYS with auto incremnt?

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.