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.

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 2: Coding

• List of Tasks

1. implementation of PostgreSQLAdapter.java
2. implementation of PostgreSQLAdapterTest.java
3. implementation of PostgreSQLSchemaManager.java
4. implementation of main.upgrade

Resources

• Intro

Concept of Adapter [1]

FOSSLC PostgreSQL

• Java
• Database & Persistence
• JDBC
• PostgreSQL Specifications
• MySQL Specifications
• Postgre - MySQL Compare