Apache Derby Database Engine and Embedded JDBC Driver 10.17.1.0 · org.apache.derby.impl.load.ImportAbstract

Field Summary

Modifier and Type	Field and Description
pack-priv static final String	COLUMNNAMEPREFIX
pack-priv String[]	columnNames
pack-priv String[]	columnTypeNames
pack-priv String	columnTypeNamesString
pack-priv int[]	columnWidths
pack-priv ControlInfo	controlFileReader
pack-priv ImportReadData	importReadData
pack-priv ImportResultSetMetaData	importResultSetMetaData
pack-priv int	lineNumber
protected boolean	lobsInExtFile
pack-priv String[]	nextRow
pack-priv int	noOfColumnsExpected
pack-priv int	numberOfColumns
pack-priv int[]	tableColumnTypes
pack-priv String	tableColumnTypesStr
pack-priv HashMap<K, V>	udtClasses
pack-priv String	udtClassNamesString
private boolean	wasNull

Constructor Summary

Access	Constructor and Description
pack-priv	ImportAbstract()

Method Summary

Modifier and Type	Method and Description
public void	close() Implements java.sql.ResultSet.close. closes the resultset
public static Object	destringifyObject(String raw) Read an object which was serialized to a string using StringUtil
pack-priv void	doAllTheWork() Does all the work
public Blob	getBlob(int number of the column. starts at 1. columnIndex) Overrides org.apache.derby.vti.VTITemplate.getBlob. Implements java.sql.ResultSet.getBlob. Returns `java.sql.Blob` type object that contains the column data from the import file.
public byte[]	getBytes(int number of the column. starts at 1. columnIndex) Overrides org.apache.derby.vti.VTITemplate.getBytes. Implements java.sql.ResultSet.getBytes. Returns byte array that contains the column data from the import file.
public Clob	getClob(int number of the column. starts at 1. columnIndex) Overrides org.apache.derby.vti.VTITemplate.getClob. Implements java.sql.ResultSet.getClob. Returns `java.sql.Clob` type object that contains the column data from the import file.
public int	getCurrentLineNumber() gets the current line number
pack-priv abstract ImportReadData	getImportReadData()
public ResultSetMetaData	getMetaData() Overrides org.apache.derby.vti.VTITemplate.getMetaData. Implements java.sql.ResultSet.getMetaData. Gets the resultset meta data
public Object	getObject(int number of the column. starts at 1. columnIndex) Overrides org.apache.derby.vti.VTITemplate.getObject. Implements java.sql.ResultSet.getObject. Returns Object that contains the column data from the import file.
public int	getRow() Overrides org.apache.derby.vti.VTITemplate.getRow. Implements java.sql.ResultSet.getRow. gets the next row
public String	getString(int the first column is 1, the second is 2, ... columnIndex) Overrides org.apache.derby.vti.VTITemplate.getString. Implements java.sql.ResultSet.getString. Retrieves the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
public SQLException	importError(Exception Exception causing the import error ex) Close the stream and wrap exception in a SQLException
private boolean	Returns: true, if the column data in a different file from the main import file , otherwise false. isColumnInExtFile(int number of the column. starts at 1. colIndex) Check if for this column type, real data is stored in an external file and only the reference is in the main import file.
pack-priv void	loadColumnNames()
public boolean	next() Implements java.sql.ResultSet.next. Moves the cursor forward one row from its current position.
public static Object	readObject(byte[] bytes) Read a serializable from a set of bytes.
public boolean	wasNull() Overrides org.apache.derby.vti.VTITemplate.wasNull. Implements java.sql.ResultSet.wasNull. Reports whether the last column read had a value of SQL `NULL`.

Inherited from org.apache.derby.vti.VTITemplate:: absolute afterLast beforeFirst cancelRowUpdates clearWarnings deleteRow findColumn first getArray getArray getAsciiStream getAsciiStream getBigDecimal getBigDecimal getBigDecimal getBigDecimal getBinaryStream getBinaryStream getBlob getBoolean getBoolean getByte getByte getBytes getCharacterStream getCharacterStream getClob getConcurrency getContext getCursorName getDate getDate getDate getDate getDouble getDouble getFetchDirection getFetchSize getFloat getFloat getHoldability getInt getInt getLong getLong getNCharacterStream getNCharacterStream getNClob getNClob getNString getNString getObject getObject getObject getObject getObject getRef getRef getReturnTableSignature getRowId getRowId getShort getShort getSQLXML getSQLXML getStatement getString getTime getTime getTime getTime getTimestamp getTimestamp getTimestamp getTimestamp getType getUnicodeStream getUnicodeStream getURL getURL getWarnings insertRow isAfterLast isBeforeFirst isClosed isFirst isLast isWrapperFor last moveToCurrentRow moveToInsertRow notImplemented previous refreshRow relative rowDeleted rowInserted rowUpdated setContext 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

Field Detail

COLUMNNAMEPREFIX	back to summary
pack-priv static final String COLUMNNAMEPREFIX

columnNames	back to summary
pack-priv String[] columnNames

columnTypeNames	back to summary
pack-priv String[] columnTypeNames

columnTypeNamesString	back to summary
pack-priv String columnTypeNamesString

columnWidths	back to summary
pack-priv int[] columnWidths

controlFileReader	back to summary
pack-priv ControlInfo controlFileReader

importReadData	back to summary
pack-priv ImportReadData importReadData

importResultSetMetaData	back to summary
pack-priv ImportResultSetMetaData importResultSetMetaData

lineNumber	back to summary
pack-priv int lineNumber

lobsInExtFile	back to summary
protected boolean lobsInExtFile

nextRow	back to summary
pack-priv String[] nextRow

noOfColumnsExpected	back to summary
pack-priv int noOfColumnsExpected

numberOfColumns	back to summary
pack-priv int numberOfColumns

tableColumnTypes	back to summary
pack-priv int[] tableColumnTypes

tableColumnTypesStr	back to summary
pack-priv String tableColumnTypesStr

udtClasses	back to summary
pack-priv HashMap<K, V> udtClasses

udtClassNamesString	back to summary
pack-priv String udtClassNamesString

wasNull	back to summary
private boolean wasNull

Constructor Detail

ImportAbstract	back to summary
pack-priv ImportAbstract()

Method Detail

close	back to summary
public void close() throws SQLException Implements java.sql.ResultSet.close. closes the resultset Exceptions SQLException: if there is an error

back to summary

public void close() throws SQLException

Implements java.sql.ResultSet.close.

closes the resultset

Exceptions

SQLException:: if there is an error

destringifyObject	back to summary
public static Object destringifyObject(String raw) throws Exception Read an object which was serialized to a string using StringUtil

doAllTheWork	back to summary
pack-priv void doAllTheWork() throws Exception Does all the work Exceptions Exception: if there is an error

doAllTheWork

back to summary

pack-priv void doAllTheWork() throws Exception

Does all the work

Exceptions

Exception:: if there is an error

getBlob back to summary

getBlob	back to summary
public Blob getBlob(int columnIndex) throws SQLException Overrides org.apache.derby.vti.VTITemplate.getBlob. Implements java.sql.ResultSet.getBlob. Returns `java.sql.Blob` type object that contains the column data from the import file. Parameters columnIndex:int number of the column. starts at 1. Returns:Blob Doc from java.sql.ResultSet.getBlob. a `Blob` object representing the SQL `BLOB` value in the specified column Exceptions SQLException: if any occurs during create of the blob object.

public Blob getBlob(int columnIndex) throws SQLException

Overrides org.apache.derby.vti.VTITemplate.getBlob.

Implements java.sql.ResultSet.getBlob.

Returns java.sql.Blob type object that contains the column data from the import file.

Parameters

columnIndex:int: number of the column. starts at 1.

Returns:Blob

Doc from java.sql.ResultSet.getBlob.

a Blob object representing the SQL BLOB value in the specified column

Exceptions

SQLException:: if any occurs during create of the blob object.

getBytes back to summary

getBytes	back to summary
public byte[] getBytes(int columnIndex) throws SQLException Overrides org.apache.derby.vti.VTITemplate.getBytes. Implements java.sql.ResultSet.getBytes. Returns byte array that contains the column data from the import file. Parameters columnIndex:int number of the column. starts at 1. Returns:byte[] Doc from java.sql.ResultSet.getBytes. the column value; if the value is SQL `NULL`, the value returned is `null` Exceptions SQLException: if any error occurs.

public byte[] getBytes(int columnIndex) throws SQLException

Overrides org.apache.derby.vti.VTITemplate.getBytes.

Implements java.sql.ResultSet.getBytes.

Returns byte array that contains the column data from the import file.

Parameters

columnIndex:int: number of the column. starts at 1.

Returns:byte[]

Doc from java.sql.ResultSet.getBytes.

the column value; if the value is SQL NULL, the value returned is null

Exceptions

SQLException:: if any error occurs.

getClob back to summary

getClob	back to summary
public Clob getClob(int columnIndex) throws SQLException Overrides org.apache.derby.vti.VTITemplate.getClob. Implements java.sql.ResultSet.getClob. Returns `java.sql.Clob` type object that contains the column data from the import file. Parameters columnIndex:int number of the column. starts at 1. Returns:Clob Doc from java.sql.ResultSet.getClob. a `Clob` object representing the SQL `CLOB` value in the specified column Exceptions SQLException: if any occurs during create of the clob object.

public Clob getClob(int columnIndex) throws SQLException

Overrides org.apache.derby.vti.VTITemplate.getClob.

Implements java.sql.ResultSet.getClob.

Returns java.sql.Clob type object that contains the column data from the import file.

Parameters

columnIndex:int: number of the column. starts at 1.

Returns:Clob

Doc from java.sql.ResultSet.getClob.

a Clob object representing the SQL CLOB value in the specified column

Exceptions

SQLException:: if any occurs during create of the clob object.

getCurrentLineNumber	back to summary
public int getCurrentLineNumber() gets the current line number

getImportReadData	back to summary
pack-priv abstract ImportReadData getImportReadData() throws Exception

getMetaData back to summary

public ResultSetMetaData getMetaData()

Overrides org.apache.derby.vti.VTITemplate.getMetaData.

Implements java.sql.ResultSet.getMetaData.

Gets the resultset meta data

Returns:ResultSetMetaData

Doc from java.sql.ResultSet.getMetaData.

the description of this ResultSet object's columns

Exceptions

SQLException:: if there is an error

getObject back to summary

getObject	back to summary
public Object getObject(int columnIndex) throws SQLException Overrides org.apache.derby.vti.VTITemplate.getObject. Implements java.sql.ResultSet.getObject. Returns Object that contains the column data from the import file. Parameters columnIndex:int number of the column. starts at 1. Returns:Object Doc from java.sql.ResultSet.getObject. a `java.lang.Object` holding the column value Exceptions SQLException: if any error occurs.

public Object getObject(int columnIndex) throws SQLException

Overrides org.apache.derby.vti.VTITemplate.getObject.

Implements java.sql.ResultSet.getObject.

Returns Object that contains the column data from the import file.

Parameters

columnIndex:int: number of the column. starts at 1.

Returns:Object

Doc from java.sql.ResultSet.getObject.

a java.lang.Object holding the column value

Exceptions

SQLException:: if any error occurs.

getRow back to summary

getRow	back to summary
public int getRow() throws SQLException Overrides org.apache.derby.vti.VTITemplate.getRow. Implements java.sql.ResultSet.getRow. gets the next row Returns:int Doc from java.sql.ResultSet.getRow. the current row number; `0` if there is no current row Exceptions SQLException: if there is an error

public int getRow() throws SQLException

Overrides org.apache.derby.vti.VTITemplate.getRow.

Implements java.sql.ResultSet.getRow.

gets the next row

Returns:int

Doc from java.sql.ResultSet.getRow.

the current row number; 0 if there is no current row

Exceptions

SQLException:: if there is an error

getString back to summary

getString	back to summary
public String getString(int columnIndex) throws SQLException Overrides org.apache.derby.vti.VTITemplate.getString. Implements java.sql.ResultSet.getString. Doc from java.sql.ResultSet.getString. Retrieves the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language. Parameters columnIndex:int the first column is 1, the second is 2, ... Returns:String the column value; if the value is SQL `NULL`, the value returned is `null` Exceptions SQLException: if there is an error

public String getString(int columnIndex) throws SQLException

Overrides org.apache.derby.vti.VTITemplate.getString.

Implements java.sql.ResultSet.getString.

Doc from java.sql.ResultSet.getString.

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

Parameters

columnIndex:int: the first column is 1, the second is 2, ...

Returns:String

the column value; if the value is SQL NULL, the value returned is null

Exceptions

SQLException:: if there is an error

importError	back to summary
public SQLException importError(Exception ex) Close the stream and wrap exception in a SQLException Parameters ex:Exception Exception causing the import error

importError

back to summary

public SQLException importError(Exception ex)

Close the stream and wrap exception in a SQLException

Parameters

ex:Exception: Exception causing the import error

isColumnInExtFile	back to summary
private boolean isColumnInExtFile(int colIndex) Check if for this column type, real data is stored in an external file and only the reference is in the main import file. Parameters colIndex:int number of the column. starts at 1. Returns:boolean true, if the column data in a different file from the main import file , otherwise false.

isColumnInExtFile

back to summary

private boolean isColumnInExtFile(int colIndex)

Check if for this column type, real data is stored in an external file and only the reference is in the main import file.

Parameters

colIndex:int: number of the column. starts at 1.

Returns:boolean

true, if the column data in a different file from the main import file , otherwise false.

loadColumnNames	back to summary
pack-priv void loadColumnNames()

next back to summary

next	back to summary
public boolean next() throws SQLException Implements java.sql.ResultSet.next. Doc from java.sql.ResultSet.next. Moves the cursor forward one row from its current position. A `ResultSet` cursor is initially positioned before the first row; the first call to the method `next` makes the first row the current row; the second call makes the second row the current row, and so on. When a call to the `next` method returns `false`, the cursor is positioned after the last row. Any invocation of a `ResultSet` method which requires a current row will result in a `SQLException` being thrown. If the result set type is `TYPE_FORWARD_ONLY`, it is vendor specified whether their JDBC driver implementation will return `false` or throw an `SQLException` on a subsequent call to `next`. If an input stream is open for the current row, a call to the method `next` will implicitly close it. A `ResultSet` object's warning chain is cleared when a new row is read. Returns:boolean `true` if the new current row is valid; `false` if there are no more rows Exceptions SQLException: if a database access error occurs or this method is called on a closed result set

public boolean next() throws SQLException

Implements java.sql.ResultSet.next.

Doc from java.sql.ResultSet.next.

Moves the cursor forward one row from its current position. A ResultSet cursor is initially positioned before the first row; the first call to the method next makes the first row the current row; the second call makes the second row the current row, and so on.

When a call to the next method returns false, the cursor is positioned after the last row. Any invocation of a ResultSet method which requires a current row will result in a SQLException being thrown. If the result set type is TYPE_FORWARD_ONLY, it is vendor specified whether their JDBC driver implementation will return false or throw an SQLException on a subsequent call to next.

If an input stream is open for the current row, a call to the method next will implicitly close it. A ResultSet object's warning chain is cleared when a new row is read.

Returns:boolean

true if the new current row is valid; false if there are no more rows

Exceptions

SQLException:: if a database access error occurs or this method is called on a closed result set

readObject	back to summary
public static Object readObject(byte[] bytes) throws Exception Read a serializable from a set of bytes.

wasNull back to summary

wasNull	back to summary
public boolean wasNull() Overrides org.apache.derby.vti.VTITemplate.wasNull. Implements java.sql.ResultSet.wasNull. Doc from java.sql.ResultSet.wasNull. Reports whether the last column read had a value of SQL `NULL`. Note that you must first call one of the getter methods on a column to try to read its value and then call the method `wasNull` to see if the value read was SQL `NULL`. Returns:boolean `true` if the last column value read was SQL `NULL` and `false` otherwise

public boolean wasNull()

Overrides org.apache.derby.vti.VTITemplate.wasNull.

Implements java.sql.ResultSet.wasNull.

Doc from java.sql.ResultSet.wasNull.

Reports whether the last column read had a value of SQL NULL. Note that you must first call one of the getter methods on a column to try to read its value and then call the method wasNull to see if the value read was SQL NULL.

Returns:boolean: true if the last column value read was SQL NULL and false otherwise

pack-priv abstract Class ImportAbstract

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail