I am running into this error "Network error: 200", or "Network error:: Operation timed out." at a certain, reproducible point.
Here are the details on my environment:
- OS: Linux, Centos 5.3, 64bit
Runtime: Mono, 2.6.1
dotConnect version: 5.6 (beta) trial
After a very long running transaction (a big, multi-table import, running around 20 minutes), an error is caused by a unique constraint violation. I know this because I have 2 versions, one with MS OracleClient, and one with yours. The unique constraint violation causes the import to rollback. The rollback process takes about 3 minutes.
With the OracleClient, I see the exception and process it normally. With your client, I get this error after about 60 seconds, and I don't get the ORA- code or any other meaningful information.
Connection is established like so:
Code: Select all
var cmdb = new Devart.Data.Oracle.OracleConnectionStringBuilder();
cmdb.Direct = true;
cmdb.Pooling = false;
cmdb.DefaultCommandTimeout = 1800;
cmdb.ConnectionTimeout = 60;
cmdb.UserId = dbi.Username;
cmdb.Password = dbi.Password;
cmdb.Port = dbi.Port;
cmdb.Sid = dbi.DatabaseName;
cmdb.Server = dbi.Host;
return cmdb.ToString();Code: Select all
var cmd = conn.CreateCommand();
cmd.CommandTimeout = 1800;
return cmd;