Changes

Develope Develop an adapter to enable NexJ Express model to interact with PostgreSQL database. ===Contributors===* [[User:Gbatumbya|Grace Batumbya]]* [[Minooz/Projects | Minoo Ziaei]]* [[User:AnastasiaS | Anastasia Semionova]]

== Current Status=Supported PostgreSQL Versions===* 8.4+

!align="left" style="background-color:OrangeSteelBlue; font-weight:bold;border-style:solid;border-width:thin;padding: 2px 2px 2px 2px;"| 6-10 Dec Nov 2010

* Going through NexJ MySQL databaseSQLAdapter (src, test) and SQLSchemaManager (src, test) classes are extended to create PostgreSQL classes* Learning about Differences between Proper PostgreSQL Driver is installed.* Postgre package url for XADataSource is added to the related files.* cofig and MySQLconnection files are modified based on Postgre properties* Application is now connected to the Postgre database.

=== Phase 1: Design Requirements Investigation (DONE) ===

* Organize list of requirements and set Walk-through the task list for each part needed code* Familiarization with PostgreSQL === Phase 2: Connect to PostgreSQL server (DONE) ===* [[NexJ_Express_Connecting_to_PostgreSQL| Connect to be donePostgreSQL server]] === Phase 3: PostgreSQLSchemaManager (DONE) ===* Estimated Duration: 3 weeks (Jan 17 - Feb 11, 2011)* [[PostgreSQL Adapter-nexj/extendingSchemaManager | Extending SQLSchemaManager ]] === Phase 4: PostgreSQLAdapter (DONE)===* Estimated Duration: 3 weeks (Feb 14 - 25, 2011)* [[PostgreSQL_Adapter-nexj/extendingSQLAdapter | Extending SQLAdapter ]] ===Phase 5: PostgreSQL UnitTests and Optimization (DONE) ===* Estimated Duration: 2 weeks (Feb 28 - Mar 11, 2016)* Add database specific tests fostr PostgreSQL*:test for required contrib scripts*:testfor custom blob read & write functions* Add PostgreSQL specific optimization ===Phase 6: Megre Code with Latest Revision (DONE) ===* Merge code with lastest revision from http://mercurial.nexj.com/express ===Phase 7: Test with NexJ Express Studio (DONE) ===* Estimated duration: Mar 7- Apr 14, 2011* Run model in Express studio using the postgresql adapter* create scripts for database initialization, creation and dumping* create scripts for JBoss* Deploy to JBoss === Phase 8: Code Review 1 - Meeting (DONE) ===* Date: Apr 20,2011 * Meet with NexJ Developer to review code === Phase 9: Code Review 1 - Apply Changes (DONE) ===* Estimated Duration: Apr 20, 2011 - July 1, 2011* [[PostgreSQL_Adapter_Project_-env _Code_Review_1_Changes | Changes to be made]] === Phase 10: Code Review 2 (DONE) ===* Send code for review* === Phase 11: Code Review 2 - Apply Changes (DONE) ===* Estimated Duration: July 7, 2011 - July 15, 2011* [[PostgreSQL_Adapter_Project_-_Code_Review_2_Changes | Changes to be made]] === Phase 12: Code Review 3 (DONE) ===* Sent code for code review 3* https://bitbucket.org/gbatumbya/postgresql_external/src/08cdedb9d071/ === Phase 13: Code Review 3 - Apply Changes (DONE) ===* Upgrade to lastest 7.1 branch* Create Statement and PreparedStatementProxy* Create Test EnvironmentPostgreSQLPreparedStatementProxy:** implement set/getQueryTimeout** move custom timeout code into this proxy* Override prepareStatement in PostgreSQL to return PostgreSQLPreparedStatementProxy* Implement implicit save points for statements within a transaction block* Modify readSchema to use addColumn for reading columns from the database** Remove MSSQL and Oracle specific code from addColumn** Override addColumn in PostgreSQL for text, bytea and lo types === Phase 14: Integration Tests (DONE) ===* Run Integration tests against the Adapter === Phase 15: Code Review 4 (DONE)===* Code review with framework architect* https://bitbucket.org/gbatumbya/postgresql_external/src/6c9a7380c8fe === Phase 16: Code Review 4 - Apply Changes (DONE) ===* Estimated Duration: Sep 9 - Sep 12* [[PostgreSQL_Adapter_Project_-_Code_Review_4_Changes | Changes to be made]] === Phase 17: Code Review 5 (DONE) ===* Submitted code for review on Sep 20.* https://bitbucket.org/gbatumbya/postgresql_external/src/a0d10ef7cdbe/ === Phase 18: Code Review 5 - Apply Changes (DONE) === === Phase 19: Code Review 6 ===* Date: Oct 13* Submitted for code review* https://bitbucket.org/gbatumbya/postgresql_external/src/153aec847d54/   == Project Repository ==* URL for central repository of the project is: https://bitbucket.org/gbatumbya/nexjexpress-postgresqladapter * Steps to work with the repository :1- Follow the [https://www.projects.openhealthtools.org/sf/docman/do/downloadDocument/projects.oht_aip/docman.root.nexj_studio_express_v7_1_113_0/doc1783/1 instructions to create the NexJ Express workspace ].:2- After creating 'ws' directory,::open Eclipse and::click on '''File -> Import -> Mercurial -> Clone Existing Mercurial Repository''':: Enter this information:::: '''URL''': https://bitbucket.org/gbatumbya/nexjexpress-postgresqladapter<!--:3- The central repository's structure is::: Main branch called 'default' :: Branches for:4- After cloning the project, follow these steps to add a new branch with your user name::: First make sure the active branch is 'default'. Notice the top of the Package Explorer e.g. ''core[5:b8b2f102343@'''default'''(tip)]'':: Right click on 'core' in the Package Explorer:: Click on 'Team' -> Add Branch:: Enter the branch name in the box -> Finish:: Enter the commit message -> OK:: Check the 'Force Push' if applicable.:: Now the branch name at the top of Package Explorer is changed to the new branch name. : 5- To switch to a different branch, choose 'Switch' instead of 'Add Branch'

===Phase 2: Coding ===* '''List of TasksNOTE!'''To avoid any conflict, do the 'Pull'# implementation of [[ PostgreSQL_Adapter-nexj/Adapter | PostgreSQLAdapterevery day and before any push.java ]]# implementation * '''NOTE!''' First just 'Commit' changesets and do not 'Push' them until the end of [[ PostgreSQL_Adapter-nexj/AdapterTest | PostgreSQLAdapterTestthe day or the time you are confident by latest changes to the code, then 'Push' them all at once and 'Merge' them with the 'default' branch in central repository.java ]]# implementation of [[ PostgreSQL_Adapter-nexj/SchemaManger | PostgreSQLSchemaManager.java ]]# implementation of [[ PostgreSQL_Adapter-nexj/Upgrade | main.upgrade ]]>