Difference between revisions of "PostgreSQL Adapter"

Revision as of 11:48, 7 December 2010

PostgreSQL Adapter for NexJ

Develope an adapter to enable NexJ Express model to interact with PostgreSQL database

Dec 2010
Database 'test' is created in Postgre. sample table 'mutex' is created for testing the connection properties. No need for SET SQL mode in Postgre Creating tables in process - data mapping needs to be done for BINARY primary keys for all the tables.

Nov 2010

Walk through parts of code related to SQLadapter, SqlSchemaManger and setup scripts in NexJ Express code
SQLAdapter (src, test) and SQLSchemaManager (src, test) classes are extended to create PostgreSQL classes
Proper PostgreSQL Driver is installed.
Postgre package url for XADataSource is added to the related files.
cofig and connection files are modified based on Postgre properties
Application is now connected to the Postgre database.

Get requirements from NexJ (Meeting on Friday Nov 5th)
Organize list of requirements and set the task list for each part needed to be done
Create Test Environment

Concept of Adapter [1]

@@ Line 9: / Line 9: @@
 {|class="collapsible collapsed" style="border-style:solid;border-width:thin;border-color:black"
 !align="left" style="background-color:SteelBlue; font-weight:bold;border-style:solid;border-width:thin;padding: 2px 2px 2px 2px;"| Dec 2010
 |-
 |
-* Walk through parts of code related to SQLadapter, SqlSchemaManger and setup scripts in NexJ Express code
+* Database 'test' is created in Postgre.
-* Going through NexJ MySQL database
+* sample table 'mutex' is created for testing the connection properties.
-* Learning about Differences between PostgreSQL and MySQL
+* No need for SET SQL mode in Postgre
+* Creating tables in process - data mapping needs to be done for BINARY primary keys for all the tables.
 |}
@@ Line 21: / Line 22: @@
 |
 * Walk through parts of code related to SQLadapter, SqlSchemaManger and setup scripts in NexJ Express code
-* Going through NexJ MySQL database
+* SQLAdapter (src, test) and SQLSchemaManager (src, test) classes are extended to create PostgreSQL classes
-* Learning about Differences between PostgreSQL and MySQL
+* Proper PostgreSQL Driver is installed.
+* Postgre package url for XADataSource is added to the related files.
+* cofig and connection files are modified based on Postgre properties
+* Application is now connected to the Postgre database.
 |}