jRuby jtds to MS SQL Server
Here's an example of connecting to SQL Server using jRuby with the jtds driver:
include Java
require 'jruby-1.4.0/lib/jtds-1.2.5.jar' # path to driver jar file
module JavaSql
include_package 'java.sql'
end
begin
import 'net.sourceforge.jtds.jdbc.Driver'
conn = JavaSql::DriverManager.getConnection("jdbc:jtds:sqlserver://192.168.0.31:1433/database","username","password");
stmt = conn.createStatement
rs = stmt.executeQuery("select * from Property")
while (rs.next) do
puts rs.getString("scode")
end
rs.close
stmt.close
conn.close()
rescue JavaLang::ClassNotFoundException
puts "ClassNotFoundException"
rescue JavaSql::SQLException
puts "SQLException"
end
0 comments
Twitter