similar to: Database connections...so many connections!

Hello all. I am still having fun with multiple databases. In this case it is the unless connected? statement. ActiveRecord::Base establishes a connection that is inherited by the majority of my models. However one Model (Componentlog) that uses a separate DB is coded as: unless Componentlog.connected? establish_connection( :adapter => "oci", :database =>

Hello all. Due to the mistakes of the company before I joined ;) I am stuck with a multiple database setup. I am planning on parsing the REQUEST_URL to decide which controller is being accessed and basing the establish_connection on that. Before I go messing around with regexps I was wondering if rails has a built in function for parsing URLS. I have googled around a bit and seen net/http

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

I searched this site on Oracle && MySql, nothing came up, so perhaps this is a new topic for this forum. I''d like to access two databases from the same application simultaneously (well, more precisely, in rapid succession, calling one first and then the other, as any "joins" will be done in the application code). One database is in MySql, the other is Oracle.

Running the functional tests has deleted the data in my production database!!! please help!! Using rails 1.1.1 + Oracle. This is my database.yml file : development: adapter: oci host: "V2:1521/TIM" username: salt password: oracle1 test: adapter: oci host: "V2:1521/TIM" username: rectest password: oracletest production: adapter: oci host:

I have a controller named xyzController under app/controllers I have a helper class named xyzHelper under app/helpers. Shouldn''t I be able to call methods from xyzHelper inside of xyzController without any problems? Thanks, Wes -- Posted via http://www.ruby-forum.com/.

Does anyone have any experience getting ODBC to work? I could really use some help here. I''m having trouble accessing a db2 database via odbc using rails. It''s an external database, that I import data from. I have placed the connection code in my model : unless connected? establish_connection( :adapter => "odbc", :dsn => "<dsn

I have to extract data from an odbc connection to another database and put into a MySQL database so that my rails app can manipulate it. What would be the best way to set that up? Would I put the connection info in a controller, so that the controller method with open and close the connection? Any thought? -- Best Regards, -Larry "Work, work, work...there is no satisfactory

Hello all. I am a novice Ruby on Rails programmer, starting my first project using a legacy Oracle 10 database. Using ''reverse_scaffold'' I have created the models/controllers/views for my existing Oracle tables. All seems to work well, using /model/index, /model/show for most of my tables, *except* when one of the tables contains a Oracle ''date'' column, for

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

In my app, for three models: foo,bar and baz, the database connection is made to a different database and hence in model code: class Foo < ActiveRecord::Base establish_connection :diff_database end class Bar < ActiveRecord::Base establish_connection :diff_database end class Baz < ActiveRecord::Base establish_connection :diff_database end Now, the problem is, if is use the above

I want to copy data from one database to another using rails. But, it seems that rails only will talk to one database at a time. Is there a way around this? Any help would be greatly appreciated. -- Best Regards, -Larry "Work, work, work...there is no satisfactory alternative." --- E.Taft Benson -------------- next part -------------- An HTML attachment was scrubbed...

Hello to everyone, I have a problem that is giving me a headache, and trying to do a project in Ruby on Rails and I need to connect with a Data Base that is en Postgres, the truth is that I didn’t think that it was so hard to connect a DB with postgres because I was working with Msyql and everything was easy. This are the thinks that I have install in my computer. 1. Debian GNU/Linux, kernel

Hi, I'm trying to get OCI support in php on RHEL 4. So i installed the oracle-client and php.src.rpm and then typed: rpmbuild -bb --with oci /usr/src/redhat/SPECS/php.spec It rebuild fine, but no oci support, on the spec file of the PHP package it's there the OCI support, it's not --with oci that i should use? Thanks Regards, Ricardo -------------- next part -------------- An

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 there! How can i use 2 database connections in my rails application ( if it''s possible of course ): one for reading from DB and one for writing to DB? Thanks, Dmitry -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To

Hi. I would like to hear how/what other users are installing for development and reference support. I currently have both InstantRails and the Ruby One-click Installer installed. I don''t like telling co-workers to install both (the OCI has lots of nice documentation useful to Rails developers). Also, the Ruby OCI helps when needing to run Ruby scripts outside of the InstantRails

Hello all. I am trying ot load table rows using AJAX based on a search. The following code results in: 1. Firefox renders correctly (Multiple rows inserted into page). 2. Opera renders the entire returned string in one <td> by the looks of it (Bunched up under first header, the <> tags arne''t visible) 3. IE6 does nothing....great ;) This is driving me nuts so any help

Hi, My application spans 2 (or more) databases for some very specific reasons... My models are working fine, even dynamically establishing connections as needed at runtime, and spanning relationships across the databases (which really impressed me). The problem is, I can''t seem to force Units for these models (that use a secondary db) to load their fixtures into and use the

Hey everyone! I have a problem that''s been making me a little nuts. I would like to use RoR for a upcoming project, but if I can''t get past this hiccup I''m afraid I''ll have to use PHP or Java. Ugh. The application needs to have a database-per-customer model. So when I do a Product.find(:all) I need to make sure i''m connecting to say acme.products