# ActiveRecordConnection from jobs script

**URL:** <https://www.ruby-forum.com/t/activerecordconnection-from-jobs-script/190117>\
**Category:** Rails\
**Created:** [June 15, 2010, 10:07pm UTC](https://www.ruby-forum.com/t/activerecordconnection-from-jobs-script/190117 "2010-06-15T22:07:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![gregm](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/bc79bd/32.png) [@gregm](https://www.ruby-forum.com/u/gregm)\
**Post date:** [June 15, 2010, 10:07pm UTC](https://www.ruby-forum.com/t/activerecordconnection-from-jobs-script/190117/1 "2010-06-15T22:07:29Z")

</div>

Hi,  
I make a cron jobs and I would like to use ActiveRecord. but I have this  
error:  
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active\_record/connection\_adapters/abstract/connection\_pool.rb:326:in  
`retrieve\_connection’: ActiveRecord::ConnectionNotEstablished  
(ActiveRecord::ConnectionNotEstablished)

Do I have to require something else?

This is what I am already requiring:  
require ‘rubygems’  
require ‘hpricot’  
require ‘open-uri’  
require ‘ostruct’  
require ‘active\_record’

Greg

---

<div class="post-metadata">

**Author:** ![gregm](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/bc79bd/32.png) [@gregm](https://www.ruby-forum.com/u/gregm)\
**Post date:** [June 17, 2010, 4:22pm UTC](https://www.ruby-forum.com/t/activerecordconnection-from-jobs-script/190117/2 "2010-06-17T16:22:12Z")

</div>

or thome think like this: ActiveRecord::Base.establish\_connection  
Ivan N.  
removed\_email\_address@domain.invalid

---

<div class="post-metadata">

**Author:** ![gregm](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/bc79bd/32.png) [@gregm](https://www.ruby-forum.com/u/gregm)\
**Post date:** [June 15, 2010, 11:20pm UTC](https://www.ruby-forum.com/t/activerecordconnection-from-jobs-script/190117/3 "2010-06-15T23:20:43Z")

</div>

Greg Ma wrote:

> Hi,  
> I make a cron jobs and I would like to use ActiveRecord. but I have this  
> error:  
> /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active\_record/connection\_adapters/abstract/connection\_pool.rb:326:in  
> `retrieve\_connection’: ActiveRecord::ConnectionNotEstablished  
> (ActiveRecord::ConnectionNotEstablished)
> 
> Do I have to require something else?
> 
> This is what I am already requiring:  
> require ‘rubygems’  
> require ‘hpricot’  
> require ‘open-uri’  
> require ‘ostruct’  
> require ‘active\_record’
> 
> Greg

I believe you should be using script/runner.

## Best,

Marnen Laibow-Koser  
[http://www.marnen.org](http://www.marnen.org)  
removed\_email\_address@domain.invalid