<big><big> PostgreSQL Adapter for NexJ - Connect to PostgreSQL database</big></big>{{NexJ_Express IndexAdmon/obsolete}}
[[category: NexJ Express PostgreSQL]][[Category:NexJ_Express_Development]][[category: NexJ Express]] == TODO Task Summary =={|border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
|-
! Task
| Add code to connect to server
| DONE
|-| Create Script for Test database| DONE |-
| Test connection to the server
| DONE
|
|}
* Install the PostgreSQL Server.<br/>
* Configure a Test database.<br/>
* Create and test connection to the server.<br/>
== Task Details ==
=== Install PostgreSQL ===
Download: <code> Installer version Version 9.0.1-1</code> from list of [http://www.enterprisedb.com/products/pgdownload.do#windows PostgreSQL downloads].
=== Install PostgreSQL JDBC3 driver ===
=== Code: Add PostgreSQL Driver ===
Package: <code>nexj.core.persistance.sql</code>
::Create <code>PostgreSQLAdapter.java</code> by extending <code>SQLAdapter</code>::Create <code>PostgreSQLSchemaManager.java</code> by extending <code>SQLSchemaManager</code>
::Edit <code>RelationalDatabase.java</code>::Edit <code>RelationalDatabaseFragment.java</code>::Edit <code>SQLSchemaManagerFactory.java</code>
Package: <code>nexj.core.meta.sys</code>
::Edit <code>system.dstypes</code> === SQL Scripts ===Package: <code>nexj.core.persistence.sql.script</code>:Create * <code>postgresql_setup.sql</code>* <code>postgresql_drop.sql</code>* <code>postgresql_insert.sql</code>* <code>postgresql_upd_addr.sql</code>* <code>postgresql_upd_cont.sql</code>
=== UnitTest: Test Connectivity to database ===
Package: <code>nexj.core.persistance.sql</code>
::Create <code>PostgreSQLAdapterTest.java</code> by extending <code>SQLAdapterTest</code>::Create <code>PostgreSQLSchemaManagerTest.java</code> by extending <code>SQLSchemaManagerTest</code>
Package: <code>nexj</code>
::Create <code>postgresql.connections</code> using NexJ Studio::Edit <code>default.config</code> to use PostgreSQL::Edit all <code>*.connections</code> files to use PostgreSQL
'''TODO: find out how to configure ===Configure UnitTests for more than one Database'''===
<!--
