Hello,
I am having a problem when my application looses it's connection with oracle. It simply 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 = ""; 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
|