Wild guess. One is a 64 bit install, the other is a 32 bit installation and the DLL only corresponds to one. ... View more

Where do you disable TLS 1.1? Where does the error occur?  When you disable TLS 1.1 on the ColdFusion Server and the error appears in the client's browser this does not have to do with the SQL Server. This is a different issue,  IMO. ... View more

This was the first I read today so I had an idea: Adobe Security Bulletin ... View more

The news sounded to me like the security issue was so urgent that the updater only brings the fix. Adobe Patches Critical ColdFusion Vulnerability With Active Exploit | Threatpost ... View more

Thanks for the mention. I'll look into this. ... View more

It looks like Punycode encoding (RFC 3492) that's used for domain names that contain special/high characters. There's a JAVA function that can do this To get the result ending by "-62bk" the name has to be followed ba a space. <cfdump var="#CreateObject( "java", "java.net.IDN" ).toAscii('"Joe Sánchez Hernández "')#"> <cfdump var="#CreateObject( "java", "java.net.IDN" ).toUnicode('xn--"joe snchez hernndez" -62bk')#"> Interestingly there's a space in front of the dash/minus 62bk after the quotes. The encoded result does not differ whether there's a space before or after the quote. ... View more

Sorry for not returning earlier. Thanks alot for your suggestions. I take it's not an issue of ColdFusion working with the data retrieved from the Thin JDBC driver. I will dive deeper into this issue, no idea why I first observed it in an Oracle scenario. ... View more

Do you know, what exception is thrown? Do you throw the exception yourself using cfthrow? I very quickly tried your sample. I copied your onError method to an otherwise empty Application.cfc and filled the session variable with a constant 0 . I created an exception using cfthrow and got the mail as expected. I used ColdFusion 2018 in a CommandBox setup. I guess it's already been updated to the most recent version - Update 2. I'm not sure if getMetaData exists for every datatype. Therefore I assume your exception contains some data that's usually not contained in an exception. ... View more

Hi, I've been naming my queries local.qRead etc. for years. Never use a variable without scope. ... View more

cfprocessingdirective changed nothing. I made a minimal sample. The special characters were not broken in the dump. Sorted last, still. ... View more

Thanks for the replies. My files are UTF8 encoded, therefore my JVM args already contain -Dfile.encoding=UTF8 In Oracle the result is sorted correctly and all the characters are displayed right in a cfdump. ... View more

Forgot the most important thing: I query the Oracle DB using the thin driver. ... View more

Depends on how you use SO. Ask your questions, accept the answers and let it be. ... View more

How does your call to LSParseDateTime look? It accepts up to three arguments? ... View more

There's one question regarding languages one used in the past year and will be using in the next year. CFML is not mentioned so one has to enter it manually. ... View more

Hi Dave, It's a very old blog post but CF once came with a version of CKEditor that allowed for certain attacks: https://www.petefreitag.com/item/704.cfm I'd say it's important to know what Adobe delivers and keep your setup up to date. ... View more

There was this thread some times back: ExtJS 4.1 Licence Adobe ColdFusion 2016 The original poster never explains where he got version 4 from. Sencha - the company behind ExtJS - has changed their licensing model repeatedly over the years. Adobe - I assume - never licensed a version after a later model and therefore still comes with a 3.x release. ... View more

Can you say what pages do not work? Maybe we can recognize a pattern? ... View more

Sean, you write other langauges allow to choose the JVM you run it on top. The thing with ACF is the missing compatibility with recent releases. I have to update JAVA every once in a while. I don't care if the major or the minor release number increases. The possibilities in my opinion are either Adobe provides JAVA 8 releases for the money I bought the license with. Adobe can also recommend a free updated release like AdoptOpenJDK or Corretto. Other possibility is, Adobe updates CF to be compatible with recent JAVA versions. I'm not a JAVA developer. I cannot say how much 10, 11, 12 etc. differ. Maybe Adobe needs to do a handful fixes only, and is safe for a couple releases. I don't remember a CF update bringing a new JDK version, an updated installer, however, brought a newer JDK version. I always keep my JDK install recent myself. That allows to secure my installation against JAVA security issues. ... View more

It seems Coretto will be available as Version 8 while OpenJDK (JDK 11.0.1 GA Release )  does not come as 8 for Windows. I guess it will be hard for Adobe to make CF11 support JAVA 11, 12 or what ever is latest. Same might be true for 2016. ... View more

Adobe pages are not well indexed by google etc. I directly searched at the tracker site. ... View more

As far as I understand, today, you can buy CF 2018 licenses and downgrade to 2016 (Adobe provides exclusive download links and a license key). No other purchase option is available. You can use CF 10 as long as you like. However, there's a chance a security related error may be found that will not be fixed. You should be careful when your site is available to the public internet. Errors may exist in CF or the JDK. CF 10 is able to use JDK 8. Free updates will not be available after January 2019 ... View more

What files are you talking about? Source files like .cfm or .cfc? When you use ColdFusion to read data from .xlsx files using POI a lock is maintained because some JAVA object was not closed correctly. ColdFusion also maintains a lock on .jar file imported using this.javaSettings in Application.cfc ... View more

Extended support is for users paying additional money. By the time CF10 was released POI probably wasn't outdated. POI is one of the libraries that can simply be replaced, has always worked. OP says he exports the files from SQL Server 2016; that was released four years after CF10 ... View more

For completeness' sake <cfset oJsoup = createObject( "java", "org.jsoup.Jsoup" )> <cfset oFile = createObject( "java", "java.io.File" ).init( Expandpath( "./file001.html" ) )> <cfset oDoc = oJsoup.parse( oFile, "UTF8" )> <cfset arrLinks = oDoc.select( "A" )> <cfloop array="#arrLinks#" index="oEl"> #oEl.attr( "href" )# </cfloop> JSOUP has plenty parse methods, input does not need to be a local file: Jsoup (jsoup Java HTML Parser 1.11.3 API) ... View more

I don't have the code at hand at this moment but there's a library called JSOUP. You feed it an HTML String (document, whatever) and can query tags like a DOM. No need to care for RegExp at all. ... View more

Do you have an IIS server on top of Tomcat? I trust, Auth_user is only filled with a value if "Windows Authentication" is enabled on the IIS site ... View more

Hi Charlie, thanks for your reply.  I sent a message to the mail address you provided after I set up a small sample that seemed to confirm my observations. ... View more