== 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
== 1.2.1 2009-06-07
* Enhancements
* caching of table indexes query which makes schema dump much faster
* Bug fixes:
* return Date (and not DateTime) values for :date column value before year 1970
* fixed after_create/update/destroy callbacks with plsql custom methods
* fixed creation of large integers in JRuby
* Made test tasks respect RAILS_ENV
* fixed support for composite primary keys for tables with LOBs
== 1.2.0 2009-03-22
* Enhancements
* support for JRuby and JDBC
* support for Ruby 1.9.1 and ruby-oci8 2.0
* support for Rails 2.3
* quoting of Oracle reserved words in table names and column names
* emulation of OracleAdapter (for ActiveRecord unit tests)
* Bug fixes:
* several bug fixes that were identified during running of ActiveRecord unit tests
== 1.1.9 2009-01-02
* Enhancements
* Added support for table and column comments in migrations
* Added support for specifying sequence start values
* Added :privilege option (e.g. :SYSDBA) to ActiveRecord::Base.establish_connection
* Bug fixes:
* Do not mark empty decimals, strings and texts (stored as NULL in database) as changed when reassigning them (starting from Rails 2.1)
* Create booleans as VARCHAR2(1) columns if emulate_booleans_from_strings is true
== 1.1.8 2008-10-10
* Bug fixes:
* Fixed storing of serialized LOB columns
* Prevent from SQL injection in :limit and :offset
* Order by LOB columns (by replacing column with function which returns first 100 characters of LOB)
* Sequence creation for tables with non-default primary key in create_table block
* Do count distinct workaround only when composite_primary_keys gem is used
(otherwise count distinct did not work with ActiveRecord 2.1.1)
* Fixed rake db:test:clone_structure task
(see http://rsim.lighthouseapp.com/projects/11468/tickets/11-rake-dbtestclone_structure-fails-in-117)
* Fixed bug when ActiveRecord::Base.allow_concurrency = true
(see http://dev.rubyonrails.org/ticket/11134)
== 1.1.7 2008-08-20
* Bug fixes:
* Fixed that adapter works without ruby-plsql gem (in this case just custom create/update/delete methods are not available)
== 1.1.6 2008-08-19
* Enhancements:
* Added support for set_date_columns and set_datetime_columns
* Added support for set_boolean_columns
* Added support for schema prefix in set_table_name (removed table name quoting)
* Added support for NVARCHAR2 column type
* Bug fixes:
* Do not call write_lobs callback when custom create or update methods are defined
== 1.1.5 2008-07-27
* Bug fixes:
* Fixed that write_lobs callback works with partial_updates enabled (added additional record lock before writing BLOB data to database)
* Enhancements:
* Changed SQL SELECT in indexes method so that it will execute faster on some large data dictionaries
* Support for other date and time formats when assigning string to :date or :datetime column
== 1.1.4 2008-07-14
* Enhancements:
* Date/Time quoting changes to support composite_primary_keys
* Added additional methods that are used by composite_primary_keys
== 1.1.3 2008-07-10
* Enhancements:
* Added support for custom create, update and delete methods when working with legacy databases where
PL/SQL API should be used for create, update and delete operations
== 1.1.2 2008-07-08
* Bug fixes:
* Fixed after_save callback addition for session store in ActiveRecord version 2.0.2
* Changed date column name recognition - now should match regex /(^|_)date(_|$)/i
(previously "updated_at" was recognized as :date column and not as :datetime)
== 1.1.1 2008-06-28
* Enhancements:
* Added ignore_table_columns option
* Added support for TIMESTAMP columns (without fractional seconds)
* NLS_DATE_FORMAT and NLS_TIMESTAMP_FORMAT independent DATE and TIMESTAMP columns support
* Bug fixes:
* Checks if CGI::Session::ActiveRecordStore::Session does not have enhanced_write_lobs callback before adding it
(Rails 2.0 does not add this callback, Rails 2.1 does)
== 1.1.0 2008-05-05
* Forked from original activerecord-oracle-adapter-1.0.0.9216
* Renamed oracle adapter to oracle_enhanced adapter
* Added "enhanced" to method and class definitions so that oracle_enhanced and original oracle adapter
could be used simultaniously
* Added Rails rake tasks as a copy from original oracle tasks
* Enhancements:
* Improved perfomance of schema dump methods when used on large data dictionaries
* Added LOB writing callback for sessions stored in database
* Added emulate_dates_by_column_name option
* Added emulate_integers_by_column_name option
* Added emulate_booleans_from_strings option
) is private.
