Devart Forums

Code: Select all

using System;
using System.Collections.Generic;
using System.Text;
using System.Threading;
using CoreLab.Oracle;
//using Oracle.DataAccess.Client;

namespace ConsoleApplication8
{
  class Program
  {
    static private OracleConnection _conn1;
    static private OracleConnection _conn2;
    static private string _connectionString = "User Id=pss;Password=pss;Data Source=NEMT14;Pooling=false";

    static private void Method()
    {
      Console.WriteLine("{0:HH-mm-ss}: Making second connection", DateTime.Now);
      try
      {
        _conn2 = new OracleConnection(_connectionString);
        _conn2.Open();
        Console.WriteLine("{0:HH-mm-ss}: Established second connection", DateTime.Now);
      }
      catch (Exception ex)
      {
        Console.WriteLine("{0:HH-mm-ss}: Second connection failed\n{1}", DateTime.Now, ex.ToString());
      }
    }

    static private void Runner()
    {
      while (true)
      {
        Thread.Sleep(1000);

        Method();

        Thread.Sleep(1000000);
      }
    }

    static void Main(string[] args)
    {
      Console.WriteLine("{0:HH-mm-ss}: Making first connection", DateTime.Now);
      _conn1 = new OracleConnection(_connectionString);
      _conn1.Open();
      Console.WriteLine("{0:HH-mm-ss}: Established first connection", DateTime.Now);

      Thread thread = new Thread(Runner);
      thread.IsBackground = true;
      thread.Start();

      Console.ReadLine();
    }
  }
}

Code: Select all

10-05-38: Making first connection
10-05-40: Established first connection
10-05-41: Making second connection
10-06-53: Second connection failed
CoreLab.Oracle.OracleException: ORA-12535: TNS:operation timed out
   at CoreLab.Oracle.OracleConnection.Open()
   at ConsoleApplication8.Program.Method() in C:\NEMMCO.NET2\TmpTestApps\Console Application8\Program.cs:line 23