Re: [DataMapper] Usage of dm-oracle-adapter

[Michael McDermott]

Tell Brown to switch to postgres :)

How's Brown going David? 

I don't know much about the state of the oracle dm adapter.   I do know DM is on the cusp of a major update so I imagine support would be thin for the time being.

On Mon, Feb 11, 2013 at 2:55 PM, <david_h...@brown.edu> wrote:

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.
To post to this group, send email to datam...@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.
 
 

[david_h...@brown.edu]

Thanks for the response, PlanetMCD!  Fancy meeting you here. 

PostgreSQL is good, I've enjoyed using it in the past.  It is good to know that DM is getting a major update and where the resources would be for now.

[Dominic Sisneros]

I use the oracle adapter and it works fine.

[david_h...@brown.edu]

Dom,

  Would you be willing to share your config file setup for dm-oracle-adapter (  passwords redacted of course), etc? 

  Any tips on getting the dm-oracle-adpater working? 

Thanks & best,

David

[Till Schulte-Coerne]

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

[david_h...@brown.edu]

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

...

To post to this group, send email to data...@googlegroups.com.