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

Modifier and Type	Field and Description
pack-priv static final int	ASCII_FIXED_FORMAT_CODE
private BufferedReader	bufferedReader
protected String	columnDefinition
protected String[]	columnTypes
private int[]	columnWidths
protected ControlInfo	controlFileReader
private char[]	currentToken
private int	currentTokenMaxSize
protected String	dataCodeset
pack-priv static final int	DEFAULT_FORMAT_CODE
protected char[]	fieldSeparator
private char	fieldSeparatorChar0
protected int	fieldSeparatorLength
private boolean	fieldSepStartNotWhite
protected char[]	fieldStartDelimiter
pack-priv int	fieldStartDelimiterIndex
protected int	fieldStartDelimiterLength
protected char[]	fieldStopDelimiter
pack-priv int	fieldStopDelimiterIndex
protected int	fieldStopDelimiterLength
protected String	format
private int	formatCode
pack-priv boolean	foundStartAndStopDelimiters
pack-priv boolean	foundStartDelimiter
private boolean	hasColumnDefinition
protected boolean	hasDelimiterAtEnd
private boolean	haveSep
private String	inputFileName
pack-priv int	lineNumber
private ImportLobFile[]	lobFileHandles
private String	lobFileName
private int	lobLength
private long	lobOffset
protected String	nullString
private int	numberOfCharsReadSoFar
protected int	numberOfColumns
pack-priv int	positionOfNonWhiteSpaceCharInBack
pack-priv int	positionOfNonWhiteSpaceCharInFront
protected char[]	recordSeparator
private char	recordSeparatorChar0
protected int	recordSeparatorLength
private boolean	recordSepStartNotWhite
private int	rowWidth
private short	skipLines
private static final int	START_SIZE
pack-priv int	stopDelimiterPosition
pack-priv boolean	streamOpenForReading
private char[]	tempString
pack-priv int	totalCharsSoFar

Access	Constructor and Description
pack-priv	ImportReadData(String inputFileName, ControlInfo controlFileReader, short skipLines)

Method Summary

Modifier and Type	Method and Description
private void	checkForWhiteSpaceInBack()
private void	checkForWhiteSpaceInFront()
pack-priv void	closeStream() close the input data file
pack-priv int	findNumberOfColumnsInARow()
pack-priv Blob	getBlobColumnFromExtFile(String location of the clob data. lobLocationStr, int number of the column. starts at 1. colIndex) Returns a blob columnn data stored at the specified location as a java.sql.Blob object.
pack-priv Clob	getClobColumnFromExtFile(String location of the clob data. lobLocationStr, int number of the column. starts at 1. colIndex) Returns a clob columnn data stored at the specified location as a java.sql.Clob object.
pack-priv String	getClobColumnFromExtFileAsString(String location of the clob data. lobLocationStr, int number of the column. starts at 1. colIndex) Returns a clob columnn data stored at the specified location.
pack-priv int	getCurrentRowNumber() returns the number of the current row
pack-priv int	getNumberOfColumns()
protected void	ignoreFirstRow() if columndefinition is true, ignore first row.
protected void	ignoreHeaderLines() if skipHeaderLines is greater than 0, ignore skipHeaderLines number of lines.
private void	initExternalLobFile(String location of the clob data. lobLocationStr, int number of the column. starts at 1. colIndex) Extract the file name, offset and length from the given lob location and setup the file resources to read the data from the file on first invocaton.
private boolean	isFieldSep(char[] chrArray)
protected void	loadColumnTypes() load the column types from the meta data line to be analyzed later in the constructor of the ImportResultSetMetaData.
private void	loadMetaData()
private void	loadPropertiesInfo()
private int	lookForPassedSeparator(char[] delimiter, int delimiterIndex, int delimiterLength, int nextChar, boolean lookForRecordSeperator)
private void	omitLineFeed()
private void	openFile()
private boolean	readNextDelimitedRow(String[] returnStringArray)
private boolean	readNextFixedRow(String[] returnStringArray)
pack-priv boolean	readNextRow(String[] returnStringArray) the way we read the next row from input file depends on it's format
pack-priv boolean	readNextToken(char[] delimiter, int delimiterIndex, int delimiterLength, boolean isRecordSeperator)
pack-priv boolean	readTokensUntilEndOfRecord()
private void	realOpenFile()
private int	reCheckRestOfTheCharacters(int startFrom, char[] delimiter, int delimiterLength)
public final Object	run()
private boolean	skipDoubleDelimiters(char[] characterDelimiter)

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

ASCII_FIXED_FORMAT_CODE	back to summary
pack-priv static final int ASCII_FIXED_FORMAT_CODE

bufferedReader	back to summary
private BufferedReader bufferedReader

columnDefinition	back to summary
protected String columnDefinition

columnTypes	back to summary
protected String[] columnTypes

columnWidths	back to summary
private int[] columnWidths

controlFileReader	back to summary
protected ControlInfo controlFileReader

currentToken	back to summary
private char[] currentToken

currentTokenMaxSize	back to summary
private int currentTokenMaxSize

dataCodeset	back to summary
protected String dataCodeset

DEFAULT_FORMAT_CODE	back to summary
pack-priv static final int DEFAULT_FORMAT_CODE

fieldSeparator	back to summary
protected char[] fieldSeparator

fieldSeparatorChar0	back to summary
private char fieldSeparatorChar0

fieldSeparatorLength	back to summary
protected int fieldSeparatorLength

fieldSepStartNotWhite	back to summary
private boolean fieldSepStartNotWhite

fieldStartDelimiter	back to summary
protected char[] fieldStartDelimiter

fieldStartDelimiterIndex	back to summary
pack-priv int fieldStartDelimiterIndex

fieldStartDelimiterLength	back to summary
protected int fieldStartDelimiterLength

fieldStopDelimiter	back to summary
protected char[] fieldStopDelimiter

fieldStopDelimiterIndex	back to summary
pack-priv int fieldStopDelimiterIndex

fieldStopDelimiterLength	back to summary
protected int fieldStopDelimiterLength

format	back to summary
protected String format

formatCode	back to summary
private int formatCode

foundStartAndStopDelimiters	back to summary
pack-priv boolean foundStartAndStopDelimiters

foundStartDelimiter	back to summary
pack-priv boolean foundStartDelimiter

hasColumnDefinition	back to summary
private boolean hasColumnDefinition

hasDelimiterAtEnd	back to summary
protected boolean hasDelimiterAtEnd

haveSep	back to summary
private boolean haveSep

inputFileName	back to summary
private String inputFileName

lineNumber	back to summary
pack-priv int lineNumber

lobFileHandles	back to summary
private ImportLobFile[] lobFileHandles

lobFileName	back to summary
private String lobFileName

lobLength	back to summary
private int lobLength

lobOffset	back to summary
private long lobOffset

nullString	back to summary
protected String nullString

numberOfCharsReadSoFar	back to summary
private int numberOfCharsReadSoFar

numberOfColumns	back to summary
protected int numberOfColumns

positionOfNonWhiteSpaceCharInBack	back to summary
pack-priv int positionOfNonWhiteSpaceCharInBack

positionOfNonWhiteSpaceCharInFront	back to summary
pack-priv int positionOfNonWhiteSpaceCharInFront

recordSeparator	back to summary
protected char[] recordSeparator

recordSeparatorChar0	back to summary
private char recordSeparatorChar0

recordSeparatorLength	back to summary
protected int recordSeparatorLength

recordSepStartNotWhite	back to summary
private boolean recordSepStartNotWhite

rowWidth	back to summary
private int rowWidth

skipLines	back to summary
private short skipLines

START_SIZE	back to summary
private static final int START_SIZE

stopDelimiterPosition	back to summary
pack-priv int stopDelimiterPosition

streamOpenForReading	back to summary
pack-priv boolean streamOpenForReading

tempString	back to summary
private char[] tempString

totalCharsSoFar	back to summary
pack-priv int totalCharsSoFar

Constructor Detail

ImportReadData	back to summary
pack-priv ImportReadData(String inputFileName, ControlInfo controlFileReader, short skipLines) throws Exception

Method Detail

checkForWhiteSpaceInBack	back to summary
private void checkForWhiteSpaceInBack()

checkForWhiteSpaceInFront	back to summary
private void checkForWhiteSpaceInFront()

closeStream

back to summary

pack-priv void closeStream() throws Exception

close the input data file

Exceptions

Exception:: if there is an error

findNumberOfColumnsInARow	back to summary
pack-priv int findNumberOfColumnsInARow() throws Exception

getBlobColumnFromExtFile

back to summary

pack-priv Blob getBlobColumnFromExtFile(String lobLocationStr, int colIndex) throws SQLException

Returns a blob columnn data stored at the specified location as a java.sql.Blob object.

Parameters

lobLocationStr:String: location of the clob data.
colIndex:int: number of the column. starts at 1.

Exceptions

SQLException:: on any errors.

getClobColumnFromExtFile

back to summary

pack-priv Clob getClobColumnFromExtFile(String lobLocationStr, int colIndex) throws SQLException

Returns a clob columnn data stored at the specified location as a java.sql.Clob object.

Parameters

lobLocationStr:String: location of the clob data.
colIndex:int: number of the column. starts at 1.

Exceptions

SQLException:: on any errors.

getClobColumnFromExtFileAsString

back to summary

pack-priv String getClobColumnFromExtFileAsString(String lobLocationStr, int colIndex) throws SQLException

Returns a clob columnn data stored at the specified location.

Parameters

lobLocationStr:String: location of the clob data.
colIndex:int: number of the column. starts at 1.

Exceptions

SQLException:: on any errors.

getCurrentRowNumber	back to summary
pack-priv int getCurrentRowNumber() returns the number of the current row

getNumberOfColumns	back to summary
pack-priv int getNumberOfColumns()

ignoreFirstRow

back to summary

protected void ignoreFirstRow() throws Exception

if columndefinition is true, ignore first row. The way to do that is to just look for the record separator

Exceptions

Exception:: if there is an error

ignoreHeaderLines

back to summary

protected void ignoreHeaderLines() throws Exception

if skipHeaderLines is greater than 0, ignore skipHeaderLines number of lines. The way to do that is to just look for the record separator

Exceptions

Exception:: if there is an error

initExternalLobFile

back to summary

private void initExternalLobFile(String lobLocationStr, int colIndex) throws SQLException

Extract the file name, offset and length from the given lob location and setup the file resources to read the data from the file on first invocaton.

Parameters

lobLocationStr:String: location of the clob data.
colIndex:int: number of the column. starts at 1.

Exceptions

SQLException:: on any errors.

isFieldSep	back to summary
private boolean isFieldSep(char[] chrArray)

loadColumnTypes	back to summary
protected void loadColumnTypes() throws Exception load the column types from the meta data line to be analyzed later in the constructor of the ImportResultSetMetaData.

loadMetaData	back to summary
private void loadMetaData() throws Exception

loadPropertiesInfo	back to summary
private void loadPropertiesInfo() throws Exception

lookForPassedSeparator	back to summary
private int lookForPassedSeparator(char[] delimiter, int delimiterIndex, int delimiterLength, int nextChar, boolean lookForRecordSeperator) throws IOException

omitLineFeed	back to summary
private void omitLineFeed() throws IOException

openFile	back to summary
private void openFile() throws Exception

readNextDelimitedRow	back to summary
private boolean readNextDelimitedRow(String[] returnStringArray) throws Exception

readNextFixedRow	back to summary
private boolean readNextFixedRow(String[] returnStringArray) throws Exception

readNextRow

back to summary

pack-priv boolean readNextRow(String[] returnStringArray) throws Exception

the way we read the next row from input file depends on it's format

Exceptions

Exception:: if there is an error

readNextToken	back to summary
pack-priv boolean readNextToken(char[] delimiter, int delimiterIndex, int delimiterLength, boolean isRecordSeperator) throws Exception

readTokensUntilEndOfRecord	back to summary
pack-priv boolean readTokensUntilEndOfRecord() throws Exception

realOpenFile	back to summary
private void realOpenFile() throws Exception

reCheckRestOfTheCharacters	back to summary
private int reCheckRestOfTheCharacters(int startFrom, char[] delimiter, int delimiterLength)

run	back to summary
public final Object run() throws Exception

skipDoubleDelimiters	back to summary
private boolean skipDoubleDelimiters(char[] characterDelimiter) throws IOException

pack-priv final Class ImportReadData

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail