import com.webobjects.foundation.*;

import com.webobjects.appserver.*;

import com.webobjects.eocontrol.*;

import com.webobjects.eoaccess.*;

import java.util.*;

public class Application extends WOApplication {

    public static void main(String argv[]) {

        WOApplication.main(argv, Application.class);

    }

    public Application() {

        super();

        System.out.println("Welcome to " + this.name() + "!");

        setupDatabaseChannelCloserTimer();

    }

    public void setupDatabaseChannelCloserTimer() {

        Timer timer = new Timer(true);

        //Close open database connections every four hours.

        timer.scheduleAtFixedRate(new DBChannelCloserTask(), new Date(), 14400);

    }

    class DBChannelCloserTask extends TimerTask {

     public DBChannelCloserTask() {

      super();

     }

      public void run() {

       closeDatabaseChannels();

       NSLog.out.appendln("running timer");

      }

      public void closeDatabaseChannels() {

       int i, contextCount, j, channelCount;

       NSArray databaseContexts;

       EOObjectStoreCoordinator coordinator;

       coordinator =

       (EOObjectStoreCoordinator)EOObjectStoreCoordinator.defaultCoordinator();

       databaseContexts = coordinator.cooperatingObjectStores();

       contextCount = databaseContexts.count();

       //Iterate through all an app’s cooperating object stores (database contexts).

       for (i = 0; i < contextCount; i++) {

        NSArray channels =

         ((EODatabaseContext)databaseContexts.objectAtIndex(i)).registeredChannels();

        channelCount = channels.count();

          for (j = 0; j < channelCount; j++) {

          //Make sure the channel you're trying to close isn't performing a transaction.

          if (!((EODatabaseChannel)channels.objectAtIndex(j)).adaptorChannel().

            adaptorContext().hasOpenTransaction()) {

             ((EODatabaseChannel)channels.objectAtIndex(j)).adaptorChannel().

              closeChannel();

           }

          }

        }

      }

    }

}