Class 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.
    • Constructor Summary

      Constructors 
      Modifier Constructor Description
      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)  
    • Method Summary

      All Methods Static Methods Instance Methods Concrete Methods 
      Modifier and Type Method Description
      private boolean dataFileExists​(java.lang.String fileName)
      Checks whether the data file exists .
      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 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.
      private boolean fileExists​(java.io.File file)
      Checks if the specified file exists.
      protected ExportWriteDataAbstract getExportWriteData()
      For internal use only
      private boolean lobsFileExists​(java.lang.String fileName)
      Checks whether the lobs file exists .
      private void setLobsExtFileName​(java.lang.String lobsFileName)
      Set the file name to which larg object data has to be exported, and also set flag to indicate that large objects are exported to a different file.
      • Methods inherited from class java.lang.Object

        clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
    • Field Detail

      • outputFileName

        private java.lang.String outputFileName
      • lobsFileName

        private java.lang.String lobsFileName
    • Constructor Detail

      • 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
        Throws:
        java.sql.SQLException
    • Method Detail

      • doExport

        private void doExport()
                       throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • setLobsExtFileName

        private void setLobsExtFileName​(java.lang.String lobsFileName)
                                 throws java.sql.SQLException
        Set the file name to which larg object data has to be exported, and also set flag to indicate that large objects are exported to a different file.
        Parameters:
        lobsFileName - the file to to which lob data has to be exported.
        Throws:
        java.sql.SQLException - if file name is null.
      • lobsFileExists

        private boolean lobsFileExists​(java.lang.String fileName)
                                throws java.sql.SQLException
        Checks whether the lobs file exists .
        Parameters:
        fileName - the file to to which lob data has to be exported.
        Throws:
        java.sql.SQLException - if file name is null.
      • dataFileExists

        private boolean dataFileExists​(java.lang.String fileName)
                                throws java.sql.SQLException
        Checks whether the data file exists .
        Parameters:
        fileName - the file to to which lob data has to be exported.
        Throws:
        java.sql.SQLException - if file name is null.
      • fileExists

        private final boolean fileExists​(java.io.File file)
        Checks if the specified file exists.
        Parameters:
        file - the file to check
        Returns:
        true if the file exists, false if not.
        Throws:
        java.lang.SecurityException - if the required privileges are missing
      • 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