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