Difference between revisions of "PostgreSQL Adapter-nexj/test-env/todo"

From CDOT Wiki
Jump to: navigation, search
 
(11 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==ToDo for Test Environment for PostgreSQL project==
+
{{Admon/obsolete}}
Create and Configure the work/ws/core/test/nexj/postgresql.config
 
for now, the contents of default.config is changed to postgresql specifications instead of mysql
 
  
walk-through lines from 214-218 in SQLManagementConnectionFactory.java
+
<big><big> PostgreSQL Adapter for NexJ - ToDO for Create Test Environment </big></big>
Walk-through properties and see what exactly is needed to be authorized to connect to 'test' database
+
:1- Create and Configure the work/ws/core/test/nexj/postgresql.config
Make sure the model connects to the PostgreSQL using user 'test' - Break @ SQLManagerFactory.java Line:122
+
::for now, the contents of default.config is changed to postgresql specifications instead of mysql
Figure out why there is the exception (unable to lock the PostgreSQL store for the adapter - Break @ SQLDataTest.java Line:443
+
:<s>2- walk-through lines from 214-218 in SQLManagementConnectionFactory.java</s>
 +
:<s>3-Walk-through properties and see what exactly is needed to be authorized to connect to 'test' database</s>>
 +
:<s>4- Make sure the model connects to the PostgreSQL using user 'test' - Break @ SQLManagerFactory.java Line:122</s>
 +
:<s>5- Figure out why there is the exception (unable to lock the PostgreSQL store for the adapter - Break @ SQLDataTest.java Line:443</s>
 +
:6 - <s>Copied the entire methode <code>readSchema)</code> from SQLSchemaManagaer to PostgreSQLSchemaManager, to change schema properties from binary to bytea. Check later for optimization. I needed to import more packages</s>.  -- NO NEED FOR THIS
 +
:7- <s>data mapping needs to be done for BINARY primary keys for all the tables</s>
 +
:8- Find out how to work around creating triggers and indexes in Postgre without using "." in the syntax (e.g. create index test.Account$2)
 +
:9- Move all the implementation for abstract methods to new extended PostgreSQLSchemaManager.java

Latest revision as of 19:49, 26 January 2014

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

PostgreSQL Adapter for NexJ - ToDO for Create Test Environment

1- Create and Configure the work/ws/core/test/nexj/postgresql.config
for now, the contents of default.config is changed to postgresql specifications instead of mysql
2- walk-through lines from 214-218 in SQLManagementConnectionFactory.java
3-Walk-through properties and see what exactly is needed to be authorized to connect to 'test' database>
4- Make sure the model connects to the PostgreSQL using user 'test' - Break @ SQLManagerFactory.java Line:122
5- Figure out why there is the exception (unable to lock the PostgreSQL store for the adapter - Break @ SQLDataTest.java Line:443
6 - Copied the entire methode readSchema) from SQLSchemaManagaer to PostgreSQLSchemaManager, to change schema properties from binary to bytea. Check later for optimization. I needed to import more packages. -- NO NEED FOR THIS
7- data mapping needs to be done for BINARY primary keys for all the tables
8- Find out how to work around creating triggers and indexes in Postgre without using "." in the syntax (e.g. create index test.Account$2)
9- Move all the implementation for abstract methods to new extended PostgreSQLSchemaManager.java