Skip to main content

Does Vertica JDBC 7.1.2.0 driver support javax.sql.rowset.FilteredRowSet?

  • June 14, 2017
  • 0 replies
  • 8 views

altesa

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!