IMPORTANT: While reasonably stable, the JAMWiki code is undergoing rapid development and should be considered beta software, not suitable for deployment on production systems. Also note that this version changes the database schema used in previous versions - see below for upgrade instructions.
JAMWiki 0.0.7 is now available for download as a WAR file suitable for deployment on a web application server. This release includes a new default look & feel, support for the Websphere application server, an update of the topic locking code, along with numerous code cleanups and bug fixes. See the changelog for a more complete list of changes and fixes.
To install the file simply deploy it like any other WAR file, restart the web application server, and then view the URL http://www.yourserver.com/context/ to begin the configuration process (context is the web application context root).
See the README.txt and CHANGELOG.txt files for additional details about this release. Additional information and documentation can be found at http://jamwiki.org/.
To upgrade from JAMWiki 0.0.6, run the following SQL commands to update the database:
DROP database jam_notification; alter table jam_topic drop constraint jam_fk_topic_locked_by; alter table jam_topic drop column topic_locked_by; alter table jam_topic drop column topic_lock_date; alter table jam_topic drop column topic_lock_session_key; /* change columns from CHAR to INTEGER */ alter table jam_wiki_user add column is_admin_new INTEGER DEFAULT 0 NOT NULL; update jam_wiki_user set is_admin_new = 1 where is_admin = '1'; alter table jam_wiki_user drop column is_admin; alter table jam_wiki_user rename column is_admin_new to is_admin; alter table jam_topic add column topic_deleted_new INTEGER DEFAULT 0 NOT NULL; update jam_topic set topic_deleted_new = 1 where topic_deleted = '1'; alter table jam_topic drop column topic_deleted; alter table jam_topic rename column topic_deleted_new to topic_deleted; alter table jam_topic add column topic_read_only_new INTEGER DEFAULT 0 NOT NULL; update jam_topic set topic_read_only_new = 1 where topic_read_only = '1'; alter table jam_topic drop column topic_read_only; alter table jam_topic rename column topic_read_only_new to topic_read_only; alter table jam_topic add column topic_admin_only_new INTEGER DEFAULT 0 NOT NULL; update jam_topic set topic_admin_only_new = 1 where topic_admin_only = '1'; alter table jam_topic drop column topic_admin_only; alter table jam_topic rename column topic_admin_only_new to topic_admin_only; alter table jam_file add column file_deleted_new INTEGER DEFAULT 0 NOT NULL; update jam_file set file_deleted_new = 1 where file_deleted = '1'; alter table jam_file drop column file_deleted; alter table jam_file rename column file_deleted_new to file_deleted; alter table jam_file add column file_read_only_new INTEGER DEFAULT 0 NOT NULL; update jam_file set file_read_only_new = 1 where file_read_only = '1'; alter table jam_file drop column file_read_only; alter table jam_file rename column file_read_only_new to file_read_only; alter table jam_file add column file_admin_only_new INTEGER DEFAULT 0 NOT NULL; update jam_file set file_admin_only_new = 1 where file_admin_only = '1'; alter table jam_file drop column file_admin_only; alter table jam_file rename column file_admin_only_new to file_admin_only;
To use the new default stylesheet, edit the "StyleSheet" topic in JAMWiki and paste in the contents of the /WEB-INF/classes/StyleSheet.txt file.