Inheritance: System.Runtime.InteropServices.ExternalException
        public ChangeScriptFailedException(DbException cause, ChangeScript script, int statement, string executedSql)
            : base(cause)
	    {
            this.script = script;
            this.statement = statement;
            this.executedSql = executedSql;
	    }
        public static string FormatMessage(DbException ex, SqlMigrationRun sqlRun)
        {
            string errorMsg = string.Empty;

            if (ex is SqlException)
            {
                var sqlEx = ex as SqlException;
                var no = sqlEx.Number;
                switch (no)
                {
                    case 515:
                        errorMsg = "把一个可空字段变更为非空字段时,由于存在不可空约束,所以数据库该表中不能有该字段为空的数据行。\r\n";
                        break;
                    case 547:
                        errorMsg = "把一个字段变更为非空外键字段时,由于外键约束,所以数据库该表中不能有该字段数据不满足引用约束的数据行。\r\n";
                        break;
                    default:
                        break;
                }
            }

            errorMsg += ex.Message;

            var error = "执行数据库迁移时出错:" + errorMsg;

            if (sqlRun != null)
            {
                error += Environment.NewLine + "对应的 SQL:" + sqlRun.Sql;
            }

            return error;
        }
Exemplo n.º 3
0
 public void Handle( DbException dbException, String sql, IEnumerable<IParameterStub> parameterStubs )
 {
     var improvedExceptionMessage = _exceptionMessageFormatter.Format( dbException, sql, parameterStubs );
     var DbEzException = new DbEzException( improvedExceptionMessage, dbException );
     DbEzException.Data.Add( "SQL", sql );
     DbEzException.Data.Add( "PARAMETERS", parameterStubs );
     throw DbEzException;
 }
 /// <summary>
 /// 	The handle batch exception.
 /// </summary>
 /// <param name = "dbException">The db exception.</param>
 protected override void HandleBatchException(DbException dbException)
 {
     Exception = dbException;
     var exp = dbException as SqlException;
     if (exp != null)
     {
         foreach (SqlError error in exp.Errors)
         {
             Messages += string.Format("Error line {0}: {1}.{2}", error.LineNumber, error.Message, Environment.NewLine);
         }
     }
 }
Exemplo n.º 5
0
 public string ExtractSqlState(DbException sqle)
 {
     string sqlState;
     Exception nested;
     sqlState = ExtractSingleSqlState(sqle);
     nested = sqle.InnerException;
     while (sqlState.Length == 0 && nested != null)
     {
         if (nested is DbException)
         {
             sqlState = ExtractSingleSqlState(sqle);
         }
         nested = sqle.InnerException;
     }
     return sqlState;
 }
Exemplo n.º 6
0
        public static void SqlError(System.Data.Common.DbException ex, string TSql, IDataParameterCollection Parameters)
        {
            if (Parameters == null || Parameters.Count == 0)
            {
                SqlError(ex, TSql);
            }
            string ptr = string.Empty;

            foreach (IDataParameter p in Parameters)
            {
                ptr += string.Format("declare {0} {2}; set {0} ='{1}'\r\n", p.ParameterName, p.Value, p.DbType);
            }
            ptr += "-----auto code------\r\n";
            ptr += TSql;
            SqlError(ex, ptr);
        }
Exemplo n.º 7
0
        /* Many drivers provide both SqlState and NativeError in the Exception
         * Some of them, like OdbcException, have fields SQLState, NativeError
         * Some of them contain it in Data field, like PsqlException
         * Some of them have only text message
         */

        public int ExtractErrorCode(DbException sqle)
        {
            int errorCode;
            Exception nested;
            errorCode = ExtractSingleErrorCode(sqle);
            nested = sqle.InnerException;
            while (errorCode == 0 && nested != null)
            {
                if (nested is DbException)
                {
                    errorCode = ExtractSingleErrorCode(sqle);
                }
                nested = sqle.InnerException;
            }
            return errorCode;
        }
        /* OdbcException, OleDbException, IfxException, Db2Exception, and possible others
         * have Errors collection which contains fields: NativeError and SQLState
         * These fields can be extracted using reflection
         */
        public override int ExtractSingleErrorCode(DbException sqle)
        {
            System.Type type;
            PropertyInfo pi;
            int nativeError;

            type = sqle.GetType();
            pi = type.GetProperty("Errors");
            if (pi == null) // there is no Errors property
            {
                return 0;
            }
            nativeError = 0;
            foreach (object o in (pi.GetValue(sqle, null) as IEnumerable))
            {
                pi = o.GetType().GetProperty("NativeError");
                if (pi == null)
                    return 0;
                nativeError = (int)pi.GetValue(o, null);
                if (nativeError != 0)
                    break;
            }
            return nativeError;
        }
        public override string ExtractSingleSqlState(DbException sqle)
        {
            System.Type type;
            PropertyInfo pi;
            string sqlState;

            type = sqle.GetType();
            pi = type.GetProperty("Errors");
            if (pi == null) // there is no Errors property
            {
                return null;
            }
            sqlState = "";
            foreach (object o in (pi.GetValue(sqle, null) as IEnumerable))
            {
                pi = o.GetType().GetProperty("SQLState");
                if (pi == null)
                    return null;
                sqlState = (string)pi.GetValue(o, null);
                if (sqlState.Length != 0)
                    break;
            }
            return sqlState;
        }
Exemplo n.º 10
0
 public override bool IsUniqueViolation(DbException ex, string keyName = "")
 {
     throw new NotImplementedException();
 }
Exemplo n.º 11
0
 public override bool IsDbBusy(DbException ex)
 {
     throw new NotImplementedException();
 }
Exemplo n.º 12
0
 public static void SqlError(System.Data.Common.DbException ex, IDbCommand cmd)
 {
     SqlError(ex, cmd.CommandText, cmd.Parameters);
 }
		public virtual string ExtractConstraintName(DbException sqle)
		{
			return null;
		}
Exemplo n.º 14
0
 public PrimaryKeyViolation(string message, DbException exception)
     : base(message, exception)
 {
 }
Exemplo n.º 15
0
 public abstract bool IsDbBusy(DbException ex);
Exemplo n.º 16
0
        public static void SqlError(System.Data.Common.DbException ex, string TSql)
        {
            bool isLocal = false;

            using (EventLog log = new EventLog("WebException"))
            {
                string url, method;
                string extData;
                if (System.Web.HttpContext.Current != null)
                {
                    HttpRequest Request = System.Web.HttpContext.Current.Request;
                    url     = Request.Url.ToString();
                    method  = Request.HttpMethod;
                    isLocal = Request.IsLocal;
                    string rp;
                    if (Request.UrlReferrer == null)
                    {
                        rp = "none";
                    }
                    else
                    {
                        rp = Request.UrlReferrer.ToString();
                        if (rp.Length > 255)
                        {
                            rp = rp.Substring(0, 255) + "<...>";
                        }
                    }
                    extData  = "\r\nReferrer:" + rp;
                    extData += "\r\nUserAgent:" + Request.UserAgent;
                    if (extData.Length > 512)
                    {
                        extData = extData.Substring(0, 512) + "<...>";
                    }
                }
                else
                {
                    url     = string.Empty;
                    method  = "n/a";
                    extData = string.Empty;
                }
                log.Source = "Sql";

                StringBuilder msg = new StringBuilder();
                msg.AppendFormat("url:{0} {1}", method, url);
                msg.AppendLine(extData);
                if (!string.IsNullOrEmpty(TSql))
                {
                    msg.AppendLine("Sql:");
                    msg.AppendLine(TSql);
                }

                //msg.AppendLine(ex.Message);
                if (ex is SqlException)
                {
                    SqlException msEx = (SqlException)ex;
                    for (int i = 0; i < msEx.Errors.Count; i++)
                    {
                        msg.AppendLine("Message: " + msEx.Errors[i].Message);
                        msg.AppendLine("LineNumber: " + msEx.Errors[i].LineNumber);
                        msg.AppendLine("Source: " + msEx.Errors[i].Source);
                        msg.AppendLine("Procedure: " + msEx.Errors[i].Procedure);
                    }
                }
                else
                {
                    msg.AppendLine("Message:" + ex.Message);
                    msg.AppendLine("ErrorCode:" + ex.ErrorCode);
                }



                StackTrace s = new StackTrace(true);
                for (int i = 1; i < s.FrameCount; i++)
                {
                    StackFrame t  = s.GetFrame(i);
                    MethodBase mb = s.GetFrame(i).GetMethod();
                    System.Reflection.Module m = mb.Module;
                    int line = t.GetFileLineNumber();

                    if (mb.Name != "SqlError" && !m.ScopeName.StartsWith("System"))
                    {
                        msg.AppendLine(mb.Name + "() " + t.GetFileName() + "  行:" + t.GetFileLineNumber());
                    }
                }
                //msg.AppendLine(ex.ToString());

                byte[] bin = null;
                if (method == "POST")
                {
                    Stream stm = System.Web.HttpContext.Current.Request.InputStream;
                    if (stm.Length > 5120)
                    {
                        bin = System.Text.ASCIIEncoding.ASCII.GetBytes("*data length:" + stm.Length.ToString());
                    }
                    else
                    {
                        long p = stm.Position;
                        bin = new byte[stm.Length];
                        stm.Seek(0, SeekOrigin.Begin);
                        stm.Read(bin, 0, bin.Length);
                        stm.Position = p;
                    }
                }

                try
                {
                    if (bin != null)
                    {
                        log.WriteEntry(msg.ToString(), EventLogEntryType.Error, 0, 0, bin);
                    }
                    else
                    {
                        log.WriteEntry(msg.ToString(), EventLogEntryType.Error);
                    }
                }
                catch
                {
                    if (isLocal)
                    {
                        throw;
                    }
                }
                log.Close();
            }
        }
Exemplo n.º 17
0
 public virtual bool IsDuplicateException(DbException exception)
 {
     var msg = exception.Message.ToUpperInvariant();
     return msg.Contains("DUPLICATE") || msg.Contains("UNIQUE");
 }
Exemplo n.º 18
0
 /// <summary>
 /// Checks is the exception was thrown because an unique constraint was violated.
 /// Can be used to implement idempotency e.g you can treat primary key violations as duplicate operations
 /// </summary>
 /// <param name="db"></param>
 /// <param name="ex"></param>
 /// <param name="keyName"></param>
 /// <returns></returns>
 public static bool IsUniqueViolation(this DbConnection db, DbException ex, string keyName = null)
     => db.Provider().IsUniqueViolation(ex, keyName);
Exemplo n.º 19
0
 public void Handle( DbException dbException, String sql )
 {
     var emptyParams = new IParameterStub[ 0 ];
     Handle( dbException, sql, emptyParams );
 }
Exemplo n.º 20
0
 public ForeignKeyViolation(string message, DbException exception)
     : base(message, exception)
 {
 }
 /// <summary> 
 /// Extract the name of the violated constraint from the given SQLException. 
 /// </summary>
 /// <param name="sqle">The exception that was the result of the constraint violation. </param>
 /// <returns> The extracted constraint name. </returns>
 public abstract string ExtractConstraintName(DbException sqle);
Exemplo n.º 22
0
 public override bool ObjectExists(DbException ex, string name = null)
 {
     throw new NotImplementedException();
 }
Exemplo n.º 23
0
 public abstract bool ObjectExists(DbException ex, string name = null);
Exemplo n.º 24
0
 public DbEzException( String message, DbException innerException )
     : base(message, innerException)
 {
 }
Exemplo n.º 25
0
 public static void SqlError(System.Data.Common.DbException ex)
 {
     SqlError(ex, string.Empty);
 }
Exemplo n.º 26
0
 public abstract bool IsUniqueViolation(DbException ex, string keyName = "");
Exemplo n.º 27
0
 public override bool ObjectExists(DbException ex, string name = null)
 {
     if (!ex.Message.Contains("already exists")) return false;
     if (name.IsNullOrEmpty()) return false;
     return ex.Message.Contains(name);
 }
Exemplo n.º 28
0
 public SchemaRaisedError(string message, DbException exception)
     : base(message, exception)
 {
 }
Exemplo n.º 29
0
 public override bool IsUniqueViolation(DbException ex, string keyName = "")
 {
     if (!ex.Message.Contains("UNIQUE constraint failed:")) return false;
     if (keyName.IsNullOrEmpty()) return false;
     return ex.Message.Contains(keyName);
 }
Exemplo n.º 30
0
Arquivo: Mapper.cs Projeto: vosen/Juiz
 private void ProcessSQLException(int idx, DbException ex)
 {
     log.Error(String.Format("<{0}> exception when processing", idx), ex);
 }
Exemplo n.º 31
0
 public abstract string ExtractSingleSqlState(DbException sqle);
Exemplo n.º 32
0
 public UniqueKeyViolation(string message, DbException exception)
     : base(message, exception)
 {
 }
Exemplo n.º 33
0
 public DatabaseError(string message, DbException exception)
     : base(message, exception)
 {
 }
Exemplo n.º 34
0
 /// <summary>
 ///   基本构造
 /// </summary>
 public AgebullSystemException(System.Data.Common.DbException serr) : this(serr.Message, serr)
 {
 }
Exemplo n.º 35
0
 public abstract int ExtractSingleErrorCode(DbException sqle);