search for: oracle_adapt

...ror: out of range of Time (expect between 1970-01-01 00:00:00 UTC and 2037-12-31 23:59:59, but 1807-10-06 22:33:09 PST) /usr/pkg/ruby184/lib/ruby/site_ruby/1.8/oci8.rb:983:in `to_time'' /usr/pkg/ruby184/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/active_record/connection_adapters/oracle_adapter.rb:503:in `select'' ./test/../lib/active_record/base.rb:1360:in `each_with_index'' /usr/pkg/ruby184/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/active_record/connection_adapters/oracle_adapter.rb:496:in `select'' ./test/../lib/active_record/connection_adapte...

...-04-26 13:43:29 -0700 (Wed, 26 Apr 2006) | 1 line > > Add Oracle support for CLOB inserts. Closes #4748. [schoenm@earthlink.net sandra.metz@duke.edu] > ------------------------------------------------------------------------ > > U activerecord/lib/active_record/connection_adapters/oracle_adapter.rb > U activerecord/CHANGELOG > Updated to revision 4280. >

...2: render :action => ''new'' 163: end Here''s the error (which is the same as what''s in the dev log): ArgumentError in Schedules#create wrong number of arguments (1 for 0) /opt/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/connection_adapters/oracle_adapter.rb:53:in `attributes_with_quotes_pre_oracle'' /opt/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/connection_adapters/oracle_adapter.rb:53:in `attributes_with_quotes'' /opt/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/base.rb:2031:in `quoted_column...

the error is : wrong number of arguments (1 for 0) where : active_record/connection_adapters/oracle_adapter.rb:53:in `attributes_with_quotes_pre_oracle'' this method is new, it was an alias in the previous version : alias :attributes_with_quotes_pre_oci :attributes_with_quotes #:nodoc: I replaced the method by the alias of the previous version, and it is working fine. This is the co...

...nt_record'' C:/web/IPSO/app/controllers/attending_ips_controller.rb:26:in `new_edit'' -e:4:in `load'' -e:4 C:/ruby_prod/lib/ruby/site_ruby/1.8/oci8.rb:229:in `initialize'' C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/connection_adapters/oracle_adapter.rb:585:in `new'' C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/connection_adapters/oracle_adapter.rb:585:in `new_connection'' C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/connection_adapters/oracle_adapter.rb:621:in `initi...

...record/test/calculations_test.rb U activerecord/lib/active_record/calculations.rb U activerecord/CHANGELOG Updated to revision 4185. 1) Error: test_should_limit_calculation(CalculationsTest): TypeError: can''t convert String into Array ./test/../lib/active_record/connection_adapters/oracle_adapter.rb:310:in `replace'' ./test/../lib/active_record/connection_adapters/oracle_adapter.rb:310:in `add_limit_offset!'' ./test/../lib/active_record/base.rb:1046:in `add_limit!'' ./test/../lib/active_record/calculations.rb:156:in `construct_calculation_sql'...

...thing is fine until i try updating/inserting something into the DB. This is the error message : wrong number of arguments (1 for 0) RAILS_ROOT: config/.. Application Trace | Framework Trace | Full Trace /opt/tools/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/connection_adapters/oracle_adapter.rb:53:in `attributes_with_quotes_pre_oracle'' /opt/tools/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/connection_adapters/oracle_adapter.rb:53:in `attributes_with_quotes'' /opt/tools/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/base.rb:1719:in `u...

All, While attempting to use ActiveRecord against a large database, approx. 1700 tables and 4 million rows, I discovered an inefficiency in oci_adapter.rb. The problem seems to be the SQL being generated to lazy-load the columns metadata. "def columns(table_name, name = nil)" method generates the following SQL: select column_name, data_type, data_default, nullable,

...;': OCIError: ORA-00972: identifier is too long: CREATE TABLE lock_with_custom_column_without_defaults (id NUMBER(38) NOT NULL PRIMARY KEY, custom_lock_version NUMBER(38)) ./test/aaa_create_tables_test.rb:18:in `test_load_schema'' ./test/../lib/active_record/connection_adapters/oracle_adapter.rb:243:in `execute'' ./test/../lib/active_record/connection_adapters/abstract/schema_statements.rb:104:in `create_table'' ./test/../lib/active_record/connection_adapters/oracle_adapter.rb:368:in `create_table'' ./test/../lib/active_record/migration.rb:274:in `m...

...oci8lib.so: ORA-12514: TNS:listener does not currently know of serv ice requested in connect descriptor (OCIError) from c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:228:in `initialize'' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_recor d/connection_adapters/oracle_adapter.rb:585:in `new'' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_rec If I change the adapter to ''oracle'' I get C:\rb-play>ar_connect_ss.rb env.c:257:in oci8lib.so: ORA-12154: TNS:could not resolve the connect identifier specified (OCIErr...

Hi, I have a question about bundle: RoR + oracle + bind variables. Heaving read forums/blogs/etc I found out RoR does not use bind vars for oracle particularly (and for all adapters in general). Then I found Michael''s patch (http://dev.rubyonrails.org/attachment/ticket/5199/oracle_bind.patch) but it was not added to the following RoR versions (since the end of May). As I suppose it was

...m the command prompt: c:\where you saved file>"ruby ruby-oci8-1.0.0-mswin32.rb" Answer "Yes" Assuming that you have previously installed rails 1.x, copy the oracle adapters manually from: C:\ruby\lib\ruby\gems\1.8\gems\activerecord-2.0.2\lib\active_record\connection_adapters\oracle_adapter.rb to: C:\ruby\lib\ruby\gems\1.8\gems\activerecord-1.15.6\lib\active_record\connection_adapters and rename it to oci_adapter.rb Copy the ora.dll & oraociei11.dll from C:\oracle\instantclient_11_1 to c:\ruby\bin Edit your database.yml to read: development: adapter: oci host: <your d...

Has anyone encountered this error or know how to correct it? I couldn''t find any Rails-specific info about this on google. Here are the circumstances: /usr/local/bin/ruby --version ruby 1.8.4 (2005-12-24) [i686-linux] /usr/local/bin/rails --version Rails 1.1.6 ## Create mcd app rails mcd -d oracle cd mcd ## Create oracle tablespace & user sqlplus ''/ as

Hi all. Does anybody use Rspec with Oracle? I have RoR app + Oracle DB. I use Rspec 0.9.4. I have installed Rspec plugin and generated spec for model Country. If I use "@countries = Country.new" in my spec I get "ArgumentError in ''Country should be valid'' block not supplied /vendor/plugins/rspec_on_rails/lib/spec/rails/extensions/kernel.rb: 12:in

I am trying to use Rails and an Oracle 7 database. I have the following error message: (eval):3:in `__send__'': ORA-12663: Services required by client not available on the server (OCIError) from (eval):3:in `describe'' and the line oracle_adapter,rb:361: (owner, table_name) = @connection.describe(table_name) Do I need this describe line? Can I replace with something else just to get the query to work? Thanks -- Posted via http://www.ruby-forum.com/.

...;'m not even trying to use the oracle active record adapter with rails. I just have oci8 installed for the migration script. Please help. Thanks in advance, andy The error in full from mongrel.log: /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/active_record/connection_adapters/oracle_adapter.rb:536: undefined method `define_a_column'' for class `OCI8::Cursor'' (NameError) from /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'' from /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.0/lib/active_support/dependencies.r...

...on makes it to the end of a request. It''s also worth mentioning the oracle adapter wouldn''t work for me at all until I found this patch code which provides the select_rows method, seems they forgot to implement it or something: require ''active_record/connection_adapters/oracle_adapter'' module ActiveRecord module ConnectionAdapters class OracleAdapter def select_rows(sql, name = nil) @connection.query_with_result = true result = execute(sql, name) rows = [] result.each { |row| rows << row } result.free r...

Hi everyone, I''m working on a new rails project and have to build it on top of a legacy oracle database. I''m trying to figure out how to get the number value from a NUMBER(1) datatype. So far I''m only getting a "true" value for 1 and "false" for any other number. From the console I can print out my object values and can see that there are number

Hello everyone, I am trying to convince my colleagues to convert to Ruby on Rails, however I am up against the following problem: Ruby on rails seems to be primarily designed a single database doing a small number of queries. While trying to process a webpage that does thousands of sql queries on Oracle, I get the message that I have used up too many cursors. In Java, I can use stmt.close()

...ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.1/lib/active_record/connection_adapters/abstract/connection_specificatio n.rb:231:in `establish_connection'': Please install the oracle adapter: `gem install activerecord-oracle-adapter` (no suc h file to load -- active_record/connection_adapters/oracle_adapter) (RuntimeError) I installed ruby-oci8 and I''m able to communicate with the Oracle database located on a remote machine via: ruby -r oci8 -e "OCI8.new(''id'', ''password'', ''???.???.?.?/xe'').exec( ''SELECT *...