Oracle Reconnection Problem

Hello,

I am having a problem when my application looses it's connection with  
oracle.  It stalls for a while.
It will eventually reconnect, but it take 9 minutes on my dev  
machine, and about 14 minutes (I think) on our deployment machine.

My EOF connection stuff on my dev machine is:
     connectionDictionary = {
         URL = "jdbc:oracle:thin:@192.168.2.2:1521:XE";
         driver = "oracle.jdbc.OracleDriver";
         jdbc2Info = {
             "ANSI92_CONFORMANCE" = ANSI92EntryLevel;
             "DBMS_NAME" = Oracle;
             "DRIVER_NAME" = "Oracle JDBC driver";
             "DRIVER_VER" = "10.2.0.1.0";
		.......

To detect this reconnection, I have set the EODatabaseContext delgate  
to Application object (for debug only)
I have added this to my Application.java
			
EODatabaseContext tmpDC = EOUtilities.databaseContextForModelNamed 
(new EOEditingContext(), "Model");
tmpDC.setDelegate(this);

public boolean databaseContextShouldHandleDatabaseException 
(EODatabaseContext dbCtxt, Throwable exception){
	aeLog.dbg("databaseContextShouldHandleDatabaseException");
	return true;
}

On the deployment machine, the Oracle connection seems to disconnect  
after some idle time when the app is not being used.
To reproduce the problem on my dev machine, I simply pull the network  
lead, and connect via another network adaptor (Airport)

This is my debug output (the first line is when the app receives the  
request from the browser):

[2006-06-14 11:48:44.809] [D] _dataDict = {H = "7382384"; R =  
"113006"; S = "2"; }
[2006-06-14 11:57:16.159] [D] [keuCfNZcleFXsti81xfR6M] [application]  
databaseContextShouldHandleDatabaseException

notice the 9 minute stall.

Has anyone come across this problem before?

Many thanks,

Mark

_______________________________________________
WebObjects-dev mailing list
[email protected]
http://www.omnigroup.com/mailman/listinfo/webobjects-dev