Friday, September 2, 2011
The oracle:thin syntax is usually for JDBC connections in my experience. Per the readme and my own experience, you'll want to specify 1 of 4 possible formats.
1. just the TNS name as the database key like 'xe' if you have the TNS_ADMIN environment variable set to point to where your tnsnames.ora file is located, and it contains the TNS descriptor for your server
2. the url, port, and SID for the database, like '//localhost:1521/xe
3. the url, port, and SID as 3 different config keys, database: xe, host: 127.0.0.1, port: 1521
4. The full TNS descriptor (DESCRIPTION = .. )
I've had the most luck with option 4 since it is the most explicit. I've had cases where TNS_ADMIN wasn't set right or the ruby process wasn't getting that environment variable (like when running under apache) and even when forcing it to be set, things still weren't right. It should be as easy as specifying the TNS name, but I have not found that to always be the case.
-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/xBe8Ure9McIJ.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment