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>
+
::
 
+
<source lang=java>
 
   protected static Metadata loadMetadata(String sAdapter)
 
   protected static Metadata loadMetadata(String sAdapter)
 
   {
 
   {
 
       Properties props = SysUtil.getConfigProperties();
 
       Properties props = SysUtil.getConfigProperties();
 
 
       props = new Properties(props);
 
       props = new Properties(props);
 
       props.setProperty(XMLMetadataLoader.CONNECTIONS_URL_PROPERTY, "/nexj/" + sAdapter.toLowerCase(Locale.ENGLISH) + ".connections");
 
       props.setProperty(XMLMetadataLoader.CONNECTIONS_URL_PROPERTY, "/nexj/" + sAdapter.toLowerCase(Locale.ENGLISH) + ".connections");

Revision as of 12:05, 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