Hello Lords of jRuby,
I want to submit something nice :
I’m currently trying to use MS SQL Server 2005 and rails 2.1 to play
together nicely (using jRuby 1.1.3 and the lastest sqljdbc.jar). So far
been quite confident I wouldn’t have any problem until I hit those
Imagine this SP which basically gets a int as parameter an returns the
double of its value (basic, right?).
CREATE PROCEDURE [dbo].[sp_test]
This works perfectly in a SQL Management Studio : Exec sp_test 2; ==>
Let’s move to Rails now…in a console (jruby script/console) in my
doing this : puts ActiveRecord.connection.select_value(“Use MyDevDB;
AR returns an error: ActiveRecord::StatementInvalid:
ActiveRecord::ActiveRecordError: A result set was generated for update.
I tried connection.execute, connect.select_all but they returns same
but what’s the deal here? I’m not (at any moment) trying to open a
for any update, it’s a dawn simple Stored Procedure giving me back a
I’ve been looking on all SQL forums, on MSDN web site, etc. it seems
error message comes from the SQL Server itself , but i guess that at any
moment AR is not giving right infos to SQL who believes I try to open
recordset for update, right?
Anyone with a solution there?
I just tried same situation using ruby…
this works with
so wtf isn’t that correctly working with jRuby and sqljdbc.jar??? (rem
this autocommit is not available with this jdbc adapter)
View this message in context:
Sent from the JRuby - User mailing list archive at Nabble.com.
To unsubscribe from this list, please visit: