1
edit
Changes
Created page with ' <big><big> PostgreSQL Adapter for NexJ - Create Test Environment </big></big> {{MinNexJ_Express Index}} == Setup the postgresql-connection == For testing the connection, the '…'
<big><big> PostgreSQL Adapter for NexJ - Create Test Environment </big></big>
{{MinNexJ_Express Index}}
== Setup the postgresql-connection ==
For testing the connection, the 'AllTests.java' is being used.
: Installed the <code> Installer version Version 9.0.1-1</code> from list of [http://www.enterprisedb.com/products/pgdownload.do#windows PostgreSQL downloads].
: Installed the <code> JDBC3 Postgresql Driver, Version 9.0-801 </code> @ 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: <code> org.postgresql.xa.PGXADataSource </code>
:: The driver is loaded from RelationalDatabaseFragment.java and RelationalDatabase.java
: Metadata is loaded from the particular driver
::
<source lang=java>
/* 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
</source>
: 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 <code> org.postgresql.xa.PGXADataSource </code>
: 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
