Nexjexpress/PostgreSQL Adapter

From CDOT Wiki
Revision as of 11:54, 5 November 2010 by Minooz (talk | contribs) (Resources)
Jump to: navigation, search

Project Goal

Develope an adapter to expose NexJ Express objects to PostgreSQL database

Current Status

  • 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

  • Get requirements from NexJ (Meeting on Thursday Sep 23rd)
  • Incorporate requirements from NexJ into Design of PostgreSQL adapter
  • Prepare and send proposal for review, make changes as by NexJ until approved

Phase 2: Coding

Resources

  • Persistence
  1. Eclipse Tutorial Videos on Persistence
  2. XML/Object Binding and Object Persistence = XStream + XBird (XML database system]
  3. data persistence with JDO
  4. java world jdo
  • JDBC
  1. JDBC @ http://en.wikipedia.org/wiki/JDBC
  2. Relational database Management System @ http://en.wikipedia.org/wiki/Relational_database_management_system
  3. JDBC Driver @ http://en.wikipedia.org/wiki/JDBC_driver
  4. Drivers table http://devapp.sun.com/product/jdbc/drivers
  • Postgre
Tutorial
postgre connection
  • MySQL
Syntax
Tutorial
Mysql Connector
  • Compare Databases
Compare SQL Implemenations
Compare Postgre and MySQL