similar to: problems with Oracle: FK, triggers

Hi all, I wonder how can I solve in RoR the problem of accessing a simple table because the URL http://localhost:3000/customers/show/2.0 is raising an Oracle error OCIError: ORA-01722: invalid number. The reason of this error is because the SELECT statement generated by ActiveRecord tries to invoke the id column as a VARCHAR : "... FROM customers WHERE customers.id =

Hi, I tried many things to insert a data in an Oracle Table, but the Rails compiler never Works! I create this Oracle table: CREATE TABLE "FOO" ( "id" int NOT NULL primary key, "acolumn" VARCHAR(10) NULL ) and when i tried to insert a new row the Rails compiler tell me : OCIError: ORA-00904: invalid column name: INSERT INTO AGO.FOO (acolumn, id)

hi I have the latest rails version and would like to connect to an Oracle 9 database: this is my code: ========= ActiveRecord::Base.establish_connection( :adapter => "oci", :host => "host", :username => "user", :port => 1888, :password => "passwd", :database => "tmp1" ) class

Hi all, when I execute the command "rake db:schema:dump" i get this error in the db/schema.rb file. ____________________________________________________ # Could not dump table "region" because of following ActiveRecord::StatementInvalid # OCIError: ORA-00918: column ambiguously defined: SELECT lower(i.index_name) as index_name, i.uniqueness, lowe r(c.column_name) as

I think Rails 2.1 introduced a bug when eager loading of associations with Oracle. In 2.1 ActiveRecord loads the included table with a big ''IN'' query: ''where association.id in (1, 2, 3, 4...)''. The problem is that Oracle has a hard limit of 1000 values in an IN clause. I get this error: ''OCIError: ORA-01795: maximum number of expressions in a list

Hello all, I''m in my 5th month on Ruby on Rails and still learning. I have an application that works fine in sqlite3 and then the boss says he wants it migrated to Oracle. Now, I know very little about Oracle, enough to get into trouble. When I did the migration everything went haywire. Well, I''ve refactored several problems and now I have another. I have two models with a

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, I am trying the following in Ruby using InstantRails 1.7 on WindowsXP Publication.find(:all, :include => [:doc_type, :release_state] ) but I get the error: OCIError: ORA-00904: "DOC_TYPES"."PUBLICATION_ID": invalid identifier: SELECT publications.id AS t0_r0, publications.docid AS t0_r1, publications.doc_type_id AS t0_r2, publications.title AS t0_r3,

I admit it--I''m newb right now. But only to rails, ruby and friends. I''m walking through a "recipe" tutorial but have been stuck for hours; it''s time to ask for help. On Windows I''ve got the latest ruby, rails, and webrick; I''ve got the Oracle OCI "thing" to talk to our Oracle 10g database, I''ve got Slick Edit and a

I am trying to connect to an older oracle DB remotely, I think version 8 or 9. I downloaded the instant client stuff from oracle and copied oci.dll and oraociei10.dll to my windows/system folder (windows XP) I get the error. C:\rb-play>ar_connect_ss.rb env.c:257:in oci8lib.so: ORA-12514: TNS:listener does not currently know of serv ice requested in connect descriptor (OCIError) from

Any idea why this fixture would fail to load any data? <% %w( Admin Pharmacist PI/Co-PI Research\ Nurse ).each { |g| Group.create( :name => g ) } %> It works perfectly in irb but when I do rake db:fixtures:load I get no data, no errors, and no error logs. I realize my fixture doesn''t look like your typical run-of-the-mill fixture but it''s that way because I''m

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_.*,

Hello all. I am using the Paginate_with_ajax code as described on the wiki but I am running into the following problem. The following code will work fine and retrieved unsorted records in a hunky dory fashion: @componentlogs = Componentlog.find(:all, :conditions => [ "cl_compname like ?", @criteria ], :offset => offset, :limit => items_per_page ) However if I try and add an

"rick" has given AR/Oracle some love, but it''s still unhappy... http://dev.rubyonrails.org/changeset/5310 ------------------------------------------------------------------------ r5310 | rick | 2006-10-16 08:42:55 -0700 (Mon, 16 Oct 2006) | 1 line Fix has_many :through to add the appropriate conditions when going through an association using STI. Closes #5783. [Jonathan Viney]

All of a sudden, on three different systems, the "server_ip_address/sid_name" syntax in database.yml has stopped working for me. I can''t even do a OCI8.new(blah blah blah) statement from an IRB shell. I get "ORA-12541: TNS:no listener", or some variant, depending on how I phrase it. On systems where I have a real deal client installed, and OCI can find the tnsnames

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

> bundle exec rails s => Booting WEBrick => Rails 3.1.5 application starting in development on http://0.0.0.0:3000 => Call with -d to detach => Ctrl-C to shutdown server Warning: NLS_LANG is not set. fallback to US-ASCII. [2012-12-19 12:17:10] INFO WEBrick 1.3.1 [2012-12-19 12:17:10] INFO ruby 1.9.3 (2012-10-12) [x86_64-linux] [2012-12-19 12:17:10] INFO WEBrick::HTTPServer#start:

Hello all. I am trying to do the equivalent of: @componentlogs = Componentlog.find(:all, :conditions => [ "cl_compname like ?", @criteria ], :offset => offset, :limit => items_per_page, :order => "cl_spr DESC" ) in a find_by_sql statement. I cannot use the build in because the adaptor isn''t quite right (OCI8) When I use it I get the following error

A person has a many company_branches and A company_branch has many people. This join is represented using a "contacts" table. I am using a legacy schema so i am forced into using non-standard rails primary keys. I am using the new through relationship in rails 1.1. p=Person.find(1) b=p.company_branches # gives this error: ActiveRecord::StatementInvalid: OCIError: ORA-00904:

Hi all, I''m using Rails/Mysql as development platform. the production server is under Rails/Oracle. Right now, i''m trying to install my application under the production server, the connection to orcale is fine via Rails, but i have a weird problem. example : here is a extract from my db scheme : Table User :_____________ id_user | first_name |