Select Page
Using ROW_NUMBER() to provide a unique row id

Using ROW_NUMBER() to provide a unique row id

Not too long ago, I needed to populate a lookup table with the data that already existed in a referencing table. Yes, yes there is a problem with the original design of the database but that is another topic. However it did provide an opportunity to learn the...
Visually show text differences

Visually show text differences

The Apache Commons Text library comes with some nifty string comparison routines which is nicely demonstrated by Baeldung in his Introduction to Apache Commons Text. Instead of only calculating the difference, I wanted to visually display those differences to the user...
Sending an email to Gmail using Apache Camel

Sending an email to Gmail using Apache Camel

Setting up Gmail All of the advise that most site provide is that you should allow less secure access to your Gmail account during the testing and then turn this setting off again afterwards. Gmail 2-Step Verification What I have found to work better is to enable...