<big><big> PostgreSQL Adapter for NexJ - Connect to PostgreSQL Driver </big></big>{{NexJ_Express IndexAdmon/obsolete}}

== Install [[category: NexJ Express PostgreSQL ==<code> Installer version Version 9.0.1-1</code> from list of ]][http[Category://www.enterprisedb.com/products/pgdownload.do#windows PostgreSQL downloadsNexJ_Express_Development]][[category: NexJ 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 JDBC3 driver == <| DONE|- | Add code> JDBC3 Postgresql Driver, Version 9.0to connect to server| DONE|-801 </code> @ http://jdbc.postgresql.org/download.html and added it | Create Script for Test database| DONE |-| Test connection to the libraries in JDKserver| DONE|-| Configure UnitTests for multiple DB's| |}

== NexJ ExpressTask 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.meta.persistance.sql</code>::Create <code>PostgreSQLAdapter.java</code> by extending <code>SQLAdapter.java</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>

::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