similar to: Connecting to Oracle from Rails 2.0.2

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,

Hello, I have Oracle XE installed. I have a table USERS. When I try to generate a scaffold it gives me this error. I tried also with Mysql and it worked. E:\radrails\projects\MPS>ruby script\generate scaffold user exists app/controllers/ exists app/helpers/ create app/views/user exists test/functional/ dependency model exists app/models/ exists

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

Hi, Normally I''m using Rails with mySql but for the moment I''m trying to make a Rails/Oracle solution using oci and instantclient, but I''m having a problem I receive the following when doing a select Exception string : undefined method `empty?'' for 1:Fixnum does anybody know a solution to this. kr Torben

Hi, after some experience with Rails on MySQL databases I gave it a try on one of our larger Oracle database. I was facing a problem when Rails tried to detect the columns for a model/table. The appropriate 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

My company''s System-admin installed Ruby and Gems (using Sun Coolstack package) and I have sudo access to ruby, gem etc. Now I need to get my app to talk to oracle db (through network). From what I understand, it requires three steps: Step 1: Install oracle instant client ( I installed it in my ~/oracle/ instantclient_11_1) Step2: Install OCI8 libraries (this is where I am stuck). Here is

Hi all, I''ve got a rather complex problem on my hands. I''m using Leopard (OSX 10.5) on an Intel Mac, with the standard Ruby and Rails installations. In order to get Rails to talk to Oracle, I upgraded the Rails gems to the latest release candidate (1.99), and installed the oracle adapter gem. So far so good. But the Oracle InstantClient is a PPC-only library. You

Does anyone have experience on installing the Oracle instantclient and DBD::Oracle on CentOS 4.4. I have been having several issues with getting the RPMs from Oracle's site working with DBD::Oracle. I can get the oracle instant client to install without issue. But I cannot compile/install DBD::Oracle using cpan or cpan2rpm. I found http://freshrpms.net/docs/oracle/ which has a nosrc rpm

Hello, I am running Linux, I have downloaded instantclient-basiclite-linux32-11.2.0.2.0.zip instantclient-sqlplus-linux32-11.2.0.2.0.zip instantclient-sdk-linux32-11.2.0.2.0.zip instantclient-precomp-linux32-11.2.0.2.0.zip All these tarballs are unzipped in /usr/local/lib/instantclient, I have added this path in the library path of the host. I can run sqlplus and proc, they do not complain

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

<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

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/.

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

I''m having a huge memory leak problem with a rails application I''m developing! I first noticed that when running under webrick (via script/server) there was a fast memory leak.. several users using the app for a few hours would use 2 gig of memory!!! I searched the archives and found that some users found that it could be avoided by saying --daemon when launching webrick..

Hi All, I have a problem in connecting to oracle and here is the steps i''ve been going through (i''m using the regular oracle8 client, not the instant one): 1. i installed the one-click ruby installer (ruby184-16p3 windows.exe) 2. i installed the rails-1.0.0 framework using gem successfully 3. i tried connecting to oracle using all possible combination in the database.yml file

Hi all, I''m having very odd behavior, but only with a few of my specs. I''m checking the value of response.body and in most cases finding it to be the content of the body... but in some cases it''s the name of the template rendered!! There''s no rhyme or reason I can see, but obviously my tests fail for no reason when I expect the body to contain the

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

Hi all! I''ve been using an instance of my model to do "query by example".. Basically I fill in a new instance of the model and then later interrogate it to generate my conditions for find( :all ).. Where things get ugly is that I just moved several properties into a joined table, but I''d like to keep the ability to set those attributes in the original model..

Hi all, Just looking for a quick sanity check. I was thinking of writing a plugin for rails to give rails developers a good way of using the new firefox 1.5/safari canvas tags. I was thinking of grabbing an existing ruby graphics library and modifying it so that it renders via the canvas tag.. So you could have link_to_remote pointing to controller actions that instead of returning

Hi All, Thank's for your hint Tim Panton I could connect my asterisk machine to my oracle machine. I used unixODBC-2.2.11.tar.gz, oracle-instantclient-basic-10.2.0.3-1.i386.rpm, oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm and the drive from www.oracle.com (odbc-oracle-3.1.0-linux-x86-glibc.tar) to configure my asterisk machine. I can connect to my oracle machine with isql and in