Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET rowcount 10
- SELECT * FROM TEST_TABLE
- require 'java'
- require 'jtds-1.2.5.jar'
- require 'rubygems'
- require 'active_record'
- config = {
- :username => 'railstest',
- :password => 'railstest',
- :adapter => 'jdbc',
- :dialect => 'sybase',
- :host => 'localhost',
- :database => 'railstest',
- :port => '5000',
- :driver => 'net.sourceforge.jtds.jdbc.Driver',
- :url => 'jdbc:jtds:sybase://localhost:5000/railstest'
- }
- ActiveRecord::Base.establish_connection(config).connection.execute(-- QUERY --)
- /usr/local/bin/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract_adapter.rb:219:in `log': ActiveRecord::ActiveRecordError: The executeUpdate method must not return a result set.: SET rowcount 10 SELECT * FROM TEST_TABLE (ActiveRecord::StatementInvalid)
- from /usr/local/bin/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.2/lib/active_record/connection_adapters/jdbc_adapter.rb:559:in `execute'
- from db-test.rb:21
- /usr/local/bin/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract_adapter.rb:219:in `log': ActiveRecord::ActiveRecordError: The executeUpdate method must not return a result set.: SET rowcount 10 SELECT * FROM TEST_TABLE (ActiveRecord::StatementInvalid)
- from /usr/local/bin/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.2/lib/active_record/connection_adapters/jdbc_adapter.rb:559:in `execute'
- from /usr/local/bin/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.2/lib/active_record/connection_adapters/jdbc_adapter.rb:629:in `select'
- from /usr/local/bin/jruby-1.4.0/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.2/lib/active_record/connection_adapters/jdbc_adapter.rb:550:in `select_rows'
- from db-test.rb:21
- require java
- require jtds-1.2.5.jar
- require rubygems
- require dbi
- dbh = DBI.connect('dbi:Jdbc:jtds:sybase://<host>:<port>/<db>', <username>, <password>, {'driver' => 'net.sourceforge.jtds.jdbc.Driver'} )
- require 'java'
- require './jars/jTDS3.jar'
- require './jars/jconn3.jar'
- require "rubygems"
- require "dbi"
- dbh = DBI.connect('dbi:Jdbc:sybase:Tds:foobar:2460/testdb', 'sa', 'password',
- {'driver' => 'com.sybase.jdbc3.jdbc.SybDriver'} )
Add Comment
Please, Sign In to add comment