wiki Deployment

Database

Download and run the database script. You should create a different database user to connect to the database. Grant the necessary rights to the database objects to this user. Create synonyms for the appropriate database objects (should be just the tables and view).

Source Code

You can download the complete JDeveloper application in a single zip file. This was written in an old version of JDeveloper (10.1.2) and should work on anything newer. It will deploy to an application server version 9.0.4. I've not tried it on anything newer, but have no reason to doubt it will work. I'd be interested to hear if it does.

Configuration

You'll have to make a few minor changes in the code to make this work properly:

• The Database class contains a url, username and password. You'll have to edit this to point to your database.
• If you use a different user above from the one you used to create the database tables, you'll need to create synonyms so that the tables and view are visible to the application.
• You'll need to edit the WIKI_USERS_VIEW to point at your own list of users.
• The logo.png file in the img folder can be over-written to show your own logo.

Deploy

A deployment profile is included in the source code. You should be able to use this to either deploy straight to the application server if you have a connection to it, or else to create an EAR file which can then be manually deployed through enterprise manager.

You (or your DBA) will have to edit the mod_osso.conf configuration file to tell the application server that access to this application should be restricted to authenticated users. An entry along the lines of this will be required (please check this - I'm a developer, not a DBA):

	<Location /wiki>
   require valid-user
   AuthType Basic
	</Location>

An http server restart will be required before this will take effect.