8:00 – 4:30 ESSO

• Backups
• Deployed new PA. There are some logic issues WRT Due, Overdue and Current. Wrote them all out, but Dong has them, so I can’t enter them yet.
• Printed out the Cognos query and results so that we have something to work with to produce the charts for Col. Dukes.
• Spent a bit of time discussing my travails and thoughts about JDeveloper and JavaScript
• OK, this book gets ridiculously good reviews on Amazon. Getting the Kindle edition.
• Holy crap!
  • One of the most powerful and most controversial parts of the < script > element is its ability to include JavaScript files from outside domains. Much like an < img > element, the < script > element’s src attribute may be set to a full URL that exists outside the domain on which the HTML page exists, as in this example:
    • <script type=”text/javascript” src=” http://www.somewhere.com/afile.js”></script&gt;
• In XHTML (and XML), CDATA sections are used to indicate areas of the document that contain free-form text not intended to be parsed.
• Aptana Studio 3? Downloaded. Interesting.

8:00 – 4:00 – ESSO

• Deployed Dong’s new PA, but there was a problem, so we pulled it back.
• Updated MySQL and Java, as per instruction from corporate. Don’t forget to update max-packet-size in my.ini to 100M
• Due to the inability of the ADF client to adjust the size of columns as a container resizes, I’m starting to have doubts about the choice of JDeveloper. I might not if the documentation were better (i.e. the Flex documentation with simple examples). But I’m not having good feelings about going down the Oracle path.
• I did find this page that points at JavaScript charting packages. Going to spend the rest of the day looking at that. Here’s my subset of the list that I think might work for us.
  • Minimal or no dependencies
    • CanvasXpress
    • D3.js
    • Flotr2
    • JavaScript InfoVis Toolkit
    • Processing.js
  • Require general-purpose library (e.g. jQuery)
    • Flot
    • jqPlot
    • jQuery-Visualize
      • The above is designed(?) to support a book Designing with Progressive Enhancement. So there is some built-in training here.
    • RAP
• Now, if we start writing without a compiler to lean on, we’re going to need something like Lint. Here’s some discussion.

8:00 – 4:00 ESSO

• Meeting with Chris, Lenny, Carla and Tom(?). Started out by discussing fixes, but became a session discussing how to make the new Financial Assistant. Over the next week, the Pit Crew will put together a spreadsheet that contains everything that they need to make a new entry in a table define by a budget center. Adding a line is essentially adding a MIPR (kind of). Adding a new line, can duplicate some or all of the previous line. Adding a MIPR addendum, for example, would duplicate the entire line except for obligation, outlay, and date. This data all goes back into the existing tables in the database. 
• One modification of the current bugs/requests – make it so contract information in the finding request dropdown maps only to the associated MIPR.
• Updated the servers with monitoring software and also updated their listings.
• Made sure that the VISIBILITY code works for Dimitri’s visit.
• Dimitri came by and we walked through an FP demo,  most of the VISIBILITY data visualization piece, hitting a lot of tangents along the way. He thinks he might find it useful.
• And I need to update my database. visibility_scripting is out of date and there is no alerts DB.

8:30 – 4:30 ESSO

• Backed up (another slow login day)
• Deployed new version of PA
• Working on ADF.
  • Fails to load page, which is pretty much the same problem as before: javax.el.PropertyNotFoundException
  • Wow. The problem was that I changed the default java compiler from the 1.6 U24 that Jdeveloper ships with to 1.7 U11, which is the current version. Impressive how an Oracle product broke an Oracle product
• Nonetheless, progress:

• We will need to resize the grid dynamically (maybe?) here’s a discussion on that: https://forums.oracle.com/forums/thread.jspa?threadID=2357691

OH

• And it looks like we’re not free of our FGM entanglements yet. Self evaluations. Woo freaking hoo.
• Sent Lynn a note about my reimbursement as well, along with my final grades. Maybe some progress?

• Doctor appt this morning. The leg is totally fine.

10:00 – 3:00 ESSO

• Talked to Dong some about the Due/Overdue/Incomplete/Complete project status 
• Installing new Java. Need to do this at home, too.
• To change the default Java library in JDeveloper, do the following
  • Application->Default Project Properties. The “Default Project Properties” dialog opens
  • Select Libraries and Classpath in the tree navigator on the left
  • Click on the change button at the top right The “Edit Java SE Definition” dialog opens
  • Click the “”Browse”” button after the “Java SE Executable:” field on the top right.
  • Navigate to your new “java.exe” (e.g.. C:Program FilesJavajdk1.7.0_11bin)
• Note that this only changes the settings to new projects. To change the settings to an existing project, right click on the project in Application Navigator, click on “Libraries and Classpath”, and follow the steps above.
• Watching the next video. This one is on ADF faces
• Programmatic ADF. And some more code snippets.

3:00 – 5:00

• Q1 Team get together

7:30 – 4:30 ESSO

• Logging in was sloooooooooooooooooooooooow today.
• Meeting with Chris B. Lenny and Tangie weren’t there, and Carla was busy, so it was just Dong, Chris and I. The main new thing was the idea of putting in a new field into the project line item (at the bottom of the project overview screen) that would have the identifier (possibly a script?) that tells the scripting system what item to look for in its query of COGNOS.  That and a few bugs were added to the list of req’s. Also, I mentioned to Chris that we were starting on FA, and that it would not be Flash-based.
• Backups
• Deployed new PPM and PA
• Onward with Step 3: Explore the Starter Application
• Walked through FSMs with Dong. PA is getting complex in spots…
• ADF developer YouTube channel
  • This looks particularly good starting around 14:00 minutes in
  • More good stuff: Oracle ADF Insider – Learn Oracle ADF Online

FP

• Moved the Phantom over to the testbed a(new firewire cable and USB mux) and verified that the tactor project is compiling and running. Yay!

8:00 – 4:00 ESSO

• Backups and meetings.
• We need to figure out a way to get around the need to “double click” to get to a cell after filling out a form.
• Found a better set of tutorials: Charting with ADF Data Visualization Components
  • Part 1: Validating the Model and Starting Building the UI
  • Nope, can’t get connected to the DB to make a schema, so I’m screwed. Error message from Ant is:
    • C:JDeveloperFOD_11InfrastructureDBSchemabuild.xml:28: java.sql.SQLException: Listener refused the connection with the following error:
      ORA-12505, TNS:listener does not currently know of SID given in connect descriptor. Checking the error message leads here. Going to poke at that after lunch.
    • Following the link above, I was able to determine what the SID(?) jdbc was attempting to connect to. This can be done in a couple of ways:
      • Go to C:oraclexeapporacleproduct11.2.0servernetworkADMIN and view tnsnames.ora. It’s a text file. The file contains (in my case) three “definitions” of connections. In my case, the one labeled “XE” had my machine (WHITEOAK) listed as the host and a port (1521). That appeared to be the way to connect to the DB.
      • The above can also be done by typing “lsnrctl services” at the command line. in this case, it shows an instance called “xe”. HOST is WHITEOAK, though the port is different (49170)
      • I verified that xe was visible using “tnsping xe” on the command line. That looked promising, so I adjusted the build.properties (jdbc.sid =) to reflect that. And now that I go back and read the tutorial, it does indeed say that this value can either be orcl or xe. Woohoo!
    • Part 2: Starting Using Graphic Components
    • Part 3: Adding Other Complex Graphical Presentations to the Page
    • Part 4: Using the Thematic Map Component
  • On a separate note, it might be nice to put in the Feed Tem Social plugin and bring in interesting content related to our coding tavailes. Need to talk to Dong about that tomorrow.