add full object spec and resolve problems with exec_insert that required vertica driver to correctly respond with gnerated keys, apparently the jdbc interface does not implement the GET_GENERATED_KEYS interface