Topcoder - Update Forums EJB to Use PostgreSQL Instead of Informix

Register
Submit a solution
The challenge is finished.

Challenge Overview

Previously in challenge Create PostgreSQL Schema And Tool For Migrate Data From Informix Database, we have worked out the solution to create PostgreSQL schema according to the current informix schema.

For this challenge, we'd like to utilize the PostgreSQL schema and migrate the Forums EJB to use PostgreSQL instead informix.

General Requirements

1. use the migration tool to create the PostgreSQL database.
2. Drop the common database, we are not going to use that database, if there is any dependency exists, please raise in forum.
3. Update forums EJB related Code and configurations to use PostgresSQL instead, for forums related code, you can start from this build file - https://github.com/topcoder-platform/tc-website/blob/dev/build_forums.xml
4. Since we can not fully deploy the topcoder forum, please figure out a proper way that demonstrates your changes is valid. We will test again in our dev environment, winner will be responsible to make changes.

Local Setup
- Please follow https://github.com/appirio-tech/tc-common-tutorials/tree/master/docker/tc-website to build and run

 

Final Submission Guidelines

- Code Changes
- Verification Steps

ELIGIBLE EVENTS:

Topcoder Open 2019

Review style

Final Review

Community Review Board

Approval

User Sign-Off

ID: 30075842