Home > database >  Oracle over a period of time is not on a remote server connection, the connection will produce abnor
Oracle over a period of time is not on a remote server connection, the connection will produce abnor

Time:09-23

C # code below
DbConnection connection=providerFactory. The CreateConnection ();
DbCommand command command=providerFactory. CreateCommand ();
Connection. The ConnectionString=the ConnectionString;
Command.Com mandText=SQL;
Command.Com mandType=commandType;
Command. The Connection=Connection;
Try
{
Command. The Connection. The Open ();
Using (DbDataReader reader=command. The ExecuteReader ())//quote here
{... Is omitted... }
} the catch (Exception ex) {... }
The finally
{
Try {the if (command. The Connection!=null) command. The Connection. The Close (); }
The catch (Exception) {}
}
Oracle in the local connection has no problem, then by oracle too card, so make the remote server (wireless router) often results in about 3 minutes without a database operation, can produce abnormal ORA - a03113: end - of - the file on the communication channel,
Note: is the exception, rather than the cause of slow, is really depressing.
And refresh after one to two times will connect successfully, and operational database

CodePudding user response:

Exception: "System.Net.Sockets.SocketException" (located in the System. DLL)
Hello, this is I met abnormalities, do you know the solution? Can you provide your QQ, my QQ 805228422 thank you