JDBC Oracle

Ruby JRuby
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

  1. database.yml

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

  1. 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

2

Hi John,

It seems that the AR-JDBC-Adapter you use now is very old. pls install
the latest version and try again.

 jruby -S gem install activerecord-jdbc-adapter

Cheers,
Jesse

3

Thanks very much Jesse !!

Can you send me the link to download this adapter?

Also, would appreciate if you can send me the link of latest Jruby
version.

regards,
John

Jesse Hu wrote:

Hi John,

It seems that the AR-JDBC-Adapter you use now is very old. pls install
the latest version and try again.

 jruby -S gem install activerecord-jdbc-adapter

Cheers,
Jesse

4

Hi John,

Issue the following command to install the latest
activerecord-jdbc-adapter version(0.8) remotely:
jruby -S gem install activerecord-jdbc-adapter

or download the gem from
http://rubyforge.org/frs/download.php/34137/activerecord-jdbc-adapter-0.8.gem

you need to install JRuby 1.1 or later to work with
activerecord-jdbc-adapter 0.8. http://dist.codehaus.org/jruby/

Cheers,
Jesse

John E. wrote:

Thanks very much Jesse !!

Can you send me the link to download this adapter?

Also, would appreciate if you can send me the link of latest Jruby
version.

regards,
John

Jesse Hu wrote:

Hi John,

It seems that the AR-JDBC-Adapter you use now is very old. pls install
the latest version and try again.

 jruby -S gem install activerecord-jdbc-adapter

Cheers,
Jesse

5

Thanks very much Jesse !!

regards
John

Jesse Hu wrote:

Hi John,

Issue the following command to install the latest
activerecord-jdbc-adapter version(0.8) remotely:
jruby -S gem install activerecord-jdbc-adapter

or download the gem from
http://rubyforge.org/frs/download.php/34137/activerecord-jdbc-adapter-0.8.gem

you need to install JRuby 1.1 or later to work with
activerecord-jdbc-adapter 0.8. http://dist.codehaus.org/jruby/

Cheers,
Jesse