Ever since our websites were upgraded to ColdFusion 8.1 and Mysql 5.14, 

we are receiving random null pointer error when executing queries.

Unfortunately the error is very non-specific, no message or line number. 

It looks like this:

The Null Pointer error is due to an issue with ColdFusion8 and MySQL. 

The fix for this is to uncheck 'Maintain connections across client requests' 

in the Advanced settings fir the ColdFusion DSN. 

Please let us know if we can be of further assistance.

Solutions:

- turning off "Maintain connections (-Maintain connections across client requests.)

OR

- Downgrading Mysql 5.1.x, 5.0.4x to Mysql 5.0.3x

After downgrading the Mysql 5.1.42 to 5.0.37.  there are no null pointer errors.