NexJ Express Connecting to PostgreSQL

PostgreSQL Adapter for NexJ - Connect to PostgreSQL Driver

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

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

UnitTests: 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

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

Setup the postgresql-connection

For testing the connection, the 'AllTests.java' is being used.

Installed the Installer version Version 9.0.1-1 from list of PostgreSQL downloads.

Installed the JDBC3 Postgresql Driver, Version 9.0-801 @ http://jdbc.postgresql.org/download.html and added it to the libraries in JDK

The driver class which is being used for NexJ Express Model is: org.postgresql.xa.PGXADataSource

The driver is loaded from RelationalDatabaseFragment.java and RelationalDatabase.java

Metadata is loaded from the particular driver

   /* MySQLAdapterTest.java */
      try
      {
         s_metadata = loadMetadata(ADAPTER_NAME);
      }

   /* SQLDataTest.java */
   protected static Metadata loadMetadata(String sAdapter)
   {
      Properties props = SysUtil.getConfigProperties();  // sets DEFAULT_CONFIG_URL = '/' + NAMESPACE + "/default.config"
      props = new Properties(props);
      props.setProperty(XMLMetadataLoader.CONNECTIONS_URL_PROPERTY, "/nexj/" + sAdapter.toLowerCase(Locale.ENGLISH) + ".connections");  // sets the properties to postgresql.connection

After all properties are loaded, it creates the connection through Connection Factory files.

Files to Configure

NOTE: Changes to these files are involved with 1-Port, which should be: 5432, and 2- Driver package that should change to org.postgresql.xa.PGXADataSource

src

system.dstype

DatabaseTool.java // This file calles SQLSchemaMangerFactory.java and creates the connection

RelationalDatabase.java // Sets the default properties for the supported drivers

RelationalDatabaseFragment.java // Sets the custom fragment properties for the supported drivers

Driver type and some other properties in JDBCInfo.java

SQLSchemaManagerFactory.java // Sets the connection for the particular adapter type

test

AllTests.java

default.config // change to these four files are: adapter="PostgreSQL" port="5432"

postgresql.connection

filestorage.connections

filestoragefragment.connections