org.mariadb.jdbc.internal.com.read.dao

Class Results

java.lang.Object

org.mariadb.jdbc.internal.com.read.dao.Results

public class Results
extends Object

Constructor Summary

Constructors

Constructor and Description
Results() Single Text query
Results(MariaDbStatement statement, int autoIncrement) Constructor for specific statement.
Results(MariaDbStatement statement, int fetchSize, boolean batch, int expectedSize, boolean binaryFormat, int resultSetScrollType, int autoIncrement) Default constructor.

Method Summary

Modifier and Type	Method and Description
void	addResultSet(SelectResultSet resultSet, boolean moreResultAvailable) Add resultSet to results.
void	addStats(long updateCount, long insertId, boolean moreResultAvailable) Add execution statistics.
void	addStatsError(boolean moreResultAvailable) Indicate that result is an Error, to set appropriate results.
void	close()
Results	commandEnd() Indicate that command / batch is finished, so set current resultSet if needed.
SelectResultSet	getCallableResultSet()
CmdInformation	getCmdInformation()
int	getCurrentStatNumber()
int	getExpectedSize()
int	getFetchSize()
ResultSet	getGeneratedKeys(Protocol protocol) Send a resultSet that contain auto generated keys. 2 differences : Batch will list all insert ids.
int	getMaxFieldSize()
boolean	getMoreResults(int current, Protocol protocol) Position to next resultSet.
SelectResultSet	getResultSet()
int	getResultSetScrollType()
MariaDbStatement	getStatement()
boolean	isBatch()
boolean	isBinaryFormat()
void	loadFully(boolean skip, Protocol protocol) Load fully current results.
void	removeFetchSize()
void	reset(int fetchSize, boolean batch, int expectedSize, boolean binaryFormat, int resultSetScrollType) Reset.
void	setAutoIncrement(int autoIncrement)
protected void	setCmdInformation(CmdInformation cmdInformation)

Methods inherited from class java.lang.Object

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

Constructor Detail

Results

public Results()

Single Text query. /! use internally, because autoincrement value is not right for multi-queries !/

Results

public Results(MariaDbStatement statement,
               int autoIncrement)

Constructor for specific statement.

Parameters:

statement - current Statement.

autoIncrement - connection auto-increment

Results

public Results(MariaDbStatement statement,
               int fetchSize,
               boolean batch,
               int expectedSize,
               boolean binaryFormat,
               int resultSetScrollType,
               int autoIncrement)

Default constructor.

Parameters:

statement - current statement

fetchSize - fetch size

batch - select result possible

expectedSize - expected size

binaryFormat - use binary protocol

resultSetScrollType - one of the following ResultSet constants: ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE

autoIncrement - Connection auto-increment value

Method Detail

reset

public void reset(int fetchSize,
                  boolean batch,
                  int expectedSize,
                  boolean binaryFormat,
                  int resultSetScrollType)

Reset.

Parameters:

fetchSize - fetch size

batch - select result possible

expectedSize - expected size

binaryFormat - use binary protocol

resultSetScrollType - one of the following ResultSet constants: ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE

addStats

public void addStats(long updateCount,
                     long insertId,
                     boolean moreResultAvailable)

Add execution statistics.

Parameters:

updateCount - number of updated rows

insertId - primary key

moreResultAvailable - is there additional packet

addStatsError

public void addStatsError(boolean moreResultAvailable)

Indicate that result is an Error, to set appropriate results.

Parameters:

moreResultAvailable - indicate if other results (ResultSet or updateCount) are available.

getCurrentStatNumber

public int getCurrentStatNumber()

addResultSet

public void addResultSet(SelectResultSet resultSet,
                         boolean moreResultAvailable)

Add resultSet to results.

Parameters:

resultSet - new resultSet.

moreResultAvailable - indicate if other results (ResultSet or updateCount) are available.

getCmdInformation

public CmdInformation getCmdInformation()

commandEnd

public Results commandEnd()

Indicate that command / batch is finished, so set current resultSet if needed.

Returns:

current results

getResultSet

public SelectResultSet getResultSet()

getCallableResultSet

public SelectResultSet getCallableResultSet()

loadFully

public void loadFully(boolean skip,
                      Protocol protocol)
               throws SQLException

Load fully current results. Lock must be set before using this method

Parameters:

skip - must result be available afterwhile

protocol - current protocol

Throws:

SQLException - if any connection error occur

getMoreResults

public boolean getMoreResults(int current,
                              Protocol protocol)
                       throws SQLException

Position to next resultSet.

Parameters:

current - one of the following Statement constants indicating what should happen to current ResultSet objects obtained using the method getResultSet: Statement.CLOSE_CURRENT_RESULT, Statement.KEEP_CURRENT_RESULT, or Statement.CLOSE_ALL_RESULTS

protocol - current protocol

Returns:

true if other resultSet exists.

Throws:

SQLException - if any connection error occur.

getFetchSize

public int getFetchSize()

getStatement

public MariaDbStatement getStatement()

isBatch

public boolean isBatch()

setCmdInformation

protected void setCmdInformation(CmdInformation cmdInformation)

getExpectedSize

public int getExpectedSize()

isBinaryFormat

public boolean isBinaryFormat()

removeFetchSize

public void removeFetchSize()

getResultSetScrollType

public int getResultSetScrollType()

getGeneratedKeys

public ResultSet getGeneratedKeys(Protocol protocol)

Send a resultSet that contain auto generated keys. 2 differences :

1. Batch will list all insert ids.
2. in case of multi-query is set, resultSet will be per query.

example "INSERT INTO myTable values ('a'),('b');INSERT INTO myTable values ('c'),('d'),('e')" will have a resultSet of 2 values, and when Statement.getMoreResults() will be called, a Statement.getGeneratedKeys will return a resultset with 3 ids.

Parameters:

protocol - current protocol

Returns:

a ResultSet containing generated ids.

close

public void close()

getMaxFieldSize

public int getMaxFieldSize()

setAutoIncrement

public void setAutoIncrement(int autoIncrement)