1
edit
Changes
Created page with '<big><big> PostgreSQL Adapter for NexJ </big></big> {{MinNexJ_Express Index}} == Project Goal== Develope an adapter to enable NexJ Express model to interact with PostgreSQL data…'
<big><big> PostgreSQL Adapter for NexJ </big></big>
{{MinNexJ_Express Index}}
== Project Goal==
Develope an adapter to enable NexJ Express model to interact with PostgreSQL database
== Current Status==
{|class="collapsible collapsed" style="border-style:solid;border-width:thin;border-color:black"
!align="left" style="background-color:SteelBlue; font-weight:bold;border-style:solid;border-width:thin;padding: 2px 2px 2px 2px;"| Dec 2010
|-
|
* Database 'test' is created in Postgre.
* sample table 'mutex' is created for testing the connection properties.
* No need for SET SQL mode in Postgre
* Creating tables in process
* Tables are created.
* Creating indexes and triggers in process
|}
{|class="collapsible collapsed" style="border-style:solid;border-width:thin;border-color:black"
!align="left" style="background-color:SteelBlue; font-weight:bold;border-style:solid;border-width:thin;padding: 2px 2px 2px 2px;"| Nov 2010
|-
|
* Walk through parts of code related to SQLadapter, SqlSchemaManger and setup scripts in NexJ Express code
* SQLAdapter (src, test) and SQLSchemaManager (src, test) classes are extended to create PostgreSQL classes
* Proper PostgreSQL Driver is installed.
* Postgre package url for XADataSource is added to the related files.
* cofig and connection files are modified based on Postgre properties
* Application is now connected to the Postgre database.
|}
* [[PostgreSQL_Adapter-nexj/test-env/todo |TODOs]]
==Project Phases==
=== Phase 1: Investigation ===
* Get requirements from NexJ (Meeting on Friday Nov 5th)
* Walk-through the code
* Familiarization with PostgreSQL
=== Phase 2: Connect to PostgreSQL===
* [[PostgreSQL_Adapter-nexj/test-env | Create Test Environment]]
=== Phase 3: Test first design ===
* 1- [[PostgreSQL_Adapter-nexj/scripts | Create a PostgreSQL database through some scripts]]
* 2- [[PostgreSQL_Adapter-nexj/schema-test | Working inside Schema 'test']]
===Phase 4: Test properties specific to PostgreSQL ===
* Add test cases that are specific to PostgreSQL database
=== Phase 5: Optimization===
*After implementation is done, optimizing the modified files.
== Resources ==
* Intro
:Concept of Adapter [http://www.vogella.de/articles/DesignPatternAdapter/article.html]
:FOSSLC [http://www.fosslc.org/drupal/category/community/databases/postgresql PostgreSQL]
* [[PostgreSQL_Adapter-nexj/Resources#Java | Java ]]
* [[PostgreSQL_Adapter-nexj/Resources#Database_.26_Persistence | Database & Persistence]]
* [[PostgreSQL_Adapter-nexj/Resources#JDBC | JDBC]]
* [[PostgreSQL_Adapter-nexj/Resources#PostgreSQL Specifications | PostgreSQL Specifications]]
* [[PostgreSQL_Adapter-nexj/Resources#MySQL_Specifications | MySQL Specifications]]
* [[PostgreSQL_Adapter-nexj/Resources#PostgreSQL_-_MySQL_Compare | Postgre - MySQL Compare]]
{{MinNexJ_Express Index}}
== Project Goal==
Develope an adapter to enable NexJ Express model to interact with PostgreSQL database
== Current Status==
{|class="collapsible collapsed" style="border-style:solid;border-width:thin;border-color:black"
!align="left" style="background-color:SteelBlue; font-weight:bold;border-style:solid;border-width:thin;padding: 2px 2px 2px 2px;"| Dec 2010
|-
|
* Database 'test' is created in Postgre.
* sample table 'mutex' is created for testing the connection properties.
* No need for SET SQL mode in Postgre
* Creating tables in process
* Tables are created.
* Creating indexes and triggers in process
|}
{|class="collapsible collapsed" style="border-style:solid;border-width:thin;border-color:black"
!align="left" style="background-color:SteelBlue; font-weight:bold;border-style:solid;border-width:thin;padding: 2px 2px 2px 2px;"| Nov 2010
|-
|
* Walk through parts of code related to SQLadapter, SqlSchemaManger and setup scripts in NexJ Express code
* SQLAdapter (src, test) and SQLSchemaManager (src, test) classes are extended to create PostgreSQL classes
* Proper PostgreSQL Driver is installed.
* Postgre package url for XADataSource is added to the related files.
* cofig and connection files are modified based on Postgre properties
* Application is now connected to the Postgre database.
|}
* [[PostgreSQL_Adapter-nexj/test-env/todo |TODOs]]
==Project Phases==
=== Phase 1: Investigation ===
* Get requirements from NexJ (Meeting on Friday Nov 5th)
* Walk-through the code
* Familiarization with PostgreSQL
=== Phase 2: Connect to PostgreSQL===
* [[PostgreSQL_Adapter-nexj/test-env | Create Test Environment]]
=== Phase 3: Test first design ===
* 1- [[PostgreSQL_Adapter-nexj/scripts | Create a PostgreSQL database through some scripts]]
* 2- [[PostgreSQL_Adapter-nexj/schema-test | Working inside Schema 'test']]
===Phase 4: Test properties specific to PostgreSQL ===
* Add test cases that are specific to PostgreSQL database
=== Phase 5: Optimization===
*After implementation is done, optimizing the modified files.
== Resources ==
* Intro
:Concept of Adapter [http://www.vogella.de/articles/DesignPatternAdapter/article.html]
:FOSSLC [http://www.fosslc.org/drupal/category/community/databases/postgresql PostgreSQL]
* [[PostgreSQL_Adapter-nexj/Resources#Java | Java ]]
* [[PostgreSQL_Adapter-nexj/Resources#Database_.26_Persistence | Database & Persistence]]
* [[PostgreSQL_Adapter-nexj/Resources#JDBC | JDBC]]
* [[PostgreSQL_Adapter-nexj/Resources#PostgreSQL Specifications | PostgreSQL Specifications]]
* [[PostgreSQL_Adapter-nexj/Resources#MySQL_Specifications | MySQL Specifications]]
* [[PostgreSQL_Adapter-nexj/Resources#PostgreSQL_-_MySQL_Compare | Postgre - MySQL Compare]]