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

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?

On 12 May 2011 17:13, Mauro [email protected] wrote:

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?

Sent from my iPhone

On May 13, 2011, at 3:31 PM, Mauro [email protected] wrote:

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.

On 14 May 2011 14:09, Bryan C. [email protected] wrote:

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?

Sent from my iPhone

On May 16, 2011, at 3:27 AM, Mauro [email protected] wrote:

“example street” and so on.

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.

On 17 May 2011 18:30, Paulo Muggler M. [email protected]
wrote:

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?

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?

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

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