Saturday 15 May 2010

jdbc - jRuby: use oracle database -


I try to make this simple MRI script work in jRuby but I get an error below I have the same gem in my MRI , I do not want to use active records JDBC, just make a simple connection and query, what should I do?

  C: \ jruby-1.7 4 \ bin & gt; JRuby gem list S --local   

returns

  .. ruby ​​oci8 (2.1.0 86-mingw32) ..   

script

  requires 'oci8' $ Conn = OCI8.new ('test', 'test', 'dbcm.cm_121') SQL =% Q {table Select * from $ conn.exec (sql) .fetch_hash do | R | R.each {| Key, value | "# {Key} is # {value}"} Finally puts $ conn.logoff   

error

  C: \ jruby-1.7 .4 \ test & gt; JRuby fetch_sql.rb LoadError: No such file to load - og8lib_jruby191 requires org / JRuby / RubyKernel.java: 1054 celsius is required: /jruby-1.7.4/lib/ruby/shared/ Rubygems / custom_require .rb: at 36 celsius (route): /jruby-1.7.4/lib/ruby/gems/shared/gems/ruby-oci8-2.1.0-x86-mingw32/lib/oci8.rb: 43 Org / requires JRuby / RubyKernel.java: 1054 (root) at C: /jruby-1.7.4/lib/ruby/shared/rubygems/custom_require.rb: 1 (root) at fetch_sql.rb: 1  

It seems that this is not possible, otherwise please tell us at least / least simple Eg The deer I can produce using JDBC

  requires Java meaning #source: http://www.oracle.com/technetwork/articles/dsl/jruby-oracle11g- 330825 Start Html java_import 'oracle.jdbc.OracleDriver' java_import 'java.sql.DriverManager' oradriver = OracleDriver.new Driver Manager. Registry driver user = 'xxx' passwd = 'xxx' url = 'jdbc: oracle: thin: @xxxxxx: 9999: Xxxx' conn = DriverManager.get_connection url, user, passwd select_sql = "select from resources" select_stmt = conn.create_statement Rset = select_stmt.execute_query select_sql "([rset.next]" resource [# {rast.getInt (1)}, # {Rset.getString (2)}] "End rescue transmission" failed to execute Oracle demo from JRB ", $ !, "\ n" Make sure select_stmt.close conn.close_connection end    

No comments:

Post a Comment