Rails - Aug 2006 - problems with Oracle: FK, triggers

Hi All!

Is anyone working with Oracle on Rails? What about testing? I will be 
very happy if you can help me:

1) When I run rake test:unit it removes all my sequences in test 
enviroment. And I get an error like "OCIError: ORA-02289: sequence does 
not exist" But when I run rake db:test:clone_structure I can see all 
sequences again. Where is a problem?

2) How I can take proper account of triggers? Now I just can''t run some
test because this action suppose to drop a data (and I have a trigger on 
DELETE event).

Unforunately I couldn''t find any good documentation about Oracle 
integration :-( and very need your help.

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

On 8/23/06, Eugene Hlyzov
<rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>
wrote:
>
> Hi All!
>
> Is anyone working with Oracle on Rails? What about testing? I will be
> very happy if you can help me:
>
> 1) When I run rake test:unit it removes all my sequences in test
> enviroment. And I get an error like "OCIError: ORA-02289: sequence
does
> not exist" But when I run rake db:test:clone_structure I can see all
> sequences again. Where is a problem?

Set schema dump format to :sql in config/environment.rb.


2) How I can take proper account of triggers? Now I just can''t run
some
> test because this action suppose to drop a data (and I have a trigger on
> DELETE event).

Others are in the same boat here; not sure how they handle it.

jeremy


--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---