Issue Details (XML | Word | Printable)

Key: ACTIVERECORD_JDBC-26
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Unassigned
Reporter: sunndog
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
activerecord-jdbc

Problems with jdbc_oracle.rb

Created: 14/Jul/09 04:49 PM   Updated: 24/Nov/09 08:46 PM   Resolved: 01/Oct/09 08:45 PM
Component/s: Oracle
Affects Version/s: 0.9.1
Fix Version/s: 0.9.2

Time Tracking:
Not Specified

Tags:


 Description  « Hide
  • When using set_table_name "schema.table" or ActiveRecord::Base.table_name_prefix = 'schema.' the table name is getting quoted improperly causing the SQL to fail (e.g. select name from "schema.table").
  • Had to patch line 74 so that integer ID columns were not coming back as BigDecimal and messing up the generated URLs (i.e., when /num|dec|real/i : (@scale.nil? || @scale == 0) ? :integer : :decimal) I believe this may already logged in a different issue...
  • The columns method incorrectly and unnecessarily passes in an Oracle schema name that's based on the database config username value. The Java code in columns_internal already breaks apart the schema and table name.
  • Migrations fail because it attempts to use 'schema_migrations_seq' which doesn't exist and is unnecessary given the structure of the 'schema_migrations' table.

We decided to revert back to 0.9



Nick Sieger added a comment - 01/Oct/09 08:45 PM

Sorry about the troubles. There are a few oracle fixes coming in 0.9.2, please try these and see if they make the situation any better.


sunndog added a comment - 19/Nov/09 09:10 PM

This issue should not be closed. activerecord-jdbc-adapter 0.9.2 does not resolve all of these issues. Even worse I can no longer fall back to 0.9 when using JRuby 1.4.0


Nick Sieger added a comment - 24/Nov/09 08:46 PM

If you can help with specific patches and/or test cases that fail for you that would be great. In the meantime, try 0.9.0.1 with JRuby 1.4.

jruby -S gem install -v 0.9.0.1 activerecord-jdbc-adapter