PostgreSQL Adapter

PostgreSQL Adapter for NexJ

Project Goal

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

Current Status

• Walk through parts of code related to SQLadapter, SqlSchemaManger and setup scripts in NexJ Express code
• Going through NexJ MySQL database
• Learning about Differences between PostgreSQL and MySQL

Project Phases

Phase 1: Design Requirements

• Get requirements from NexJ (Meeting on Friday Nov 5th)
• Organize list of requirements and set the task list for each part needed to be done
• Create Test Environment

Create the JUnit test environment for PostgreSQL

1- Setup the postgresql-connection

Configure the work/ws/core/bin/nexj/default.config

Configure the work/ws/core/test/nexj/default.config

Configure the work/ws/core/bin/nexj/postgresql.connection

Configure the work/ws/core/test/nexj/postgresql.connection

2- Add PostgreSQL database to related java files

SQLSchemaMangerFactory.java

3- Create the extended PostgreSQL source files

PostgreSQLAdapter.java

PostgreSQLSchemaManger.java

4- Create the extended PostgreSQL test files

PostgreSQLAdapterTest.java

PostgreSQLSchemaMangerTest.java

Phase 2: Coding

• List of Tasks

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

Resources

Concept of Adapter [1] FOSSLC PostgreSQL

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