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
Phase 2: Coding
- implementation of PostgreSQLAdapter.java
- implementation of PostgreSQLAdapterTest.java
- implementation of PostgreSQLSchemaManager.java
- implementation of main.upgrade
Resources
- Concept of Adapter [1]
- FOSSLC PostgreSQL
