org.apache.derby.impl.load

Class Export

java.lang.Object

org.apache.derby.impl.load.Export

public class Export
extends java.lang.Object

This class provides ways to export data from a table or a view into a file. Export functions provided in this class are called through Systement Procedures.

Method Summary

Modifier and Type	Method and Description
static void	exportQuery(java.sql.Connection con, java.lang.String selectStatement, java.lang.String outputFileName, java.lang.String columnDelimeter, java.lang.String characterDelimeter, java.lang.String codeset) SYSCS_EXPORT_QUERY system Procedure from ij or from a Java application invokes this method to perform export of the data retrieved by select statement to a file.
static void	exportQuery(java.sql.Connection con, java.lang.String selectStatement, java.lang.String outputFileName, java.lang.String columnDelimeter, java.lang.String characterDelimeter, java.lang.String codeset, java.lang.String lobsFileName) SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE system Procedure from ij or from a Java application invokes this method to perform export of the data retrieved by select statement to a file.
static void	exportTable(java.sql.Connection con, java.lang.String schemaName, java.lang.String tableName, java.lang.String outputFileName, java.lang.String columnDelimeter, java.lang.String characterDelimeter, java.lang.String codeset) SYSCS_EXPORT_TABLE system Procedure from ij or from a Java application invokes this method to perform export of a table data to a file.
static void	exportTable(java.sql.Connection con, java.lang.String schemaName, java.lang.String tableName, java.lang.String outputFileName, java.lang.String columnDelimeter, java.lang.String characterDelimeter, java.lang.String codeset, java.lang.String lobsFileName) SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE system procedure from ij or from a Java application invokes this method to perform export of a table data to a file.
static java.lang.String	stringifyObject(java.lang.Object udt)

Methods inherited from class java.lang.Object

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

Method Detail

exportTable

public static void exportTable(java.sql.Connection con,
                               java.lang.String schemaName,
                               java.lang.String tableName,
                               java.lang.String outputFileName,
                               java.lang.String columnDelimeter,
                               java.lang.String characterDelimeter,
                               java.lang.String codeset)
                        throws java.sql.SQLException

SYSCS_EXPORT_TABLE system Procedure from ij or from a Java application invokes this method to perform export of a table data to a file.

Parameters:

con - The Derby database connection URL for the database containing the table

schemaName - schema name of the table data is being exported from

tableName - Name of the Table from which data has to be exported.

outputFileName - Name of the file to which data has to be exported.

columnDelimeter - Delimiter that seperates columns in the output file

characterDelimeter - Delimiter that is used to quoate non-numeric types

codeset - Codeset that should be used to write the data to the file

Throws:

java.sql.SQLException - on errors

exportTable

public static void exportTable(java.sql.Connection con,
                               java.lang.String schemaName,
                               java.lang.String tableName,
                               java.lang.String outputFileName,
                               java.lang.String columnDelimeter,
                               java.lang.String characterDelimeter,
                               java.lang.String codeset,
                               java.lang.String lobsFileName)
                        throws java.sql.SQLException

SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE system procedure from ij or from a Java application invokes this method to perform export of a table data to a file. Large object data is exported to a different file and the reference to it is stored in the main output file.

Parameters:

con - The Derby database connection URL for the database containing the table

schemaName - schema name of the table data is being exported from

tableName - Name of the Table from which data has to be exported.

outputFileName - Name of the file to which data has to be exported.

columnDelimeter - Delimiter that seperates columns in the output file.

characterDelimeter - Delimiter that is used to quote non-numeric types.

codeset - Codeset that should be used to write the data to the file/

lobsFileName - Name of the file to which large object data has to be exported.

Throws:

java.sql.SQLException - on errors

exportQuery

public static void exportQuery(java.sql.Connection con,
                               java.lang.String selectStatement,
                               java.lang.String outputFileName,
                               java.lang.String columnDelimeter,
                               java.lang.String characterDelimeter,
                               java.lang.String codeset)
                        throws java.sql.SQLException

SYSCS_EXPORT_QUERY system Procedure from ij or from a Java application invokes this method to perform export of the data retrieved by select statement to a file.

Parameters:

con - The Derby database connection URL for the database containing the table

selectStatement - select query that is used to export the data

outputFileName - Name of the file to which data has to be exported.

columnDelimeter - Delimiter that seperates columns in the output file

characterDelimeter - Delimiter that is used to quiote non-numeric types

codeset - Codeset that should be used to write the data to the file

Throws:

java.sql.SQLException - on errors

exportQuery

public static void exportQuery(java.sql.Connection con,
                               java.lang.String selectStatement,
                               java.lang.String outputFileName,
                               java.lang.String columnDelimeter,
                               java.lang.String characterDelimeter,
                               java.lang.String codeset,
                               java.lang.String lobsFileName)
                        throws java.sql.SQLException

SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE system Procedure from ij or from a Java application invokes this method to perform export of the data retrieved by select statement to a file. Large object data is exported to a different file and the reference to it is stored in the main output file.

Parameters:

con - The Derby database connection URL for the database containing the table

selectStatement - select query that is used to export the data

outputFileName - Name of the file to which data has to be exported.

columnDelimeter - Delimiter that seperates columns in the output file

characterDelimeter - Delimiter that is used to quote non-numeric types

codeset - Codeset that should be used to write the data to the file

lobsFileName - Name of the file to which large object data has to be exported.

Throws:

java.sql.SQLException - on errors

stringifyObject

public static java.lang.String stringifyObject(java.lang.Object udt)
                                        throws java.lang.Exception

Throws:

java.lang.Exception