Choi, Junegunn
2/22/2009 9:17:00 AM
2009/2/21 Joseph Still <daitai.raifu@gmail.com>:
>
> So in summary:
> -MSSQL DB connection
> -Must be usable across Linux and Windows with minimal changes
> -Must allow for multiple record sets
>
Hi, If it's ok to use JRuby, you can try JDBC with JRuby. I have no
experience in MSSQL and ADO, but i'm sure MSSQL provides JDBC driver
and JDBC is inherently compatible across different platforms. And if I
understood your point correctly, it supports multiple record sets as
well. The following JRuby code works with my PostgreSQL database.
stmt.execute 'select * from test_a; select * from test_b'
rset = stmt.get_result_set
while rset.next
puts rset.get_long(1)
end
stmt.get_more_results
rset = stmt.get_result_set
while rset.next
puts rset.get_long(1)
end
--
junegunn.