1,234
edits
Changes
no edit summary
{{Admon/obsolete}}
<big><big> PostgreSQL Adapter for NexJ </big></big>
{{NexJ_Express Index}}
[[category: NexJ Current Past Projects]]
[[category: NexJ Express PostgreSQL]]
== Project Goal==
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]] === Supported PostgreSQL Versions===* 8.4* 9.0+
== Current Status==
* Phase 9'''Completed''' (October 21, 2011)* Get the last PostgreSQL adapter source code from http://mercurial.nexj.com/express.cgi/core
<!--{|class="collapsible collapsed" style="border-style:solid;border-width:thin;border-color:black"
* Deploy to JBoss
=== Phase 8: Code Review 1 - Meeting (DoneDONE) ===
* Date: Apr 20,2011
* Meet with NexJ Developer to review code
=== Phase 9: Code Review 1 - Apply Changes (DONE) ===* Estimated Duration: Apr 20, 2011 - May 13July 1, 20012011* Apply [[PostgreSQL_Adapter_Project_-_Code_Review_1_Changes | Changes to be made]] === Phase 10: Code Review 2 (DONE) ===* Send code for review changes* === 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 PostgreSQLPreparedStatementProxy:** 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/postgresql_externalnexjexpress-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 from the manual].
:2- After creating 'ws' directory,
::open Eclipse and
::click on '''File -> Import -> Mercurial -> Clone Existing Mercurial Repository'''
:: Enter this information:
::: '''URL''': http://liberia.proximity.on.ca:81/PostgreSQL%20Adapter OR https://bitbucket.org/gbatumbya/postgresql_externalnexjexpress-postgresqladapter<!--
:3- The central repository's structure is:
:: Main branch called 'default'
:: New branch or branches with this naming convention: 'wsComitter' e.g. 'wsMinoo'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)]''
* '''NOTE!''' To avoid any conflict, do the 'Pull' every day and before any push.
* '''NOTE!''' First just 'Commit' changesets and do not 'Push' them until the end of the 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.
-->
== Resources ==
* Downloads
Linux binaries http://www.openscg.org/se/postgresql/packages.jsp
* Debugging
:[[Run_Junit_Tests_For_Non_Default_SQL_Adapter | Unit Testing for non Default SQL Adapter]]
* [[PostgreSQL_Adapter-nexj/Resources#MySQL_Specifications | MySQL Specifications]]
* [[PostgreSQL_Adapter-nexj/Resources#PostgreSQL_-_MySQL_Compare | Postgre - MySQL Compare]]
== Summary of Applied Research ==
* [[Research Findings - PostgreSQLAdapter]]
* [[Research Notes - PostgreSQLAdapter]]
