>- see footer for list info -< 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 though 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 _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
