Difference between revisions of "PostgreSQL Adapter-nexj/test-env/todo"
| (7 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> | <big><big> PostgreSQL Adapter for NexJ - ToDO for Create Test Environment </big></big> | ||
| − | |||
| − | |||
:1- 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> | |
| − | 2- 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>> | :<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>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> | :<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
This page may be obsolete.
It contains historical information.
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.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
