Hi all

Oracle DB
I'd like to query a table in other schema (account) than
i'm logged in.



DataMapper.setup(:default,"oracle:fred/p...@server:1521:SID")

class Customer
  include DataMapper::Resource

  storage_names[:default] = "scott.tbl_customer"

  property :id, Integer, :key => true
  property :name, String
  property :company, String

end


Datamapper create this Query:

 SELECT  "NAME", "COMPANY" FROM "SCOTT.TBL_CUSTOMER"

 but correct in Oracle is:

 SELECT  "NAME", "COMPANY" FROM "SCOTT"."TBL_CUSTOMER"


 How has my class to look like,that i get a correct query string?

 with somthing like that:
 DataMapper.repository(:default).adapter.resource_naming_convention =
 .......


 Best regards
 Thomas

-- 
You received this message because you are subscribed to the Google Groups 
"DataMapper" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/datamapper?hl=en.

Reply via email to