0

I am using activerecord with oracle enhaced adapter and oci8. I am having some trouble with the ORA-03113 error. I believe that using OCI8 AutoRecover could solve my problem, though, I cannot find anywere how to tell activerecord to use this functionality? Is there an option in the database.yml file? Is there any piece of code that I must run in order to activate it?

Technologies: Oracle 10g ActiveRecord 3.2.14 ruby 1.9.3

This is a non-Rails project.

user229044
  • 232,980
  • 40
  • 330
  • 338
Pedro Rolo
  • 28,273
  • 12
  • 60
  • 94
  • 1
    does the reconnect parameter not work? Try specifying `reconnect: true` in your configuration yaml. – mcfinnigan Oct 09 '13 at 14:53
  • are you sure that this parameter exists? I have no easy way to reproducce this situation. – Pedro Rolo Oct 09 '13 at 14:56
  • 1
    ah, I missed that you were using AR 2.3 - we're using 3.2 and it is likely introduced there. – mcfinnigan Oct 09 '13 at 14:59
  • I am acctually using 3.2.14. it was a mistype. thanks for the tip. – Pedro Rolo Oct 09 '13 at 15:02
  • I'm unsure if it will do what you need, since we run on mysql here. But from the parameter name I guess the intent is to reconnect when a connection dies or is closed by the server - hopefully it will sort out your oracle issue too :-) – mcfinnigan Oct 09 '13 at 15:03

0 Answers0