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.