Last weekend, I updated my HTPC with all new hard drives and software. I had been putting it off because of an incompatibility between my IR receiver and the latest kernel drivers. But a couple weeks ago, I learned about the flirc device and immediately ordered one. Flirc doesn’t require any complicated setup or special [...]
Archive of posts filed under the Technology category.
Returning A CLOB From A Java Stored Procedure
This took me way too long to figure out. All of my search results were coming back with questions about passing CLOBs or VARARRAYs to a Java stored procedure, and nothing about returning such datatypes. In the end, it turns out to be somewhat simple, but completely nonsensical. First, know that you will need to [...]
A Simple Grails Plugin
Before I get into this, I want to make it clear that my Groovy knowledge is basic to moderate, at best. Also, my Grails knowledge is even less. In fact, things like Grails rub me the wrong way. But I haven’t seen any articles that clearly describe this process from a beginner’s perspective. So this [...]
Oracle And Unix Timestamps Revisited
In my last post I provided some Oracle PL/SQL functions for dealing with Oracle DATEs and Unix timestamps. After using these functions in an application that is executed via Oracle Application Server I discovered a problem. In short, if the executing environment doesn’t supply any time zone information then the part of the functions that [...]
Oracle, Daylight Saving Time, And Unix Timestamps
Notice: the functions in this post are fragile. See Oracle And Unix Timestamps Revisited for a more robust implementation. If ever there was a combination to make you hate developing web applications against an Oracle database, it’s the one defined in the title of this post. Let’s see: Unix timestamps are used in a lot [...]
