Options
Vertica JDBC Driver prepared statement
HI All, How to get the autogenerated key of a prepared statement.. IN Mysql we used to define preparedStatement1 = dbConnection.prepareStatement(insertCustomerTableSQL, Statement.RETURN_GENERATED_KEYS); and after executing prepared statement ResultSet generatedKeys1 = preparedStatement1.getGeneratedKeys(); int key; if (generatedKeys1.next()) { key= generatedKeys1.getInt(1); } When i tried same with vertica JDBC driver, it says driver not capable for that statement and fails.. please let me know how do we get the latest generated key?
0