Difference between revisions of "NexJ Express Connecting to PostgreSQL"

From CDOT Wiki
Jump to: navigation, search
(Setup the postgresql-connection)
(Setup the postgresql-connection)
Line 26: Line 26:
 
: After all properties are loaded, it creates the connection through Connection Factory files.
 
: After all properties are loaded, it creates the connection through Connection Factory files.
  
 
+
===Files to Configure===
{|class="collapsible collapsed" style="border-style:solid;border-width:thin;border-color:black"
 
!align="left" style="background-color:SteelBlue; font-weight:bold;border-style:solid;border-width:thin;padding: 2px 2px 2px 2px;"| '''Files to Configure'''
 
|-
 
|
 
 
: src
 
: src
 
:: system.dstype
 
:: system.dstype
Line 44: Line 40:
 
:: filestorage.connections
 
:: filestorage.connections
 
::filestoragefragment.connections
 
::filestoragefragment.connections
|}
 

Revision as of 11:01, 10 December 2010

PostgreSQL Adapter for NexJ - Create Test Environment

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

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 // System resources are being extracted from these 4 XML files
postgresql.connection
filestorage.connections
filestoragefragment.connections