Kompaktne kalender 2009 Eesti pühadega

Hiljuti avastasin DavidSeah The Printable CEO sarja kuuluva Exceli kalendritemplate'i Compact Calendar 2009.  See kalender ei jäta iga kuu algusesse ja lõppu nädalate keskele auke, seetõttu on planeerimise jaoks praktilisem kui paljud muud tavapärased kalendrid. Eesti Vabariigi rahvus- ja riiklike pühadega eestikeelne versioon (Excel 97-2003 template) on saadaval siin:

Kompaktne Kalender 2009 Eesti

(This page links to the Estonian-language version of the Excel template for DavidSeah's Compact Calendar 2009.  The template contains Estonian public holidays.)

XML Diff

Today I googled for XML diff tools and found this great XML Diff tool!  And it comes with source code, so I can run it on my own machine without uploading confidential files to their servers (you also need the XML Pretty Printer they graciously provide).  

There are other tools that came up in google results, but none other proved so simple and effective.  

Host-specific configuration files in Spring, with fallback

I was very happy to find a practical example of how to use host-specific configuration files in Spring, but unfortunately, the given example still forces one to specify a configuration entry for each host that the application might ever be deployed on.  I am lazy, I would like to have a reasonable fallback, and only configure for the specific exception cases.  Hence I have enhanced Jeff's code a little further:

// In class HostPrecedingPropertyPlaceholderConfigurer
protected String resolvePlaceholder(String placeholder, Properties props) {
 try {
   if (placeholder.startsWith("HOST.")) {
     String hostname = InetAddress.getLocalHost().getHostName();
     String hostSpecific = placeholder.replaceFirst("HOST", hostname);
     log.debug("Looking for property " + hostSpecific);
     String value = props.getProperty(hostSpecific);
     if (value == null) {
       log.debug("Falling back to default property " + placeholder);
       value = props.getProperty(placeholder);
     }
     return value;
   } else {
     return props.getProperty(placeholder);
   }
 } catch (UnknownHostException e) {
   log.warn(e);
   return null;
 }
}

Now, my ${HOST.jdbc.url} in the Spring context file will first look for my hostname.jdbc.url property, but alas, if that returns null, it will default to the value of the HOST.jdbc.url property, enabling me to have a properties file like this:

prodweb.jdbc.url=jdbc:mysql://proddata/db
testweb.jdbc.url=jdbc:mysql://testdata/db
mstest.jdbc.url=jdbc:sqlserver://mstest\\sql2005;database=db;integratedSecurity=true
HOST.jdbc.url=jdbc:mysql://localhost/db

It might be even nicer if it looked for default.jdbc.url, or fallback.jdbc.url, depending on your taste. :-)

Trip tracker

Added Tomek & Rita's trip tracker to the left sidebar.

Apparently it cannot just be copy-pasted into Edit HTML section as-is... :-(

But it can be done via the Layouts / Page Elements section!  Here is how:

After clicking Add a Page Element, a new window will appear.  In the new window, choose:

Well, the layout of these instructions is now all messy... I don't really know how to arrange pictures in a blogger post yet.  But hey!  after you add the new HTML/JavaScript element, it will ask you for the title (anything) and for the actual code (which you have from whereever you got it).  Save, and then you can already arrange your new widget by drag-and-dropping it to the right location:

There you should have it!

:-)

First Post!

:-)