Difference between revisions of "NexJ Express Connecting to PostgreSQL"
Line 9: | Line 9: | ||
:: | :: | ||
<source lang=java> | <source lang=java> | ||
+ | /* MySQLAdapterTest.java */ | ||
+ | |||
+ | try | ||
+ | { | ||
+ | s_metadata = loadMetadata(ADAPTER_NAME); | ||
+ | } | ||
+ | |||
+ | |||
/* SQLDataTest.java*/ | /* SQLDataTest.java*/ | ||
protected static Metadata loadMetadata(String sAdapter) | protected static Metadata loadMetadata(String sAdapter) |
Revision as of 12:09, 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
/* MySQLAdapterTest.java */
try
{
s_metadata = loadMetadata(ADAPTER_NAME);
}
/* SQLDataTest.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"); // the postgresql.connection is hardcoded
- 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