Difference between revisions of "NexJ Express Connecting to PostgreSQL"

Latest revision as of 19:30, 26 January 2014

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

@@ Line 1: / Line 1: @@
-<big><big> PostgreSQL Adapter for NexJ - Create Test Environment </big></big>
+{{Admon/obsolete}}
-{{NexJ_Express Index}}
-=== 1- Setup the postgresql-connection ===
+[[category: NexJ Express PostgreSQL]][[Category:NexJ_Express_Development]][[category: NexJ Express]]
-For testing the connection, the 'PostgreSQLAdapterTest.java' is being used.
-* [[PostgreSQL_Adapter-nexj/test-env/todo |TODOs]]
+== Task Summary ==
-* Done
+{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
-: Installed the <code> JDBC3 Postgresql Driver, Version 9.0-801 </code> and added it to the libraries in JDK
+|-
+! 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
+===Configure UnitTests for more than one Database===
+<!--
+== Setup the postgresql-connection ==
+For testing the connection, the 'AllTests.java' is being used.
+: Installed the <code> Installer version Version 9.0.1-1</code> from list of [http://www.enterprisedb.com/products/pgdownload.do#windows PostgreSQL downloads].
+: Installed the <code> JDBC3 Postgresql Driver, Version 9.0-801 </code> @ http://jdbc.postgresql.org/download.html and added it to the libraries in JDK
 :: The driver class which is being used for NexJ Express Model is: <code> org.postgresql.xa.PGXADataSource </code>
 :: The driver is loaded from RelationalDatabaseFragment.java and RelationalDatabase.java
@@ Line 25: / Line 92: @@
        props.setProperty(XMLMetadataLoader.CONNECTIONS_URL_PROPERTY, "/nexj/" + sAdapter.toLowerCase(Locale.ENGLISH) + ".connections");  // sets the properties to postgresql.connection
 </source>
+: After all properties are loaded, it creates the connection through Connection Factory files.
-: Configured the work/ws/core/test/nexj/postgresql.connection
+===Files to Configure===
-: Configured system.dstype
+'''NOTE''': Changes to these files are involved with '''1-Port''', which should be: 5432, and '''2- Driver package''' that should change to  <code> org.postgresql.xa.PGXADataSource </code>
-: Configured DatabaseTool.java  // This file calles SQLSchemaMangerFactory.java and creates the connection
+: src
-: Configured RelationalDatabase.java // Sets the default properties for the supported drivers
+:: system.dstype
-: Configured RelationalDatabaseFragment.java // Sets the custom fragment properties for the supported drivers
+:: DatabaseTool.java  // This file calles SQLSchemaMangerFactory.java and creates the connection
-: Configured Driver type and some other properties in JDBCInfo.java
+:: RelationalDatabase.java // Sets the default properties for the supported drivers
-: Configured : SQLSchemaManagerFactory.java
+:: RelationalDatabaseFragment.java // Sets the custom fragment properties for the supported drivers
+:: Driver type and some other properties in JDBCInfo.java
-=== 2- Create a PostgreSQL database through some scripts===
+:: SQLSchemaManagerFactory.java  // Sets the connection for the particular adapter type
-: Through the process in postgresql_setup.sql:
+: test
-:: A database called 'test is created in PostgreSQL : <code> CREATE DATABASE test </code>
+:: AllTests.java
-:: To create a <code>user</code> along with <code>password</code>: <code> CREATE USER test WITH PASSWORD 'test'; </code>
+:: default.config  // change to these four files are: adapter="PostgreSQL" port="5432"
-:: Login to the database 'test' with username 'test': <code> psql -U test test </code>
+:: postgresql.connection
-:: Create a <code> Schema </code> called 'test' inside the database 'test' with particular owner 'test': <code> CREATE SCHEMA test AUTHORIZATION test;</code>
+:: filestorage.connections
-:: Create a <code>table</code> called 'mutex' with primary key: <code> CREATE TABLE test.mutex(id INT PRIMARY KEY); </code>
+::filestoragefragment.connections
-:: Insert a value into the primary key: <code> INSERT INTO test.mutex(id) VALUES (1); </code>
+-->
-=== 3- Create the extended PostgreSQL source files ===
-: PostgreSQLAdapter.java
-: PostgreSQLSchemaManger.java
-=== 4- Create the extended PostgreSQL test files ===
-: PostgreSQLAdapterTest.java
-: PostgreSQLSchemaMangerTest.java

Difference between revisions of "NexJ Express Connecting to PostgreSQL"

Latest revision as of 19:30, 26 January 2014

Contents

Task Summary

Task Details

Install PostgreSQL

Install PostgreSQL JDBC3 driver

Code: Add PostgreSQL Driver

SQL Scripts

UnitTest: Test Connectivity to database

Configure UnitTests for more than one Database

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

get involved with CDOT

courses

course projects

links

Tools