java.lang.Object
org.apache.derby.impl.load.ExportAbstract
org.apache.derby.impl.load.Export
- public class Export
- extends ExportAbstract
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 |
protected void |
doAllTheWork()
|
private void |
doExport()
|
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 |
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. |
protected ControlInfo |
getControlFileReader()
|
protected ExportWriteDataAbstract |
getExportWriteData()
For internal use only |
java.lang.String[] |
getOneRowAtATime(java.sql.ResultSet rs)
|
protected java.sql.ResultSet |
resultSetForEntity()
|
| Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
outputFileName
private java.lang.String outputFileName
controlFileReader
protected ControlInfo controlFileReader
exportResultSetForObject
protected ExportResultSetForObject exportResultSetForObject
exportWriteData
protected ExportWriteDataAbstract exportWriteData
con
protected java.sql.Connection con
entityName
protected java.lang.String entityName
schemaName
protected java.lang.String schemaName
selectStatement
protected java.lang.String selectStatement
Export
private Export(java.sql.Connection con,
java.lang.String schemaName,
java.lang.String tableName,
java.lang.String selectStatement,
java.lang.String outputFileName,
java.lang.String characterDelimeter,
java.lang.String columnDelimeter,
java.lang.String codeset)
throws java.sql.SQLException
doExport
private void doExport()
throws java.sql.SQLException
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.
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.
getExportWriteData
protected ExportWriteDataAbstract getExportWriteData()
throws java.lang.Exception
- For internal use only
- Specified by:
getExportWriteData in class ExportAbstract
resultSetForEntity
protected java.sql.ResultSet resultSetForEntity()
throws java.lang.Exception
getOneRowAtATime
public java.lang.String[] getOneRowAtATime(java.sql.ResultSet rs)
throws java.lang.Exception
getControlFileReader
protected ControlInfo getControlFileReader()
doAllTheWork
protected void doAllTheWork()
throws java.lang.Exception