Hi!
Working with queries and filter using in a FilteredRowSet is not a problem, but when I try to insert a new row I get this error :
java.sql.SQLFeatureNotSupportedException: [Vertica]JDBC Driver not capable.
at com.vertica.exceptions.ExceptionConverter.toSQLException(Unknown Source)
at com.vertica.jdbc.common.SConnection.prepareStatement(Unknown Source)
at com.sun.rowset.internal.CachedRowSetWriter.insertNewRow(Unknown Source)
at com.sun.rowset.internal.CachedRowSetWriter.writeData(Unknown Source)
at com.sun.rowset.CachedRowSetImpl.acceptChanges(Unknown Source)
at com.sun.rowset.CachedRowSetImpl.acceptChanges(Unknown Source)
The error shows up at the acceptChanges() statement:
frs.moveToInsertRow();
frs.updateInt("ID", intID);
...
frs.insertRow();
frs.moveToCurrentRow();
frs.acceptChanges(con);
Can anyone please confirm this action is supported by the driver? (7.1.2.0)
Thanks!