Package com.art.anette.client.database

Examples of com.art.anette.client.database.ClientDB.execute()


            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()));
View Full Code Here


        } 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()));
View Full Code Here

            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()));
View Full Code Here

                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()));
View Full Code Here

                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) {
View Full Code Here

                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);
View Full Code Here

                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) {
View Full Code Here

                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);
View Full Code Here

                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);
            }
View Full Code Here

TOP
Copyright © 2018 www.massapi.com. 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.