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) | ||
{ | { | ||
− | 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"); // the postgresql.connection is hardcoded | props.setProperty(XMLMetadataLoader.CONNECTIONS_URL_PROPERTY, "/nexj/" + sAdapter.toLowerCase(Locale.ENGLISH) + ".connections"); // the postgresql.connection is hardcoded |
Revision as of 12:14, 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