Devart Forums

Code: Select all

DECLARE 
  cnt NUMBER;
BEGIN
  SELECT COUNT(*)
   INTO cnt
    FROM all_users
  WHERE username = 'DEVART';
  IF (cnt>0) THEN
    EXECUTE IMMEDIATE 'DROP USER DEVART CASCADE';
  end if; 
  end;
/
CREATE USER DEVART IDENTIFIED BY DEVART;
GRANT UNLIMITED TABLESPACE TO DEVART;
GRANT CREATE SESSION TO DEVART;

CREATE TABLE DEVART.INT0 (keycol INT PRIMARY KEY, datcol INT);
CREATE TABLE DEVART.INT1 (keycol INT PRIMARY KEY, datcol INT);
CREATE TABLE DEVART.INT2 (keycol INT PRIMARY KEY, datcol INT);

CREATE TABLE DEVART.CHAR0 (keycol CHAR(100) PRIMARY KEY, datcol INT);
CREATE TABLE DEVART.CHAR1 (keycol CHAR(100) PRIMARY KEY, datcol INT);
CREATE TABLE DEVART.CHAR2 (keycol CHAR(100) PRIMARY KEY, datcol INT);

INSERT INTO DEVART.INT1(keycol, datcol) VALUES (1,1);

INSERT INTO DEVART.INT2(keycol, datcol) VALUES (1,1);
INSERT INTO DEVART.INT2(keycol, datcol) VALUES (2,1);

INSERT INTO DEVART.CHAR1(keycol, datcol) VALUES ('1',1);

INSERT INTO DEVART.CHAR2(keycol, datcol) VALUES ('1',1);
INSERT INTO DEVART.CHAR2(keycol, datcol) VALUES ('2',1);

COMMIT;

Code: Select all

using System.Data.Common;
using Devart.Data.Oracle;
using NUnit.Framework;

namespace DevArtTests
{
    public class DevArtTests
    {
        private string GetHostname(int version)
        {
            return version == 9 ? "my.ninei.server" : "my.eleveng.server";
        }

        private string GetSid(int version)
        {
            return version == 9 ? "my.nine.sid" : "my.eleveng.sid";
        }

        private string GetConnectionString(string hostname, string sid, bool direct, bool unicode, string userId = "DEVART", string password = "DEVART")
        {
            var dataSource = string.Format(
                @"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST={0})(PORT=1521)))(CONNECT_DATA=(SID={1})));",
                hostname,
                sid
            );

            if (direct)
            {
                dataSource = string.Format(
                    "Data Source={0};Port=1521;SID={1};",
                    hostname,
                    sid
                );
            }

            return string.Format(
                @"{0};Direct={1};User Id={2};Password='{3}';Connection Timeout=60;Pooling=false;Unicode={4};",
                dataSource,
                direct,
                userId,
                password,
                unicode
            );
        }

        [Test, Combinatorial]
        public void DevartUnknownError1(
            [Values(9, 11)] int version,
            [Values(true, false)] bool direct,
            [Values(true, false)] bool unicode,
            [Values("keycol", "datcol", "keycol, datcol")] string column,
            [Values("INT", "CHAR")] string keyType,
            [Values(0, 1, 2)] int rowCount)
        {
            var hostname = GetHostname(version);
            var sid = GetSid(version);
            var table = string.Format("DEVART.{0}{1}", keyType, rowCount);

            var connectionString = GetConnectionString(hostname, sid, direct, unicode);

            using (var connection = new OracleConnection(connectionString))
            {
                connection.Open();

                using (DbCommand command = connection.CreateCommand())
                {
                        command.CommandTimeout = 10; // Give up on hanging commands quickly
                        command.CommandText = "SELECT " + column + " FROM " + table;
                        var reader = command.ExecuteReader();

                        reader.Read(); // This is where the problems occur
                }
            }
        }        
    }
}

Code: Select all

System.Exception : NET: Unknown error 1
   at Devart.Data.Oracle.DirectUtils.c(Int32 A_0)
   at Devart.Data.Oracle.h.a(Byte A_0)
   at Devart.Data.Oracle.db.b()
   at Devart.Data.Oracle.dg.d()
   at Devart.Data.Oracle.OracleInternalConnection.a(Boolean A_0)
   at Devart.Common.DbConnectionInternal.CloseInternalConnection()
   at Devart.Common.DbConnectionInternal.Close()
   at Devart.Data.Oracle.OracleInternalConnection.Close()
   at Devart.Common.DbConnectionBase.Close()
   at Devart.Common.DbConnectionBase.Dispose(Boolean disposing)
   at System.ComponentModel.Component.Dispose()
   at DevArtTests.DevArtTests.DevartUnknownError1(Int32 version, Boolean direct, Boolean unicode, String column, String keyType, Int32 rowCount) in DevArtTests.cs: line 73

Code: Select all

Devart.Data.Oracle.OracleException : ORA-01013: user requested cancel of current operation
   at Devart.Data.Oracle.an.d()
   at Devart.Data.Oracle.cq.e()
   at Devart.Data.Oracle.cq.a()
   at Devart.Data.Oracle.i.b(Int32 A_0)
   at Devart.Data.Oracle.OracleDataReader.Read()
   at DevArtTests.DevArtTests.DevartUnknownError1(Int32 version, Boolean direct, Boolean unicode, String column, String keyType, Int32 rowCount) in DevArtTests.cs: line 71