Underlying Java methods of CFML objects

G'day:
A week or so ago, I wrote an article 'Using "undocumented" methods'. This got mention on CFHour last week: "Show #206 - Mucho Happy Box", and one observation I think Scott made was that it'd be useful to know what methods were available, even if one might not necessarily want to use 'em (see the earlier article and its comments as to why one might not want to use 'em).

Anyway, ages ago I came across a handy Java class, ClassViewer, which enables one to inspect the underlying methods of CFML objects using Java reflection. I wrote an article about it "ClassViewer.java", and posted the source code. I hasten to add it is not my own work, but it is jolly handy code. I also knocked together a CFML version of it: "ClassViewer.cfc" (Gist). I've gone through a pumped a bunch of CFML objects through this, and saved the output on my CFMLDeveloper account. Here's links to 'em all:

CFML: To that 20% of you out there: what the f*** are you thinking?

G'day:
I am utterly gobsmacked. Look at this:

These figures are from the intermediary results of the "State of the CF Union survey 2014" survey that's on currently. it's a trimmed version of the full results, which one can see if one completes the survey.

A few people in the community - including myself - have expressed derision at this:

@JimPickering more shocking is the 10% that do NO SOURCE CODE CONTROL! #StateOfTheCFUnion2014 #CFML #ColdFusion #Railo
— Sean Corfield (@seancorfield) January 29, 2014

@seancorfield @JimPickering and fucking *admit it*!!!
— Adam Cameron (@dacCfml) January 29, 2014

@seancorfield @dacCfml @JimPickering if you write code, but don't use version control, you're committing fraud on your customers
— Andy Allan (@fymd) January 29, 2014

SET ARITHABORT

G'day:
Hey, we've got a problem with a stored procedure we're running. When running it in SQL Server Management Studio it runs like lightning. When running it over a JDBC connection, it takes over a minute.

Our DB Manager has tracked this back to being down to a settings difference between the JDBC driver and SSMS... the latter has SET ARITHABORT=ON, and JDBC by default has it OFF.

Does anyone know how to pass these settings on the JDBC URL to set it ON? Or any other way of doing it?

Cheers for any suggestions.

--
Adam

Enhancement suggestion for parseDateTime()

G'day:
A quick one. parseDateTime() is used for taking a string and trying to convert it into a date object (as reflected by the date represented by the string).  It does a pretty shocking job of it, as demonstrated by the following code:

CFML: Bug(s) in ODBC-date/time formatting functions

G'day:
Whilst testing some TestBox glitches (more about that in a later article, but the executive summary is "it's good!"), I noticed some dodgy behaviour in the ODBC-date/time-formatting functions. In both ColdFusion and Railo.

TBH, I have no idea why we are using createOdbcDate() in our codebase at all... we do not use ODBC drivers. And that'd be the only time one would want to use these functions. Equally, they're only really useful if one wants to pass dates to DBs as strings, hard-coded into the SQL statement, and this should be actively discouraged in favour of passing parameters; and for that a native CFML date/time object is fine.

Firstly... what the hell are these functions for? (that's rhetorical... I'm about to tell you...) ODBC defines a string format one can use to unambiguously represent a date value. The details are in the Microsoft docs: "ODBC Datetime Format", but a summary is this:

{ literal_type 'constant_value' }
literal_type
Specifies the type of the escape sequence. Timestamps have three literal_type specifiers:

d

date only

t

time only

ts

timestamp (time + date)

constant_value
Is the value of the escape sequence. constant_value must follow these formats for each literal_type.

d

yyyy-mm-dd

t

hh:mm:ss[.fff]

ts

yyyy-mm-dd hh:mm:ss[.fff]

Note that the specification is very clear that the d is date only; the t is time only; and the ts is both.

State of the CF(ML?) Union survey 2014

G'day:
Just a quicky... I was astounded to see that the CFUnited blog is still "a thing", but it is. And they're currently running a survey entitled "State of the CF Union".

I think the survey is misnamed for where the CFML community is at these days, but - having filled it out - it's clear it's not a ColdFusion-specific thing, it's actually targeted at the CFML community as a whole.

So whether you use ColdFusion or Railo or OpenBD... go and fill it in! And spread the word about it. I know how hard it is to get CFMLers to fill in a survey, so the CFUnited bods could probably use all the help they can get.

Cheers.

--
Adam

Gavin is a star!

G'day:
Within minutes of me reaching out for help regarding my wee icon for the @CfmlNotifier Twitter account, me mate Gavin Pickin had sent me a number of options, more than one of which was eminently fit for purpose.

So I've picked this one:

That's pretty cool, and is fairly simple. Which suits me :-)

Currently my Twitter page is broken (Twitter are claiming responsibility) so I can't update it just yet.

Gavin: next time we're in the same place at the same time: there will be beer.

Cheers mate!

--
Adam