My Applied Research Log

This page may be obsolete.
It contains historical information.

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 - March
  • Web/Ex meeting with NexJ (3/13/2012)
  • identification of research problems being solved
    • ICU (International Components Unicode) support by SQLite [1]
    • NexJ extension of SQLite to support full text search [2]
      • the rank function for the Windows and Linux platforms
    • the full text search problem
      • Android Quick Tip: Using SQLite FTS Tables (September 30, 2011) [3]
      • Android SQLite Database and ContentProvider - Tutorial (Lars Vogel, 2012) [4]
      • Search with InnoDB By Bertrand Matthelié (Oracle's MySQL Blog, Nov 09, 2011) [5]
      • Natural Language Full-Text Searches (MySQL) [6]
      • Is Full Text search the answer? (stackoverflow 2009) [7]
  • identification of inter-related issues (code repository)
    • 79, 80 (open)
      • create top-lovel makefile
    • 75 (open), 77
      • the NexJ Framework expects SQLite to support UNICODE collations
    • 84, 85 (open)
      • add build steps (the Linux command line compile options, Windows) to the project makefile under the compile label
    • 82, 83
      • append extensions to SQLite Library (sqlite.c): notes
    • 76
      • SQLiteDataSourceWrapper: logic to identify the current os and architecture for loading the appropriate extension
    • 65, 64, 61, 60, 59, 49
      • NexJ extension of SQLite to suppport the rank function in FTS (full text search)
    • 1
  • code inspection
  • installation of NexJ Studio Express 8.0 with Eclipse SDK 3.7.1
    • problems encountered
    • solution: Use Eclipse SDK 3.7 (instead of 3.7.1) [8] [9] [10] [11]
• 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
    • checked out the source code of the SQLite Adapter
    • upgrade problems encountered
  • Search for an application to demonstrate the usefulness of the CDOT projects related to the NexJ Express server [12]
  • 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. [13]
  • 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) [14]
    • Android SQLite Database - Tutorial by Lars Vogel (2011) [15]
  • 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

• The 1st NexJ Academic Research User Group Meeting [16]
  • NexJ Project Ideas

January - April 2011

Week 1/January 2011

1/12/2011 (Wed)

• NexJ project team meeting

1/15/2011 (Sat)

• Research Notes on the SQLAdapter class

Week 2

1/18/2011 (Tue)

• Summary of Code Walkthrough by Grace
  

1/19/2011 (Wed)

• NexJ project team meeting
  • The PostgreSQLAdapter project must be completed by March 31, 2011.
  • New projects will be proposed to NexJ for approval.
• Research Notes on the SQLSchemaManager class
  

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)

• Research Notes on the SQLAdapter class

1/26/2011 (Wed)

• NexJ team meeting
• error encounterd in running PostgreSQLSchemaManagerTest
• system path error encountered
  • solution was offered by Grace

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)
  • PostgreSQSchemaManagerTest
  • PostgreSQLAdapterTest
• 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)

• posted Grouping of methods to be implemented 2/09/2011
• team meeting
  • look into jQuery, Scheme (Racket?), Goolge Web Toolkit (GWT)
  • work with Tung

Week 6

2/16/2011 (Wed)

• code review of PostgreSQLSchemaManager: 1st iteration
  • summary
• 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 [17]

Week 7

2/23/2011 (Wed)

• code review of PostgreSQLSchemaManager (revision 45) : 2nd iteration
  • summary
• 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 [18]

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.[19]
• Tung delivered the GWT application.