Introduction

This project is made to facilitate making database data backups in repetitive manner (Cron) and manually restore data to tables; with java drivers you can virtually backup any RDBMS database.
With Woccoon, it's very easy to setup the database driver, choose your database and tables; Visually scheduling backups and manage them.

About the project and features

This project is an open source Java web application.

  • Zero configuration. No initial configuration is needed. simply put the woccoon.war under your servlet server and use it.
  • Very easy driver setup. Upload and configure your database driver from your web navigator.
  • Choosing tables. you can choose the entire database to backup or some tables only.
  • Time-based job scheduler. With the visual job scheduler no need to know Cron expresions.
  • Manage your backups. you can restore or delete backups.
  • Web interface. You can do all these tasks from your web browser.

Technical aspects

  • Persistence : JPA with Hibernate 3.6, Hades 2
  • Application core : Spring 3
  • Web Framework: JSF 2 with RichFaces 4 and OpenFaces 3
  • Jobs scheduler: Quartz 2
  • Web security : Spring security 3
  • Database tables backup and restore: DBUnit 2.4
  • Javascript : JQuery 1.6

Restrictions and requirements

This project requires Java SE 6 or later. To run it on Java SE 5 feel free to change the source code included in woccoon.war and recompile it.
Another restriction is that Woccoon backup only and only tables data!!, it didn't backup in any way the tables' structures (DDL).

Usage

Login page

When you connect for the first time please use the user name / password : user / user to login into the application

Drivers page

The first step to make is to configure the database driver which can be used in many backups configurations, there are two preconfigured drivers when you launch Woccoon for the first time : Mysql and Postgresql.

Configurations page

This page give you the ability to add, edit and remove backups configurations. This page is composed by three parts :

  • Database connection informations.
  • Available and selected tables.
  • Backups informations.
  • the button 'Visual Cron' : It launch an utility popup to help you scheduling your backups


Users page

This page give you the ability to add, edit and remove users accounts. Woccoon come with a default user :
name : user
password : user

Download

Date : June 13, 2011
SourceForge project download page

Author

Nabil Dridi, Senior J2EE developer, Tunisia.

Email : woccoon.feedback@gmail.com for any feedback and suggestions.

Tests

The project was tested under :

  • Tomcat V6
  • Tomcat V7
  • Jetty V7
  • GlassFish 3.1
Tested RDBMS :
  • MySql V5
  • Postgresql V8
  • Oracle 10g Express Edition
  • DB2 V9 Express Edition
  • Apache Derby V10