Class ApplicationSqlDao


  • public class ApplicationSqlDao
    extends AbstractSqlDao
    The application data access object (DAO) writes and queries the SQL database for general information about the application.
    • Field Detail

      • logger

        protected static final java.util.logging.Logger logger
    • Constructor Detail

    • Method Detail

      • writeKnownRemoteDatabases

        public void writeKnownRemoteDatabases​(java.util.List<DatabaseRemoteFile> remoteDatabases)
                                       throws java.sql.SQLException
        Writes a list of DatabaseRemoteFiles to the database using the given connection.

        Note: This method executes, but does not commit the query.

        Parameters:
        remoteDatabases - List of remote databases to write to the database
        Throws:
        java.sql.SQLException - If the SQL statement fails
      • deleteAll

        public void deleteAll()
        Deletes all metadata, including known databases.
      • shutdown

        public void shutdown()
        Shuts down the HSQL database, i.e. persists all data, closes all connections and unlocks the database for other processes.

        The command sends the SHUTDOWN SQL command.

      • readSettingAsLong

        public java.lang.Long readSettingAsLong​(java.lang.String key)
      • readSetting

        public java.lang.String readSetting​(java.lang.String key)
      • writeSetting

        public void writeSetting​(java.lang.String key,
                                 java.lang.String value)