Hier ein kleines Beispiel wie man mittel JRuby über JDBC sich zu Oracle verbinden kann:
require 'java' module J include_package "java.lang" include_package 'java.sql' end db_user='jruby' db_password=db_user db_host='localhost' db_port=1521 db_sid='XE' url="jdbc:oracle:thin:#{db_user}/#{db_password}@#{db_host}:#{db_port}:#{db_sid}" J::Class.forName("oracle.jdbc.OracleDriver") conn = J::DriverManager.getConnection(url); stmt = conn.createStatement rs = stmt.executeQuery("select object_type, object_name from user_objects") while (rs.next) do puts rs.getString(1)+' '+rs.getString(2) end rs.close stmt.close conn.close()
Bisher keine Kommentare