ntlmHTTP (Update 5) – This Project No Longer Necessary

I noticed some interest in my earlier posts about ntlmHTTP, and that surprised me a bit. I wrote about the subject in 2011, and that is a long time ago, in IT terms!

So to clarify things: the ntlmHTTP project is no longer required: Adobe added NTML (aka. “Windows Integrated Authentication”) support to the CFHTTP tag in ColdFusion version 11. I did rework my code from 2011, and indeed: CFHTTP did suffice to call the Microsoft Exchange web services successfully with the credentials of a special technical account.

Although I did not test it I’m pretty sure NTLM is still there in later CF versions ;-)

Read Full Post »

AndiCar, Or The Power Of Open-Source

Considering the number of mobile apps dedicated to the subject I know I’m not alone in wanting to know the fuel consumption of my vehicles. Like my father, I have been doing that as long as I have driven motor vehicles on two and four wheels. Since 2013 or so I am using AndiCar (on Android): it has the features I want, and it’s a piece of FOSS (Free and Open Source Software). Keeping an eye on your fuel consumption is always a good idea, since a rise in numbers can be the first indicator of a problem with your vehicle.

When we bought a bi-fuel car, however, things got complicated. In November 2017, as far as I could tell, there were no apps that had full support for “hybrid” or bi-fuel vehicles. I had no choice but to start experimenting a bit, and I settled on testing an app called Fuelio as a possible alternative for AndiCar. I won’t do a complete comparative review of these two: let me just explain that AndiCar is faster for data entry (at least in my situation: I enter the data in the evening or in the weekend, when I’m at home, not in the gas station), and Fuelio is the better looking app.

Some of the statistics available in the apps I mentioned (AndiCar on the left, Fuelio on the right). The numbers do not correspond because the periods are different, not because of errors ;-)

So I mailed Miklós, the author of AndiCar, explaining my situation. I probably wasn’t the first one to mention the “multi-fuel problem” to him. Nevertheless I’m quite impressed with the fact that six weeks later he already published a new version of AndiCar that allows detailed data entry for hybrid vehicles like mine. To top it off, he also mailed me to tell me about the new version!

One of the advantages of AndiCar is that it allows you to define your own fuel types. I actually use three types of fuel, since we have two types of CNG in Belgium: low caloric content (L) and high caloric content (H) gas. AndiCar is perfectly capable of handling that.

As a happy person I simply had to respond to Miklós – here’s the core of my mail:

Good work, man! You impressed me with the speed with which you implemented the support for alternative fuel vehicles. I’m not just giving you last version “a look”: I have copied all the fill-ups of my new car into AndiCar, of course.

For the moment I will continue to compare AndiCar with Fuelio, if only to get a feeling for what might constitute a good solution for the “fuel consumption/efficiency calculation” issue, as you call it. The Fuelio solution is not good enough: it just uses the distance between the two latest fillings for that type of fuel. But that results in silly numbers when driving most kilometers with one type of fuel, interspersed with an occasional fill-up of the alternative fuel (and that’ what I try to do: run mostly on CNG because it’s cleaner, just switching to petrol when no CNG is available).

What is probably needed, is a system whereby it is possible to indicate for each fill-up whether it can be used for a consumption calculation based on the previous fill-up of the same fuel type. Or perhaps an extra odometer field ? Or …? I realise that my situation is different from that of people with electric hybrid cars: my g-tron runs on CNG as long as there is enough of it in the tank, and switches to petrol with an explicit warning the moment that switch happens. In e-hybrids the rules are completely different, and I have no ideas about how AndiCar (or any other app) could support such calculations – I suppose those cars can do it themselves ;-)

Oh well. I’m already quite happy with the work you’ve done, so thanks again!

PS. I ran into one issue when entering my fill-ups in AndiCar: trying to “convert” an existing entry to the new fuel type and UOM crashed the app (I tried it several times). But of course, deleting the existing entry and reentering the data in a new entry solved the issue, so no real harm done.

If only all software makers would be so friendly and so quick to react to their users!

Read Full Post »

Unexpected Timestamp Effects In ColdFusion’s Query Of Queries

At work I’m busy moving all the ColdFusion applications from Windows 2003 servers with CF8 to new virtualised servers with Windows 2012 running CF11. Configuring Windows and IIS are also much more complicated than ten or more years ago, but we have that under control now. Most of the ColdFusion (and Java) code transfers without a problem, and I spend more of my time deleting scripts and components that are no longer used than modifying code.

Until this week, when I stumbled over a script that shows an inventory of the active Scheduled Tasks on the server, together with the link to their respective output (which we write to a network drive)… To do that, the code gets the data from the file, and then we put all the data in a handcrafted Query object. The names of the tasks and the links displayed fine, but there was something wrong with the start and end times: “1899-12-30” is not a time!

It took me hours to figure out what was wrong, because I was focusing on the date and time formatting functions used to format the data before adding them the query. Why the formatting, you ask? Well, we wanted to sort the data on columns containing start and end times, and in previous versions of CF our solution was to prepare the strings before adding them to the Query – seemed like a good way to make sure that ‘11:00:00 AM‘ and ‘11:00:00 PM‘ turned up in the right place of a sorted column.

So what was wrong with our code? Let me quote the “Query of Queries user guide”:

If you create a query object with the QueryNew function and populate a column with date constants, ColdFusion stores the dates as a string inside the query object until a Query of Queries is applied to the query object. When ColdFusion applies a Query of Queries to the query object, it converts the string representations into date objects.

Our code added strings formatted as “hh:mm” to the Query object, but once we filtered or sorted that Query using QoQ those columns were transformed into datetime objects. ColdFusion 11 then adds that time to the default date used, i.e. “1899-12-30“.

Clearly, that was not the case in earlier versions of ColdFusion – at least not in CF8. There are multiple solutions to solve this problem, once you know what’s going on – so now our overview displays everything as intended.

Read Full Post »

Dear Developer: When Reporting Exceptions, Please Be Clear

I’m currently trying to automate the creation of datasources in ColdFusion server instances, in order to facilitate a number of migrations our machines and applications have to go through. For the record: this turns out to be reasonably simple, once you get the knack of using the ColdFusion Administrator API classes (if I find the time, I’ll write about that later).

One thing slowed me down: a typical error message without much meaning. This is what I received when recreating (or at least trying to recreate) an Oracle RAC datasource:

java.sql.sqlrecoverableexception: IO Error: NL Exception was generated

I wonder why developers often invent error messages that do not tell us what really went wrong. In this case, it turned out that I forgot to copy a single closing parenthesis at the end of the JDBC connection string. Let’s call that a syntax error, Oracle, and please give a significant message if I mess up! Or is it Adobe’s ColdFusion that is hiding more explicit and clear details about what went wrong?

Read Full Post »

Great Job, Even If It’s Utterly Useless: b2fj

I appreciate the fun one can have at building programs and tools that do something thought to be impossible. Running Java code on a Commodore C64 is such a project.

Back to the Future Java (b2fJ) aims at bringing the power of Java to 8-bit home computers of the ’80s. This project provides a toolchain to cross-compile Java programs under Windows.

You’ll find everything about “b2fJ – Back to Future Java” on Github.

Read Full Post »

Kotlin: A Strangely Named Programming Language Brings Smiles To Coder’s Faces

The language isn’t new: Kotlin was created more than 5 years ago by JetBrains engineers. A preview version was released in 2011. Kotlin is a statically typed programming language for the Java Virtual Machine (JVM). Being crude, you could say that it’s “just another” enhancement of the Java language, just like Groovy or Scala. Nice, but hardly indispensable.

But Kotlin made a name for itself in May 2017, when Google announced “that it is making Kotlin […] a first-class language for writing Android apps” (in the words of Frederic Lardinois on TechCrunch). The Wired website has a bit more info on why the language was developed and why it is so “hot” these days. And the article concludes:

And its applications extend well beyond Google’s platform. Like Java, it can be used to write apps that run on desktops and servers as well. Plus, JetBrains has released tools for translating Kotlin code into code that can run on iOS or even in web browsers. All of which is to say, you can expect to find yourself using apps written in Kotlin more and more often in the coming months and years.

I have not yet written a line of Kotlin, but perhaps I should try that sooner rather than later. Since I’m also looking at Apple’s Swift language, the combination of learning both could be beneficial… or problematic, since someone asserts that both are quite similar (but not the same, of course): see “Swift is like Kotlin” for details.

I still would like to know how the name “Kotlin” was chosen…

Read Full Post »

Visual Studio For Mac Is Officially Available To All

Of course I’m going to try this out: “Huzzah, Visual Studio for Mac is now available to all“!

Click the image to see more details about the product

Read Full Post »