Ruby on Rails

Hi,

After a few days of struggling, I was able to run this command
successfully.

ruby -r oci8 -e "OCI8.new('xxx_dba', 'xxx', '//xxxx:1521/
xxxxx.xxx.org').exec('SELECT 1 from dual') {|r| puts r.join}"

I got "1.0" as output and I got my prompt back.

So, I went back to the RoR app that I am working on, started WEBrick
in Radrails but I got this error:

ORA-12154: TNS:could not resolve the connect identifier specified

RAILS_ROOT: ./script/../config/..
Application Trace | Framework Trace | Full Trace

env.c:257:in oci8lib.so
C:/web/IPSO/app/controllers/attending_ips_controller.rb:140:in
`get_most_recent_record'
C:/web/IPSO/app/controllers/attending_ips_controller.rb:26:in
`new_edit'
-e:4:in `load'
-e:4

C:/ruby_prod/lib/ruby/site_ruby/1.8/oci8.rb:229:in `initialize'
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/oracle_adapter.rb:585:in `new'
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/oracle_adapter.rb:585:in
`new_connection'
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/oracle_adapter.rb:621:in
`initialize'
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/oracle_adapter.rb:35:in `new'
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/oracle_adapter.rb:35:in
`oracle_connection'
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/abstract/connection_specification.rb:
262:in `send'
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/abstract/connection_specification.rb:
262:in `connection_without_query_cache='
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/query_cache.rb:54:in `connection='
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/abstract/connection_specification.rb:
230:in `retrieve_connection'
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/abstract/connection_specification.rb:
78:in `connection'
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/base.rb:427:in `find_by_sql'
C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/
action_controller/base.rb:1101:in `send'
C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/
action_controller/base.rb:1101:in `perform_action_without_filters'
C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/
action_controller/filters.rb:696:in `call_filters'
C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/
action_controller/filters.rb:688:in `perform_action_without_benchmark'
C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/
action_controller/benchmarking.rb:66:in
`perform_action_without_rescue'
C:/ruby_prod/lib/ruby/1.8/benchmark.rb:293:in `measure'
C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/
action_controller/benchmarking.rb:66:in
`perform_action_without_rescue'
C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/
action_controller/rescue.rb:83:in `perform_action'
C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/
action_controller/base.rb:435:in `send'
C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/
action_controller/base.rb:435:in `process_without_filters'
C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/
action_controller/filters.rb:684:in
`process_without_session_management_support'
C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/
action_controller/session_management.rb:114:in `process'
C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/
action_controller/base.rb:334:in `process'
C:/ruby_prod/lib/ruby/gems/1.8/gems/rails-1.2.5/lib/dispatcher.rb:
41:in `dispatch'
C:/ruby_prod/lib/ruby/gems/1.8/gems/rails-1.2.5/lib/webrick_server.rb:
113:in `handle_dispatch'
C:/ruby_prod/lib/ruby/gems/1.8/gems/rails-1.2.5/lib/webrick_server.rb:
79:in `service'
C:/ruby_prod/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
C:/ruby_prod/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
C:/ruby_prod/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
C:/ruby_prod/lib/ruby/1.8/webrick/server.rb:162:in `start'
C:/ruby_prod/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
C:/ruby_prod/lib/ruby/1.8/webrick/server.rb:95:in `start'
C:/ruby_prod/lib/ruby/1.8/webrick/server.rb:92:in `each'
C:/ruby_prod/lib/ruby/1.8/webrick/server.rb:92:in `start'
C:/ruby_prod/lib/ruby/1.8/webrick/server.rb:23:in `start'
C:/ruby_prod/lib/ruby/1.8/webrick/server.rb:82:in `start'
C:/ruby_prod/lib/ruby/gems/1.8/gems/rails-1.2.5/lib/webrick_server.rb:
63:in `dispatch'
C:/ruby_prod/lib/ruby/gems/1.8/gems/rails-1.2.5/lib/commands/servers/
webrick.rb:59
C:/ruby_prod/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
`gem_original_require'
C:/ruby_prod/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
`require'
C:/ruby_prod/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/
active_support/dependencies.rb:495:in `require'
C:/ruby_prod/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/
active_support/dependencies.rb:342:in `new_constants_in'
C:/ruby_prod/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/
active_support/dependencies.rb:495:in `require'
C:/ruby_prod/lib/ruby/gems/1.8/gems/rails-1.2.5/lib/commands/server.rb:
39
C:/ruby_prod/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
`gem_original_require'
C:/ruby_prod/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
`require'
script/server:3

env.c:257:in oci8lib.so
C:/ruby_prod/lib/ruby/site_ruby/1.8/oci8.rb:229:in `initialize'
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/oracle_adapter.rb:585:in `new'
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/oracle_adapter.rb:585:in
`new_connection'
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/oracle_adapter.rb:621:in
`initialize'
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/oracle_adapter.rb:35:in `new'
...
...

does this mean my database.yml is not right? I am using exactly same
database.yml compare to prod box.
database.yml

development:

adapter: oracle
database: //xxxx:1521/xxxxx.xxx.org
username: xxxx_dba
password: xxxx

this setup is working fine in prod box that runs ruby 1.8.6, rails
2.1.0, and oracle instant client. The only difference that I can think
of is that prod box runs mongrel as a windows service.

am I missing something here?

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
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.