Stored Procedures mySQl 5, CFMX 6.1

[WeeJames]

Hi Folks,

Today we went about upgrading one of our servers to mySQL 5 in order to use
the delights of stored procedures on our new application.

Installation was fine and all datasources were getting picked perfectly (using
the mysql-connector-java-3.0.16-ga-bin.jar driver to connect, as we had
installed this for mySql 4.1). Everything works fine except stored procedures
from CF (using the <cfstoredproc> tag) which gives the following error message.

Error Executing Database Query.
Callable statments not supported.

While trying to find a solution i read that the 3.0.16 drivers didnt support
stored procedures as these function were not implemented in mySQL when they
were released. Fair enough i thought and proceeded to upgrade to
mysql-connector-java-3.1.12-bin.jar (the latest version availible on
mySQL.com). Unfortunately all this does is give another error when trying to
perform any query.


Unable to instantiate logger class 'com.mysql.jdbc.log.Log4JLogger'


Has anyone got stored procedures working successfully in mySQL 5 with CFMX 6.1?

If so, please shed a little light on what drivers etc. you ended up using.

Cheers

James

[WeeJames]

For completeness.... and anyone who finds this thread in the near to
distant future...

The only way ive found to get around this problem is to use the 3.2.0
Connector J drivers. At the moment they're still in Alpha but they seem
stable enough to use.

James

[Mountain Lover]

out of curiosity, the latest is 3.0.17 ga that runs with CFMX 6 (
[url]http://dev.mysql.com/downloads/connector/j/3.0.html[/url] ) have you tried
that? (you say 3.0.16) I haven't tried 3.0.17 with MySQl5, but it does
work with 4.0 and 4.1...so I don't know if 3.0.17 can use SPs.
HTH,
Tim
--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]

[TomDonovan]

You probably want to avoid Connector/J 3.1.17 because of mySQL bug
[url]http://bugs.mysql.com/bug.php?id=13469[/url]

This prevents using 3.1.10 or higher versions with CFMX7 until it gets fixed.
Probably CFMX6 too.

Connector/J 3.1.9 works with CFMX 7.0.1 and mySQL 5.0 on Windows.
Finding previous Connector/J 3.1 versions can be a little tricky - but they
still can be found if you dig a little.