Difference between revisions of "PostgreSQL Adapter-nexj/test-env/todo"
(Created page with ' ToDo for Test Environment Create and Configure the work/ws/core/test/nexj/postgresql.config for now, the contents of default.config is changed to postgresql specifications inste…') |
|||
(12 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
+ | {{Admon/obsolete}} | ||
− | + | <big><big> PostgreSQL Adapter for NexJ - ToDO for Create Test Environment </big></big> | |
− | Create and Configure the work/ws/core/test/nexj/postgresql.config | + | :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 | + | ::for now, the contents of default.config is changed to postgresql specifications instead of mysql |
− | + | :<s>2- walk-through lines from 214-218 in SQLManagementConnectionFactory.java</s> | |
− | walk-through lines from 214-218 in SQLManagementConnectionFactory.java | + | :<s>3-Walk-through properties and see what exactly is needed to be authorized to connect to 'test' database</s>> |
− | Walk-through properties and see what exactly is needed to be authorized to connect to 'test' database | + | :<s>4- Make sure the model connects to the PostgreSQL using user 'test' - Break @ SQLManagerFactory.java Line:122</s> |
− | Make sure the model connects to the PostgreSQL using user 'test' - Break @ SQLManagerFactory.java Line:122 | + | :<s>5- Figure out why there is the exception (unable to lock the PostgreSQL store for the adapter - Break @ SQLDataTest.java Line:443</s> |
− | Figure out why there is the exception (unable to lock the PostgreSQL store for the adapter - Break @ SQLDataTest.java Line:443 | + | :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
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.java3-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:1225- 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. -- NO NEED FOR THISreadSchema)
from SQLSchemaManagaer to PostgreSQLSchemaManager, to change schema properties from binary to bytea. Check later for optimization. I needed to import more packages - 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