Patch to enable --database=ibm_db

I have been using Ruby on Rails/DB2/XML for quite some time. This would turn things easier for other developers like myself. Nice idea!

Something I've been wanting to happen for so long !!!

I can't imagine how many times I've patched the Rails code manually in the last two years or so, since I started doing Rails development with DB2.

Phil Nelson ScotDB Limited

That really sounds nice!

I found myself patching rails code as well and this would be a huge step forward.

At our company we still go a bit further and use DB2's native XML support with rails, so this is definitely something we'd like to see.

Looks nice. Some suggestions :

• Please use 'development', 'test', '_production' postfixes.
• Instead of commented values for schema, host, port, account etc. why not fill sensible defaults ? Not being an IBM DB user, I don't know what they might be.
• I'd skip those tests

Thanks.

Pratik, thank you for reviewing the patch.

I proceeded with reviewing the patch developed by the API development team, and changed a few things, also incorporating some of your suggestions.

A couple of important considerations are in order though:

• The development, test and _production postfixes are not acceptable for DB2. This is due to the fact that database names are currently limited to 8 characters. This is why the resulting database names are derived from the application name (truncated to 4 characters) and contracted postfixes;

• I changed the parameters for which default values exist, to their defaults. That said, some of the optional parameters are entirely arbitrary and have no defaults, as such I placed obvious placeholders. The password field is empty for the other adapters, so I left it blank as well.

I think the resulting config/database.yml file looks good, all things considered and it's ready to be introduced into the core.

Thank you, Antonio

Please find attached the new patch.

Thanks.