Challenge Overview
Competition Task Overview
SAS is a web application that supports management of service activities, it's currently working well and it's using an Oracle database.
In this challenge, we'd like to do the following:
- Add a new maven profile that supports targeting Postgres (v9.2.4) as database in addition to Oracle. The maven profile for Postgres should trigger the generation of the correct SQL, connection strings, etc.
- Make sure it's easy to switch between Oracle / Postgres if we need to, note you can assume we'll also implement JNDI resources for the Postgres data source and email connections so no changes should be needed there
- Provide new SQL scripts / Hibernate mapping files to support Postgres SQL
- Properly structure the folders so it's easy to tell which are for Oracle and which are for Postgres SQL
- Provide new deployment guide (with verification details) for Postgres SQL
- Make sure all unit tests still work
Testing
No unit tests should be broken, they should all work with Postgres and Oracle after the changes.
Technology Overview
- Java
- JSP
- Postgres 9.2.4
- Maven
Documentation Provided
Existing code will be provided in challenge forum.
Final Submission Guidelines
Submission Deliverables
A complete list of deliverables can be viewed in the TopCoder Assembly competition Tutorial at: http://apps.topcoder.com/wiki/display/tc/Assembly+Competition+Tutorials
Below is an overview of the deliverables:
- Updated code that covers all requirements
- A complete and detailed deployment documented explaining how to deploy the application including configuration information.
- Existing JUnit tests must still work.
- The maven build script to create the war files.
Final Submission
For each member, the final submission should be uploaded via the challenge detail page on topcoder.com