Package com.art.anette.client.database

Examples of com.art.anette.client.database.ClientDB


            loginData = lr;
            writeIDs();
        } catch (DBDirtyException ex) {
            try {
                logger.info("Database is dirty - cleaning and the retrying...");
                ClientDB cdb = new ClientDB(ex.getId());
                cdb.execute(SQLFormatter.generateQuery("DELETE FROM %s", Employee.getTableName()));
                cdb.execute(SQLFormatter.generateQuery("DELETE FROM %s", Project.getTableName()));
                cdb.execute(SQLFormatter.generateQuery("DELETE FROM %s", Department.getTableName()));
                cdb.execute(SQLFormatter.generateQuery("DELETE FROM %s", WorkPackage.getTableName()));
                cdb.execute(SQLFormatter.generateQuery("DELETE FROM %s", EmployeeProjectRelation.getTableName()));
                cdb.execute(SQLFormatter.generateQuery("DELETE FROM %s", EmployeeWorkPackageRelation.getTableName()));
                cdb.execute(SQLFormatter.generateQuery("DELETE FROM %s", WorkPackageDependsRelation.getTableName()));
                cdb.execute(SQLFormatter.generateQuery("DELETE FROM %s", Task.getTableName()));
                cdb.execute(SQLFormatter.generateQuery("DELETE FROM %s", Duration.getTableName()));
            } catch (SQLException ex1) {
                logger.warning("Failed reading the database!", ex1);
            } catch (IOException ex1) {
                logger.warning("Reading the database file failed!", ex1);
            }

            login(lr);
        } catch (NetworkException ex) {
            if (logins.containsKey(lr)) {
                loginData = lr;
                try {
                    long id = logins.get(lr);
                    ClientDB cdb = new ClientDB(id);
                    ResultSet rs = cdb.query(SQLFormatter.generateQuery("SELECT * FROM %s WHERE id = %d", Employee.getTableName(), id));
                    if (!rs.next()) {
                        logger.warning("The login is known but not available in the local database. Raise an error to refetch from server.");
                        rs.close();
                        throw ex;
                    }
View Full Code Here

TOP

Related Classes of com.art.anette.client.database.ClientDB

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.