Open main menu

CDOT Wiki β

Changes

Nexjexpress/PostgreSQL Adapter

351 bytes removed, 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 ==
* Persistence# Eclipse Tutorial Videos on Concept of Adapter [http://eclipsetutorialwww.sourceforgevogella.netde/persistencearticles/DesignPatternAdapter/article.html Persistence]# * [[http://xstream.codehaus.org/persistencePostgreSQL_Adapter-tutorial.html XMLnexj/Object BindingResources#Java | Java ] and [http://code.google.com/p/xbird/wiki/XmlObjectBinding Object Persistence] = * [http://xstream.codehaus.org/index.html XStream] + [http:PostgreSQL_Adapter-nexj//codeResources#Database_.google.com/p/xbird/ XBird26_Persistence | Database & Persistence] (XML database system]# * [[http://www.developer.comPostgreSQL_Adapter-nexj/xml/article.php/918111/Data-Persistence-and-Java-Data-Objects----JDO.htm data persistence] * JDBCResources# 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: [http://www.postgresql.org/docs/9.0/static/index.html Tutorial]: [http:PostgreSQL_Adapter-nexj//www.postgresql.org/docs/7.1/static/jdbcResources#PostgreSQL_-_MySQL_Specifications | Postgre -ext.html postgre connection] * MySQL: [http://dev.mysql.com/doc/refman/5.1/en/sql-syntax.html Syntax]: [http://dev.mysql.com/doc/refman/5.0/en/tutorial.html TutorialSpecifications]: [http://www.mysql.com/downloads/connector/j/ Mysql Connector] * Compare Databases: Compare [http://troels.arvin.dk/db/rdbms/ SQL Implemenations]: Compare [http://wwwPostgreSQL_Adapter-css.fnal.govnexj/dsg/external/freeware/pgsqlResources#PostgreSQL_-vs_MySQL_Compare | Postgre -mysql.html Postgre and MySQLCompare]]