search for: oci_adapter

...ppropriate statement ran about 1 min which led to a timeout. Our Oracle guru told me to analyze the SYSTEM schema. After that hadn''t helped, he said the only remaining chance is to use a hint in the statement. Other tools like TOAD would do it by themself anyway... I made the change in oci_adapter.rb and Rails was responsive again. If anybody else has this problem or if anybody wants to include the change into the next ActiveRecord version, here is what I''ve changed: in activerecord-1.13.2/lib/active_record/connection_adapters/oci_adapter.rb at line 341 (in the #columns method):...

...ROOT: ./script/../config/.. Application Trace | Framework Trace | Full Trace e:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:155:in `attrSet'' e:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:155:in `initialize'' e:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/oci_adapter.rb:515:in `new'' e:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/oci_adapter.rb:515:in `new_connection'' e:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/oci_adapter.rb:545:in `initialize'' e...

...rror when run from apache. this is the copy of the FULL TRACE i get /usr/local/lib/ruby/site_ruby/1.8/oci8.rb:131:in `create'' /usr/local/lib/ruby/site_ruby/1.8/oci8.rb:131:in `initialize'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/oci_adapter.rb:515:in `new_connection'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/oci_adapter.rb:545:in `initialize'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/oci_adapter.rb:35:in `oci_connectio...

Hello all, my first project is on it''s way, and I am loving it! But, and that''s a big BUT: Active Record does not use prepared statements! How is that? Everybody is bragging about performance and the most obvious tuning measure is missing. Ok, I don''t know, if MySQL can even do them as I am using Postgres, but still. I started looking at the code and it is not

...t 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 db host>:<your db port>/<your db sid> username: <uid> password: <pwd> go to http://localhost:3000...

...1:in `initialize'' from /usr/local/lib/ruby/site_ruby/1.8/oci8.rb:161:in `do_ocicall'' from /usr/local/lib/ruby/site_ruby/1.8/oci8.rb:161:in `initialize'' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.11.1/lib/active_record/connection_adapters/oci_adapter.rb:211:in `new'' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.11.1/lib/active_record/connection_adapters/oci_adapter.rb:211:in `oci_connection'' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.11.1/lib/active_record/query_cache.rb:52:in `send''...

Hi, Is anyone using Oracle with RoR successfully? Is everything running smoothly? What are the main issues? any response is appreciated thanks, Chris -- Posted via http://www.ruby-forum.com/.

<ubuntu_gutsy> me@ubuntu:~/workspace/oracle/ro$ gem install activerecord-oci-adapter Bulk updating Gem source index for: http://gems.rubyforge.org ERROR: While executing gem ... (Gem::GemNotFoundException) Could not find activerecord-oci-adapter (> 0) in any repository <ubuntu_gutsy> me@ubuntu:~/workspace/oracle/ro$ rake db:migrate (in /home/me/workspace/oracle/ro) rake

I have a table with "expires_on" a DATE field. "Show" and "Destroy" work, but "Edit" errors: /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_view/helpers/date_helper.rb:150:in `select_hour'' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_view/helpers/date_helper.rb:149:in `select_hour'' It only happens when

...method redefined; discarding old default /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/connection_adapters/sqlserver_adapter.rb:95: warning: (...) interpreted as grouped expression /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/connection_adapters/oci_adapter.rb:58: warning: (...) interpreted asgrouped expression /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/connection_adapters/oci_adapter.rb:103: warning: ambiguous first argument; put parentheses or even spaces /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_r...

...2005 Using Rails 0.10.1 , following error when I have OCI8 (ver 1.9) installed .. Older rails (0.9) did not have this problem, AFAIK. Uninstalling OCI8 from site_ruby makes the problem go away. Ideas? Thanks. /usr/lib/ruby/gems/1.8/gems/activerecord-1.8.0/lib/active_record/connection_ adapters/oci_adapter.rb:253: undefined method `define_a_column'' for class `OCI8::Cursor'' (NameError) from /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `require__'' from /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `require'' from...

.../kernel/reporting.rb:11:in `silence_warnings'' C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/core_ext/kernel/requires.rb:5:in `require_library_or_gem'' C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-oracle-adapter-1.0.0.9250/lib/active_record/connection_adapters/oci_adapter.rb:29 C:/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:36:in `gem_original_require'' C:/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:36:in `require'' C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:153:in `require'' C:...

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, decode(data_type, ''NUMBER'', data_precision, '...

Hi I run Ruby on Rails on Oracle XE. I have a simple table: create table customer(id number primary key, name varchar2(100)); And ruby script\generate model Customer ruby script\generate controller Customer http://localhost:3000/customer/ - show a fine list, but when I click show/edit/destroy, I get an ORA-01722: OCIError: ORA-01722: invalid number: select * from (select raw_sql_.*,