Folks,
I am using ruby 1.8.5 with rails 1.2.3 and have made changes to
mysql_adapter.rb based on recommendations made here
http://wiki.rubyonrails.org/rails/pages/StoredProceduresInMySql to be
able to use stored procs in my code.
I have changed this call in mysql_adapter.rb
ConnectionAdapters::MysqlAdapter.new(mysql, logger, [host, username,
password, database, port, socket], config)
to
ConnectionAdapters::MysqlAdapter.new(mysql, logger, [host, username,
password, database, port, socket, 65536 + 131072], config)
as recommended. However I use connection.select_all(“call
spName(params)”) to execute my stored proc instead of using select_sp
as defined and recommended in the abovementioned article - partly
because select_all seemed to work fine and the article above was
written for some older version of rails as the lines numbers where
changes were to be made didn’t match with those in my version of
mysql_adapter.rb file.
However, after making that one change, while individual calls to
stored procs work fine now, when I mix stored proc calls with Rails
based database look ups (two separate lines of code in the same
function) I get the following error
Mysql::Error: Commands out of sync; you can’t run this command now.
In general I find very little documentation on usage of stored procs
in rails. I know it is not recommended but when you are forced to
there doesn’t seem to be much support available on this topic.
Thanks for any thoughts/pointers to help with this problem.
-S