NexJ Express Connecting to PostgreSQL

PostgreSQL Adapter for NexJ - Connect to PostgreSQL database

Install PostgreSQL

Download: Installer version Version 9.0.1-1 from list of PostgreSQL downloads.

Install PostgreSQL JDBC3 driver

Download: JDBC3 Postgresql Driver, Version 9.0-801 @ http://jdbc.postgresql.org/download.html
Install: Copy driver to [jdk folder]/jre/lib/ext

Code: Add PostgreSQL Driver

Package: nexj.core.persistance.sql

Create PostgreSQLAdapter.java by extending SQLAdapter

Create PostgreSQLSchemaManager.java by extending SQLSchemaManager

Edit RelationalDatabase.java

Edit RelationalDatabaseFragment.java

Edit SQLSchemaManagerFactory.java

Package: nexj.core.meta.sys

Edit system.dstypes

UnitTest: Test Connectivity to database

Package: nexj.core.persistance.sql

Create PostgreSQLAdapterTest.java by extending SQLAdapterTest

Create PostgreSQLSchemaManagerTest.java by extending SQLSchemaManagerTest

Package: nexj

Create postgresql.connections using NexJ Studio

Edit default.config to use PostgreSQL

Edit all *.connections files to use PostgreSQL

TODO: find out how to configure UnitTests for more than one Database