ActiveRecord adding quotes where it should not using JDBC Oracle Driver

rubyonrails-talk
1

Hi everyone,

So here is my problem :

I'm using the Oracle JDBC Driver (with JRuby) to talk to a legacy database. I also use set_table_name directive since my model doesn't have the same name as my table.

class Person < ActiveRecord::Base     set_table_name 'BOTS.USERS'

In the console, if I try Person.find(1) I get an error saying that the table doesn't exit. The query generated is : SELECT * FROM "BOTS.USERS" WHERE ("BOTS.USERS".id = 1)

The thing is that this is not valid, it should be :

SELECT * FROM BOTS.USERS WHERE (BOTS.USERS.id = 1)

How could I fix this ?