Package com.art.anette.client.database

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

192
193
194
195
196
197
198
199
200
201
202
            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
193
194
195
196
197
198
199
200
201
202
203
        } 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
194
195
196
197
198
199
200
201
202
203
204
            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
195
196
197
198
199
200
201
202
203
204
205
                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
196
197
198
199
200
201
202
203
204
205
206
                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
197
198
199
200
201
202
203
204
205
206
207
                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
198
199
200
201
202
203
204
205
206
207
208
                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
199
200
201
202
203
204
205
206
207
208
209
                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
200
201
202
203
204
205
206
207
208
209
210
                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.