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

This class provides supportto create casting/conversions required to perform import. Import VTI gives all the data in VARCHAR type becuase data in the files is in CHAR format. There is no implicit cast availabile from VARCHAR to some of the types. In cases where explicit casting is allowed, columns are casted with explict cast to the type of table column; in case of double/real explicit casting is also not allowd , scalar fuction DOUBLE is used in those cases.

Field Summary

Modifier and Type	Field and Description
private ArrayList<E>	columnPositions
private ArrayList<String>	columnTypes
private Connection	conn
private boolean	createolumnNames
private int	expectedNumberOfCols
private String[]	headerColumnNames
private ArrayList<String>	insertColumnNames
private ArrayList<Integer>	jdbcColumnTypes
private int	noOfColumns
private String	schemaName
private String	tableName
private HashMap<String, String>	udtClassNames
private ArrayList<String>	vtiColumnNames

Constructor Summary

Access	Constructor and Description
public	ColumnInfo(Connection - connection to use for metadata queries conn, String - table's schema sName, String - table Name tName, String - comma seperared insert statement column list insertColumnList, String - Indexes in the file vtiColumnIndexes, String - Prefix to use to generate column names to select from VTI vtiColumnPrefix, String[] headerColumnNames) Initialize the column type and name information

Access

Constructor and Description

public

ColumnInfo(Connection

- connection to use for metadata queries

conn, String

- table's schema

sName, String

- table Name

tName, String

- comma seperared insert statement column list

insertColumnList, String

- Indexes in the file

vtiColumnIndexes, String

- Prefix to use to generate column names to select from VTI

vtiColumnPrefix, String[] headerColumnNames)

Initialize the column type and name information

Method Summary

Modifier and Type	Method and Description
public static HashMap<K, V>	deserializeHashMap(String stringVersion)
public String	getColumnNamesWithCasts()
public String	getColumnTypeNames() Get the column type names.
public static String[]	getExpectedColumnTypeNames(String columnTypeNamesString, int noOfColumns)
public int	getExpectedNumberOfColumnsInFile()
public static HashMap<K, V>	getExpectedUDTClasses(String stringVersion)
public static int[]	getExpectedVtiColumnTypes(String columnTypesStr, int noOfColumns)
public String	getExpectedVtiColumnTypesAsString()
public String	getInsertColumnNames()
private String	getTypeOption(String type, int length, int precision, int scale)
private String	getUDTClassName(DatabaseMetaData dmd, String sqlTypeName)
public String	getUDTClassNames() Get the class names of udt columns as a string.
public static final boolean	importExportSupportedType(int type)
private boolean	initializeColumnInfo(String columnPattern)
private int	readHeaders(String columnPattern)
private boolean	tableExists()

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

Field Detail

columnPositions	back to summary
private ArrayList<E> columnPositions

columnTypes	back to summary
private ArrayList<String> columnTypes

conn	back to summary
private Connection conn

createolumnNames	back to summary
private boolean createolumnNames

expectedNumberOfCols	back to summary
private int expectedNumberOfCols

headerColumnNames	back to summary
private String[] headerColumnNames

insertColumnNames	back to summary
private ArrayList<String> insertColumnNames

jdbcColumnTypes	back to summary
private ArrayList<Integer> jdbcColumnTypes

noOfColumns	back to summary
private int noOfColumns

schemaName	back to summary
private String schemaName

tableName	back to summary
private String tableName

udtClassNames	back to summary
private HashMap<String, String> udtClassNames

vtiColumnNames	back to summary
private ArrayList<String> vtiColumnNames

Constructor Detail

ColumnInfo	back to summary
public ColumnInfo(Connection conn, String sName, String tName, String insertColumnList, String vtiColumnIndexes, String vtiColumnPrefix, String[] headerColumnNames) throws SQLException Initialize the column type and name information Parameters conn:Connection - connection to use for metadata queries sName:String - table's schema tName:String - table Name insertColumnList:String - comma seperared insert statement column list vtiColumnIndexes:String - Indexes in the file vtiColumnPrefix:String - Prefix to use to generate column names to select from VTI Exceptions Exception: on error

ColumnInfo

back to summary

public ColumnInfo(Connection conn, String sName, String tName, String insertColumnList, String vtiColumnIndexes, String vtiColumnPrefix, String[] headerColumnNames) throws SQLException

Initialize the column type and name information

Parameters

conn:Connection: - connection to use for metadata queries
sName:String: - table's schema
tName:String: - table Name
insertColumnList:String: - comma seperared insert statement column list
vtiColumnIndexes:String: - Indexes in the file
vtiColumnPrefix:String: - Prefix to use to generate column names to select from VTI

Exceptions

Exception:: on error

Method Detail

deserializeHashMap	back to summary
public static HashMap<K, V> deserializeHashMap(String stringVersion) throws Exception

getColumnNamesWithCasts	back to summary
public String getColumnNamesWithCasts()

getColumnTypeNames	back to summary
public String getColumnTypeNames() throws Exception Get the column type names.

getExpectedColumnTypeNames	back to summary
public static String[] getExpectedColumnTypeNames(String columnTypeNamesString, int noOfColumns) throws Exception

getExpectedNumberOfColumnsInFile	back to summary
public int getExpectedNumberOfColumnsInFile()

getExpectedUDTClasses	back to summary
public static HashMap<K, V> getExpectedUDTClasses(String stringVersion) throws Exception

getExpectedVtiColumnTypes	back to summary
public static int[] getExpectedVtiColumnTypes(String columnTypesStr, int noOfColumns)

getExpectedVtiColumnTypesAsString	back to summary
public String getExpectedVtiColumnTypesAsString()

getInsertColumnNames	back to summary
public String getInsertColumnNames()

getTypeOption	back to summary
private String getTypeOption(String type, int length, int precision, int scale)

getUDTClassName	back to summary
private String getUDTClassName(DatabaseMetaData dmd, String sqlTypeName) throws SQLException

getUDTClassNames	back to summary
public String getUDTClassNames() throws Exception Get the class names of udt columns as a string.

importExportSupportedType	back to summary
public static final boolean importExportSupportedType(int type)

initializeColumnInfo	back to summary
private boolean initializeColumnInfo(String columnPattern) throws SQLException

readHeaders	back to summary
private int readHeaders(String columnPattern) throws SQLException