Difference between revisions of "NexJ Express Connecting to PostgreSQL"

From CDOT Wiki
Jump to: navigation, search
 
(9 intermediate revisions by one other user not shown)
Line 1: Line 1:
−
<big><big> PostgreSQL Adapter for NexJ - Connect to PostgreSQL database</big></big>
+
{{Admon/obsolete}}
−
{{NexJ_Express Index}}
 
  
−
== TODO ==
+
[[category: NexJ Express PostgreSQL]][[Category:NexJ_Express_Development]][[category: NexJ Express]]
−
{|
+
 
 +
== Task Summary ==
 +
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
 
|-
 
|-
 
! Task
 
! Task
Line 16: Line 17:
 
| Add code to connect to server
 
| Add code to connect to server
 
| DONE
 
| DONE
−
|-  
+
|-
 +
| Create Script for Test database
 +
| DONE
 +
|-
 
| Test connection to the server
 
| Test connection to the server
 
| DONE
 
| DONE
Line 23: Line 27:
 
|  
 
|  
 
|}
 
|}
−
* Install the PostgreSQL Server.<br/>
 
−
* Configure a Test database.<br/>
 
−
* Create and test connection to the server.<br/>
 
  
 +
== Task Details ==
 
=== Install PostgreSQL ===
 
=== 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].
+
Download: <code>Version 9.0</code> from list of [http://www.enterprisedb.com/products/pgdownload.do#windows PostgreSQL downloads].
  
 
=== Install PostgreSQL JDBC3 driver ===
 
=== Install PostgreSQL JDBC3 driver ===
Line 36: Line 38:
 
=== Code: Add PostgreSQL Driver ===
 
=== Code: Add PostgreSQL Driver ===
 
Package: <code>nexj.core.persistance.sql</code>
 
Package: <code>nexj.core.persistance.sql</code>
−
::Create <code>PostgreSQLAdapter.java</code> by extending <code>SQLAdapter</code>
+
:Create <code>PostgreSQLAdapter.java</code> by extending <code>SQLAdapter</code>
−
::Create <code>PostgreSQLSchemaManager.java</code> by extending <code>SQLSchemaManager</code>
+
:Create <code>PostgreSQLSchemaManager.java</code> by extending <code>SQLSchemaManager</code>
  
−
::Edit <code>RelationalDatabase.java</code>
+
:Edit <code>RelationalDatabase.java</code>
−
::Edit <code>RelationalDatabaseFragment.java</code>
+
:Edit <code>RelationalDatabaseFragment.java</code>
−
::Edit <code>SQLSchemaManagerFactory.java</code>
+
:Edit <code>SQLSchemaManagerFactory.java</code>
  
 
Package: <code>nexj.core.meta.sys</code>
 
Package: <code>nexj.core.meta.sys</code>
−
::Edit <code>system.dstypes</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 ===
 
=== UnitTest: Test Connectivity to database ===
 
Package: <code>nexj.core.persistance.sql</code>
 
Package: <code>nexj.core.persistance.sql</code>
−
::Create <code>PostgreSQLAdapterTest.java</code> by extending <code>SQLAdapterTest</code>
+
:Create <code>PostgreSQLAdapterTest.java</code> by extending <code>SQLAdapterTest</code>
−
::Create <code>PostgreSQLSchemaManagerTest.java</code> by extending <code>SQLSchemaManagerTest</code>
+
:Create <code>PostgreSQLSchemaManagerTest.java</code> by extending <code>SQLSchemaManagerTest</code>
  
 
Package: <code>nexj</code>
 
Package: <code>nexj</code>
−
::Create <code>postgresql.connections</code> using NexJ Studio
+
:Create <code>postgresql.connections</code> using NexJ Studio
−
::Edit <code>default.config</code> to use PostgreSQL
+
:Edit <code>default.config</code> to use PostgreSQL
−
::Edit all <code>*.connections</code> files to use PostgreSQL
+
:Edit all <code>*.connections</code> files to use PostgreSQL
  
−
'''TODO: find out how to configure UnitTests for more than one Database'''
+
===Configure UnitTests for more than one Database===
  
 
<!--
 
<!--

Latest revision as of 20:30, 26 January 2014

Important.png
This page may be obsolete.
It contains historical information.

Task Summary

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: Version 9.0 from list of PostgreSQL downloads.

Install PostgreSQL JDBC3 driver

Download: JDBC3 Postgresql Driver, Version 9.0-801 @ http://jdbc.postgresql.org/download.html
Install: Copy driver to [jdk folder]/jre/lib/ext

Code: Add PostgreSQL Driver

Package: nexj.core.persistance.sql

Create PostgreSQLAdapter.java by extending SQLAdapter
Create PostgreSQLSchemaManager.java by extending SQLSchemaManager
Edit RelationalDatabase.java
Edit RelationalDatabaseFragment.java
Edit SQLSchemaManagerFactory.java

Package: nexj.core.meta.sys

Edit system.dstypes

SQL Scripts

Package: nexj.core.persistence.sql.script

Create
  • postgresql_setup.sql
  • postgresql_drop.sql
  • postgresql_insert.sql
  • postgresql_upd_addr.sql
  • postgresql_upd_cont.sql

UnitTest: Test Connectivity to database

Package: nexj.core.persistance.sql

Create PostgreSQLAdapterTest.java by extending SQLAdapterTest
Create PostgreSQLSchemaManagerTest.java by extending SQLSchemaManagerTest

Package: nexj

Create postgresql.connections using NexJ Studio
Edit default.config to use PostgreSQL
Edit all *.connections files to use PostgreSQL

Configure UnitTests for more than one Database

Retrieved from "https://wiki.cdot.senecapolytechnic.ca/w/index.php?title=NexJ_Express_Connecting_to_PostgreSQL&oldid=104071"