org.apache.derbyTesting.functionTests.tests.lang

Class RestrictedTableVTI

java.lang.Object

org.apache.derby.vti.VTITemplate

org.apache.derbyTesting.functionTests.tests.lang.RestrictedTableVTI

All Implemented Interfaces:

java.lang.AutoCloseable, java.sql.ResultSet, java.sql.Wrapper, org.apache.derby.vti.RestrictedVTI

public class RestrictedTableVTI
extends org.apache.derby.vti.VTITemplate
implements org.apache.derby.vti.RestrictedVTI

This class contains a table function which can be used to read data from a Derby table.

Field Summary

Fields

Modifier and Type	Field and Description
private java.lang.String[]	_columnNames
private int[]	_columnNumberMap
private java.sql.Connection	_connection
private static java.lang.String	_lastQuery
private java.sql.PreparedStatement	_preparedStatement
private org.apache.derby.vti.Restriction	_restriction
private java.sql.ResultSet	_resultSet
private java.lang.String	_schemaName
private java.lang.String	_tableName

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

Modifier	Constructor and Description
protected	RestrictedTableVTI(java.lang.String schemaName, java.lang.String tableName)

Method Summary

Modifier and Type	Method and Description
void	close()
private static java.lang.String	doubleQuote(java.lang.String text)
java.io.InputStream	getAsciiStream(int i)
java.math.BigDecimal	getBigDecimal(int i)
java.math.BigDecimal	getBigDecimal(int i, int scale)
java.io.InputStream	getBinaryStream(int i)
java.sql.Blob	getBlob(int i)
boolean	getBoolean(int i)
byte	getByte(int i)
byte[]	getBytes(int i)
java.io.Reader	getCharacterStream(int i)
java.sql.Clob	getClob(int i)
java.sql.Date	getDate(int i)
java.sql.Date	getDate(int i, java.util.Calendar cal)
private static java.sql.Connection	getDerbyConnection()
double	getDouble(int i)
float	getFloat(int i)
int	getInt(int i)
static java.lang.String	getLastQuery() Scalar function to retrieve the last query generated by this machinery.
long	getLong(int i)
java.sql.ResultSetMetaData	getMetaData()
java.lang.Object	getObject(int i)
short	getShort(int i)
java.lang.String	getString(int i)
java.sql.Time	getTime(int i)
java.sql.Time	getTime(int i, java.util.Calendar cal)
java.sql.Timestamp	getTimestamp(int i)
java.sql.Timestamp	getTimestamp(int i, java.util.Calendar cal)
void	initScan(java.lang.String[] columnNames, org.apache.derby.vti.Restriction restriction)
boolean	isClosed()
private java.lang.String	makeQuery() Build the query which will be sent to the nested connection.
private int	mapColumnNumber(int derbyNumber) Map a 1-based Derby column number to a 1-based column number in the query.
boolean	next()
protected java.sql.SQLException	notImplemented(java.lang.String arg0)
private static java.sql.PreparedStatement	prepareStatement(java.sql.Connection conn, java.lang.String text)
static RestrictedTableVTI	readTable(java.lang.String schemaName, java.lang.String tableName) Table function to read a table in Derby.
private static java.lang.String	singleQuote(java.lang.String text)
boolean	wasNull()

Methods inherited from class org.apache.derby.vti.VTITemplate

getBigDecimal, getBigDecimal, getBoolean, getByte, getBytes, getDate, getDouble, getFloat, getInt, getLong, getObject, getShort, getString, getTime, getTimestamp

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.sql.ResultSet

getHoldability, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getRowId, getRowId, getSQLXML, getSQLXML, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateObject, updateObject, updateObject, updateObject, updateRowId, updateRowId, updateSQLXML, updateSQLXML

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Field Detail

_schemaName

private java.lang.String _schemaName

_tableName

private java.lang.String _tableName

_connection

private java.sql.Connection _connection

_columnNames

private java.lang.String[] _columnNames

_restriction

private org.apache.derby.vti.Restriction _restriction

_columnNumberMap

private int[] _columnNumberMap

_preparedStatement

private java.sql.PreparedStatement _preparedStatement

_resultSet

private java.sql.ResultSet _resultSet

_lastQuery

private static java.lang.String _lastQuery

Constructor Detail

RestrictedTableVTI

protected RestrictedTableVTI(java.lang.String schemaName,
                             java.lang.String tableName)
                      throws java.lang.Exception

Throws:

java.lang.Exception

Method Detail

readTable

public static RestrictedTableVTI readTable(java.lang.String schemaName,
                                           java.lang.String tableName)
                                    throws java.lang.Exception

Table function to read a table in Derby.

Throws:

java.lang.Exception

getLastQuery

public static java.lang.String getLastQuery()

Scalar function to retrieve the last query generated by this machinery.

close

public void close()
           throws java.sql.SQLException

Specified by:

close in interface java.lang.AutoCloseable

Specified by:

close in interface java.sql.ResultSet

Specified by:

close in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

next

public boolean next()
             throws java.sql.SQLException

Specified by:

next in interface java.sql.ResultSet

Specified by:

next in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

isClosed

public boolean isClosed()

Specified by:

isClosed in interface java.sql.ResultSet

wasNull

public boolean wasNull()
                throws java.sql.SQLException

Specified by:

wasNull in interface java.sql.ResultSet

Overrides:

wasNull in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException

Specified by:

getMetaData in interface java.sql.ResultSet

Overrides:

getMetaData in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getAsciiStream

public java.io.InputStream getAsciiStream(int i)
                                   throws java.sql.SQLException

Specified by:

getAsciiStream in interface java.sql.ResultSet

Overrides:

getAsciiStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getBigDecimal

public java.math.BigDecimal getBigDecimal(int i)
                                   throws java.sql.SQLException

Specified by:

getBigDecimal in interface java.sql.ResultSet

Overrides:

getBigDecimal in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getBigDecimal

public java.math.BigDecimal getBigDecimal(int i,
                                          int scale)
                                   throws java.sql.SQLException

Specified by:

getBigDecimal in interface java.sql.ResultSet

Overrides:

getBigDecimal in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getBinaryStream

public java.io.InputStream getBinaryStream(int i)
                                    throws java.sql.SQLException

Specified by:

getBinaryStream in interface java.sql.ResultSet

Overrides:

getBinaryStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getBlob

public java.sql.Blob getBlob(int i)
                      throws java.sql.SQLException

Specified by:

getBlob in interface java.sql.ResultSet

Overrides:

getBlob in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getBoolean

public boolean getBoolean(int i)
                   throws java.sql.SQLException

Specified by:

getBoolean in interface java.sql.ResultSet

Overrides:

getBoolean in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getByte

public byte getByte(int i)
             throws java.sql.SQLException

Specified by:

getByte in interface java.sql.ResultSet

Overrides:

getByte in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getBytes

public byte[] getBytes(int i)
                throws java.sql.SQLException

Specified by:

getBytes in interface java.sql.ResultSet

Overrides:

getBytes in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getCharacterStream

public java.io.Reader getCharacterStream(int i)
                                  throws java.sql.SQLException

Specified by:

getCharacterStream in interface java.sql.ResultSet

Overrides:

getCharacterStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getClob

public java.sql.Clob getClob(int i)
                      throws java.sql.SQLException

Specified by:

getClob in interface java.sql.ResultSet

Overrides:

getClob in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getDate

public java.sql.Date getDate(int i)
                      throws java.sql.SQLException

Specified by:

getDate in interface java.sql.ResultSet

Overrides:

getDate in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getDate

public java.sql.Date getDate(int i,
                             java.util.Calendar cal)
                      throws java.sql.SQLException

Specified by:

getDate in interface java.sql.ResultSet

Overrides:

getDate in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getDouble

public double getDouble(int i)
                 throws java.sql.SQLException

Specified by:

getDouble in interface java.sql.ResultSet

Overrides:

getDouble in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getFloat

public float getFloat(int i)
               throws java.sql.SQLException

Specified by:

getFloat in interface java.sql.ResultSet

Overrides:

getFloat in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getInt

public int getInt(int i)
           throws java.sql.SQLException

Specified by:

getInt in interface java.sql.ResultSet

Overrides:

getInt in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getLong

public long getLong(int i)
             throws java.sql.SQLException

Specified by:

getLong in interface java.sql.ResultSet

Overrides:

getLong in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getObject

public java.lang.Object getObject(int i)
                           throws java.sql.SQLException

Specified by:

getObject in interface java.sql.ResultSet

Overrides:

getObject in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getShort

public short getShort(int i)
               throws java.sql.SQLException

Specified by:

getShort in interface java.sql.ResultSet

Overrides:

getShort in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getString

public java.lang.String getString(int i)
                           throws java.sql.SQLException

Specified by:

getString in interface java.sql.ResultSet

Overrides:

getString in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getTime

public java.sql.Time getTime(int i)
                      throws java.sql.SQLException

Specified by:

getTime in interface java.sql.ResultSet

Overrides:

getTime in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getTime

public java.sql.Time getTime(int i,
                             java.util.Calendar cal)
                      throws java.sql.SQLException

Specified by:

getTime in interface java.sql.ResultSet

Overrides:

getTime in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getTimestamp

public java.sql.Timestamp getTimestamp(int i)
                                throws java.sql.SQLException

Specified by:

getTimestamp in interface java.sql.ResultSet

Overrides:

getTimestamp in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getTimestamp

public java.sql.Timestamp getTimestamp(int i,
                                       java.util.Calendar cal)
                                throws java.sql.SQLException

Specified by:

getTimestamp in interface java.sql.ResultSet

Overrides:

getTimestamp in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

initScan

public void initScan(java.lang.String[] columnNames,
                     org.apache.derby.vti.Restriction restriction)
              throws java.sql.SQLException

Specified by:

initScan in interface org.apache.derby.vti.RestrictedVTI

Throws:

java.sql.SQLException

getDerbyConnection

private static java.sql.Connection getDerbyConnection()
                                               throws java.sql.SQLException

Throws:

java.sql.SQLException

makeQuery

private java.lang.String makeQuery()

Build the query which will be sent to the nested connection.

doubleQuote

private static java.lang.String doubleQuote(java.lang.String text)

singleQuote

private static java.lang.String singleQuote(java.lang.String text)

prepareStatement

private static java.sql.PreparedStatement prepareStatement(java.sql.Connection conn,
                                                           java.lang.String text)
                                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

mapColumnNumber

private int mapColumnNumber(int derbyNumber)

Map a 1-based Derby column number to a 1-based column number in the query.

notImplemented

protected java.sql.SQLException notImplemented(java.lang.String arg0)