Has anyone worked on project based on Rails on JRuby and db2
database?
As we know db2 has no native boolean type, I thought
activerecord-jdbc-adapter can convert it automatically. But actually as
Nick
replied, he has not worked on db2, so that this issue has not been taken
care of.
Then every time when I need to assign/fetch I have to convert it
manually: from ‘Yes’, ‘True’, TrueClass, FalseClass… to smallint 1, 0
or
reverse.
I shout here just want to know if anyone encountered same problem or
even better someone has solved it out? Actually I really like to push a
batch for it.
i’m working on a project using JRuby, Rails, and DB2…the db2 database
is a legacy database schema and i don’t bother converting between 0s and
1s or 'Y’s and 'N’s to boolean types
no special gotchas and everything works great, just in case you wanted
the extra reassurance for your project…sorry, this probably isn’t much
help!
I am curious. Is the “legacy” database on an IBM i (AS/400) by chance?
That happens to be the DB2 platform I am most familiar with and I have
had a few challenges. Embedded ‘#’ in column names for one.
No real reason for the query. There are only a few DB/2 for i5/OS folks
on the planet using JRuby so I got curious.
Pete
Finegan, Richard [HDS - WC] wrote:
Has anyone worked on project based on Rails on JRuby and db2
or
reverse.
I shout here just want to know if anyone encountered same problem or
even better someone has solved it out? Actually I really like to push a
batch for it.
yes, using DB2 9 and activerecord-jdbc-adapter here…its been a pretty
“vanilla” rails experience so far, a testament to the amazing job the
jruby guys have done on jruby and activerecord-jdbc-adapter
It sounds like a LUW installation. IBM i has some syntactical
differences to the DB2 most folks know. Since you indicated DB 9 in a
later post, I can pretty much rule out the i.
My rails experience hasn’t been quite as “vanilla” when it comes to
legacy schemas. On current (21st century) schemas, no problems. But
the legacy schemas (30 years old) I work with, embedded # in column
names, multi-column keys and a few other things have made it a
challenge.
No. Not a problem at all. I have had some issues and put together a
AR-JDBC driver (still not submitted to Nick’s project…yet). There is
a boolean to int cast in the driver (I think).
No concerns. Just lazy (and busy with other concerns). Java is my
primary development language and I have been working on a project whose
scope continues to grow (although on IBM i I spend a fair amount of time
in ILE RPG). I keep meaning to run a final series of tests on at least
the 2 supported OS versions (V5R4M0 and IBM i 6.1) but I haven’t had the
time.
Is there an ETA for a new version of the activerecord-jdbc-adapter? I’m
running into the same oracle issues others have logged in JIRA. It’s
preventing us from moving to JRuby 1.4.0.
This email communication and any files transmitted with it may contain
confidential and or proprietary information and is provided for the use
of the intended recipient only. Any review, retransmission or
dissemination of this information by anyone other than the intended
recipient is prohibited. If you receive this email in error, please
contact the sender and delete this communication and any copies
immediately. Thank you.
I tried 0.9.0.1, and there seems to be a problem with it recognizing
that the schema_migrations table already exists. Otherwise, it seems to
work (at least for some rudimentary tests).
If I can find the time I’ll try seeing if I can help out with some
tests. What kind of test infrastructure do I need? Do you actually run
tests against a physical Oracle instance or just verify the generated
text/sql?
On Wed, Dec 2, 2009 at 4:29 PM, Schultz, Darcy L. [email protected] wrote:
I tried 0.9.0.1, and there seems to be a problem with it recognizing that the schema_migrations table already exists. Otherwise, it seems to work (at least for some rudimentary tests).
If I can find the time I’ll try seeing if I can help out with some tests. What kind of test infrastructure do I need? Do you actually run tests against a physical Oracle instance or just verify the generated text/sql?
Yes, I usually run the tests against a real Oracle. I’ve been using an
express instance setup in a Ubuntu VM. There are some instructions in
test/db/oracle.rb that should give you an idea of what you need.
Thanks for pitching in and helping out with Oracle support! Let me
know if you need any further help getting going.
Cheers,
/Nick
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.