<big><big> PostgreSQL Adapter for NexJ - Connect to PostgreSQL Driver </big></big>{{NexJ_Express IndexAdmon/obsolete}}
== Install [[category: NexJ Express PostgreSQL ==Download]][[Category: <code> Installer version Version 9.0.1-1</code> from list of NexJ_Express_Development]][[httpcategory://www.enterprisedb.com/products/pgdownload.do#windows PostgreSQL downloadsNexJ Express]].
== Task Summary =={| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"|-! Task! Status|- | Install the PostgreSQL Server| DONE|- | Install PostgreSQL driver| DONE|- | Add code to connect to server| DONE|-| Create Script for Test database| DONE |-| Test connection to the server| DONE|-| Configure UnitTests for multiple DB's| |} == Task Details ===== Install PostgreSQL ===Download: <code>Version 9.0</code> from list of [http://www.enterprisedb.com/products/pgdownload.do#windows PostgreSQL downloads]. === Install PostgreSQL JDBC3 driver ===
Download: <code> JDBC3 Postgresql Driver, Version 9.0-801 </code> @ http://jdbc.postgresql.org/download.html
<br/>Install: Copy driver to <code>[jdk folder]/jre/lib/ext</code>
=== 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'''===
<!--
