Difference between revisions of "NexJ Express Connecting to PostgreSQL"

From CDOT Wiki
Jump to: navigation, search
Line 7: Line 7:
 
: Configure the work/ws/core/bin/nexj/postgresql.connection
 
: Configure the work/ws/core/bin/nexj/postgresql.connection
 
: Configure the work/ws/core/test/nexj/postgresql.connection
 
: Configure the work/ws/core/test/nexj/postgresql.connection
 +
::<source lang=java>
  
 +
  protected static Metadata loadMetadata(String sAdapter)
 +
  {
 +
      Properties props = SysUtil.getConfigProperties();
 +
 +
      props = new Properties(props);
 +
      props.setProperty(XMLMetadataLoader.CONNECTIONS_URL_PROPERTY, "/nexj/" + sAdapter.toLowerCase(Locale.ENGLISH) + ".connections");
 +
</source>
 
* 2- Add PostgreSQL database to related java files
 
* 2- Add PostgreSQL database to related java files
 
: SQLSchemaMangerFactory.java
 
: SQLSchemaMangerFactory.java

Revision as of 12:04, 22 November 2010

PostgreSQL Adapter for NexJ - Create Test Environment

  • 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
   protected static Metadata loadMetadata(String sAdapter)
   {
      Properties props = SysUtil.getConfigProperties();

      props = new Properties(props);
      props.setProperty(XMLMetadataLoader.CONNECTIONS_URL_PROPERTY, "/nexj/" + sAdapter.toLowerCase(Locale.ENGLISH) + ".connections");
  • 2- Add PostgreSQL database to related java files
SQLSchemaMangerFactory.java
RelationalDatabaseFragment.java
  • 3- Create the extended PostgreSQL source files
PostgreSQLAdapter.java
PostgreSQLSchemaManger.java
  • 4- Create the extended PostgreSQL test files
PostgreSQLAdapterTest.java
PostgreSQLSchemaMangerTest.java