Thanks Don.
Yeah, I looked at that and used it as the basis for getting started.
The problem is that db2/400 isn't happy with the syntax that contains
LIMIT and OFFSET. I think that is used in pagination but for the life of
me, I can't figure out where that syntax is generated. Perhaps the
driver isn't properly registered in the .yml?
The newer activerecord-jdbc gem looks like it has been refactored a bit
so I am trying to understand the relationships between the DB entries in
the .yml file and how activerecord determines what jdbc driver to use.
Is it the "adapter" in the yml that points to the jdbc adapter in
connection_adapters folder or is it the url in the yml?
For example, if I wanted to create a whole new driver called 'foo', what
entries are needed in the .yml and what files/entries are needed in the
activerecord folders?
I'd like to debug this stuff if I could but I am having some difficulty
with getting the environment set up so I can do that (I am using Aptana
Studio and Rad Rails). I am woefully uneducated on Ruby so I have the
learning curve as well.
I'll try to push through on this on my own but it has been a bit of a
challenge so far.
Pete
Donald Parish wrote:
Pete,
See my entry last summer for how I got version 3.1 to work
pretty well for me, including pagination support. I haven't gotten the
later versions (.5) to work, but am still working on it as time
allows.
_http://rubyforge.org/pipermail/jruby-extras-devel/2007-August/001215.html_.
Note, you also need to add the line: require 'jdbc_adapter/jdbc_as400'
to the active_record/connection_adapters/jdbc_adapter_spec.rb file.
You might also look at this thread:
_http://rubyforge.org/pipermail/jruby-extras-devel/2007-July/001161.html_
Don Parish
I'd like to work with *someone*, or on my own if necessary, to develop
an adapter for DB2400, a database that runs on IBM's System i
hardware. Although similar to DB2, it is different enough that it
needs it's own adapter (I think). There has been some work in this
area but I'd like to establish something a bit more "official" if
possible even though I'd guess the System i community using Ruby and
Rails is pretty small. I am new to ruby, experienced with Java, but
have used activerecord-jdbc very little (since there is no adapter for
the System i - aka AS/400). I saw one post about an AS/400 adapter but
that was using AR-jdbc 4.0. Looks like some things have changed a bit
since that release. How would I get started? I have poked around,
looking at the adapter source, but if there is a more effective way of
starting a project like this I'd rather start in the right direction
rather than wandering around until I found my way. Thanks Pete
------------------------------------------------------------------------
_______________________________________________
Jruby-extras-devel mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/jruby-extras-devel
_______________________________________________
Jruby-extras-devel mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/jruby-extras-devel
