On last day of Oracle OpenWorld I did my unconference presentation – Using Ruby on Rails with legacy Oracle databases.
As I did not know if anyone will come to listen to it I was glad that six people attended (including Kuassi Mensah from Oracle who is helping to promote Ruby support inside Oracle). And on the previous day I also managed to show parts of my presentation to Rich and Anthony from Oracle AppsLab team.
I published my slides on Slideshare:
And I published my demo project on GitHub:

Thanks to all Oracle people who recognize my work on Ruby and Oracle integration and I hope that our common activities will increase number of Ruby and Rails projects on Oracle :)

Great work Raimonds. I think your work on Ruby/Oracle is excellent. Can’t wait to see what else you come up with.
Comment by Rich Manalang — September 26, 2008 @ 4:29 am |
I’m an active user of Ruby on Rails and I’m really impressed with the work you are doing, but every time I see the words “legacy” and “oracle” in the same sentence it makes the hairs on the back of my neck stand on end! Is legacy really the right word to use ?
Martin
Comment by Martin Jarvis — September 26, 2008 @ 11:31 am |
I do not think that “legacy” is such bad word :) I just use it refer to existing systems which you are not going to redesign but which contain valuable information that you want to reuse. I do not want say that everything from Oracle is legacy :) Do you have some better word how to describe such systems?
BTW DHH gave very good keynote at RailsConf Europe 2008 – “Living with legacy software”. The main message was that the code you write today will be legacy code tomorrow and you should not rewrite it all the time using new technologies but improve all the time existing code base.
Comment by Raimonds Simanovskis — September 26, 2008 @ 6:46 pm |
I am v interested in building a RoR on jRuby/Glassfish project that uses your enhancements and pl/sql gem. I need to create a WS(or REST) to EBS API adapter, with specific functionality around creating RMA orders, new items, items into categories, items into orgs, items having subinventories and locators, sensing when items are shipped, received from vendor or customer. Have you done any prelim work in these areas? Could become opensource project or in-house with contracted assistance.
Comment by Guy Boertje — September 26, 2008 @ 7:13 pm |
Curently my oracle_enhanced adapter is working just with MRI Ruby interpreter and not with JRuby. In JRuby you have to use JDBC adapter which supports Oracle database but it does not have my additional extensions that I described in presentation.
But in JRuby you can use ruby-plsql gem – see discussion on my previous post for usage examples.
In our projects we have used Ruby on Rails to make web applications on top of Oracle E-Business Suite data – e.g. customer self-service portal or employee time sheets application. But you can of course use Ruby on Rails to create web services on top of Oracle E-Business Suite data. REST approach would be easier but you can also create SOAP based web service – in this case you need to use soap4r gem.
Comment by Raimonds Simanovskis — September 27, 2008 @ 1:36 am |
Thanks again for your excellent job on Ruby/Rails and Oracle. Looking forward to your new ruby “product”.
Comment by Jesse Hu — October 7, 2008 @ 4:36 am |
Hi Raimonds, I was looking after our demo booth while your talk was on and missed the fun. Keep up the good work.
Comment by Chris Jones — October 9, 2008 @ 3:05 am |
I am seaching for some idea to write in my blog… somehow come to your blog. best of luck. Eugene
Comment by Eugene — October 20, 2008 @ 8:40 pm |