Release Name: 1.2.2
Notes:
Oracle "enhanced" ActiveRecord adapter contains useful additional methods for working with new and legacy Oracle databases
from Rails which are extracted from current real projects' monkey patches of original Oracle adapter.
See http://github.com/rsim/oracle-enhanced/wikis for usage information.
See http://oracle-enhanced.rubyforge.org/rdoc for detailed API documentation.
For questions and feature discussion please use http://groups.google.com/group/oracle-enhanced
Blog posts about oracle-enahnced can be found at http://blog.rayapps.com/category/oracle-enhanced
Bugs and enhancement requests can be reported at http://rsim.lighthouseapp.com/projects/11468-oracle-enhanced
Changes:
== 1.2.2 2009-09-28
* Enhancements
* improved RDoc documentation of public methods
* structure dump optionally (database.yml environment has db_stored_code: yes) extracts
packages, procedures, functions, views, triggers and synonyms
* automatically generated too long index names are shortened down to 30 characters
* create tables with primary key triggers
* use 'set_sequence_name :autogenerated' for inserting into legacy tables with trigger populated primary keys
* access to tables over database link (need to define local synonym to remote table and use local synonym in set_table_name)
* [JRuby] support JDBC connection using TNS_ADMIN environment variable and TNS database alias
* changed cursor_sharing option default from 'similar' to 'force'
* optional dbms_output logging to ActiveRecord log file (requires ruby-plsql gem)
* use add_foreign_key and remove_foreign_key to define foreign key constraints
(the same syntax as in http://github.com/matthuhiggins/foreigner and similar
to http://github.com/eyestreet/active_record_oracle_extensions)
* raise RecordNotUnique and InvalidForeignKey exceptions if caused by corresponding ORA errors
(these new exceptions are supported just by current ActiveRecord master branch)
* implemented disable_referential_integrity
(enables safe loading of fixtures in schema with foreign key constraints)
* use add_synonym and remove_synonym to define database synonyms
* add_foreign_key and add_synonym are also exported to schema.rb
* Bug fixes:
* [JRuby] do not raise LoadError if ojdbc14.jar cannot be required (rely on application server to add it to class path)
* [JRuby] 'execute' can be used to create triggers with :NEW reference
* support create_table without a block
* support create_table with Symbol table name
* use ActiveRecord functionality to do time zone conversion
* rake tasks such as db:test:clone are redefined only if oracle_enhanced is current adapter in use
* VARCHAR2 and CHAR column sizes are defined in characters and not in bytes (expected behavior from ActiveRecord)
* set_date_columns, set_datetime_columns, ignore_table_columns will work after reestablishing connection
* ignore :limit option for :text and :binary columns in migrations
* patches for ActiveRecord schema dumper to remove table prefixes and suffixes from schema.rb
|