>- see footer for list info -< 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 [EMAIL PROTECTED] wrote on 19/12/2005 16:45:38: > >- 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 -< _______________________________________________ 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 -<
