[Rails] Re: Problem with generating a scaffold with an Oracle DB

Tom Hofte
2006-03-29T07:06:23Z

William Groppe wrote:
> Hey Tom,
>
> Looks like a problem connecting to Oracle.  The ''ORA-12537:
> TNS:connection closed'' is an Oracle error.
>
> Have you tried just generating a model and starting the console to
> check connectivity?
>
> try this:
>
> ruby script/generate model Product
>
> when done start up the console:
>
> ruby script/console
>  >>p = Product.new
>  >>p.save
>
> See if you get an error message on the ''p.save'' line.
You may want
> to check that Oracle is allowing connections from remote hosts.
>
> According to ora-code.com, ora-12537 is defined as:
>
> ORA-12537: TNS:connection closed
> Cause: ''End of file'' condition has been reached; partner
has
> disconnected.
> Action: None needed; this is an information message.
>
> Hope this helps.
>
> -wilig

Hi Wilig,

I have already solved the problem. The settings in my database.yml where
not the same as in the tnsnames.ora file of my DB installation.

The problem is now fixed and everythings works perfectly

--
Posted via http://www.ruby-forum.com/.