java.lang.Object
- org.mariadb.jdbc.client.result.Result
- - org.mariadb.jdbc.client.result.CompleteResult
  - - org.mariadb.jdbc.client.result.UpdatableResult

All Implemented Interfaces:

java.lang.AutoCloseable, java.sql.ResultSet, java.sql.Wrapper, Completion, ServerMessage
```
public class UpdatableResult
extends CompleteResult
```
Updatable result implementation

Field Summary

Fields
Modifier and Type	Field	Description
`private boolean`	`canInsert`
`private boolean`	`canUpdate`
`private java.lang.String`	`changeError`
`private java.lang.String`	`database`
`private boolean`	`isAutoincrementPk`
`private ParameterList`	`parameters`
`private java.lang.String[]`	`primaryCols`
`private int`	`savedRowPointer`
`private java.lang.String`	`sqlStateError`
`private int`	`state`
`private static int`	`STATE_INSERT`
`private static int`	`STATE_INSERTED`
`private static int`	`STATE_STANDARD`
`private static int`	`STATE_UPDATE`
`private static int`	`STATE_UPDATED`
`private java.lang.String`	`table`

Fields inherited from class org.mariadb.jdbc.client.result.CompleteResult
BEFORE_FIRST_POS

Fields inherited from class org.mariadb.jdbc.client.result.Result
closed, context, data, dataSize, exceptionFactory, fieldIndex, loaded, maxRows, metadataList, NULL_LENGTH, outputParameter, reader, resultSetType, rowBuf, rowDecoder, rowPointer, statement, traceEnable

Fields inherited from interface java.sql.ResultSet
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE

Constructor Summary

Constructors
Constructor	Description
`UpdatableResult(Statement stmt, boolean binaryProtocol, long maxRows, ColumnDecoder[] metadataList, Reader reader, Context context, int resultSetType, boolean closeOnCompletion, boolean traceEnable)`	Constructor

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`boolean`	`absolute(int row)`
`void`	`afterLast()`
`void`	`beforeFirst()`
`private java.lang.String`	`buildInsertQuery()`	Build insert query
`void`	`cancelRowUpdates()`
`private void`	`cannotUpdateInsertRow(java.lang.String reason)`
`private void`	`checkIfUpdatable()`
`private void`	`checkUpdatable(int position)`
`void`	`deleteRow()`
`boolean`	`first()`
`int`	`getConcurrency()`
`void`	`insertRow()`
`boolean`	`last()`
`void`	`moveToCurrentRow()`
`void`	`moveToInsertRow()`
`boolean`	`next()`	Position resultset to next row
`private java.sql.PreparedStatement`	`prepareRefreshStmt()`
`boolean`	`previous()`
`private byte[]`	`refreshRawData()`
`void`	`refreshRow()`
`private java.lang.String`	`refreshStmt()`
`boolean`	`relative(int rows)`
`private void`	`resetToRowPointer()`
`boolean`	`rowDeleted()`
`boolean`	`rowInserted()`
`boolean`	`rowUpdated()`
`void`	`updateArray(int columnIndex, java.sql.Array x)`
`void`	`updateAsciiStream(int columnIndex, java.io.InputStream x)`
`void`	`updateAsciiStream(int columnIndex, java.io.InputStream x, int length)`
`void`	`updateAsciiStream(int columnIndex, java.io.InputStream x, long length)`
`void`	`updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x)`
`void`	`updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, int length)`
`void`	`updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, long length)`
`void`	`updateBigDecimal(int columnIndex, java.math.BigDecimal x)`
`void`	`updateBigDecimal(java.lang.String columnLabel, java.math.BigDecimal x)`
`void`	`updateBinaryStream(int columnIndex, java.io.InputStream x)`
`void`	`updateBinaryStream(int columnIndex, java.io.InputStream x, int length)`
`void`	`updateBinaryStream(int columnIndex, java.io.InputStream x, long length)`
`void`	`updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x)`
`void`	`updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, int length)`
`void`	`updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length)`
`void`	`updateBlob(int columnIndex, java.io.InputStream x)`
`void`	`updateBlob(int columnIndex, java.io.InputStream x, long length)`
`void`	`updateBlob(int columnIndex, java.sql.Blob x)`
`void`	`updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream)`
`void`	`updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream, long length)`
`void`	`updateBlob(java.lang.String columnLabel, java.sql.Blob x)`
`void`	`updateBoolean(int columnIndex, boolean x)`
`void`	`updateBoolean(java.lang.String columnLabel, boolean x)`
`void`	`updateByte(int columnIndex, byte x)`
`void`	`updateByte(java.lang.String columnLabel, byte x)`
`void`	`updateBytes(int columnIndex, byte[] x)`
`void`	`updateBytes(java.lang.String columnLabel, byte[] x)`
`void`	`updateCharacterStream(int columnIndex, java.io.Reader x)`
`void`	`updateCharacterStream(int columnIndex, java.io.Reader x, int length)`
`void`	`updateCharacterStream(int columnIndex, java.io.Reader x, long length)`
`void`	`updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader)`
`void`	`updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, int length)`
`void`	`updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length)`
`void`	`updateClob(int columnIndex, java.io.Reader x)`
`void`	`updateClob(int columnIndex, java.io.Reader x, long length)`
`void`	`updateClob(int columnIndex, java.sql.Clob x)`
`void`	`updateClob(java.lang.String columnLabel, java.io.Reader reader)`
`void`	`updateClob(java.lang.String columnLabel, java.io.Reader reader, long length)`
`void`	`updateClob(java.lang.String columnLabel, java.sql.Clob x)`
`void`	`updateDate(int columnIndex, java.sql.Date x)`
`void`	`updateDate(java.lang.String columnLabel, java.sql.Date x)`
`void`	`updateDouble(int columnIndex, double x)`
`void`	`updateDouble(java.lang.String columnLabel, double x)`
`void`	`updateFloat(int columnIndex, float x)`
`void`	`updateFloat(java.lang.String columnLabel, float x)`
`void`	`updateInt(int columnIndex, int x)`
`void`	`updateInt(java.lang.String columnLabel, int x)`
`private void`	`updateInternalObject(int columnIndex, java.lang.Object x, java.lang.Long scaleOrLength)`
`void`	`updateLong(int columnIndex, long x)`
`void`	`updateLong(java.lang.String columnLabel, long x)`
`void`	`updateNCharacterStream(int columnIndex, java.io.Reader x)`
`void`	`updateNCharacterStream(int columnIndex, java.io.Reader x, long length)`
`void`	`updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader)`
`void`	`updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length)`
`void`	`updateNClob(int columnIndex, java.io.Reader reader)`
`void`	`updateNClob(int columnIndex, java.io.Reader reader, long length)`
`void`	`updateNClob(int columnIndex, java.sql.NClob nClob)`
`void`	`updateNClob(java.lang.String columnLabel, java.io.Reader reader)`
`void`	`updateNClob(java.lang.String columnLabel, java.io.Reader reader, long length)`
`void`	`updateNClob(java.lang.String columnLabel, java.sql.NClob nClob)`
`void`	`updateNString(int columnIndex, java.lang.String nString)`
`void`	`updateNString(java.lang.String columnLabel, java.lang.String nString)`
`void`	`updateNull(int columnIndex)`
`void`	`updateNull(java.lang.String columnLabel)`
`void`	`updateObject(int columnIndex, java.lang.Object x)`
`void`	`updateObject(int columnIndex, java.lang.Object x, int scaleOrLength)`
`void`	`updateObject(int columnIndex, java.lang.Object x, java.sql.SQLType targetSqlType)`
`void`	`updateObject(int columnIndex, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength)`
`void`	`updateObject(java.lang.String columnLabel, java.lang.Object x)`
`void`	`updateObject(java.lang.String columnLabel, java.lang.Object x, int scaleOrLength)`
`void`	`updateObject(java.lang.String columnLabel, java.lang.Object x, java.sql.SQLType targetSqlType)`
`void`	`updateObject(java.lang.String columnLabel, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength)`
`private java.lang.String`	`updateQuery()`
`void`	`updateRow()`
`void`	`updateShort(int columnIndex, short x)`
`void`	`updateShort(java.lang.String columnLabel, short x)`
`void`	`updateString(int columnIndex, java.lang.String x)`
`void`	`updateString(java.lang.String columnLabel, java.lang.String x)`
`void`	`updateTime(int columnIndex, java.sql.Time x)`
`void`	`updateTime(java.lang.String columnLabel, java.sql.Time x)`
`void`	`updateTimestamp(int columnIndex, java.sql.Timestamp x)`
`void`	`updateTimestamp(java.lang.String columnLabel, java.sql.Timestamp x)`

Methods inherited from class org.mariadb.jdbc.client.result.CompleteResult
closeFromStmtClose, createResultSet, createResultSet, fetchRemaining, getFetchSize, getRow, isAfterLast, isBulkResult, isFirst, isLast, newResultsetWithUseAliasAsName, setBulkResult, setFetchSize, streaming

Methods inherited from class org.mariadb.jdbc.client.result.Result
abort, addRowData, checkClose, checkNotForwardOnly, clearWarnings, close, closeOnCompletion, findColumn, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBigInteger, getBigInteger, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getCurrentRowData, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFloat, getFloat, getHoldability, getInt, getInt, getLong, getLong, getMetaData, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, isBeforeFirst, isClosed, isOutputParameter, isWrapperFor, loaded, readNext, setFetchDirection, setNullRowBuf, setRow, setStatement, skipRemaining, unwrap, updateArray, updateRef, updateRef, updateRowData, updateRowId, updateRowId, updateSQLXML, updateSQLXML, wasNull

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

STATE_STANDARD
```
private static final int STATE_STANDARD
```
See Also:

Constant Field Values

STATE_UPDATE
```
private static final int STATE_UPDATE
```
See Also:

Constant Field Values

STATE_UPDATED
```
private static final int STATE_UPDATED
```
See Also:

Constant Field Values

STATE_INSERT
```
private static final int STATE_INSERT
```
See Also:

Constant Field Values

STATE_INSERTED
```
private static final int STATE_INSERTED
```
See Also:

Constant Field Values

database
```
private java.lang.String database
```

table
```
private java.lang.String table
```

canInsert
```
private boolean canInsert
```

canUpdate
```
private boolean canUpdate
```

sqlStateError
```
private java.lang.String sqlStateError
```

isAutoincrementPk
```
private boolean isAutoincrementPk
```

savedRowPointer
```
private int savedRowPointer
```

changeError
```
private java.lang.String changeError
```

state
```
private int state
```

parameters
```
private ParameterList parameters
```

primaryCols
```
private java.lang.String[] primaryCols
```

Constructor Detail

UpdatableResult

public UpdatableResult(Statement stmt,
                       boolean binaryProtocol,
                       long maxRows,
                       ColumnDecoder[] metadataList,
                       Reader reader,
                       Context context,
                       int resultSetType,
                       boolean closeOnCompletion,
                       boolean traceEnable)
                throws java.io.IOException,
                       java.sql.SQLException

Constructor

Parameters:: stmt - statement that initiate this result; binaryProtocol - are rows binary encoded; maxRows - maximum rows; metadataList - columns metadata; reader - packet reader; context - connection context; resultSetType - result-set type; closeOnCompletion - close on completion; traceEnable - must network exchanges be logged
Throws:: java.io.IOException - if any socket error occurs; java.sql.SQLException - for other kind of error

Method Detail

checkIfUpdatable

private void checkIfUpdatable()
                       throws java.sql.SQLException

Throws:: java.sql.SQLException

cannotUpdateInsertRow

private void cannotUpdateInsertRow(java.lang.String reason)

checkUpdatable

private void checkUpdatable(int position)
                     throws java.sql.SQLException

Throws:: java.sql.SQLException

rowUpdated
```
public boolean rowUpdated()
```
Specified by:

rowUpdated in interface java.sql.ResultSet

Overrides:

rowUpdated in class Result

rowInserted
```
public boolean rowInserted()
```
Specified by:

rowInserted in interface java.sql.ResultSet

Overrides:

rowInserted in class Result

rowDeleted
```
public boolean rowDeleted()
```
Specified by:

rowDeleted in interface java.sql.ResultSet

Overrides:

rowDeleted in class Result

updateNull
```
public void updateNull(int columnIndex)
                throws java.sql.SQLException
```
Specified by:

updateNull in interface java.sql.ResultSet

Overrides:

updateNull in class Result

Throws:

java.sql.SQLException

updateBoolean

public void updateBoolean(int columnIndex,
                          boolean x)
                   throws java.sql.SQLException

Specified by:: updateBoolean in interface java.sql.ResultSet
Overrides:: updateBoolean in class Result
Throws:: java.sql.SQLException

updateByte
```
public void updateByte(int columnIndex,
                       byte x)
                throws java.sql.SQLException
```
Specified by:

updateByte in interface java.sql.ResultSet

Overrides:

updateByte in class Result

Throws:

java.sql.SQLException

updateShort
```
public void updateShort(int columnIndex,
                        short x)
                 throws java.sql.SQLException
```
Specified by:

updateShort in interface java.sql.ResultSet

Overrides:

updateShort in class Result

Throws:

java.sql.SQLException

updateInt
```
public void updateInt(int columnIndex,
                      int x)
               throws java.sql.SQLException
```
Specified by:

updateInt in interface java.sql.ResultSet

Overrides:

updateInt in class Result

Throws:

java.sql.SQLException

updateLong
```
public void updateLong(int columnIndex,
                       long x)
                throws java.sql.SQLException
```
Specified by:

updateLong in interface java.sql.ResultSet

Overrides:

updateLong in class Result

Throws:

java.sql.SQLException

updateFloat
```
public void updateFloat(int columnIndex,
                        float x)
                 throws java.sql.SQLException
```
Specified by:

updateFloat in interface java.sql.ResultSet

Overrides:

updateFloat in class Result

Throws:

java.sql.SQLException

updateDouble
```
public void updateDouble(int columnIndex,
                         double x)
                  throws java.sql.SQLException
```
Specified by:

updateDouble in interface java.sql.ResultSet

Overrides:

updateDouble in class Result

Throws:

java.sql.SQLException

updateBigDecimal

public void updateBigDecimal(int columnIndex,
                             java.math.BigDecimal x)
                      throws java.sql.SQLException

Specified by:: updateBigDecimal in interface java.sql.ResultSet
Overrides:: updateBigDecimal in class Result
Throws:: java.sql.SQLException

updateString

public void updateString(int columnIndex,
                         java.lang.String x)
                  throws java.sql.SQLException

Specified by:: updateString in interface java.sql.ResultSet
Overrides:: updateString in class Result
Throws:: java.sql.SQLException

updateBytes
```
public void updateBytes(int columnIndex,
                        byte[] x)
                 throws java.sql.SQLException
```
Specified by:

updateBytes in interface java.sql.ResultSet

Overrides:

updateBytes in class Result

Throws:

java.sql.SQLException

updateDate

public void updateDate(int columnIndex,
                       java.sql.Date x)
                throws java.sql.SQLException

Specified by:: updateDate in interface java.sql.ResultSet
Overrides:: updateDate in class Result
Throws:: java.sql.SQLException

updateTime

public void updateTime(int columnIndex,
                       java.sql.Time x)
                throws java.sql.SQLException

Specified by:: updateTime in interface java.sql.ResultSet
Overrides:: updateTime in class Result
Throws:: java.sql.SQLException

updateArray

public void updateArray(int columnIndex,
                        java.sql.Array x)
                 throws java.sql.SQLException

Specified by:: updateArray in interface java.sql.ResultSet
Overrides:: updateArray in class Result
Throws:: java.sql.SQLException

updateTimestamp

public void updateTimestamp(int columnIndex,
                            java.sql.Timestamp x)
                     throws java.sql.SQLException

Specified by:: updateTimestamp in interface java.sql.ResultSet
Overrides:: updateTimestamp in class Result
Throws:: java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              java.io.InputStream x,
                              int length)
                       throws java.sql.SQLException

Specified by:: updateAsciiStream in interface java.sql.ResultSet
Overrides:: updateAsciiStream in class Result
Throws:: java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               java.io.InputStream x,
                               int length)
                        throws java.sql.SQLException

Specified by:: updateBinaryStream in interface java.sql.ResultSet
Overrides:: updateBinaryStream in class Result
Throws:: java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  java.io.Reader x,
                                  int length)
                           throws java.sql.SQLException

Specified by:: updateCharacterStream in interface java.sql.ResultSet
Overrides:: updateCharacterStream in class Result
Throws:: java.sql.SQLException

updateObject

public void updateObject(int columnIndex,
                         java.lang.Object x,
                         int scaleOrLength)
                  throws java.sql.SQLException

Specified by:: updateObject in interface java.sql.ResultSet
Overrides:: updateObject in class Result
Throws:: java.sql.SQLException

updateObject

public void updateObject(int columnIndex,
                         java.lang.Object x)
                  throws java.sql.SQLException

Specified by:: updateObject in interface java.sql.ResultSet
Overrides:: updateObject in class Result
Throws:: java.sql.SQLException

updateNull
```
public void updateNull(java.lang.String columnLabel)
                throws java.sql.SQLException
```
Specified by:

updateNull in interface java.sql.ResultSet

Overrides:

updateNull in class Result

Throws:

java.sql.SQLException

updateBoolean

public void updateBoolean(java.lang.String columnLabel,
                          boolean x)
                   throws java.sql.SQLException

Specified by:: updateBoolean in interface java.sql.ResultSet
Overrides:: updateBoolean in class Result
Throws:: java.sql.SQLException

updateByte

public void updateByte(java.lang.String columnLabel,
                       byte x)
                throws java.sql.SQLException

Specified by:: updateByte in interface java.sql.ResultSet
Overrides:: updateByte in class Result
Throws:: java.sql.SQLException

updateShort

public void updateShort(java.lang.String columnLabel,
                        short x)
                 throws java.sql.SQLException

Specified by:: updateShort in interface java.sql.ResultSet
Overrides:: updateShort in class Result
Throws:: java.sql.SQLException

updateInt

public void updateInt(java.lang.String columnLabel,
                      int x)
               throws java.sql.SQLException

Specified by:: updateInt in interface java.sql.ResultSet
Overrides:: updateInt in class Result
Throws:: java.sql.SQLException

updateLong

public void updateLong(java.lang.String columnLabel,
                       long x)
                throws java.sql.SQLException

Specified by:: updateLong in interface java.sql.ResultSet
Overrides:: updateLong in class Result
Throws:: java.sql.SQLException

updateFloat

public void updateFloat(java.lang.String columnLabel,
                        float x)
                 throws java.sql.SQLException

Specified by:: updateFloat in interface java.sql.ResultSet
Overrides:: updateFloat in class Result
Throws:: java.sql.SQLException

updateDouble

public void updateDouble(java.lang.String columnLabel,
                         double x)
                  throws java.sql.SQLException

Specified by:: updateDouble in interface java.sql.ResultSet
Overrides:: updateDouble in class Result
Throws:: java.sql.SQLException

updateBigDecimal

public void updateBigDecimal(java.lang.String columnLabel,
                             java.math.BigDecimal x)
                      throws java.sql.SQLException

Specified by:: updateBigDecimal in interface java.sql.ResultSet
Overrides:: updateBigDecimal in class Result
Throws:: java.sql.SQLException

updateString

public void updateString(java.lang.String columnLabel,
                         java.lang.String x)
                  throws java.sql.SQLException

Specified by:: updateString in interface java.sql.ResultSet
Overrides:: updateString in class Result
Throws:: java.sql.SQLException

updateBytes

public void updateBytes(java.lang.String columnLabel,
                        byte[] x)
                 throws java.sql.SQLException

Specified by:: updateBytes in interface java.sql.ResultSet
Overrides:: updateBytes in class Result
Throws:: java.sql.SQLException

updateDate

public void updateDate(java.lang.String columnLabel,
                       java.sql.Date x)
                throws java.sql.SQLException

Specified by:: updateDate in interface java.sql.ResultSet
Overrides:: updateDate in class Result
Throws:: java.sql.SQLException

updateTime

public void updateTime(java.lang.String columnLabel,
                       java.sql.Time x)
                throws java.sql.SQLException

Specified by:: updateTime in interface java.sql.ResultSet
Overrides:: updateTime in class Result
Throws:: java.sql.SQLException

updateTimestamp

public void updateTimestamp(java.lang.String columnLabel,
                            java.sql.Timestamp x)
                     throws java.sql.SQLException

Specified by:: updateTimestamp in interface java.sql.ResultSet
Overrides:: updateTimestamp in class Result
Throws:: java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(java.lang.String columnLabel,
                              java.io.InputStream x,
                              int length)
                       throws java.sql.SQLException

Specified by:: updateAsciiStream in interface java.sql.ResultSet
Overrides:: updateAsciiStream in class Result
Throws:: java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(java.lang.String columnLabel,
                               java.io.InputStream x,
                               int length)
                        throws java.sql.SQLException

Specified by:: updateBinaryStream in interface java.sql.ResultSet
Overrides:: updateBinaryStream in class Result
Throws:: java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(java.lang.String columnLabel,
                                  java.io.Reader reader,
                                  int length)
                           throws java.sql.SQLException

Specified by:: updateCharacterStream in interface java.sql.ResultSet
Overrides:: updateCharacterStream in class Result
Throws:: java.sql.SQLException

updateObject

public void updateObject(java.lang.String columnLabel,
                         java.lang.Object x,
                         int scaleOrLength)
                  throws java.sql.SQLException

Specified by:: updateObject in interface java.sql.ResultSet
Overrides:: updateObject in class Result
Throws:: java.sql.SQLException

updateObject

public void updateObject(java.lang.String columnLabel,
                         java.lang.Object x)
                  throws java.sql.SQLException

Specified by:: updateObject in interface java.sql.ResultSet
Overrides:: updateObject in class Result
Throws:: java.sql.SQLException

insertRow
```
public void insertRow()
               throws java.sql.SQLException
```
Specified by:

insertRow in interface java.sql.ResultSet

Overrides:

insertRow in class Result

Throws:

java.sql.SQLException

buildInsertQuery

private java.lang.String buildInsertQuery()
                                   throws java.sql.SQLException

Build insert query

Returns:: insert sql
Throws:: java.sql.SQLException - exception

refreshStmt

private java.lang.String refreshStmt()

prepareRefreshStmt

private java.sql.PreparedStatement prepareRefreshStmt()
                                               throws java.sql.SQLException

Throws:: java.sql.SQLException

refreshRawData

private byte[] refreshRawData()
                       throws java.sql.SQLException

Throws:: java.sql.SQLException

updateQuery

private java.lang.String updateQuery()

updateRow
```
public void updateRow()
               throws java.sql.SQLException
```
Specified by:

updateRow in interface java.sql.ResultSet

Overrides:

updateRow in class Result

Throws:

java.sql.SQLException

deleteRow
```
public void deleteRow()
               throws java.sql.SQLException
```
Specified by:

deleteRow in interface java.sql.ResultSet

Overrides:

deleteRow in class Result

Throws:

java.sql.SQLException

refreshRow
```
public void refreshRow()
                throws java.sql.SQLException
```
Specified by:

refreshRow in interface java.sql.ResultSet

Overrides:

refreshRow in class Result

Throws:

java.sql.SQLException

cancelRowUpdates
```
public void cancelRowUpdates()
```
Specified by:

cancelRowUpdates in interface java.sql.ResultSet

Overrides:

cancelRowUpdates in class Result

moveToInsertRow
```
public void moveToInsertRow()
                     throws java.sql.SQLException
```
Specified by:

moveToInsertRow in interface java.sql.ResultSet

Overrides:

moveToInsertRow in class Result

Throws:

java.sql.SQLException

moveToCurrentRow
```
public void moveToCurrentRow()
```
Specified by:

moveToCurrentRow in interface java.sql.ResultSet

Overrides:

moveToCurrentRow in class Result

updateBlob

public void updateBlob(int columnIndex,
                       java.sql.Blob x)
                throws java.sql.SQLException

Specified by:: updateBlob in interface java.sql.ResultSet
Overrides:: updateBlob in class Result
Throws:: java.sql.SQLException

updateBlob

public void updateBlob(java.lang.String columnLabel,
                       java.sql.Blob x)
                throws java.sql.SQLException

Specified by:: updateBlob in interface java.sql.ResultSet
Overrides:: updateBlob in class Result
Throws:: java.sql.SQLException

updateClob

public void updateClob(int columnIndex,
                       java.sql.Clob x)
                throws java.sql.SQLException

Specified by:: updateClob in interface java.sql.ResultSet
Overrides:: updateClob in class Result
Throws:: java.sql.SQLException

updateClob

public void updateClob(java.lang.String columnLabel,
                       java.sql.Clob x)
                throws java.sql.SQLException

Specified by:: updateClob in interface java.sql.ResultSet
Overrides:: updateClob in class Result
Throws:: java.sql.SQLException

updateNString

public void updateNString(int columnIndex,
                          java.lang.String nString)
                   throws java.sql.SQLException

Specified by:: updateNString in interface java.sql.ResultSet
Overrides:: updateNString in class Result
Throws:: java.sql.SQLException

updateNString

public void updateNString(java.lang.String columnLabel,
                          java.lang.String nString)
                   throws java.sql.SQLException

Specified by:: updateNString in interface java.sql.ResultSet
Overrides:: updateNString in class Result
Throws:: java.sql.SQLException

updateNClob

public void updateNClob(int columnIndex,
                        java.sql.NClob nClob)
                 throws java.sql.SQLException

Specified by:: updateNClob in interface java.sql.ResultSet
Overrides:: updateNClob in class Result
Throws:: java.sql.SQLException

updateNClob

public void updateNClob(java.lang.String columnLabel,
                        java.sql.NClob nClob)
                 throws java.sql.SQLException

Specified by:: updateNClob in interface java.sql.ResultSet
Overrides:: updateNClob in class Result
Throws:: java.sql.SQLException

updateNCharacterStream

public void updateNCharacterStream(int columnIndex,
                                   java.io.Reader x,
                                   long length)
                            throws java.sql.SQLException

Specified by:: updateNCharacterStream in interface java.sql.ResultSet
Overrides:: updateNCharacterStream in class Result
Throws:: java.sql.SQLException

updateNCharacterStream

public void updateNCharacterStream(java.lang.String columnLabel,
                                   java.io.Reader reader,
                                   long length)
                            throws java.sql.SQLException

Specified by:: updateNCharacterStream in interface java.sql.ResultSet
Overrides:: updateNCharacterStream in class Result
Throws:: java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              java.io.InputStream x,
                              long length)
                       throws java.sql.SQLException

Specified by:: updateAsciiStream in interface java.sql.ResultSet
Overrides:: updateAsciiStream in class Result
Throws:: java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               java.io.InputStream x,
                               long length)
                        throws java.sql.SQLException

Specified by:: updateBinaryStream in interface java.sql.ResultSet
Overrides:: updateBinaryStream in class Result
Throws:: java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  java.io.Reader x,
                                  long length)
                           throws java.sql.SQLException

Specified by:: updateCharacterStream in interface java.sql.ResultSet
Overrides:: updateCharacterStream in class Result
Throws:: java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(java.lang.String columnLabel,
                              java.io.InputStream x,
                              long length)
                       throws java.sql.SQLException

Specified by:: updateAsciiStream in interface java.sql.ResultSet
Overrides:: updateAsciiStream in class Result
Throws:: java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(java.lang.String columnLabel,
                               java.io.InputStream x,
                               long length)
                        throws java.sql.SQLException

Specified by:: updateBinaryStream in interface java.sql.ResultSet
Overrides:: updateBinaryStream in class Result
Throws:: java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(java.lang.String columnLabel,
                                  java.io.Reader reader,
                                  long length)
                           throws java.sql.SQLException

Specified by:: updateCharacterStream in interface java.sql.ResultSet
Overrides:: updateCharacterStream in class Result
Throws:: java.sql.SQLException

updateBlob

public void updateBlob(int columnIndex,
                       java.io.InputStream x,
                       long length)
                throws java.sql.SQLException

Specified by:: updateBlob in interface java.sql.ResultSet
Overrides:: updateBlob in class Result
Throws:: java.sql.SQLException

updateBlob

public void updateBlob(java.lang.String columnLabel,
                       java.io.InputStream inputStream,
                       long length)
                throws java.sql.SQLException

Specified by:: updateBlob in interface java.sql.ResultSet
Overrides:: updateBlob in class Result
Throws:: java.sql.SQLException

updateClob

public void updateClob(int columnIndex,
                       java.io.Reader x,
                       long length)
                throws java.sql.SQLException

Specified by:: updateClob in interface java.sql.ResultSet
Overrides:: updateClob in class Result
Throws:: java.sql.SQLException

updateClob

public void updateClob(java.lang.String columnLabel,
                       java.io.Reader reader,
                       long length)
                throws java.sql.SQLException

Specified by:: updateClob in interface java.sql.ResultSet
Overrides:: updateClob in class Result
Throws:: java.sql.SQLException

updateNClob

public void updateNClob(int columnIndex,
                        java.io.Reader reader,
                        long length)
                 throws java.sql.SQLException

Specified by:: updateNClob in interface java.sql.ResultSet
Overrides:: updateNClob in class Result
Throws:: java.sql.SQLException

updateNClob

public void updateNClob(java.lang.String columnLabel,
                        java.io.Reader reader,
                        long length)
                 throws java.sql.SQLException

Specified by:: updateNClob in interface java.sql.ResultSet
Overrides:: updateNClob in class Result
Throws:: java.sql.SQLException

updateNCharacterStream

public void updateNCharacterStream(int columnIndex,
                                   java.io.Reader x)
                            throws java.sql.SQLException

Specified by:: updateNCharacterStream in interface java.sql.ResultSet
Overrides:: updateNCharacterStream in class Result
Throws:: java.sql.SQLException

updateNCharacterStream

public void updateNCharacterStream(java.lang.String columnLabel,
                                   java.io.Reader reader)
                            throws java.sql.SQLException

Specified by:: updateNCharacterStream in interface java.sql.ResultSet
Overrides:: updateNCharacterStream in class Result
Throws:: java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              java.io.InputStream x)
                       throws java.sql.SQLException

Specified by:: updateAsciiStream in interface java.sql.ResultSet
Overrides:: updateAsciiStream in class Result
Throws:: java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               java.io.InputStream x)
                        throws java.sql.SQLException

Specified by:: updateBinaryStream in interface java.sql.ResultSet
Overrides:: updateBinaryStream in class Result
Throws:: java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  java.io.Reader x)
                           throws java.sql.SQLException

Specified by:: updateCharacterStream in interface java.sql.ResultSet
Overrides:: updateCharacterStream in class Result
Throws:: java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(java.lang.String columnLabel,
                              java.io.InputStream x)
                       throws java.sql.SQLException

Specified by:: updateAsciiStream in interface java.sql.ResultSet
Overrides:: updateAsciiStream in class Result
Throws:: java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(java.lang.String columnLabel,
                               java.io.InputStream x)
                        throws java.sql.SQLException

Specified by:: updateBinaryStream in interface java.sql.ResultSet
Overrides:: updateBinaryStream in class Result
Throws:: java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(java.lang.String columnLabel,
                                  java.io.Reader reader)
                           throws java.sql.SQLException

Specified by:: updateCharacterStream in interface java.sql.ResultSet
Overrides:: updateCharacterStream in class Result
Throws:: java.sql.SQLException

updateBlob

public void updateBlob(int columnIndex,
                       java.io.InputStream x)
                throws java.sql.SQLException

Specified by:: updateBlob in interface java.sql.ResultSet
Overrides:: updateBlob in class Result
Throws:: java.sql.SQLException

updateBlob

public void updateBlob(java.lang.String columnLabel,
                       java.io.InputStream inputStream)
                throws java.sql.SQLException

Specified by:: updateBlob in interface java.sql.ResultSet
Overrides:: updateBlob in class Result
Throws:: java.sql.SQLException

updateClob

public void updateClob(int columnIndex,
                       java.io.Reader x)
                throws java.sql.SQLException

Specified by:: updateClob in interface java.sql.ResultSet
Overrides:: updateClob in class Result
Throws:: java.sql.SQLException

updateClob

public void updateClob(java.lang.String columnLabel,
                       java.io.Reader reader)
                throws java.sql.SQLException

Specified by:: updateClob in interface java.sql.ResultSet
Overrides:: updateClob in class Result
Throws:: java.sql.SQLException

updateNClob

public void updateNClob(int columnIndex,
                        java.io.Reader reader)
                 throws java.sql.SQLException

Specified by:: updateNClob in interface java.sql.ResultSet
Overrides:: updateNClob in class Result
Throws:: java.sql.SQLException

updateNClob

public void updateNClob(java.lang.String columnLabel,
                        java.io.Reader reader)
                 throws java.sql.SQLException

Specified by:: updateNClob in interface java.sql.ResultSet
Overrides:: updateNClob in class Result
Throws:: java.sql.SQLException

updateObject

public void updateObject(int columnIndex,
                         java.lang.Object x,
                         java.sql.SQLType targetSqlType,
                         int scaleOrLength)
                  throws java.sql.SQLException

Specified by:: updateObject in interface java.sql.ResultSet
Overrides:: updateObject in class Result
Throws:: java.sql.SQLException

updateInternalObject

private void updateInternalObject(int columnIndex,
                                  java.lang.Object x,
                                  java.lang.Long scaleOrLength)
                           throws java.sql.SQLException

Throws:: java.sql.SQLException

updateObject

public void updateObject(java.lang.String columnLabel,
                         java.lang.Object x,
                         java.sql.SQLType targetSqlType,
                         int scaleOrLength)
                  throws java.sql.SQLException

Specified by:: updateObject in interface java.sql.ResultSet
Overrides:: updateObject in class Result
Throws:: java.sql.SQLException

updateObject

public void updateObject(int columnIndex,
                         java.lang.Object x,
                         java.sql.SQLType targetSqlType)
                  throws java.sql.SQLException

Specified by:: updateObject in interface java.sql.ResultSet
Overrides:: updateObject in class Result
Throws:: java.sql.SQLException

updateObject

public void updateObject(java.lang.String columnLabel,
                         java.lang.Object x,
                         java.sql.SQLType targetSqlType)
                  throws java.sql.SQLException

Specified by:: updateObject in interface java.sql.ResultSet
Overrides:: updateObject in class Result
Throws:: java.sql.SQLException

getConcurrency
```
public int getConcurrency()
```
Specified by:

getConcurrency in interface java.sql.ResultSet

Overrides:

getConcurrency in class Result

resetToRowPointer
```
private void resetToRowPointer()
```

beforeFirst
```
public void beforeFirst()
                 throws java.sql.SQLException
```
Specified by:

beforeFirst in interface java.sql.ResultSet

Overrides:

beforeFirst in class CompleteResult

Throws:

java.sql.SQLException

first
```
public boolean first()
              throws java.sql.SQLException
```
Specified by:

first in interface java.sql.ResultSet

Overrides:

first in class CompleteResult

Throws:

java.sql.SQLException

last
```
public boolean last()
             throws java.sql.SQLException
```
Specified by:

last in interface java.sql.ResultSet

Overrides:

last in class CompleteResult

Throws:

java.sql.SQLException

afterLast
```
public void afterLast()
               throws java.sql.SQLException
```
Specified by:

afterLast in interface java.sql.ResultSet

Overrides:

afterLast in class CompleteResult

Throws:

java.sql.SQLException

absolute
```
public boolean absolute(int row)
                 throws java.sql.SQLException
```
Specified by:

absolute in interface java.sql.ResultSet

Overrides:

absolute in class CompleteResult

Throws:

java.sql.SQLException

relative
```
public boolean relative(int rows)
                 throws java.sql.SQLException
```
Specified by:

relative in interface java.sql.ResultSet

Overrides:

relative in class CompleteResult

Throws:

java.sql.SQLException

next
```
public boolean next()
             throws java.sql.SQLException
```
Description copied from class: Result

Position resultset to next row

Specified by:

next in interface java.sql.ResultSet

Overrides:

next in class CompleteResult

Returns:

true if next row exists

Throws:

java.sql.SQLException - if any error occurs

previous
```
public boolean previous()
                 throws java.sql.SQLException
```
Specified by:

previous in interface java.sql.ResultSet

Overrides:

previous in class CompleteResult

Throws:

java.sql.SQLException

Class UpdatableResult

Field Summary

Fields inherited from class org.mariadb.jdbc.client.result.CompleteResult

Fields inherited from class org.mariadb.jdbc.client.result.Result

Fields inherited from interface java.sql.ResultSet

Constructor Summary

Method Summary

Methods inherited from class org.mariadb.jdbc.client.result.CompleteResult

Methods inherited from class org.mariadb.jdbc.client.result.Result

Methods inherited from class java.lang.Object

Field Detail

STATE_STANDARD

STATE_UPDATE

STATE_UPDATED

STATE_INSERT

STATE_INSERTED

database

table

canInsert

canUpdate

sqlStateError

isAutoincrementPk

savedRowPointer

changeError

state

parameters

primaryCols

Constructor Detail

UpdatableResult

Method Detail

checkIfUpdatable

cannotUpdateInsertRow

checkUpdatable

rowUpdated

rowInserted

rowDeleted

updateNull

updateBoolean

updateByte

updateShort

updateInt

updateLong

updateFloat

updateDouble

updateBigDecimal

updateString

updateBytes

updateDate

updateTime

updateArray

updateTimestamp

updateAsciiStream

updateBinaryStream

updateCharacterStream

updateObject

updateObject

updateNull

updateBoolean

updateByte

updateShort

updateInt

updateLong

updateFloat

updateDouble

updateBigDecimal

updateString

updateBytes

updateDate

updateTime

updateTimestamp

updateAsciiStream

updateBinaryStream

updateCharacterStream

updateObject

updateObject

insertRow

buildInsertQuery

refreshStmt

prepareRefreshStmt

refreshRawData