# View and Controller not working

**URL:** <https://www.ruby-forum.com/t/view-and-controller-not-working/154075>\
**Category:** Rails\
**Created:** [November 25, 2008, 3:43am UTC](https://www.ruby-forum.com/t/view-and-controller-not-working/154075 "2008-11-25T03:43:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![MrSWatson](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/46a35a/32.png) [@MrSWatson](https://www.ruby-forum.com/u/MrSWatson)\
**Post date:** [November 25, 2008, 3:43am UTC](https://www.ruby-forum.com/t/view-and-controller-not-working/154075/1 "2008-11-25T03:43:06Z")

</div>

Hello,

I created a controller named animals and a .rhtml file called hello.

There is nothing in the controller, but there is “hello, world!” in  
the .rhtml.

I booted up webbrick and typed “[http://localhost:3000/animals/hello](http://localhost:3000/animals/hello)”  
and it should have displayed “hello, world!” instead it gave me this  
error.

MissingSourceFile in AnimalsController#hello

no such file to load – sqlite3

Any ideas?

RAILS\_ROOT: C:/InstantRails/rails\_apps/view\_demo  
Application Trace | Framework Trace | Full Trace

C:/Ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:31:in  
`gem_original_require' C:/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require’  
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active\_support/  
dependencies.rb:153:in `require' C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/ dependencies.rb:521:in `new\_constants\_in’  
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active\_support/  
dependencies.rb:153:in `require' C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/ core_ext/kernel/requires.rb:7:in `require\_library\_or\_gem’  
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active\_support/  
core\_ext/kernel/reporting.rb:11:in `silence_warnings' C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/ core_ext/kernel/requires.rb:5:in `require\_library\_or\_gem’  
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active\_record/  
connection\_adapters/sqlite3\_adapter.rb:10:in `sqlite3_connection' C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/ connection_adapters/abstract/connection_pool.rb:223:in `send’  
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active\_record/  
connection\_adapters/abstract/connection\_pool.rb:223:in  
`new_connection' C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/ connection_adapters/abstract/connection_pool.rb:245:in `checkout\_new\_connection’  
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active\_record/  
connection\_adapters/abstract/connection\_pool.rb:188:in `checkout' C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/ connection_adapters/abstract/connection_pool.rb:184:in `loop’  
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active\_record/  
connection\_adapters/abstract/connection\_pool.rb:184:in `checkout' C:/Ruby/lib/ruby/1.8/monitor.rb:242:in `synchronize’  
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active\_record/  
connection\_adapters/abstract/connection\_pool.rb:183:in `checkout' C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/ connection_adapters/abstract/connection_pool.rb:98:in `connection’  
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active\_record/  
connection\_adapters/abstract/connection\_pool.rb:326:in  
`retrieve_connection' C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/ connection_adapters/abstract/connection_specification.rb:121:in `retrieve\_connection’  
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active\_record/  
connection\_adapters/abstract/connection\_specification.rb:113:in  
`connection' C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/ query_cache.rb:8:in `cache’  
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/  
caching/sql\_cache.rb:12:in `perform_action' C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/ base.rb:524:in `send’  
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/  
base.rb:524:in `process_without_filters' C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/ filters.rb:606:in `process\_without\_session\_management\_support’  
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/  
session\_management.rb:134:in `process' C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/ base.rb:392:in `process’  
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/  
dispatcher.rb:183:in `handle_request' C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/ dispatcher.rb:110:in `dispatch\_unlocked’  
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/  
dispatcher.rb:123:in `dispatch' C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/ dispatcher.rb:122:in `synchronize’  
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/  
dispatcher.rb:122:in `dispatch' C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/ dispatcher.rb:132:in `dispatch\_cgi’  
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/  
dispatcher.rb:39:in `dispatch' C:/Ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/webrick_server.rb: 103:in `handle\_dispatch’  
C:/Ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/webrick\_server.rb:74:in  
`service' C:/Ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service’  
C:/Ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run' C:/Ruby/lib/ruby/1.8/webrick/server.rb:173:in `start\_thread’  
C:/Ruby/lib/ruby/1.8/webrick/server.rb:162:in `start' C:/Ruby/lib/ruby/1.8/webrick/server.rb:162:in `start\_thread’  
C:/Ruby/lib/ruby/1.8/webrick/server.rb:95:in `start' C:/Ruby/lib/ruby/1.8/webrick/server.rb:92:in `each’  
C:/Ruby/lib/ruby/1.8/webrick/server.rb:92:in `start' C:/Ruby/lib/ruby/1.8/webrick/server.rb:23:in `start’  
C:/Ruby/lib/ruby/1.8/webrick/server.rb:82:in `start' C:/Ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/webrick_server.rb:60:in `dispatch’  
C:/Ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/commands/servers/  
webrick.rb:66  
C:/Ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:31:in  
`gem_original_require' C:/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require’  
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active\_support/  
dependencies.rb:153:in `require' C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/ dependencies.rb:521:in `new\_constants\_in’  
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active\_support/  
dependencies.rb:153:in `require' C:/Ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/commands/server.rb:49 C:/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem\_original\_require’  
C:/Ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:31:in  
`require’  
script/server:3

C:/Ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:31:in  
`gem_original_require' C:/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require’  
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active\_support/  
dependencies.rb:153:in `require' C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/ dependencies.rb:521:in `new\_constants\_in’  
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active\_support/  
dependencies.rb:153:in `require' C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/ core_ext/kernel/requires.rb:7:in `require\_library\_or\_gem’  
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active\_support/  
core\_ext/kernel/reporting.rb:11:in `silence_warnings' C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/ core_ext/kernel/requires.rb:5:in `require\_library\_or\_gem’  
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active\_record/  
connection\_adapters/sqlite3\_adapter.rb:10:in `sqlite3_connection' C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/ connection_adapters/abstract/connection_pool.rb:223:in `send’  
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active\_record/  
connection\_adapters/abstract/connection\_pool.rb:223:in  
`new_connection' C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/ connection_adapters/abstract/connection_pool.rb:245:in `checkout\_new\_connection’  
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active\_record/  
connection\_adapters/abstract/connection\_pool.rb:188:in `checkout' C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/ connection_adapters/abstract/connection_pool.rb:184:in `loop’  
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active\_record/  
connection\_adapters/abstract/connection\_pool.rb:184:in `checkout' C:/Ruby/lib/ruby/1.8/monitor.rb:242:in `synchronize’  
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active\_record/  
connection\_adapters/abstract/connection\_pool.rb:183:in `checkout' C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/ connection_adapters/abstract/connection_pool.rb:98:in `connection’  
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active\_record/  
connection\_adapters/abstract/connection\_pool.rb:326:in  
`retrieve_connection' C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/ connection_adapters/abstract/connection_specification.rb:121:in `retrieve\_connection’  
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active\_record/  
connection\_adapters/abstract/connection\_specification.rb:113:in  
`connection' C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/ query_cache.rb:8:in `cache’  
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/  
caching/sql\_cache.rb:12:in `perform_action' C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/ base.rb:524:in `send’  
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/  
base.rb:524:in `process_without_filters' C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/ filters.rb:606:in `process\_without\_session\_management\_support’  
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/  
session\_management.rb:134:in `process' C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/ base.rb:392:in `process’  
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/  
dispatcher.rb:183:in `handle_request' C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/ dispatcher.rb:110:in `dispatch\_unlocked’  
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/  
dispatcher.rb:123:in `dispatch' C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/ dispatcher.rb:122:in `synchronize’  
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/  
dispatcher.rb:122:in `dispatch' C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/ dispatcher.rb:132:in `dispatch\_cgi’  
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action\_controller/  
dispatcher.rb:39:in `dispatch' C:/Ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/webrick_server.rb: 103:in `handle\_dispatch’  
C:/Ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/webrick\_server.rb:74:in  
`service' C:/Ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service’  
C:/Ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run' C:/Ruby/lib/ruby/1.8/webrick/server.rb:173:in `start\_thread’  
C:/Ruby/lib/ruby/1.8/webrick/server.rb:162:in `start' C:/Ruby/lib/ruby/1.8/webrick/server.rb:162:in `start\_thread’  
C:/Ruby/lib/ruby/1.8/webrick/server.rb:95:in `start' C:/Ruby/lib/ruby/1.8/webrick/server.rb:92:in `each’  
C:/Ruby/lib/ruby/1.8/webrick/server.rb:92:in `start' C:/Ruby/lib/ruby/1.8/webrick/server.rb:23:in `start’  
C:/Ruby/lib/ruby/1.8/webrick/server.rb:82:in `start' C:/Ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/webrick_server.rb:60:in `dispatch’  
C:/Ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/commands/servers/  
webrick.rb:66  
C:/Ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:31:in  
`gem_original_require' C:/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require’  
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active\_support/  
dependencies.rb:153:in `require' C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/ dependencies.rb:521:in `new\_constants\_in’  
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active\_support/  
dependencies.rb:153:in `require' C:/Ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/commands/server.rb:49 C:/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem\_original\_require’  
C:/Ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:31:in  
`require’  
script/server:3

This error occurred while loading the following files:  
sqlite3

---

<div class="post-metadata">

**Author:** ![MrSWatson](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/46a35a/32.png) [@MrSWatson](https://www.ruby-forum.com/u/MrSWatson)\
**Post date:** [November 25, 2008, 3:58am UTC](https://www.ruby-forum.com/t/view-and-controller-not-working/154075/2 "2008-11-25T03:58:54Z")

</div>

On Nov 24, 9:41 pm, “Mr. Watson” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> MissingSourceFile in AnimalsController#hello

Hey there. To create a basic, custom controller action, you need to do  
three things:

1. Create a method in the controller. In your case you’d need:  
class AnimalsController \< ApplicationController  
def hello  
end  
end

2. Create a view template for the action to render. In your case,  
you’d need app/views/animals/hello.html.erb .

3. Create a route to the custom controller action. In your case, you’d  
need this in config/routes.rb :  
map.resources :animals, :collection =\> :hello

Since you’re getting started with Rails, I highly recommend reading  
through Agile Web D. With Rails:  
[Pragmatic Bookshelf: By Developers, For Developers](http://www.pragprog.com/titles/rails3/)

Cheers,  
Nick

---

<div class="post-metadata">

**Author:** ![MrSWatson](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/46a35a/32.png) [@MrSWatson](https://www.ruby-forum.com/u/MrSWatson)\
**Post date:** [November 25, 2008, 4:00am UTC](https://www.ruby-forum.com/t/view-and-controller-not-working/154075/3 "2008-11-25T04:00:40Z")

</div>

You have to configure Database in config/database.yml - and install  
sqlite or mysql gem (db adapters, according to which db you want to  
use).

But its obvious that the application you are building now doesnt  
require any database, but rails needs a database connection by  
default. So either create a dummy database for rails to connect to,

OR

In config/environment.rb, inside the Rails::Initializer block, add  
this line:

config.frameworks -= [:active\_record]