I have a RoR app which uses an existing Oracle database. It has its
own user/schema which uses Rails conventions for naming. The data are
extracted from another schema into views so that we can use these
The problem is that it intermittently throws an
ActiveRecord::StatementInvalid when trying to update data in the
application. It seems to be a problem with how the oci adapter handles
the date format; however, all the data are cleaned up using callbacks
and validated before submission.
The problem seems most prevalent when there are more people using the
application (but even at its maximum it would be no more than 30 -- it
is a CRM application for clients of our company to view/update data
that we maintain for them), which leads me to my question:
Is anyone aware of any problems with OCI/Oracle adapter maintaining
multiple connections for the same (Oracle) user (schema)?
I am using Rails 1.1.6/Ruby 1.8.4. We have another application which
uses the same versions and does not seem to have this problem.