Bugs: Browse | Submit New | Admin

[#16471] rails 2.0.2, ibm_db 0.9.2, rake db:create:all fails silently

Date:
2007-12-21 00:30
Priority:
3
Submitted By:
Joshua Poulson (shirgall)
Assigned To:
Praveen Devarao (praveend)
Category:
Adapter
State:
Open
Summary:
rails 2.0.2, ibm_db 0.9.2, rake db:create:all fails silently

Detailed description
With rails 2.0.2 and ibm_db 0.9.2 the command "rake db:create:all" runs without error, but does not create
any databases.

Subsequently, starting script/server and clicking the "About your application's environment" on the default
start page causes the following error:

Failed to connect to the [xchngdev] due to: [IBM][CLI Driver] SQL1013N  The database alias name or database name
"XCHNGDEV" could not be found.  SQLSTATE=42705 SQLCODE=-1013

Add A Comment: Notepad

Please login


Followup

Message
Date: 2007-12-21 14:42
Sender: Alex Pitigoi

It's probably worth a try, given the general view in the Rails
development to have all non-core functionality added through
gems, rather than contributed directly into the Rails gem itself.

Before asking for it though, in order to increase the chances
of getting attention, I think we need to do some homework and
provide at least an initial solution that would prove how a gem
based extension would hook into Rails tasks. Rails development
team is certainly more receptive when some up-front leg-work
was done for a fix, and it's reasonable, given it works as is
quite well for them.
Date: 2007-12-21 03:24
Sender: Joshua Poulson

Should I file a trac against rails to open an API for
database adapters there?
Date: 2007-12-21 00:54
Sender: Alex Pitigoi

Joshua, I think we need to clarify something before hand: the
'rake db:create:all'  is a task defined by the Rails gem. That
is located in the $GEM_HOME/gems/rails-2.0.1/lib/tasks/databases.rake,
therefore it's code solely under Rails gem control. I know some
databases have the privilege of getting some support in there,
but this is one place were IBM_DB gem is out of bounds. The IBM_DB
team doesn't have legal clearance to contribute in that place
(not even read the code source), but Antonio Cangiano has posted
some related and helpful hints for those interested:
http://db2onrails.com/2007/06/20/rake-db-test-purge-and-rake-db-t
est-clone/

I hope this helps clarify why this cannot explicitly be fixed
in the IBM_DB gem yet. We'll need to find some other way to have
this Rails task supported by DB vendors outside the Rails gem.

Attached Files:

Name Description Download
No Files Currently Attached

Changes:

Field Old Value Date By
assigned_toalexp2008-03-31 18:49alexp
resolution_idNone2007-12-21 00:54alexp