Changes

== Week 1==1{{Admon/12/2011 (Wed)  NexJ projects team meetingobsolete}}

1/15/2011 (Sat)  == [[PostgreSQl Adatper-nexj/research_notes_PostgreAdapter| Research NotesCommon Problems and Solutions]]==

== Week 2==1/18/2011 (Tue) *[[Summary of Code Walkthrough by GraceNexJ-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 projects group project team meeting** The PostgreSQL PostgreSQLAdapter project must be completed by March 31, 2011.

*[[PostgreSQl AdatperPostgreSQL Adapter-nexj/research notes SQLSchemaManager | Research Noteson 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 312/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.