# Activerecord and composite keys

**URL:** <https://www.ruby-forum.com/t/activerecord-and-composite-keys/121362>\
**Category:** Ruby\
**Created:** [November 27, 2007, 9:38am UTC](https://www.ruby-forum.com/t/activerecord-and-composite-keys/121362 "2007-11-27T09:38:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kayros](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/45deac/32.png) [@kayros](https://www.ruby-forum.com/u/kayros)\
**Post date:** [November 27, 2007, 9:38am UTC](https://www.ruby-forum.com/t/activerecord-and-composite-keys/121362/1 "2007-11-27T09:38:22Z")

</div>

I’m using Dr Nic’s composite keys gems.  
I’m connected to an Oracle database. So far, so good.  
I set up my models as such :

class Dossier \< ActiveRecord::Base  
set\_table\_name :dc\_dossier  
set\_primary\_key :n\_dossier  
has\_many :dossier\_personnes  
end  
class Dossier\_Personne \< ActiveRecord::Base  
set\_table\_name :dc\_dossier\_personne  
set\_primary\_keys :n\_dossier, :n\_personne  
belongs\_to :dossier, :foreign\_key =\> :n\_dossier  
end

And tried that :  
Dossier.find(:first).dossier\_personnes

Got this error :  
uninitialized constant Dossier::DossierPersonne (NameError)

I’m quite new to ruby, is there something that i’m doing wrong ?  
Thanks in advance for your help.

---

<div class="post-metadata">

**Author:** ![kayros](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/45deac/32.png) [@kayros](https://www.ruby-forum.com/u/kayros)\
**Post date:** [November 27, 2007, 2:32pm UTC](https://www.ruby-forum.com/t/activerecord-and-composite-keys/121362/2 "2007-11-27T14:32:31Z")

</div>

Nicolas :

> uninitialized constant Dossier::DossierPersonne (NameError)  
> Maybe you should call your class DossierPersonne instead of  
> Dossier\_Personne.

– Jean-François.

---

<div class="post-metadata">

**Author:** ![kayros](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/45deac/32.png) [@kayros](https://www.ruby-forum.com/u/kayros)\
**Post date:** [November 29, 2007, 3:21am UTC](https://www.ruby-forum.com/t/activerecord-and-composite-keys/121362/3 "2007-11-29T03:21:04Z")

</div>

On Tue, 27 Nov 2007 17:38:20 +0900, Nicolas Couturier wrote:

> I’m using Dr Nic’s composite keys gems.

I didn’t know rails could do composite keys – thanks for the info 🙂

-Thufir