NexJ Express Connecting to PostgreSQL
(Redirected from PostgreSQL Adapter-nexj/connecting to PostgreSQL)
Contents
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 extendingSQLAdapter
- Create
PostgreSQLSchemaManager.java
by extendingSQLSchemaManager
- 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 extendingSQLAdapterTest
- Create
PostgreSQLSchemaManagerTest.java
by extendingSQLSchemaManagerTest
Package: nexj
- Create
postgresql.connections
using NexJ Studio - Edit
default.config
to use PostgreSQL - Edit all
*.connections
files to use PostgreSQL