Open main menu

CDOT Wiki β

Changes

Nexjexpress/PostgreSQL Adapter

150 bytes added, 20:52, 26 January 2014
no edit summary
{{Admon/obsolete}}
 
<big><big> PostgreSQL Adapter for NexJ </big></big>
 
 
== Project Goal==
Develope an adapter to expose enable NexJ Express objects model to interact with PostgreSQL database
== Current Status==
* Walk through parts of code related to SQLadapter, SqlSchemaManger and setup scripts in NexJ Express code
* Going through NexJ MySQL database
* Learning about Differences between PostgreSQL and MySQL
* Walk through MySQL adapter.java code in NexJ Express code
* Going through NexJ MySQL database
==Project Phases==
=== Phase 1: Design Proposal Requirements ===* Get requirements from NexJ (Meeting on Thursday Sep 23rdFriday Nov 5th)* Incorporate Organize list of requirements from NexJ into Design of PostgreSQL adapter* Prepare and send proposal set the task list for review, make changes as by NexJ until approvedeach part needed to be done
===Phase 2: Coding ===
* '''List of Tasks'''# implementation of [[ PostgreSQL_Adapter-nexj/Adapter | PostgreSQLAdapter.java ]]# implementation of [[ PostgreSQL_Adapter-nexj/AdapterTest | PostgreSQLAdapterTest.java ]]# implementation of [[ PostgreSQL_Adapter-nexj/SchemaManger | PostgreSQLSchemaManager.java ]]# Setup [[ PostgreSQL_Adapter-nexj/Script | Scripts ]]# implementation of [[ PostgreSQL_Adapter-nexj/Upgrade | main.upgrade ]]
== Resources ==
* JDBC# JDBC @ http://en.wikipedia.org/wiki/JDBC# Relational database Management System @ http://en.wikipedia.org/wiki/Relational_database_management_system # JDBC Driver @ http://en.wikipedia.org/wiki/JDBC_driver# Drivers table http://devapp.sun.com/product/jdbc/drivers  * Postgre: Concept of Adapter [http://www.postgresqlvogella.orgde/docs/9.0articles/staticDesignPatternAdapter/indexarticle.html Tutorial]: * [[http:PostgreSQL_Adapter-nexj//www.postgresql.org/docs/7.1/static/jdbc-ext.html postgre connectionResources#Java | Java ]] * MySQL: [http:[PostgreSQL_Adapter-nexj//devResources#Database_.mysql.com/doc/refman/5.1/en/sql-syntax.html Syntax26_Persistence | Database & Persistence]]: * [[http:PostgreSQL_Adapter-nexj//dev.mysql.com/doc/refman/5.0/en/tutorial.html TutorialResources#JDBC | JDBC]: [http://www.mysql.com/downloads/connector/j/ Mysql Connector]  * Compare Databases: Compare [[http:PostgreSQL_Adapter-nexj//troels.arvin.dk/db/rdbms/ SQL ImplemenationsResources#PostgreSQL_-_MySQL_Specifications | Postgre - MySQL Specifications]]: Compare * [http://www[PostgreSQL_Adapter-css.fnal.govnexj/dsg/external/freeware/pgsqlResources#PostgreSQL_-vs_MySQL_Compare | Postgre -mysql.html Postgre and MySQLCompare]]
Retrieved from "https://wiki.cdot.senecapolytechnic.ca/wiki/Special:MobileDiff/45293...104112"