# Adapter: JDBC Oracle

**URL:** <https://www.ruby-forum.com/t/adapter-jdbc-oracle/197079>\
**Category:** Ruby\
**Created:** [May 2, 2008, 1:34pm UTC](https://www.ruby-forum.com/t/adapter-jdbc-oracle/197079 "2008-05-02T13:34:11Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![lgas](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/a87d85/32.png) [@lgas](https://www.ruby-forum.com/u/lgas)\
**Post date:** [May 2, 2008, 1:34pm UTC](https://www.ruby-forum.com/t/adapter-jdbc-oracle/197079/1 "2008-05-02T13:34:11Z")

</div>

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