PostgreSQL Adapter-nexj/test-env/todo

From CDOT Wiki
Revision as of 14:34, 22 January 2011 by Gbatumbya (talk | contribs)
Jump to: navigation, search

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