StringColumnTableFunction (Sample Table Functions)

Oracle

Overview

Package

Class

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

sun.javadb.vti.core
Class StringColumnTableFunction

       
java.lang.Object
   
      
       
sun.javadb.vti.core.TemplateTableFunction
       
      
       
sun.javadb.vti.core.StringColumnTableFunction

All Implemented Interfaces:: ResultSet, Wrapper

Direct Known Subclasses:: EnumeratorTableFunction, FlatFileTableFunction, PropertiesTableFunction

public abstract class  
          
StringColumnTableFunction<dt>extends  
          
TemplateTableFunction</dl>

This is an abstract Table Function which assumes that all columns are strings and which coerces the strings to reasonable values for various getXXX() methods. Subclasses must implement the following public ResultSet methods:

next( )
close()

and the following protected methods introduced by this class:

getRawColumn( int columnNumber )

Nested Class Summary
`class`	`StringColumnTableFunction.SimpleBlob` A crude Blob implementation.
`class`	`StringColumnTableFunction.SimpleClob` A crude Clob implementation.

Field Summary
`private String[]`	`_columnNames`
`private boolean`	`_lastColumnWasNull`

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
`StringColumnTableFunction ( String[] columnNames)` Build a StringColumnTableFunction with the given column names

Method Summary
`private int`	`castLong (long value)`
`private void`	`checkNull ( String columnValue)` Set the wasNull flag based on whether this column value turned out to be null.
`int`	`findColumn ( String columnName)`
`InputStream`	`getAsciiStream (int columnIndex)`
`BigDecimal`	`getBigDecimal (int columnIndex)`
`InputStream`	`getBinaryStream (int columnIndex)`
`Blob`	`getBlob (int columnIndex)`
`boolean`	`getBoolean (int columnIndex)`
`byte`	`getByte (int columnIndex)`
`byte[]`	`getBytes (int columnIndex)`
`Clob`	`getClob (int columnIndex)`
`protected int`	`getColumnCount ()` Return the number of columns in this table function.
`protected String[]`	`getColumnNames ()` Return the names of the columns.
`Date`	`getDate (int columnIndex)`
`double`	`getDouble (int columnIndex)`
`private InputStream`	`getEncodedStream ( String columnValue, String encoding)` Turn a string into an appropriately encoded ByteArrayInputStream.
`float`	`getFloat (int columnIndex)`
`int`	`getInt (int columnIndex)`
`long`	`getLong (int columnIndex)`
`protected abstract String`	`getRawColumn (int columnNumber)` Get the string value of the column in the current row identified by the 1-based columnNumber.
`short`	`getShort (int columnIndex)`
`String`	`getString (int columnIndex)`
`Time`	`getTime (int columnIndex)`
`Timestamp`	`getTimestamp (int columnIndex)`
`private long`	`parseDateTime ( String columnValue)` Translate a date/time expression into the corresponding long number of milliseconds.
`boolean`	`wasNull ()`
`protected SQLException`	`wrap ( String message, Throwable t)` Wrap an exception in a SQLException.
`protected SQLException`	`wrap ( Throwable t)` Wrap an exception in a SQLException.

Methods inherited from class sun.javadb.vti.core. TemplateTableFunction
absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, deleteRow, first, getArray, getArray, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBlob, getBoolean, getByte, getBytes, getCharacterStream, getCharacterStream, getClob, getConcurrency, getCursorName, getDate, getDate, getDate, getDouble, getFetchDirection, getFetchSize, getFloat, getHoldability, getInt, getLong, getMetaData, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getRef, getRef, getRow, getRowId, getRowId, getShort, getSQLXML, getSQLXML, getStatement, getString, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, isWrapperFor, last, moveToCurrentRow, moveToInsertRow, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, unwrap, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp

Methods inherited from class sun.javadb.vti.core. TemplateTableFunction


                absolute,  
                afterLast,  
                beforeFirst,  
                cancelRowUpdates,  
                clearWarnings,  
                deleteRow,  
                first,  
                getArray,  
                getArray,  
                getAsciiStream,  
                getBigDecimal,  
                getBigDecimal,  
                getBigDecimal,  
                getBinaryStream,  
                getBlob,  
                getBoolean,  
                getByte,  
                getBytes,  
                getCharacterStream,  
                getCharacterStream,  
                getClob,  
                getConcurrency,  
                getCursorName,  
                getDate,  
                getDate,  
                getDate,  
                getDouble,  
                getFetchDirection,  
                getFetchSize,  
                getFloat,  
                getHoldability,  
                getInt,  
                getLong,  
                getMetaData,  
                getNCharacterStream,  
                getNCharacterStream,  
                getNClob,  
                getNClob,  
                getNString,  
                getNString,  
                getObject,  
                getObject,  
                getObject,  
                getObject,  
                getRef,  
                getRef,  
                getRow,  
                getRowId,  
                getRowId,  
                getShort,  
                getSQLXML,  
                getSQLXML,  
                getStatement,  
                getString,  
                getTime,  
                getTime,  
                getTime,  
                getTimestamp,  
                getTimestamp,  
                getTimestamp,  
                getType,  
                getUnicodeStream,  
                getUnicodeStream,  
                getURL,  
                getURL,  
                getWarnings,  
                insertRow,  
                isAfterLast,  
                isBeforeFirst,  
                isClosed,  
                isFirst,  
                isLast,  
                isWrapperFor,  
                last,  
                moveToCurrentRow,  
                moveToInsertRow,  
                previous,  
                refreshRow,  
                relative,  
                rowDeleted,  
                rowInserted,  
                rowUpdated,  
                setFetchDirection,  
                setFetchSize,  
                unwrap,  
                updateArray,  
                updateArray,  
                updateAsciiStream,  
                updateAsciiStream,  
                updateAsciiStream,  
                updateAsciiStream,  
                updateAsciiStream,  
                updateAsciiStream,  
                updateBigDecimal,  
                updateBigDecimal,  
                updateBinaryStream,  
                updateBinaryStream,  
                updateBinaryStream,  
                updateBinaryStream,  
                updateBinaryStream,  
                updateBinaryStream,  
                updateBlob,  
                updateBlob,  
                updateBlob,  
                updateBlob,  
                updateBlob,  
                updateBlob,  
                updateBoolean,  
                updateBoolean,  
                updateByte,  
                updateByte,  
                updateBytes,  
                updateBytes,  
                updateCharacterStream,  
                updateCharacterStream,  
                updateCharacterStream,  
                updateCharacterStream,  
                updateCharacterStream,  
                updateCharacterStream,  
                updateClob,  
                updateClob,  
                updateClob,  
                updateClob,  
                updateClob,  
                updateClob,  
                updateDate,  
                updateDate,  
                updateDouble,  
                updateDouble,  
                updateFloat,  
                updateFloat,  
                updateInt,  
                updateInt,  
                updateLong,  
                updateLong,  
                updateNCharacterStream,  
                updateNCharacterStream,  
                updateNCharacterStream,  
                updateNCharacterStream,  
                updateNClob,  
                updateNClob,  
                updateNClob,  
                updateNClob,  
                updateNClob,  
                updateNClob,  
                updateNString,  
                updateNString,  
                updateNull,  
                updateNull,  
                updateObject,  
                updateObject,  
                updateObject,  
                updateObject,  
                updateRef,  
                updateRef,  
                updateRow,  
                updateRowId,  
                updateRowId,  
                updateShort,  
                updateShort,  
                updateSQLXML,  
                updateSQLXML,  
                updateString,  
                updateString,  
                updateTime,  
                updateTime,  
                updateTimestamp,  
                updateTimestamp

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
`close, next`

Field Detail

_columnNames

private  
          
String[]  
          
_columnNames

_lastColumnWasNull

private boolean  
          
_lastColumnWasNull

Constructor Detail

StringColumnTableFunction

public  
          
StringColumnTableFunction(
          
String[] columnNames)

Build a StringColumnTableFunction with the given column names

Method Detail

getRawColumn

protected abstract  
          
String  
          
getRawColumn(int columnNumber)
                                throws  
          
SQLException

Get the string value of the column in the current row identified by the 1-based columnNumber.

Throws:: SQLException

wasNull

public boolean  
          
wasNull()
                throws  
          
SQLException

Specified by:: wasNull in interface ResultSet
Overrides:: wasNull in class TemplateTableFunction

Throws:: SQLException

findColumn

public int  
          
findColumn(
          
String columnName)
               throws  
          
SQLException

Specified by:: findColumn in interface ResultSet
Overrides:: findColumn in class TemplateTableFunction

Throws:: SQLException

getString

public  
          
String  
          
getString(int columnIndex)
                 throws  
          
SQLException

Specified by:: getString in interface ResultSet
Overrides:: getString in class TemplateTableFunction

Throws:: SQLException

getBoolean

public boolean  
          
getBoolean(int columnIndex)
                   throws  
          
SQLException

Specified by:: getBoolean in interface ResultSet
Overrides:: getBoolean in class TemplateTableFunction

Throws:: SQLException

getByte

public byte  
          
getByte(int columnIndex)
             throws  
          
SQLException

Specified by:: getByte in interface ResultSet
Overrides:: getByte in class TemplateTableFunction

Throws:: SQLException

getShort

public short  
          
getShort(int columnIndex)
               throws  
          
SQLException

Specified by:: getShort in interface ResultSet
Overrides:: getShort in class TemplateTableFunction

Throws:: SQLException

getInt

public int  
          
getInt(int columnIndex)
           throws  
          
SQLException

Specified by:: getInt in interface ResultSet
Overrides:: getInt in class TemplateTableFunction

Throws:: SQLException

getLong

public long  
          
getLong(int columnIndex)
             throws  
          
SQLException

Specified by:: getLong in interface ResultSet
Overrides:: getLong in class TemplateTableFunction

Throws:: SQLException

getFloat

public float  
          
getFloat(int columnIndex)
               throws  
          
SQLException

Specified by:: getFloat in interface ResultSet
Overrides:: getFloat in class TemplateTableFunction

Throws:: SQLException

getDouble

public double  
          
getDouble(int columnIndex)
                 throws  
          
SQLException

Specified by:: getDouble in interface ResultSet
Overrides:: getDouble in class TemplateTableFunction

Throws:: SQLException

getBigDecimal

public  
          
BigDecimal  
          
getBigDecimal(int columnIndex)
                         throws  
          
SQLException

Specified by:: getBigDecimal in interface ResultSet
Overrides:: getBigDecimal in class TemplateTableFunction

Throws:: SQLException

getBytes

public byte[]  
          
getBytes(int columnIndex)
                throws  
          
SQLException

Specified by:: getBytes in interface ResultSet
Overrides:: getBytes in class TemplateTableFunction

Throws:: SQLException

getDate

public  
          
Date  
          
getDate(int columnIndex)
             throws  
          
SQLException

Specified by:: getDate in interface ResultSet
Overrides:: getDate in class TemplateTableFunction

Throws:: SQLException

getTime

public  
          
Time  
          
getTime(int columnIndex)
             throws  
          
SQLException

Specified by:: getTime in interface ResultSet
Overrides:: getTime in class TemplateTableFunction

Throws:: SQLException

getTimestamp

public  
          
Timestamp  
          
getTimestamp(int columnIndex)
                       throws  
          
SQLException

Specified by:: getTimestamp in interface ResultSet
Overrides:: getTimestamp in class TemplateTableFunction

Throws:: SQLException

getAsciiStream

public  
          
InputStream  
          
getAsciiStream(int columnIndex)
                           throws  
          
SQLException

Specified by:: getAsciiStream in interface ResultSet
Overrides:: getAsciiStream in class TemplateTableFunction

Throws:: SQLException

getBinaryStream

public  
          
InputStream  
          
getBinaryStream(int columnIndex)
                            throws  
          
SQLException

Specified by:: getBinaryStream in interface ResultSet
Overrides:: getBinaryStream in class TemplateTableFunction

Throws:: SQLException

getBlob

public  
          
Blob  
          
getBlob(int columnIndex)
             throws  
          
SQLException

Specified by:: getBlob in interface ResultSet
Overrides:: getBlob in class TemplateTableFunction

Throws:: SQLException

getClob

public  
          
Clob  
          
getClob(int columnIndex)
             throws  
          
SQLException

Specified by:: getClob in interface ResultSet
Overrides:: getClob in class TemplateTableFunction

Throws:: SQLException

getColumnNames

protected  
          
String[]  
          
getColumnNames()

Return the names of the columns.

getColumnCount

protected int  
          
getColumnCount()

Return the number of columns in this table function.

wrap

protected  
          
SQLException  
          
wrap(
          
Throwable t)

Wrap an exception in a SQLException.

wrap

protected  
          
SQLException  
          
wrap(
          
String message,
                             
          
Throwable t)

Wrap an exception in a SQLException.

checkNull

private void  
          
checkNull(
          
String columnValue)

Set the wasNull flag based on whether this column value turned out to be null.

parseDateTime

private long  
          
parseDateTime(
          
String columnValue)
                    throws  
          
SQLException

Translate a date/time expression into the corresponding long number of milliseconds.

Throws:: SQLException

getEncodedStream

private  
          
InputStream  
          
getEncodedStream(
          
String columnValue,
                                      
          
String encoding)
                              throws  
          
SQLException

Turn a string into an appropriately encoded ByteArrayInputStream.

Throws:: SQLException

castLong

private int  
          
castLong(long value)
              throws  
          
SQLException

Throws:: SQLException

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

	Java SDKs and Tools
Java SE Java EE and Glassfish Java ME JavaFX Java Card NetBeans IDE

	Java Resources
New to Java? APIs Code Samples & Apps Developer Training Documentation Java.com Java.net Student Developers Tutorials

E-mail this page

Printer View

Oracle Cloud

Java

Customer and Events

Communities

Services and Store

Log In to My Oracle Support
Training and Certification
Become a Partner
Find a Partner Solution
Purchase from the Oracle Store
Contact and Chat
Global Contacts
Oracle Support
Phone: 800-633-0738

Products and Services

Solutions

Downloads

Store

Support

Training

Partners

About

Oracle Technology Network

sun.javadb.vti.core Class StringColumnTableFunction

_columnNames

_lastColumnWasNull

StringColumnTableFunction

getRawColumn

wasNull

findColumn

getString

getBoolean

getByte

getShort

getInt

getLong

getFloat

getDouble

getBigDecimal

getBytes

getDate

getTime

getTimestamp

getAsciiStream

getBinaryStream

getBlob

getClob

getColumnNames

getColumnCount

wrap

wrap

checkNull

parseDateTime

getEncodedStream

castLong

Oracle Cloud

Java

Customer and Events

Communities

Services and Store

Contact and Chat

Hardware and Software, Engineered to Work Together

sun.javadb.vti.core
Class StringColumnTableFunction