Problems with stored procedures in mysql5 and coldfusion

I have been haveing a problem calling stored procedures from a cfquery tag. Something to do with result sets.

Anyway, the solution that worked for me was to use a jdbc dsn rather than a mysql dsn in the coldfusion administrator.

First I downloaded the jdbc connector from mysql.net and installed it on my Ubuntu coldfusion installation

Next I entered the details below in my coldfusion administrator:
CF Data Source Name: xyz_dsn
JDBC URL: jdbc:mysql://localhost:3306/my_db
Driver Class: com.mysql.jdbc.Driver
Driver Name: jdbc-mysql
username: xyz
password: pwd0002

Now I can use the cfquery tag to call stored procedures!