diff options
author | Andreas Fitzek <andreas.fitzek@iaik.tugraz.at> | 2014-12-01 12:23:47 +0100 |
---|---|---|
committer | Andreas Fitzek <andreas.fitzek@iaik.tugraz.at> | 2014-12-02 10:09:35 +0100 |
commit | e929b5f4c6d9351b29150e6c1843f06806ee7b00 (patch) | |
tree | c6ecc4e5f6c3da6ef381a3d852c0a2211ca060e2 /pdf-as-web-db/src/main/java/at/gv/egiz/pdfas/web/store/DBRequestStore.java | |
parent | 6398c85d80213f316dd0f9e4be10e34b54b1f5f9 (diff) | |
download | pdf-as-4-e929b5f4c6d9351b29150e6c1843f06806ee7b00.tar.gz pdf-as-4-e929b5f4c6d9351b29150e6c1843f06806ee7b00.tar.bz2 pdf-as-4-e929b5f4c6d9351b29150e6c1843f06806ee7b00.zip |
added status servlet to pdf-as-web
Diffstat (limited to 'pdf-as-web-db/src/main/java/at/gv/egiz/pdfas/web/store/DBRequestStore.java')
-rw-r--r-- | pdf-as-web-db/src/main/java/at/gv/egiz/pdfas/web/store/DBRequestStore.java | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/pdf-as-web-db/src/main/java/at/gv/egiz/pdfas/web/store/DBRequestStore.java b/pdf-as-web-db/src/main/java/at/gv/egiz/pdfas/web/store/DBRequestStore.java index a1b88270..df006f02 100644 --- a/pdf-as-web-db/src/main/java/at/gv/egiz/pdfas/web/store/DBRequestStore.java +++ b/pdf-as-web-db/src/main/java/at/gv/egiz/pdfas/web/store/DBRequestStore.java @@ -64,6 +64,29 @@ public class DBRequestStore implements IRequestStore { } } + public void cleanOldRequestException() { + int seconds = WebConfiguration.getDBTimeout(); + Calendar calendar = Calendar.getInstance(); + calendar.add(Calendar.SECOND, (-1)* seconds); + Date date = calendar.getTime(); + SimpleDateFormat dt = new SimpleDateFormat("yyyy-mm-dd hh:mm:ss"); + logger.info("Clearing Entries before: " + dt.format(date)); + Session session = null; + Transaction tx = null; + try { + session = sessions.openSession(); + tx = session.beginTransaction(); + Query query = session.createQuery("delete from Request as req" + + " where req.created < :date"); + query.setCalendar("date", calendar); + query.executeUpdate(); + } finally { + if(session != null) { + session.close(); + } + } + } + public String createNewStoreEntry(PDFASSignRequest request) { // Clean Old Requests this.cleanOldRequests(); |