I started using stored procedures in MySQL from ColdFusion.
I began receiving a NullPointerException when calling the stored procedure with the <cfstoredproc> tag. After checking the syntax I consulted Google for a hint. I found the MySQL JDBC driver that is included with ColdFusion is an older version that does not support calling stored procedures. I downloaded version 5 of MySQL Connector/J and copied the JAR to the shared library directory in my Tomcat installation and restarted.
I then created an "other" datasource in ColdFusion Administrator. I specified "com.mysql.jdbc.Driver" as the Driver Class. Stored procedures now work.
