how to connect a form field to a table from another database?

rubyonrails-talk
1

I have a form with some fields. In one of these ones the user can put data of type address, like "example street" and so on. I want that the user can select from a list of streets but these streets are in a table from a Oracle database. I can connect the form field to the street field of the Oracle table?

2

no advices?

3

I have a form with some fields. In one of these ones the user can put data of type address, like “example street” and so on. I want that the user can select from a list of streets but these streets are in a table from a Oracle database. I can connect the form field to the street field of the Oracle table?

no advices?

The question is pretty basic and answered by any tutorial or Rails guide out there. Yes is the answer. Your controller calls the model for the other table and returns the list of streets to populate a select box on a form.

B.

4

But how can I associate the model with the preexisting oracle table?

5

Sent from my iPhone

I have a form with some fields.

In one of these ones the user can put data of type address, like

"example street" and so on.

I want that the user can select from a list of streets but these

streets are in a table from a Oracle database.

I can connect the form field to the street field of the Oracle table?

no advices?

The question is pretty basic and answered by any tutorial or Rails guide out there. Yes is the answer. Your controller calls the model for the other table and returns the list of streets to populate a select box on a form.

But how can I associate the model with the preexisting oracle table?

Create a model that has same name as your table an inherit ActiveRecord for it.

Example Table: my_table

Model: my_table.rb

class MyTable < ActiveRecord::Base

end

B.

6

The way I understand it, Mauro has his models stored in different databases, i.e., his rails app is running on one DB server (SQLite/PostgreSQL/X) and he wants to fetch data on another DB server (Oracle), is that so? In that case, it would do good to look here:

http://api.rubyonrails.org/classes/ActiveRecord/Base.html

Under the section “Connection to multiple databases in different models”, there’s your answer.

Then, there’s this guide, which drills it down a bit more:

http://www.messaliberty.com/2009/02/ruby-how-to-use-multiple-databases-with-activerecord/

regards

7

Yes it is, thank you for yor answer. I'm trying to connect to a oracle8 db using activerecord-oracle-enhanced and jdbc but I think that this gem has problems with oracle version 8. There is someone that use oracle8 with jdbc in his application?