My Applied Research Log

From CDOT Wiki
Revision as of 16:05, 20 February 2012 by Peter.liu (talk | contribs) (→‎January - March 2012)
Jump to: navigation, search

Common Problems and Solutions

NexJ-CDOT Knowledge Base

January - March 2012

  • continuous construction of the NEXJ-CDOT knowledge base
  • contributions to the SQLite open source community (NexJ SQLite Adapter)
  • contributions to the PostgreSQL open source community (NexJ PostgreSQL Adapter)
  • February
    • identification of research problems solved
      • NexJ extension of SQLite to supprot full text search [1]
    • identification of inter-related issues
      • 75, 76, 79, 78 (open issues)
      • 65, 64, 61, 60, 59, 49 (resolved issues)
        • NexJ extension of SQLite to suppport the analytical function rank?
      • 1
    • code inspection
    • installation of NexJ Studio Express 8.0 with Eclipse SDK 3.7.1
  • January
    • code inspection (reverse engineering)
      • 20 Dec. 2011, 21 Dec. 2011, 4 January, 5 January, 10 January, 12 January

September - December 2011

  • November
    • team meetings on Mondays
    • WebEx meetings with NexJ (11/11, 11/18, 11/25)
    • continuous construction of the NexJ-CDOT knowledge base
  • October
    • team meetings on Mondays
    • Quality Assurance
    • Search for an application to demonstrate the usefulness of the CDOT projects related to the NexJ Express server [6]
    • Research Reading
      • Scrum in Action: Agile Software Project Management and Development by Andrew Pham and Phuong-Van Pham (Cengage Learning, 2012).
      • A practical guide to distributed Scrum by Elizabeth Woodward, Steffan Surdek, Matthew Ganis (IBM Press, 2010).
  • September
    • team meetings at CDOT
    • MTOM project meeting at NexJ Systems scheduled on 9/23
    • Read the MTOM (SOAP Message Transmission Optimization Mechanism) specification. [7]
    • Project Change: MTOM to SQLite Adapter (9/16).
    • SQLite Adapter project meeting at NexJ Systems (9/23)
    • Research Reading
      • Using SQLite by Jay A. Kreibich, O'Reilly 2010.
      • SQLite Tutorial by Mike Chirico (2004) [8]
      • Android SQLite Database - Tutorial by Lars Vogel (2011) [9]
    • Continue with the Knowledge Base project (initiated in July 2011).
      • data analysis of the interview with Brian Lim

July - August 2011

  • Applied Research Notes (July-August 2011)
  • Research Tasks
    • Inspect the code base of NexJ Express
      • the Persistence engine
      • the Integration engine
    • the tree optimization problem (JSON Integration Adapter)
  • Events
    • 7/10/2011 I checked out the code base (revision 540) of NexJ Express from OHT with MercurialEclipse. JAVA_HOME must be set to JDK 1.5, not 1.6. The revised version "Working with NexJ Express Source Code" (2011-3-15) must be used.
    • 7/25/2011 Regarding the JSON Integration Adapter project, I checked out the code base from Brian Lim's mercurial code repository. I ran two JUnit tests and one of them had caused some errors. Later the problem was fixed by Brian.
    • team meetings

June 9, 2011

January - April 2011

Week 1/January 2011

1/12/2011 (Wed)

  • NexJ project team meeting

1/15/2011 (Sat)

Week 2

1/18/2011 (Tue)

1/19/2011 (Wed)

1/20/2011 (TH)

  • NexJ Coding Standards received from Grace
  • Checkd out the code base of the PostgreSQLAdapter project from the mercurial repository
    • build errors encountered

Week 3

1/24/2011 (Mon)

  • ran the JUnit test PostgreSQLSchemaManagerTest on my laptop (vs the CDOT desktop)
    • errors encountered

1/25/2011 (Tue)

1/26/2011 (Wed)

1/27/2011 (Friday)

  • met with Grace to understand how he has used JUnit tests to guide his research and coding process

Week 4

2/09/2011 (Mon)

  • met with Jordan and Dawn to discuss about two projects that have been approved by NexJ

2/11/2011 (Wed)

  • checked out Revision 28 from the code repository, ran PostgreSQLSchemaMangerTest and PostgreSQLAdapterTest
  • uploaded the JUnit testing results (the current status of the project)
  • reviewed NexJ Developer's Guide (coding standard)

Week 5/February

2/07/2011 (Mon)

  • posted the summary of JUnit errors on PostgreSQLAdatperTest

2/09/2011 (Wed)

Week 6

2/16/2011 (Wed)

  • code review of PostgreSQLSchemaManager: 1st iteration
  • team meeting
    • work with Tung: his timeline
    • investigate testRead in PostgreSQLAdapterTest
at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
    at $Proxy2.setString(Unknown Source)
    at nexj.core.rpc.sql.ra.SQLManagedConnection$SQLPreparedStatement.setString(SQLManagedConnection.java:1689)
    at nexj.core.persistence.sql.SQLAdapter$1.setValue(SQLAdapter.java:105)
    at nexj.core.persistence.sql.SQLCursor.query(SQLCursor.java:159)
    ... 26 more
  • action: postgresql source code received from Grace

2/17/2011 (Th)

  • revision 39 was pulled
    • testRead has a different failure trace (problem with serialized representation of readCollectionWhere.xml)
Test object does not match the serialized representation at
"file:/C:/workspace3.5/jan222011/core/bin/nexj/core/persistence/sql/data/readCollectionWhere.xml"
    at junit.framework.Assert.fail(Assert.java:47)
  • Vogella's tutorial on GWT [11]

Week 7

2/23/2011 (Wed)

  • code review of PostgreSQLSchemaManager (revision 45) : 2nd iteration
  • team meeting
    • work with Tung: a list of problems encountered

Week 9/March

3/08/2011 (Tue)

  • 2 JUnit errors encountered on running revision 76 on my laptop

3/09/2011 (Wed)

  • team meeting
  • meet with Tung to understand his deployment problems
  • draft Applied Research Summary on the PostgreSQLAdapter project

Week 10

3/16/2011 (Wed)

  • team meeting

3/18/2011

  • downloaded NexJ Studio Express (v 7.1) from Open Health Tools and tried to install it on my laptop

Week 11

3/23/2011 (Wed)

  • team meeting
  • solving the problems of installing NexJ Studio Express (v 7.1) on my laptop
  • mentoring Tung on creating a GWT application, based on Grace's sample application

3/26/2011 (Sat)

  • released Applied Research Findings [12]

Week 12/April

  • April 13 - student presentations for OCE Connections
  • April 20 - project-end meeting with NexJ and Ontario Centres of Excellence (OCE)
  • Tung delivered visual guides and videos.[13]
  • Tung delivered the GWT application.
Retrieved from "https://wiki.cdot.senecapolytechnic.ca/w/index.php?title=My_Applied_Research_Log&oldid=81675"