Sha256: da30b40cf0499cc9272905e437af4794d084d31af4f422bf09759a97964cb0b7

Contents?: true

Size: 1.31 KB

Versions: 83

Compression:

Stored size: 1.31 KB

Contents

Composite Primary key support for db2 

== Driver Support

DB2 support requires the IBM_DB driver provided by http://rubyforge.org/projects/rubyibm/
project. Install using gem install ibm_db. Tested against version 0.60 of the driver.
This rubyforge project appears to be permenant location for the IBM adapter.
Older versions of the driver available from IBM Alphaworks will not work. 

== Driver Bug and workaround provided as part of this plugin

Unlike the basic quote routine available for Rails AR, the DB2 adapter's quote
method doesn't return " column_name = 1 " when string values (integers in string type variable) 
are passed for quoting numeric column. Rather it returns "column_name = '1'. 
DB2 doesn't accept single quoting numeric columns in SQL. Currently, as part of 
this plugin a fix is provided for the DB2 adapter since this plugin does 
pass string values like this. Perhaps a patch should be sent to the DB2 adapter
project for a permanant fix.

== Database Setup

Database must be manually created using a separate command. Read the rake task
for creating tables and change the db name, user and passwords accordingly.

== Tested Database Server version

This is tested against DB2 v9.1 in Ubuntu Feisty Fawn (7.04)

== Tested Database Client version

This is tested against DB2 v9.1 in Ubuntu Feisty Fawn (7.04)


Version data entries

83 entries across 83 versions & 2 rubygems

Version Path
composite_primary_keys-4.0.0.beta4 README_DB2.txt
composite_primary_keys-4.0.0.beta3 README_DB2.txt
composite_primary_keys-3.1.10 README_DB2.txt
composite_primary_keys-4.0.0.beta2 README_DB2.txt
composite_primary_keys-4.0.0.beta1 README_DB2.txt
composite_primary_keys-3.1.9 README_DB2.txt
composite_primary_keys-3.1.8 README_DB2.txt
composite_primary_keys-3.1.7 README_DB2.txt
composite_primary_keys-3.1.6 README_DB2.txt
composite_primary_keys-3.1.5 README_DB2.txt
composite_primary_keys-3.1.4 README_DB2.txt
composite_primary_keys-3.1.2 README_DB2.txt
composite_primary_keys-3.1.1 README_DB2.txt
composite_primary_keys-3.1.0 README_DB2.txt
composite_primary_keys-3.0.9 README_DB2.txt
composite_primary_keys-3.0.8 README_DB2.txt
composite_primary_keys-3.0.7 README_DB2.txt
composite_primary_keys-3.0.4 README_DB2.txt
composite_primary_keys-3.0.3 README_DB2.txt
composite_primary_keys-3.0.0.b3 README_DB2.txt