ColdFusion Muse

JDBC Drivers, Data Binding and Implicit Conversion

You may know that MSSQL allows for "implicit conversion" between data types. For example if you have a character column and you pass it a number without single quotes (as in myCharCol = 1), MSSQL will automatically convert the value 1 into a character for the purpose of the query. On a Coldfusion 5 server this behavior carries through seamlessly even when you are binding data using cfqueryparam. However, if you are using cfqueryparam in a query on a CF 5 server and also relying on implicit conversion within the same query you should know that you may have a problem getting that cfquery to work in Coldfusion MX. The issue is that JDBC "prepares" the statement by validating against the schema. Here's an example:


Instructions on Upgrading the JVM

My friend and fellow Guru Ryan Stille has written an outstanding tutorial on upgrading your JVM. In case you didn't know, you will need to move your JVM up to 1.4.2_11 prior to March 11th in order to comply with new daylight savings time standards.

Coldfusion MX and the 64 bit JVM

CF Muse Reader, Eric Priest from Montana University, Asks:
We are getting ready to upgrade our web and database servers from Windows 2000, running SQL server 2000, 32-bit, to Windows 2003 server running SQL server 2005, 64-bit. We have a lot of legacy applications written in JavaScript and Coldfusion mx studio. I am wondering if these changes will break any of our existing applications and how can I determine the impacts?

First, you should know that this is not a widely used platform yet - at least not for web servers. Secondly, if you are running both SQL 2005 and Coldfusion on the same 64 bit server make sure and buy 6 Gigs or more of RAM. Now, assuming you have separate servers SQL will run splendidly in 64 bit mode (assuming you have the right version). Let's talk about Coldfusion.


Coldfusion MX and Mqseries Revisited

In my previous post on the topic of integrating MQSeries with Coldfusion MX I included some sample code for sending and retrieving messages to "put" and "get" queues using an MQManager object. This post has a correction and addition to that original sample code.


Working With IBM's MQSeries and Coldfusion MX

This post may be one that very few of my readers will care about. But if you are the 1 reader in 1000 that needs to know how to connect to MQSeries version 6 using coldfusion then this post may prove a life saver. You can benefit from the 50 hours of my life I spent figuring this out that I will never get back. Here's the scoop. We have a client who needs to upgrade a Coldfusion installation running on CF 5. The current installation uses COM. Under a load it becomes unresponsive.

NOTE: There is an update to this post that was entered on 4/24.


Why move to CFMX

Picture this - a good customer comes to you with a complex application running nicely on Coldfusion 5.0. It has a few performance issues, but much of it is related to the code not the platform. He or she poses this question, "Why should I move to Coldfusion MX"? Hmmmmmm....


Blog provided and hosted by CF Webtools. Blog Sofware by Ray Camden.