Thursday, July 17, 2014

Oracle 12c VM for developers is here

Probably this is an old news and I'm just giving it some shout out here.

OTN Developer Day VM

The goodies in this VM as follows:

  • Oracle Linux 6.5
  • Oracle Database 12c Release 1 Enterprise Edition
  • Oracle XML DB
  • Oracle SQL Developer
  • Oracle SQL Developer Data Modeler
  • Oracle Application Express
  • Hands-On-Labs (accessed via the Toolbar Menu in Firefox)
Download oracle virtual box and load this VM for fun. 


Monday, July 14, 2014

Data dictionary that makes me angry

The user requested for an agreement report that consists of an agreement start date and agreement sold date. I found my table in the database and based on the column name it was straight forward.

AGMTSTARTDATE (Obviously, the column name stands for agreement start date)
AGMTSOLDDATE (This one is definitely the sold date)

The column is self defined obviously and therefore, the report is easy to generate and I passed the report to the user for review.

However, it was all wrong. According to the front-end system screen, the date reflected was the other way round. I was surprised why system screen would put the AGMTSTARTDATE as solddate and AGMTSOLDDATE as startdate.

The problem has prompted me to check in the data dictionary for the definition and it was defined as follows:

AGMTSTARTDATE - This is the agreement startdate. If the an agreement has a status as SOLD, the agreement sold date will be used as startdate.

This is sort of nonsense that really makes me angry. Apparently, the system developer is down right lazy to update the correct value in the correctly labeled column. Was it really that hard to switch the date between the two columns? Gee...

In short, this is just another bad design or lazy developer. :(

Saturday, July 5, 2014

Sony Xperia Z Battery Drain

Main cause of the battery drain? Google Play services.

After couple of re-occurrence of the battery drain, I found out that it was caused by the GPS I left it on for all day. I wonder why Google Play services keep using the GPS although I didn't open the app.

To fix this, always keep the GPS off after  using it.

Update: Android 4.4.4 update has fixed this.