NexJ Express Connecting to PostgreSQL

PostgreSQL Adapter for NexJ - Create Test Environment

1- Setup the postgresql-connection

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

• TODOs
• Files to configure based on PostgreSQL properties

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

test

AllTests.java

PostgreSQLAdapterTest.java

PostgreSQLSchemaManagerTest.java

default.config

postgresql.connection

filestorage.connections

filestoragefragment.connections

Script

• Done

Installed the JDBC3 Postgresql Driver, Version 9.0-801 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

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

Configured system.dstype

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

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

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

Configured Driver type and some other properties in JDBCInfo.java

Configured : SQLSchemaManagerFactory.java

2- Create a PostgreSQL database through some scripts

postgresql_setup.sql

3- Create the extended PostgreSQL source files

PostgreSQLAdapter.java

PostgreSQLSchemaManger.java

4- Create the extended PostgreSQL test files

PostgreSQLAdapterTest.java

PostgreSQLSchemaMangerTest.java