8:00 – 4:00 VISIBILITY

• Hey! No ice!
• Described the new FGM development incentive structure do Dong. Also, he’s going to start regular backups of fgmdev just in case VA forgets to pay the bill.
• Statistics class
• Working on tying the server side code back to the flex side for generic table retrieval. First pass is done! Login is now handled in the new system.
• Burned a disk of new PPM swf

7:30 – 3:30 VISIBILITY

• Working from home today. When the roads melt, I’ll see if I can go install the PPM update from yesterday
• Installing xampp – done. Worked the first time. Sooooooooooooooooooooo nice.
• Working on a version of DbTable that tries to match a java data type to the sql data type. Done, at least for the types that Flex likes.
• Walked through the concept of views into infinite data with Mike.
• Installed the new PPM. When I updated the DB, I got some errors:
  • On the 10th item (UPDATE direct_cites SET contract_id = [SELECT uid FROM contracts WHERE direct_cites.contract_number = contracts.contract_number )], and the 13th item (UPDATE funding_requests SET project_id = [SELECT uid FROM projects WHERE funding_requests.project_number = projects.project_number )] I got the following error:
  • ERROR 1242 (21000): Subquery returns more than 1 row
  • I left it as is since things appeared to be working. Worst case I can roll it back to just before I made the change.

8:00 – 5:30 VISIBILITY

• Finally found out what was causing the “save problem” with PPM financial data. If a cell that has information has that info deleted, then when the window is closed, the save dialog appears.
• Wrote up server requirements for Brian
• Got most of the object transfer done. Need to get the typing on DbTable working better.

7:30 – 5:30 VISIBILITY

• Meeting with Matt and Anne from 3:00 – 4:00. Went very well. We’re going to try to get some more and better data into VISIBILITY
• Class today – out between 9:30 and 11:30
• working on  generic data handlers
  • Get insert working – Done, but I want to add precompiled queries as well
  • Get SELECT Query working
  • change User Info over to use new system
• Spent some time improving the precompiled query code in DbHelper

10:30 – 4:30 VISIBILITY

• It took about 90 minutes to dig out today. Heavy snow.
• Working on InfoObjectManager.java/as
  • Remote objects are only typed when read by Java if the .as file is decorated properly. An actionscript object that inherits from a decorated class is read in as an ASObject.
  • I couldn’t cast data the way that I wanted to from the remote objects so I redid the approach so that data objects are wrapped in remote objects. There are now the following objects:
    • CreateTableObject: Wraps an actionscript object and sets the class name as the table name. Returns a status string that can be the error message from SQL
    • InsertObject: Wraps an actionscript object and attaches a table name. When received by the host, a statement is built to insert the data into an existing table
    • QueryObject: Passes a query and a table name top the host. The table name is created by passing the actionscript object into the QueryObject class
    • QueryResultObject: Contains the query string, any message string, the table name, and an ArrayList of Maps that are converted to a Bindable ArrayCollection on the Client side
  • Tomorrow I’ll try to refactor the user info to use the new mechanism and work out into projects and entries from there.
• It is, by the way, very convenient to look at what’s going on with the server at times 🙂

8:30 – 4:30 VISIBILITY

• First big(ish) snow of the year
• Meeting with Matt and Anne still appears to me on for this afternoon – nope canceled. Maybe Friday.
• Working on debugging remote objects
• Got it all working. Here’s how you do it:
  1. You will need a workingversion of Tomcat. But it needs to be stopped. We’re going to be running it from within Eclipse
  2. Download and install the Eclipse Web Tools Package. You don’t need the SDK version. The update site for helios is here: http://download.eclipse.org/webtools/repository/helios/
  3. Open the Window->Show View->Other… then inside the view three find Sever->Servers view
  4. Inside the Servers view, create a new Server. You should be able to select the Tomcat version that you want. You will also need to point it at the version of Tomcat you have installed.
  5. Right-click on your Server and select Open to bring up the “Overview” configuration screen as a tab in your editor. Under Server Locations, select the “Use Tomcat Installation (takes control of Tomcat installation)
  6. Create a new project of type Web->Dynamic Web Project. I named mine RemoteObjectTestbed
  7. Set the properties->Java Build Path source tab to have the Default output folder to XXX/WEB-INF/classes, where XXX is the name of the directory you’re deploying to. Note that you have to type this in, you CAN”T point and click.
  8. Add the project to the server by right-clicking on the server in the server view. That brings up a dialog that allows you to select web projects and move them over to the server.
  9. Since I was debugging a project that I had already started using MavenAssist, I copied over a bunch of stuff. These files get placed in the WebContent folder. THis is the folder that you pointed to in step 7. :
     • The files that get deployed are under the Program Files folder in your web project.
       • Add a lib folder and fill it with all the jars you need to run flex (take from a working version)
       • Add a flex folder and put the flex xml files from a working project
       • Under web inf, copy a web.xml file
     • If you’ve copied everything over correctly, you should be able to start the server by right clicking on the Server in the Servers view and selecting “Start” or “Debug”. If you navigate to http://localhost/XXX/messagebroker/amf you should get a nice blank screen, not a 404 or some other crappy result. If everything works, turn off the server before continuing.
     • Create package(s) under the “Java Resources:src” folder for your code. These packages will need to be the same as what’s in the remoting-config.xml file. These are your remote objects.
     • To debug the remote object, place your breakpoints and start the server in debug mode. Starting the server appears to reload the entire project so if you have a Flex project dropping its output in the XXX folder, you’ll have to rebuild.
  10. At this point you should be able to debug both side of the application.
• OK, back to actually making things.
• The data is coming over the wire as an ASObject. Inside it is a hashmap. All types work correctly except for the uint, which comes over as an int. Based on this info, I’m going to add a String to the base class that defines the table name. Then the object contains everything it needs to create a table in its hashmap. No creation of XML is required.
• Spent a while wondering why some items weren’t appearing in the variables view of the java hashmap. Wound up creating a Set and looking at the variables there. They all show up, so I guess I’m just blind…

8:00 – 5:00 VISIBILITY

• Tentative meeting to discuss + data with Anne and Matt on Wednesday afternoon
• Looks like I’m going to be taking classes at UMBC from 10:00 – 11:00 Wed/Fri. No one schedule meetings then until May 13 🙂
• Working on automatic table creation. Instead of using the describeType xml directly, I now use it to create a smaller table that gets size information from the data in the object. Next is automating that process and inserting some data.
• I really want to see how  data comes to a remote object, so I’m attempting to connect the debugger to my Tomcat instance.
  • Downloading the server adapters from the Eclipse  Web tools package. Actually, it looks like you have to download the whole WTP. I did not download the SDK version
  • Got Eclipse to control the server instance in the installed directory.
    • Create a new server in the Eclipse “Server” view
    • Right-click on the server and select “Open F3”. This brings up a configuration page.
    • Set the “Server Location” to “Use Tomcat Installation (takes control of Tomcat installation)
    • Tried just connecting to the remote object, but no joy. Next thing will be to try to create a dynamic web project in the normal Tomcat location where I can see the logs. Also, general behavior should be easier to tease out.

7:30 – 3:30 VISIBILITY

• Deployed Dong’s changes to PPM. All went well. I also ran TRUNCATE on the query_logs table and the size of the backup went from 78 megs to 4.5 megs. It was easily 90% SELECT statements. I asked Dong to only log DB access that affects the tables. That should keep things under control and make it more searchable.
• Working on my Java db accessor classes. Decided that I’m going to work on building FLAILS to do this. it’s a good opportunity, and the other objects were just dissimilar to be annoying.
• Took a detour into the javax xml parsing code and it still sucks. Dom4j has moved from dom4j.org to sourceforge. Had a bit of cognitive dissonance for a while at the website.
• Added dom4j utilities from MavenAssist to JavaUtils, and found that we had commented out the part of MaveAssist that puts the deployment urls in the POM. That’s back in and we have a new Maven on the repo.
• Created a SQL table from describeType xml!

7:30 – 4:00 VISIBILITY

• Pinged Kristie C. about a followup demo. We’re trying to schedule something for next week either here or at S2F
• Pinged Anne about scheduling a + meeting
• Testing Dong’s update. If everything works, I’ll roll it in this afternoon. Looks good.
• Working on Project Tracker
  • Added ProjectInfoObject
  • Added EntryInfoObject
  • Added HistoryInfoObject
  • Added StatusInfoObject
  • Added TypeInfoObject
  • Abstracted RemotObject DB creation into base class, cleverly named ‘BaseObject’

7:30 – 4:30 VISIBILITY

• Got a big delivery of FP stuff yesterday. Brought it in along with the tweezers and ruler.
• Project creation today
  • Added Menus
  • Added Project Panel
  • Added States

8:30 – 4:30 VISIBILITY

• Larry needs a VISIBILITY architecture diagram? Yep. Working on that. Done.
• Sent Christine a snapshot of my User Settings
• More work on the project tracker. Finished login.

8:30 – 4:30 VISIBILITY

• Helped Mike with getting Dong’s Data Manager to compile
• ProjectTrackLite
  • Flex client project is up and running
  • Java server poject is started and compiling
  • Getting the user remote object to behave. Ran into some trouble geting the amf messagebrokjer to behave. The most important thing seems to have been that the blaze jhar files wer not dependencies in the pom. After some tweaking, that seems to have gotten the instance successfully deployed by Tomcat and is working.
  • Getting the improved config manager working. Done. All you have to do now to access a value in the setupModel.xml file is run the ConfigLoader and add a listener (and function) for the values you want to watch.

8:00 – 4:00 VISIBILITY

• Looks like the Unix server that we thought we might be getting is in fact a web page that we could edit on an existing server. Which isn’t at all what we need. The guy (Charles H.) who’s handing the ticket is looking into the matter to see who we have to talk to to get a real server
  • Update – CH found a place that might be able to set up a server for us. He sent me an email on my other accounts with the info. I’ll check into it tomorrow.
• Talked to Mike Cowan today about sharepoint. He agreed with Walter Jones that communication between VISIBILITY and Sharepoint could be done by a webservice that sends a list consisting of zipped db tables in a list. Even more simply, we can get data out of Sharepoint by having the data table webpage (webpart?) provide an RSS feed of the data, which would be pretty easy to parse. No data upload that way though
  • We also wrapped the VISIBILITY Data Navigator web page inside a webpart in Sharepoint. It worked just fine.
• Ordered a bunch of stuff for the FP
• Testing PPM
  • Got an error when selecting a user to modify:

    • status: false
      sqlStr: SELECT * FROM user_roles, roles WHERE login ='pgfeldm' AND role_id = id
      statusString: Error occurred during runSQL()
      errorString:
      exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'project_portfolio.user_roles' doesn't exist
      data:

  • The vertical sizing of the panels is off. This may be related to the fact that the Arial font is being used again?
• Worked a bit on ProjectTrackLite
  • Building in Flashbuilder and Maven
  • Using Mike’s new DynamicPanel. Need to add a listener/handler for a closeEvent.
  • Adding bits to FGMUtils
  • Working on the login. Trying it with the SingletonDataDictionary

8:00 – 4:00 VISIBILITY

• It looks like S3 might be able to let us have a Unix (Linux?) Server equipped with Tomcat and mySql
• Working on requirements app. Table descriptions are here. More requirements to follow, probably
• Interview with Walter Jones
• Wrote a Java test for interviewees. We’ll see if we use it.

7:30 – 5:30VISIBILITY

• We should do something to celebrate at 1:11 this afternoon
• Wrote up a quick estimate of the effort required for the S2/SV effort
• Working on the VIS4 plan – finished initial. Need to break into a set of traceable requirements
• Looking for a requirements tracking package. Eclipse has some nice vaporware (useme), and there are a lot of bug trackers like jira, but nothing else I can find. Grr.