Difference between revisions of "NexJ Express Connecting to PostgreSQL"
Line 3: | Line 3: | ||
* 1- Setup the postgresql-connection | * 1- Setup the postgresql-connection | ||
− | + | : Configure the work/ws/core/test/nexj/postgresql.config | |
− | : Configure the work/ws/core/test/nexj/ | ||
− | |||
: Configure the work/ws/core/test/nexj/postgresql.connection | : Configure the work/ws/core/test/nexj/postgresql.connection | ||
:: | :: | ||
Line 22: | Line 20: | ||
props.setProperty(XMLMetadataLoader.CONNECTIONS_URL_PROPERTY, "/nexj/" + sAdapter.toLowerCase(Locale.ENGLISH) + ".connections"); // sets the properties to postgresql.connection | props.setProperty(XMLMetadataLoader.CONNECTIONS_URL_PROPERTY, "/nexj/" + sAdapter.toLowerCase(Locale.ENGLISH) + ".connections"); // sets the properties to postgresql.connection | ||
</source> | </source> | ||
− | * 2- Add PostgreSQL | + | |
+ | |||
+ | * 2- Add PostgreSQL adapter type to related java files | ||
: SQLSchemaMangerFactory.java | : SQLSchemaMangerFactory.java | ||
: RelationalDatabaseFragment.java | : RelationalDatabaseFragment.java | ||
− | * 3- Create the extended PostgreSQL source files | + | |
+ | * 3- Create a PostgreSQL database through some scripts | ||
+ | : postgresql_setup.sql | ||
+ | |||
+ | * 4- Create the extended PostgreSQL source files | ||
: PostgreSQLAdapter.java | : PostgreSQLAdapter.java | ||
: PostgreSQLSchemaManger.java | : PostgreSQLSchemaManger.java | ||
− | * | + | * 5- Create the extended PostgreSQL test files |
: PostgreSQLAdapterTest.java | : PostgreSQLAdapterTest.java | ||
: PostgreSQLSchemaMangerTest.java | : PostgreSQLSchemaMangerTest.java |
Revision as of 13:14, 22 November 2010
PostgreSQL Adapter for NexJ - Create Test Environment
- 1- Setup the postgresql-connection
- Configure the work/ws/core/test/nexj/postgresql.config
- Configure the work/ws/core/test/nexj/postgresql.connection
/* 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
- 2- Add PostgreSQL adapter type to related java files
- SQLSchemaMangerFactory.java
- RelationalDatabaseFragment.java
- 3- Create a PostgreSQL database through some scripts
- postgresql_setup.sql
- 4- Create the extended PostgreSQL source files
- PostgreSQLAdapter.java
- PostgreSQLSchemaManger.java
- 5- Create the extended PostgreSQL test files
- PostgreSQLAdapterTest.java
- PostgreSQLSchemaMangerTest.java