Problems with Oracle: FK, triggers

Rails
1

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 :frowning: and very need your help.

2

On 8/23/06, Eugene H. [email protected] 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.

  1. 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