Changes

Jump to: navigation, search

NexJ Express Connecting to PostgreSQL

396 bytes added, 13:33, 11 January 2011
no edit summary
{{NexJ_Express Index}}
== TODO =={|class="wikitable"|-! Task! Status|- | Install the PostgreSQL Server| DONE|- | Install PostgreSQL driver| DONE|- | Add code to connect to server| DONE|- | Test connection to the server| DONE|-| Configure UnitTests for multiple DB's| |}* Install the PostgreSQL Server.<br/>* Configure a Test database.<br/>* Create and test connection to the server.<br/> === 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 ===
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>
::Edit <code>system.dstypes</code>
=== UnitTest: Test Connectivity to database ===
Package: <code>nexj.core.persistance.sql</code>
::Create <code>PostgreSQLAdapterTest.java</code> by extending <code>SQLAdapterTest</code>
1
edit

Navigation menu