Global.writeAccessLog ()
function swaps app.data.accessLog, loops over the objects contained in Vector and inserts records for every log-entry in AV_ACCESSLOG

Sourcecode in Global/objectFunctions.js:
1:   function writeAccessLog() {
2:      if (app.data.accessLog.size() == 0)
3:         return;
4:      // first of all swap app.data.accessLog
5:      var size = app.data.accessLog.size();
6:      var log = app.data.accessLog;
7:      app.data.accessLog = new java.util.Vector(size);
8:      // open database-connection
9:      var c = getDBConnection("antville");
10:     var dbError = c.getLastError();
11:     if (dbError) {
12:        app.log("Error establishing DB connection: " + dbError);
13:        return;
14:     }
15:     // loop over log-vector
16:     var query;
17:     for (var i=0;i<log.size();i++) {
18:        var logObj = log.get(i);
19:        query = "insert into AV_ACCESSLOG (ACCESSLOG_F_SITE,ACCESSLOG_F_TEXT," +
20:           "ACCESSLOG_REFERRER,ACCESSLOG_IP,ACCESSLOG_BROWSER) values (" +
21:           logObj.siteID + "," + logObj.storyID + ",'" + logObj.referrer + "','" + logObj.remoteHost +
22:           "','" + logObj.browser + "')";
23:        c.executeCommand(query);
24:        if (dbError) {
25:           app.log("Error executing SQL query: " + dbError);
26:           return;
27:        }
28:     }
29:     app.log("wrote " + i + " referrers into database");
30:     return;
31:  }