Connect from jruby to SAP HANA 1.0 using JDBC

You can easily connect to SAP HANA 1.0 through jdbc installed with your HANA Studio on SAP HANA Client.

In case on jruby programming language it will look something like this:

require 'rubygems'

require 'java'

require 'ngdbc.jar'

driver = Java::com.sap.db.jdbc.Driver.new

props = java.util.Properties.new

props.setProperty("user", "<username>")

props.setProperty("password", "<yourS0oPaCo0lPWD>")

props.setProperty("autocommit", "false")

props.setProperty("reconnect", "false")

url = 'jdbc:sap://<hostname>:<port>/?'

conn = driver.connect(url, props)

statement = conn.create_statement

q = "SELECT 'hello from SAP HANA database' as name FROM dummy"

rs = statement.execute_query(q)

while (rs.next) do

  puts rs.getObject('name')

end

statement.close

conn.close

Check out more at experiencesaphana and Official SAP HANA help.