On Wednesday, March 7, 2012 4:25:59 PM UTC-8, Hillary wrote: > > Does any of the mssql adaptors support executing a stored procedure? > > It seems like JBDC does, but I'm using sequel with watir to test a web > application so i can't really install jruby. >
Unfortunately, JDBC is the only adapter that currently supports MSSQL and stored procedures. The odbc, ado, and tinytds adapters support MSSQL, but not stored procedures. By that I mean there is no direct support at the Sequel level. I vaguely recall you can just call stored procedures in MSSQL using literal strings with EXEC, but I don't believe there is support for in/out variables (I don't think the Sequel JDBC adapter supports in/out variables either). Note that if stored procedures are supported directly by the underlying driver, you can just drop down to the driver level via DB.synchronize and call the methods on the yielded connection object. I'll certainly consider merging patches that add stored procedure support, as long as they come with specs. Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/sequel-talk/-/LLI-pBBtzA0J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
