Maven Build Scripts

Competition Task Overview

We have a project that uses maven to build the code and run tests, and we'd like to make some enhancements to the build script.

Our client uses Team City and we want to run the build and tests seamlessly from the environment:

1. The team city environment will be passing the following Maven command line parameters.  These parameters should be retrieved and used in the hibernate.cfg file file to control the data source used instead of hardcoded values:
   • -Dconnection.url=jdbc:oracle:thin:@localhost:1521:XE
   • -Dconnection.username=SASADM
   • -Dconnection.password=SASADM
2. We want to be able to call the SQL scripts createTables.sql, dropTables.sql, clear.sql, and testData.sql scripts seamelessy from maven so that during build and integration test execution we can control the database as needed via Team City and maven. Our code is built for an Oracle database so we want to be able to run those SQL scripts against an oracle server using maven . Probably the best way is to create a Windows bat file with the sqlplus commands in them and provide options in maven to fire off the scripts via the cmd.exe in windows. Examples:
   • sqlplus SASADM/SASADM@XE @sql/dropTables.sql
   • sqlplus SASADM/SASADM@XE @sql/createTables.sql

Technology Overview

• Maven
• Java
• Oracle

Documentation Provided

Register to download documents / code from challenge forum.

Final Submission Guidelines

Submission Deliverables

• Updated maven build scripts that meets the requirements
• Simple instructions on how to test your submission

Final Submission

For each member, the final submission should be uploaded to the Online Review Tool.