Open main menu

CDOT Wiki β

My Applied Research Log

Important.png
This page may be obsolete.
It contains historical information.

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 - 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
  • 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 [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

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 [17]

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 [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.