Activerecord::Netezza::Adapter

ActiveRecord JDBC adapter for Netezza backends.

The organization of the adapter was cribbed wholesale from Nick Sieger's CacheDB adapter. Any errors are my own.

Netezza does not have a data type to map to :text and :binary. You can use activerecord-jdbc-adapter to connect if you remove those data types from the type converter lookup hash AR_TO_JDBC_TYPES. Here's the monkey patch to do so:

# Not really recommended

require 'arjdbc/jdbc/type_converter'

module ActiveRecord
  module ConnectionAdapters
    class JdbcTypeConverter
      AR_TO_JDBC_TYPES.delete(:text)
      AR_TO_JDBC_TYPES.delete(:binary)
    end
  end
end

One of the disadvantages of this monkeypatch is that within a codebase using ARJDBC and the patch, no other JDBC driver will have the :text and :binary data types. This gem is intended to confine the removal of types to only database connections using this adapter.

Add these lines to your application's Gemfile:

    gem 'activerecord-netezza-adapter', 
        :git => 'https://github.com/robbkidd/activerecord-netezza-adapter'

And then execute:

$ bundle

Or install it yourself as:

$ gem install activerecord-netezza-adapter

Place the Netezza JDBC driver--not distributed with this gem--in your JRuby classpath.

For example, place nzjdbc3.jar in vendor/lib/java. If using Warbler to deploy your app as a WAR, include the following in config/warble.rb

config.java_libs += FileList["vendor/lib/java/*.jar"]

Define your database connection information as expected:

development:
  adapter: netezza
  host: nzhostname
  database: dbname
  user: username
  password: $up3r$3cr3t!

1. Fork it
2. Create your feature branch (git checkout -b my-new-feature)
3. Commit your changes (git commit -am 'Added some feature')
4. Push to the branch (git push origin my-new-feature)
5. Create new Pull Request