ActiveRecord-JDBC Oracle

rubyonrails-talk
1

Hi,

I’m trying to migrate the AR script on to Oracle database. Im using jdbc adapter.

There are number of functions defined in jdbc_oracle.rb, but when I call them (eg: rename_column(…)) in my AR script, it says “rake aborted !! rename_column is not implemented” . It is not referring to the jdbc_oracle.rb file. Is there any configuration setting to be done?

I have written many custom functions in jdbc_postgre.rb and jdbc_mssql.rb, it works absolutely fine.

Please find the sample code attached.

1. 001_rename_columns.rb (file to migrate)

class CreateOrclTables < ActiveRecord::Migration   def self.up      rename_column(:companyprofile, :tname, :tname_new)   end   def self.down   end end

2. database.yml

development_orcl1:   adapter: jdbc   username: scott   password: tiger   driver: com.inet.ora.OraDriver   url: jdbc:inetora:vxind01:1521:BAPCDEV1

3. jdbc_oracle.rb (adapter: jdbc)

The file is under ( D:\jruby-1.0.0RC1\lib\ruby\gems\1.8\gems\ActiveRecord-JDBC-0.3.1\lib\jdbc_adapter )

Please refer the jdbc_oracle.rb file attached.

Appreciate your response !!

Thanks, John

Attachments: http://www.ruby-forum.com/attachment/1832/jdbc_oracle.rb

2

Do you have the requisite configuration in environment.rb to ensure that the jdbc adapter is loaded?

See http://wiki.jruby.org/wiki/Running_Rails_with_ActiveRecord-JDBC for details.

Also, 0.3.1 is pretty old (as is JRuby 1.0.0RC1). If you want to help develop the jdbc oracle support further it would be great if you could update to JRuby 1.1.1 and ar-jdbc 0.8.

Finally, can we take this discussion over to the jruby-user list?

http://xircles.codehaus.org/projects/jruby/lists

Cheers, /Nick

3

Hi Nick,

Thanks for your response.

I have the requisite configuration done in environment.rb. Below are the detials.

require 'rubygems' gem 'ActiveRecord-JDBC' require 'jdbc_adapter'

Interesting part is, a simple create_table script works fine even when I deleted the contents of jdbc_oracle.rb file and made it blank. But when I deleted the file jdbc_oracle.rb from the folder, it throws an error "could not find file jdbc_oracle.rb".

I had a look at http://xircles.codehaus.org/projects/jruby/lists

There are number of email-ids, to which ID should I post the message or which is the relevant forum?

Awaiting your response.

Thanks, John

Nick Sieger wrote:

4

The jruby-user list should be fine for this.

/Nick

5

Thanks very much Nick !!

I will post it there ..

regards John.

Nick Sieger wrote: