View source for My Applied Research Log

{{Admon/obsolete}}

== [[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 [http://site.icu-project.org/]
*** NexJ extension of SQLite to support full text search [http://www.sqlite.org/fts3.html#appendix_a]
**** the '''rank''' function for the Windows and Linux platforms
*** the full text search problem
**** Android Quick Tip: Using SQLite FTS Tables (September 30, 2011) [http://blog.andresteingress.com/2011/09/30/android-quick-tip-using-sqlite-fts-tables/]
**** Android SQLite Database and ContentProvider - Tutorial (Lars Vogel, 2012) [http://www.vogella.de/articles/AndroidSQLite/article.html]
**** Search with InnoDB By Bertrand Matthelié (Oracle's MySQL Blog, Nov 09, 2011) [https://blogs.oracle.com/MySQL/entry/full_text_search_with_innodbFull-Text]
**** Natural Language Full-Text Searches (MySQL) [http://dev.mysql.com/doc/refman/5.0/en/fulltext-natural-language.html]
**** Is Full Text search the answer? (stackoverflow 2009) [http://stackoverflow.com/questions/614358/is-full-text-search-the-answer]
** 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 - 82, 83 |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
*** [[NexJ Studio Express 8.0 - Problems|problems encountered]]
*** solution: Use Eclipse  SDK 3.7 (instead of 3.7.1) [http://www.eclipse.org/downloads/packages/release/indigo/r]  [http://www.eclipse.org/eclipse/development/readme_eclipse_3.7.1.html] [http://www.infoq.com/news/2011/09/eclipse-indigo-371] [http://www.slideshare.net/kartben/p2-the-new-eclipse-provisioning-system-presentation]
*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
*** [[Common Problems and Solutions|upgrade problems encountered  ]]
** Search for an application to demonstrate the usefulness of the CDOT projects related to the NexJ Express server [https://medatedge-openhealthtoolsacademicchallenge.pbworks.com/w/page/38269515/FrontPage]
** 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. [http://www.w3.org/TR/soap12-mtom/]
** '''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)''' [http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html]
*** '''Android SQLite Database - Tutorial by Lars Vogel (2011)''' [http://www.vogella.de/articles/AndroidSQLite/article.html]
** Continue with the '''[[ Applied Research Notes (July-August 2011)|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 [[JUnit Stack Trace |some errors]]. Later the problem was fixed by Brian.
** team meetings

== June 9, 2011 ==
* The 1st NexJ Academic Research User Group Meeting [http://brianlimtemp.blogspot.com/]
** [[List of Potential Project Ideas for NexJ Express | NexJ Project Ideas]]

== January - April 2011 ==
=== Week 1/January 2011===
'''1/12/2011 (Wed)'''  
*NexJ project team meeting

'''1/15/2011 (Sat)''' 
*[[PostgreSQL Adapter-nexj/research_notes_PostgreAdapter| Research Notes on the SQLAdapter class ]]

=== Week 2===
'''1/18/2011 (Tue)''' 
*[[Summary of Code Walkthrough by Grace]] <br>

'''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.
*[[PostgreSQL Adapter-nexj/research notes SQLSchemaManager | Research Notes on the SQLSchemaManager class]]<br>

'''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)'''
*[[PostgreSQL Adapter-nexj/research_notes_PostgreAdapter| Research Notes on the SQLAdapter class ]]
'''1/26/2011 (Wed)'''
* NexJ team meeting
* [[error| error encounterd ]]in running PostgreSQLSchemaManagerTest
* [[error - system path| 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)
**[[Media:Screen_SMTest_2112011.jpg | PostgreSQSchemaManagerTest ]]
**[[Media:Screen_ATest_2112011.jpg | PostgreSQLAdapterTest ]]
* reviewed NexJ Developer's Guide (coding standard)

=== Week 5/February ===
'''2/07/2011 (Mon)'''
* posted [[Summary_of_JUnit_errors_2/07/2011| 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 of Code Review 2/16/2011| summary]]
* team meeting
** work with Tung: his timeline
** investigate testRead in PostgreSQLAdapterTest
<pre>
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
</pre>
* 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)
<pre>
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)
</pre>
* Vogella's tutorial on GWT [http://www.vogella.de/articles/GWT/article.html]

=== Week 7 ===
2/23/2011 (Wed)
*code review of PostgreSQLSchemaManager (revision 45) : 2nd iteration
** [[Summary of Code Review 2/23/2022 | 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 [http://zenit.senecac.on.ca/wiki/index.php/Research_Findings_-_PostgreSQLAdapter]

=== 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.[http://zenit.senecac.on.ca/wiki/index.php/Tung-NexJ-Page]
* Tung delivered the GWT application.