Skip navigation links

com.sigmadynamics.server.DataServices.DatabaseProvider
Interface TableReader

All Superinterfaces:

Where

public interface TableReader

extends Where

Interface that allows you to read relational tables.

Since:

1.0

Field Summary

Fields inherited from interface com.sigmadynamics.server.DataServices.DatabaseProvider.Where

AND, OR

Method Summary

void	close() Close the TableReader object.
SDResultSet	read() Read data from a database.
void	setResultSetTypeForwardOnly() Set the result set type to a ResultSet object whose cursor may move only forward.
void	setResultSetTypeScrollInsensitive() Set the result set type to a ResultSet object that is scrollable but generally not sensitive to changes to the data that underlies the ResultSet..
void	setResultSetTypeScrollsensitive() Set the result set type to a ResultSet object that is scrollable and generally sensitive to changes to the data that underlies the ResultSet.

Methods inherited from interface com.sigmadynamics.server.DataServices.DatabaseProvider.Where

initWhere, initWhere, setDateWhereArg, setDateWhereArg, setWhereArg, setWhereArg, setWhereArg, setWhereArg

Method Detail

read

SDResultSet read()
                 throws DatabaseProviderException

Read data from a database.

This method reads data from the database and returns a result set object. The columns to get and the WHERE constraints are specified in either the parameters to getTableReader or through methods of the Where interface.

Returns:

the result set

Throws:

DatabaseProviderException

setResultSetTypeForwardOnly

void setResultSetTypeForwardOnly()

Set the result set type to a ResultSet object whose cursor may move only forward.

setResultSetTypeScrollInsensitive

void setResultSetTypeScrollInsensitive()

Set the result set type to a ResultSet object that is scrollable but generally not sensitive to changes to the data that underlies the ResultSet..

setResultSetTypeScrollsensitive

void setResultSetTypeScrollsensitive()

Set the result set type to a ResultSet object that is scrollable and generally sensitive to changes to the data that underlies the ResultSet.

close

void close()

Close the TableReader object.

It is important to call this method as early as possible in order to free up. resources.

Specified by:

close in interface Where

Skip navigation links