PostgreSQL Adapter

PostgreSQL Adapter for NexJ

Project Goal

Develope an adapter to enable NexJ Express model to interact with PostgreSQL database

Current Status

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

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.

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

Create Test Environment

Phase 3: Test first design

Running AllTests.java

1- Create a PostgreSQL database through some scripts
2- Working inside Schema 'test'

2.a- Initilizaing the SQL Environment

2.b- Working with Database Structure - DDL

2.c- Working with Data in a Table - DML

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.

Project Repository

URL for central repository of the project is: http://liberia.proximity.on.ca:81/

Steps to work with the repository

1- Follow the 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 these information:

URL: ssh://liberia.proximity.on.ca/mercurial/postgreSQL/core

Username: developer

Clone directory name: core

Resources

Intro

Concept of Adapter [1]

FOSSLC PostgreSQL

CDOT Wiki β