Ruby 1.9.3-p125, rails 3.2.1, activerecord-oracle_enhanced-adapter 1.4.1, ruby-oci8-2.1.0, oracle instantclient 11.2. Application uses mySQL as its db and wants to do read-only lookups in two Oracle tables (2 different databases). I got past the TNS error and the Timezone error and made a connection.
My query is simple: select <subset_of_cols> from <table> where <conditions>. I get no rows back. I copy/paste into SQLPlus and get 6 rows back. No errors from the rails script, just an empty array.
Am I supposed to be doing some kind of fetch after the sql select statement with this configuration as I would do in PHP? This is running me crazy, and I will still have the (either tomcat/jruby or) Passenger/apache2 problems to deal with when deploying.
Found a possible answer on the net. I had two dates. The one in yyyy-mm-dd format, I used the to_date function but the other date was dd-mon-yyyy so I used it directly as a <. Apparently this works in SQLPlus but when using ruby-oci8 and the adapter, this comes back doesn't work so I don't have a valid < date.
On to the next problems.