Utilities

  • PostgreSQL table creation script

    Download this is you are running PostgreSQL and need to create a compatible table for use with iGroupCal. Note that this database/table will not be compatible with Group Calendar from OpusFlow. The following shows a short session with the psql command-line tool to create the database, the gcuser, and the TB_Appointments table:

    ~ % psql template1
template1=# create user gcuser createdb password 'gcuser';
template1=# \c - gcuser
template1=> create database igroupcal;
template1=> \c igroupcal
igroupcal=> \i postgresql_create_table.sql
igroupcal=> \q

    You will need to enable password-protected access to the database in the pg_hba.conf PostgreSQL configuration directory. Be sure to avoid any conflicts in previous statements in this file (thanks to Harald Fricke for this info!)

    Pure-Java JDBC drivers for PostgreSQL can be found at http://jdbc.postgresql.org.

    [up] Top...
  • MySQL table creation script

    Download this is you are running MySQL and need to create a compatible table for use with iGroupCal. Note that this database/table will not be compatible with Group Calendar from OpusFlow. The following shows a short session with the mysql command-line tool to create the database, the gcuser, and the TB_Appointments table:

    ~ % mysql -p mysql
mysql> grant all on igroupcal.* to gcuser identified by 'gcuser';
mysql> flush privileges;
mysql> create database igroupcal;
mysql> use igroupcal;
mysql> \. mysql_create_table.sql;
mysql> quit

    A pure-Java JDBC driver for MySQL can be downloaded from http://dev.mysql.com/downloads/connector/j. Instead of calling it a JDBC driver, they call it Connector/J.

    [up] Top...
  • Access database

    An empty Access database for use with both Group Calendar and iGroupCal. You will need to set up an appropriate ODBC System DSN.

    [up] Top...
  • MS SQL Server 2000 JDBC driver (currently at Service Pack 3)

    This is the free version of Microsoft's SQL Server JDBC driver. They don't support fancy stuff like bi-directional cursors, but that's okay because I wrote iGroupCal to work within the limitations of the free driver. Microsoft's End-User License Agreement forbids the redistribution of these files, so if you want to use SQL Server you'll have to download and install the driver yourself.

    At the bottom of the page above, you'll notice that you can download a windows installer (the .exe file), or a tar file (mssqlserver.tar). It's up to you of course, but I'd recommend the tar file since it's multi-platform (including Windows), and on windows doesn't gum up your registry and give you a few extra useless DLLs. The following steps are for the tar file:

    1. Untar the mssqlserver.tar file (WinZip or WinRar should work on Windows).
    2. Find the file msjdbc.tar file just extracted, and untar it.
    3. In the lib directory just created, find the three files
      • msbase.jar
      • mssqlserver.jar
      • msutil.jar
    4. Copy the three jar files above to the lib directory under the iGroupCal webapp folder. If you installed iGroupCal using the manager servlet deployment function, this will be ${CATALINA_BASE}/webapps/igroupcal/WEB-INF/lib. If you want to use the drivers with other servlets, you can copy the jars to ${CATALINA_BASE}/shared/lib instead.
    5. Change the iGroupCal webapp web.xml file JDBC settings to use MS SQL Server settings as described on the DB setup section of the installation page.
    6. Restart Tomcat if necessary.

    [up] Top...
  • MS SQL Server table creation script

    Download this is you are running MS SQL Server but aren't using Group Calendar. Run the script in the Query Analyzer to set up the GroupCalendar database and create the necessary tables. This script is from OpusFlow and creates a database fully compatible with Group Calendar should you decide to try out their connector in the future.

    [up] Top...
  • SQLite JDBC/JNI driver bundle for MacOS X 10.4

    A precompiled version of the SQLite JDBC driver provided by Christian Werner, who unfortunately didn't foresee people wanting to use this on MacOS X. Additional information can be found on Tim Anderson's SQLite notes page, as well as versions for MacOS X 10.3 and other platforms.

    [up] Top...