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 |
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
