org.firebirdsql.jdbc

Class FBRowUpdater

java.lang.Object

org.firebirdsql.jdbc.FBRowUpdater

public class FBRowUpdater
extends java.lang.Object

Class responsible for modifying updatable result sets. A result set is updatable if and only if:

• It is a subset of a single table and includes all columns from the table's primary key (in other words, includes all best row identifiers) or RDB$DB_KEY column (in this case tables without primary key can be updated too).
• If base table columns not included in the result set allow NULL values, result set allows inserting rows into it.
• The result set's SELECT statement does not contain subqueries, a DISTINCT predicate, a HAVING clause, aggregate functions, joined tables, user-defined functions, or stored procedures.

If the result set definition does not meet these conditions, it is considered read-only.

Author:

Roman Rokytskyy

Constructor Summary

Constructors

Constructor and Description
FBRowUpdater(AbstractConnection connection, XSQLVAR[] xsqlvars, Synchronizable syncProvider, boolean cached, FBObjectListener.ResultSetListener rsListener)

Method Summary

Modifier and Type	Method and Description
void	cancelRowUpdates()
void	close()
void	deleteRow()
org.firebirdsql.jdbc.field.FBField	getField(int fieldPosition)
byte[][]	getInsertRow()
byte[][]	getNewRow()
byte[][]	getOldRow()
void	insertRow()
void	moveToCurrentRow()
void	moveToInsertRow()
void	refreshRow()
boolean	rowDeleted()
boolean	rowInserted()
boolean	rowUpdated()
void	setRow(byte[][] row)
void	updateRow()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

FBRowUpdater

public FBRowUpdater(AbstractConnection connection,
                    XSQLVAR[] xsqlvars,
                    Synchronizable syncProvider,
                    boolean cached,
                    FBObjectListener.ResultSetListener rsListener)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

Method Detail

close

public void close()
           throws java.sql.SQLException

Throws:

java.sql.SQLException

setRow

public void setRow(byte[][] row)

cancelRowUpdates

public void cancelRowUpdates()

getField

public org.firebirdsql.jdbc.field.FBField getField(int fieldPosition)

updateRow

public void updateRow()
               throws java.sql.SQLException

Throws:

java.sql.SQLException

deleteRow

public void deleteRow()
               throws java.sql.SQLException

Throws:

java.sql.SQLException

insertRow

public void insertRow()
               throws java.sql.SQLException

Throws:

java.sql.SQLException

refreshRow

public void refreshRow()
                throws java.sql.SQLException

Throws:

java.sql.SQLException

rowInserted

public boolean rowInserted()
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

rowDeleted

public boolean rowDeleted()
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

rowUpdated

public boolean rowUpdated()
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getNewRow

public byte[][] getNewRow()

getInsertRow

public byte[][] getInsertRow()

getOldRow

public byte[][] getOldRow()

moveToInsertRow

public void moveToInsertRow()
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

moveToCurrentRow

public void moveToCurrentRow()
                      throws java.sql.SQLException

Throws:

java.sql.SQLException