Database went away - can't re-establish the connection (JRuby/Tomcat)

[Tamer Salama]

Hi,

We have an application that couldn't re-establish connection to the database after it went down (ORA-00942: table or view does not exist). Other apps accessing the same DB didn't experience the issue - however - this application has attempted a query DURING the DB downtime.

I'm not sure where to start digging. Any pointers would be appreciated.

ORA-00942: table or view does not exist

oracle-enhanced 1.4

Rails 3.2

JRuby 1.7 (1.9 mode)

Tomcat 6.0.20

In server.xml:

<Resource name="JDBC_NAME"

auth="Container"

type="javax.sql.DataSource"

driverClassName="oracle.jdbc.OracleDriver"

url="jdbc:oracle:thin:@INSTANCE:1521:DATABASE"

username="USERNAME"

password="PASSWORD"

validationQuery="Select 1 from dual"

testOnBorrow="true"

testOnReturn="true"

timeBetweenEvictionRunsMillis="1800000"

removeAbandoned="true"

removeAbandonedTimeout="300"

accessToUnderlyingConnectionAllowed="true" />

[Lori M Olson]

Question... That "table or view does not exist" sounds familiar, and is NOT indicative of a failure to reestablish the connection.

Are you using a specific schema?  We had this same problem with connections coming back, and our "current_schema" being reset to default, and not the schema we specified.  

Regards, Lori

--
You received this message because you are subscribed to the Google Groups "Oracle enhanced adapter for ActiveRecord" group.
To unsubscribe from this group and stop receiving emails from it, send an email to oracle-enhanc...@googlegroups.com.
To post to this group, send email to oracle-...@googlegroups.com.
Visit this group at http://groups.google.com/group/oracle-enhanced?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Tamer Salama]

That's quite interesting Lori. Perhaps that's what's happening. Will further test this.