ActiveRecord-JDBC Oracle

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

On Fri, May 2, 2008 at 6:28 AM, John E.
[email protected] wrote:

configuration setting to be done?
rename_column(:companyprofile, :tname, :tname_new)
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.

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

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 S. wrote:

On Fri, May 2, 2008 at 6:28 AM, John E.
[email protected] wrote:

configuration setting to be done?
rename_column(:companyprofile, :tname, :tname_new)
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.

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

Thanks very much Nick !!

I will post it there …

regards
John.

Nick S. wrote:

On Sun, May 4, 2008 at 10:58 PM, John E.
[email protected] wrote:

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?

The jruby-user list should be fine for this.

/Nick

On Sun, May 4, 2008 at 10:58 PM, John E.
[email protected] wrote:

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?

The jruby-user list should be fine for this.

/Nick

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs