My Applied Research Log

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

CDOT Wiki β