Rails with DB2 and multiple schemas

Posted by GNUMatrix on Stack Overflow See other posts from Stack Overflow or by GNUMatrix
Published on 2010-04-06T05:37:55Z Indexed on 2010/04/06 5:43 UTC
Read the original article Hit count: 259

Filed under:

db2

|

rails

|

multiple

|

schema

I have a 'legacy' DB2 database that has many other applications and users. Trying to experiment with a rails app. Got everything working great with the ibm_db driver.

Problem is that I have some tables like schema1.products, schema1.sales and other tables like schema2.employees and schema2.payroll.

In the ibm_db adapter connection, I specify a schema, like schema1 or schema2, and I can work within that one schema, but I need to be able to easily (and transparently) reference both schemas basically interchangeably. I don't want to break the other apps, and the SQL I would normally write against DB2 doesn't have any of these restrictions (schemas can be mixed in SQL against DB2 without any trouble at all).

I would like to just specify table names as "schema1.products" for example and be done with it, but that doesn't seem to jive with the "rails way" of going about it.

Suggestions?

© Stack Overflow or respective owner

Related posts about db2

link DB2 AS/400 (system i) and DB2 AIX

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, everybody. I have two different database in DB2, a in DB2 AS400 and other in DB2 AIX, is possible link this database, similar to link by Oracle? Thank you in advance. erva. >>> More
Speed-start your Linux App: Using DB2 and the DB2 Control Center

as seen on Internet.com - Search for 'Internet.com'
This article guides you through setting up and using IBM DB2 7.2 with the Command Line Processor. You'll also learn to use the graphical Control Center, which helps you explore and control your databases, and the graphical Command Center, which helps you generate SQL queries. Other topics covered… >>> More
DB2 LUW Security - The DB2 DBA as a Locksmith

as seen on Internet.com - Search for 'Internet.com'
Database security should have multiple locks at multiple layers with multiple keys (and perhaps some barbed wire, an electric fence, a moat and a mean junkyard dog as well). With all these locks and keys, some locksmith skills are certainly useful. Rebecca Bond introduces some of her favorite DB2… >>> More
Why can't Perl's DBD::DB2 find dbivport.h during installation?

as seen on Stack Overflow - Search for 'Stack Overflow'
We are using a Perl utility to dump data from DB2 database. We installed DBI package and it is asking for DBD package also. We dont have root access and when we try to install DBD package we are getting the following error: ERROR BUILDING DB2.pm [lijumathew@intblade03 DBD-DB2-1.78]$ make make[1]:… >>> More
DBI::DBD package not getting installed for Perl?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, We are using a Perl utility to dump data from DB2 database. We installed DBI package and it is asking for DBD package also. We dont have root access and when we try to install DBD package we are getting the following error. ERROR BUILDING DB2.pm [lijumathew@intblade03 DBD-DB2-1.78]$ make make[1]:… >>> More

Related posts about rails

Ruby on Rails: url_for :back leads to NoMethodError for back_url

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I'm trying to use url_for(:back) to create a redirect leading back to a previous page upon a user's logging in. I've had it working successfully for when the user just goes to the login page on his or her own. However, when the user is redirected to the login page due to accessing a page… >>> More
Why am I getting "ArgumentError: wrong number of arguments (1 for 0)" when running my rails function

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm stumped on what's causing this. I get this error and stack trace in all my functional tests where I call 'post'. Here is the full stack trace: 7) Error: test_should_validate(UsersControllerTest): ArgumentError: wrong number of arguments (1 for 0) /Users/hisham/src/rails/ftuBackend/vendor/rails/actionpack/lib/action_controller/routing/route… >>> More
Spork servers super slow (>3m) to start for RSpec & Cucumber BDD

as seen on Stack Overflow - Search for 'Stack Overflow'
I recently installed a fresh development setup on my laptop and now notice that my instances of spork take several minutes to start up. This is also most likely of the RSpec and Cucumber tests start up times running super slow. I ran in diagnostic mode with the -d flag and received the output below… >>> More
trying to convert rails 2.3.4 app to rails 3 but views not appearing

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a simple rails 2.3.4 application I am trying to get running with rails 3.0.0-beta2. I have the server running and all my links and navigation showing, however for some reason the content of my views is not displaying. When I navigate to Site/index the html in my index.html.erb in my site… >>> More
Create new Rails project with previews rails version

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, The latest version of rails installed on my mac is 3.0.0.beta gem list returns rails (3.0.0.beta, 2.3.5, 2.3.4, 2.3.2, 2.2.2, 1.2.6) I want to create a new project using version 2.3.5 So I run: rails _2.3.5_ myProject But it returns the following error $ rails _2.3.5_ photosbackup /Library/Ruby/Site/1… >>> More