Thanks Till. Here is the format of the database.yml file that worked for me. Rather than using TNS, we used the full host
defaults: &defaults adapter: oracle development: host: some_machine.somewhere.edu:[port num]/[SID] username: MY_SCHEMA password: NOT_REALLY_MY_PW <<: *defaults ... On Wednesday, February 13, 2013 4:10:47 AM UTC-5, tillsc wrote: > > Hi, > > we're using the oracle adapter in production with JRuby on Windows > without any bigger problems. We're using the TNSNAMES.ora to configure an > Oracle RAC with two nodes. This has been tricky but it works: > https://github.com/datamapper/dm-oracle-adapter/issues/ > > The configuration must look like this: > > production: > adapter: oracle > database: user/password@databasename > > There had been some problems with dm-constraints and some other details > we fixed and merged back intro the current release (thanks again @solnic). > > Problems still open: > > In development the MRI version (with ruby_oci) had some problems in some > situations. But I didn't try to fix them yet (our focus is on JRuby and > ojdbc). > > There are still some problems efficiently preventing the usage of > dm-xxx-adapters together with JNDI connection pooling: > https://github.com/datamapper/dm-oracle-adapter/issues/13 > https://github.com/datamapper/dm-core/pull/186 > https://github.com/datamapper/do/pull/25 > I don't think that is an oracle specific problem. But AFAICS there is > currently nobody (me neither) really interested in fixing this. > > We're using JNDI's [Environment entries]( > http://tomcat.apache.org/tomcat-7.0-doc/config/globalresources.html#Environment_Entries) > > instead for configuring the connection settings (as strings). This works > fine for us until now. Drop me a line if you're interested in this (it has > nothing to do with Oracle too). > > Regards, > Till > > Am 11.02.2013 um 20:55 schrieb david_h...@brown.edu <javascript:>: > > Hello Everyone, > > If you are using the Oracle Adapter for datamapper, dm-oracle-adapter, > I would like to hear from you. > I'm considering using datamapper and dm-oracle-adapter on a project. > > I would like to know the following: > Is there specific documentation on dm-oracle-adapter ? If so, > please tell me where to find it. > Is anyone using the oracle adapter in a production environment? > Is it generally working or are their issues with it? > When there are problems, how quickly are they addressed by the > community? How many people actively support/revise the oracle adapter? > > Thanks & best, > David > > -- > You received this message because you are subscribed to the Google Groups > "DataMapper" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to datamapper+...@googlegroups.com <javascript:>. > To post to this group, send email to data...@googlegroups.com<javascript:> > . > Visit this group at http://groups.google.com/group/datamapper?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > > > -- You received this message because you are subscribed to the Google Groups "DataMapper" group. To unsubscribe from this group and stop receiving emails from it, send an email to datamapper+unsubscr...@googlegroups.com. To post to this group, send email to datamapper@googlegroups.com. Visit this group at http://groups.google.com/group/datamapper?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
