I have a similar situation going on. I'm getting connection issue
errors (ORA-03114 and others) after experiencing a couple different
errors. It seems that Sequel never attempts to acquire a new
connection. I'm looking at this too.
On Dec 2, 9:09 am, Drunkguy <[EMAIL PROTECTED]> wrote:
> There is an older oracle database that I make a connection to, but the
> connection isn't stable and it just goes away after a period of time.
> I need to be able to try to catch that and reconnect if it has gone
> away.
>
> While inspecting the object that Sequel.connect makes, I see that
> there is a test_connection method, but that returns true even after I
> see I lost the connection. Below is some snips from irb, I did cut
> out a lot of the stack trace.
>
> irb(main):014:0> DB = Sequel.connect('oracle://
> test:[EMAIL PROTECTED]:1521/DB')
>
> irb(main):015:0> rows = DB[:reporter_status].filter(:firstoccurrence
> => "28-NOV-08")
> => #<Sequel::Oracle::Dataset: "SELECT * FROM \"REPORTER_STATUS\" WHERE
> (\"FIRSTOCCURRENCE\" = '28-NOV-08')">
>
> irb(main):016:0> rows.count
> OCIError: ORA-03114: not connected to ORACLE
> from stmt.c:539:in oci8lib.so
>
> irb(main):017:0> DB.test_connection
> => true
>
> irb(main):018:0> DB.disconnect
> OCIError: ORA-03114: not connected to ORACLE
> from svcctx.c:144:in oci8lib.so
>
> You can see that after I try to do rows.count, that test_connection is
> returning true. Are there parameters I need to pass to it? Should I
> be testing the connection another way?
>
> Thanks,
> Matt
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
