Leo on Tech

Powered by
WordPress

  • Creating Start Menu shortcuts with Javascript

    While preparing the installer for the Web 2.0 Starter Toolkit for IBM DB2, I had to set up Start Menu shortcuts. The way to do that is to work through the Windows Scripting Host (WSH). The WSH supports two built-in languages – VBScript and Jscript – and a theoretical number of third-party alternatives. VBScript is…

  • Setting up svn with trac

    Trac is an excellent web-based wrapper for SVN that adds bug tracking, a wiki, and several handy project management features. I keep setting up new repositories up for all the little projects we cook up in DB2 Technical Marketing, so I thought I’d write up a guide. Installing Trac, SVN, and dav_svn for Apache2 is…

  • Rails and DB2 data types

    When creating a table in a Rails migration, you have to specify data types using platform-agnostic names. The mapping of Rails types onto DB2 types is defined in ibm_db_adapter.rb: :primary_key => @servertype.primary_key, :string => { :name => “varchar”, :limit => 255 }, :text => { :name => “clob” }, :integer => { :name => “integer”…

  • No implementation defined for org.apache.commons.logging.LogFactory

    While writing a DB2 stored procedure that invoked a SOAP/WSDL web service using Apache Axis as part of WSIF, I ran into this doozie: org.apache.commons.discovery.DiscoveryException: No implementation defined for org.apache.commons.logging.LogFactory Ultimately, it’s caused by a too restrictive lib/security/java.policy file that ships with DB2. Wrong Solution The standard way to define an implementation is to create…

  • Utilities for Windows I

    Hard Drive Cleanup WinDirStat is an excellent utility for visualizing your used disk space and drilling down to files that you can clean up, back up, and delete. It’s similar to SequoiaView and Steffen Gerlach’s Scanner, but even more powerful. You can drill down through a folder tree as well as highlight filetypes in the…

  • Choosing colours

    One of the tricky things in web design is picking the right colours. They need to be easy to read, not grim, not flashy, yet somehow distinctive. Often, taking a stab in the dark and then tweaking a screenshot of the result for saturation, contrast, and the like can be very effective. At other times,…

  • Unexpected for following namespace declaration

    I ran into a problem running a simple test xquery. I hadn’t directly dealt with XML namespaces in xquery prior to this, but the documentation was clear enough: XQUERY declare default element namespace “http://posample.org” for $x in db2-fn:xmlcolumn(“PURCHASEORDER.PORDER”) return $x Oops, EOF error. It needs a terminator. XQUERY declare default element namespace “http://posample.org” for $x…

  • Mapping DB2 databases after a reinstall

    Due to the vagaries of software, I had to reinstall DB2 on my laptop. Unfortunately, the existing databases were not automatically added to the Control Center. Physically, DB2 stores its databases in a directory similar to C:DB2NODE0000. Logically, there must a way to remap them. So, how does one remap them? To list databases stored…

  • Installing Pear and PECL on Zend Core for IBM

    Links Atomized | PHP Performance Best Practices – Informative. Installing PEAR and PECL on Zend Core for IBM Save http://go-pear.org/ to go-pear.php (in, say, C:Program FilesZendCore for IBMpear) Open Command Prompt % cd “C:Program FilesZendCore for IBMpear” % ../bin/php go-pear.php Follow the steps and let it modify your php.ini Restart your Apache Installing the profiling…

  • Reflection

    Post obsolete. See Reflection in Javascript instead.