Migrations in Oracle9 to Oracle schema with existing tables

Hello,

I’m trying to use the same Oracle schema for development and test
configurations to go through the Shoplet example in Ola B.'s Practical
JRuby book. I specified different active record table name prefixes for
the
two configurations. The Oracle schema has existing tables in it that I
don’t want to touch.

When I run the migrations for development, schema.rb contains comments
like
the following:

Could not dump table “audit_actions” because of following

NativeException

java.sql.SQLException: ORA-00942: table or view does not exist

Could not dump table “backup_history” because of following

NativeException

java.sql.SQLException: ORA-00942: table or view does not exist

Could not dump table “mbsval_repo_pricing” because of following

NativeException

java.sql.SQLException: ORA-00942: table or view does not exist

The last comment refers to a table that was dropped about a year ago.
However, the shoplet tables do get created. When I try to run tests,
I’m
getting the following:

C:/3rd/jruby/dist/jruby-1.0.1/bin/jruby.bat -Ilib;test
“C:/3rd/jruby/dist/jruby-1.0.1/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake/rake_test_loader.rb”
C:/3rd/jruby/dist/jruby-1.0.1/bin/jruby.bat -Ilib;test
“C:/3rd/jruby/dist/jruby-1.0.1/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake/rake_test_loader.rb”
NativeException: java.sql.SQLException: ORA-02449: unique/primary keys
in
table referenced by foreign keys
: DROP TABLE broker

The broker table is one of the pre-existing table that I don’t want to
touch. Is what I’m trying to do supported? I appreciate any help.
Thx.

Michael

Oracle 9.0.2.7
ActiveRecord-JDBC-0.5
Rails 1.2.3
JRuby 1.0.1


View this message in context:
http://www.nabble.com/Migrations-in-Oracle9-to-Oracle-schema-with-existing-tables-tf4577961.html#a13068382
Sent from the JRuby - User mailing list archive at Nabble.com.


To unsubscribe from this list please visit:

http://xircles.codehaus.org/manage_email

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs