连接池--sp_reset_connection

最新推荐文章于 2021-09-14 09:02:02 发布
转载 最新推荐文章于 2021-09-14 09:02:02 发布 · 529 阅读 · 1
文章标签：

#数据库 #数据结构与算法

本文深入探讨了SQLSERVER中sp_reset_connection存储过程的功能，包括清除连接内部数据结构、重置连接设置、回滚事务、切换数据库及权限检查等关键操作。详细解释了在连接管理中的应用。

--当客户端使用连接池访问数据库时，客户端使用OPEN来重用数据库连接，使用CLOSE来断开数据库连接，但并不物理上新建和断开连接，因此可以提高程序运行速度并降低性能损耗。

--ADO和ADO.NET程序会默认启用连接池
--如果一个连接未提交或回滚事务便在客户端显示close,则事务会被一直保持到该连接被重用时被释放.
--第一次建立的连接不会调用sp_reset_connection
 
--sp_reset_connection会在SQLSERVER里做些什么？
--1、清除连接现有所有内部数据结构。包括：
--清除所有openxml打开的document句柄
--关闭所有的游标(cursor)
--释放所有SQL语句句柄
--清除所有临时对象(临时表等)
--释放连接持有的所有锁
--清除缓存的所有安全上下文信息(security context)
 
--2、重置连接设置。包括：
--重置连接的SQL Trace标志值
--重置所有"SET" 选项值(SET IMPLICIT_TRANSACTIONS ON 等)
--重置连接的统计信息值
 
 
--3、回滚所有SQLSERVER事务
--需要说明的是，如果连接当前参与了一个由客户端发起的分布式事务，这个分布式事务不会受到影响。在SQL里的事务还会被保留
 
--4、把当前数据库切换到用户默认数据库
 
--5、SQLSERVER会再次检查当前用户是否有权做数据库连接。如果这个权限已被移除SQLSERVER会中断这个物理连接(这样防止一个已经被取消访问权的用户还能长时间使用数据库的问题)
 
 
--参考：http://www.cnblogs.com/lyhabc/articles/3222241.html

【好好学习】SocketException: Connection reset——根因是重复认证
来啦，老弟~
11-20 7760
一、异常现象 Exception in thread "main" org.apache.spark.SparkException: Job aborted due to stage failure: Task 1 in stage 73.0 failed 4 times, most recent failure: Lost task 1.3 in stage 73.0 (TID 533, HQC...
EF 4.1中内部经常提交的 exec sp_reset_connection 的用途原来是为了重用池中的连接...
weixin_33795806的博客
05-28 377
sp_reset_connection 的作用     当您使用连接池连接到 SQL Server 时，SQL Server 将调用 sp_reset_connection 存储过程来重用之前池中的连接。(在.NET中是由.Net SqlClient Data Provider调用)     使用 sp_reset_connection 存储过程可确保连接选项被重置，使 客户端应用程序 重用 ...
sp_reset_connection
weixin_30566149的博客
10-10 222
SP_RESET_CONNECTION:清理当前连接上次遗留下来的所有对象，包括回滚未提交的事务。 转载于:https://www.cnblogs.com/tianlangli/p/4015964.html
使用多记录集返回数据，避免多次执行sp_reset_connection http://blog.tiantiansoft.com/user1/9/archives/2007/4131.html
专栏
12-11 4000
先说一下sp_reset_connection，我对这个存储过程不是很理解，我是在ms sql的事件探查器里跟踪页面查到这个存储过程的，在F1里，有关这个存储过程只有一句话：sp_reset_connection 存储过程由 SQL Server 用来支持事务中的远程存储过程调用。msdn对系统存储过程(http://msdn2.microsoft.com/zh-cn/library/ms
sp_reset_connection是干嘛的？( What does sp_reset_connection do?)
GRANDTREE的专栏
05-27 3914
What does sp_reset_connection do?From http://sqldev.net/misc/sp_reset_connection.htm version: 1.0.0.1last updated: 14 April 2005Data access APIs layers like ODBC, OLE-DB and SqlClient c
What does sp_reset_connection do
FBug的专栏
02-22 1520
http://www.sqldev.net/misc/sp_reset_connection.htm sp_reset_connection resets the following aspects of a connection: It resets all error states and numbers (like @@error) It stops all EC's (execu
ADO.NET数据连接池剖析
09-11
ADO.NET数据连接池是.NET Framework中的一个重要特性，它在数据库应用程序中起到了优化性能的作用。连接池的出现主要是为了解决频繁建立和关闭数据库连接时所消耗的资源问题。在没有连接池的情况下，每次与数据库...
using System; using System.Collections; using System.Collections.Generic; using System.Linq; using System.Text; using System.IO; using System.IO.Ports; using System.Net; using System.Net.Sockets; using System.Threading; using System.Reflection; using System.Diagnostics; /* 类使用说明： 1. 在调用协议函数前，需先调用 Connect()函数，以便初始化数据端口。程序退出前也需调用Disconnect()函数。以释放端口。 2. 函数Send()和ReceiveByte()在协议函数中使用，无需在通讯时再次使用。 3. 串口ModbusMasterSerial类的构造函数中完成了协议的相关模式定义，并存入类成员变量中。函数名ModbusMasterSerial(); 需代入参数有串口模式(ASCII OR RTU),端口号，波特率，数据位宽，校验位，停止位，握手位。 4. */ namespace ModbusField { //----------------------------------------------------------------------------------------------------------------------------------------------------------- #region Custom Events Args // Event args for remote endpoint connection public sealed class ModbusTCPUDPClientConnectedEventArgs : EventArgs { #region Global Variables /// <summary> /// Remote endpoint /// </summary> IPEndPoint remote_ep; #endregion #region Parameters /// <summary> /// Remote EndPoint /// </summary> public IPEndPoint RemoteEndPoint { get { return remote_ep; } } #endregion #region Constructor // Constructor /// <param name="remote_ep">Remote EndPoint</param> public ModbusTCPUDPClientConnectedEventArgs(IPEndPoint remote_ep) { this.remote_ep = remote_ep; } #endregion } #endregion //----------------------------------------------------------------------------------------------------------------------------------------------------------- #region Enumerations // Connection types public enum ConnectionType { SERIAL_RTU = 0, SERIAL_ASCII = 1, TCP_IP = 2, UDP_IP = 3 } // Type of modbus serial public enum ModbusSerialType { RTU = 0, ASCII = 1 } //Type of device public enum DeviceType { MASTER = 0, SLAVE = 1 } // Tabelle del database modbus public enum ModbusDBTables { DISCRETE_INPUTS_REGISTERS = 0, COIL_REGISTERS = 1, INPUT_REGISTERS = 2, HOLDING_REGISTERS = 3 } // Modbus calling codes enum ModbusCodes { READ_COILS = 0x01, READ_DISCRETE_INPUTS = 0x02, READ_HOLDING_REGISTERS = 0x03, READ_INPUT_REGISTERS = 0x04, WRITE_SINGLE_COIL = 0x05, WRITE_SINGLE_REGISTER = 0x06, READ_EXCEPTION_STATUS = 0x07, DIAGNOSTIC = 0x08, GET_COM_EVENT_COUNTER = 0x0B, GET_COM_EVENT_LOG = 0x0C, WRITE_MULTIPLE_COILS = 0x0F, WRITE_MULTIPLE_REGISTERS = 0x10, REPORT_SLAVE_ID = 0x11, READ_FILE_RECORD = 0x14, WRITE_FILE_RECORD = 0x15, MASK_WRITE_REGISTER = 0x16, READ_WRITE_MULTIPLE_REGISTERS = 0x17, READ_FIFO_QUEUE = 0x18, READ_DEVICE_IDENTIFICATION = 0x2B } // Error codes public enum Errors { NO_ERROR = 0, RX_TIMEOUT = -1, WRONG_TRANSACTION_ID = -2, WRONG_PROTOCOL_ID = -3, WRONG_RESPONSE_UNIT_ID = -4, WRONG_RESPONSE_FUNCTION_CODE = -5, WRONG_MESSAGE_LEN = -6, WRONG_RESPONSE_ADDRESS = -7, WRONG_RESPONSE_REGISTERS = -8, WRONG_RESPONSE_VALUE = -9, WRONG_CRC = -10, WRONG_LRC = -11, START_CHAR_NOT_FOUND = -12, END_CHARS_NOT_FOUND = -13, WRONG_RESPONSE_AND_MASK = -14, WRONG_RESPONSE_OR_MASK = -15, THREAD_BLOCK_REQUEST = -16, WRONG_WRITE_SINGLE_COIL_VALUE = -17, TOO_MANY_REGISTERS_REQUESTED = -18, ZERO_REGISTERS_REQUESTED = -19, EXCEPTION_ILLEGAL_FUNCTION = -20, EXCEPTION_ILLEGAL_DATA_ADDRESS = -21, EXCEPTION_ILLEGAL_DATA_VALUE = -22, EXCEPTION_SLAVE_DEVICE_FAILURE = -23, EXCEPTION_ACKNOLEDGE = -24, EXCEPTION_SLAVE_DEVICE_BUSY = -25, EXCEPTION_MEMORY_PARITY_ERROR = -26, EXCEPTION_GATEWAY_PATH_UNAVAILABLE = -27, EXCEPTION_GATEWAY_TARGET_DEVICE_FAILED_TO_RESPOND = -28, WRONG_REGISTER_ADDRESS = -29 } #endregion //----------------------------------------------------------------------------------------------------------------------------------------------------------- #region Base abstract class // Base abstract class public abstract class ModbusBase { //-------------------------------------------------------------------------------------------------------------- //常量 protected const ushort PROTOCOL_ID = 0x0000;// Modbus protocol identifier (only TCP and UDP) const int DEFAULT_RX_TIMEOUT = 6000;// Default rx timeout in milliseconds protected const int MBAP_HEADER_LEN = 7;// Length in bytes of MBAP header protected const char ASCII_START_FRAME = ':';// Start frame character (only Modbus serial ASCII) protected const char ASCII_STOP_FRAME_1ST = '\x0D';// End frame first character (only Modbus serial ASCII) protected const char ASCII_STOP_FRAME_2ND = '\x0A';// End frame second character (only Modbus serial ASCII) public const ushort MAX_COILS_IN_READ_MSG = 2000;// Max number of coil registers that can be read public const ushort MAX_DISCRETE_INPUTS_IN_READ_MSG = 2000;// Max number of discrete inputs registers that can be read public const ushort MAX_HOLDING_REGISTERS_IN_READ_MSG = 125;// Max number of holding registers that can be read public const ushort MAX_INPUT_REGISTERS_IN_READ_MSG = 125;// Max number of input registers that can be read public const ushort MAX_COILS_IN_WRITE_MSG = 1968;// Max number of coil registers that can be written public const ushort MAX_HOLDING_REGISTERS_IN_WRITE_MSG = 123;// Max number of holding registers that can be written public const ushort MAX_HOLDING_REGISTERS_TO_READ_IN_READWRITE_MSG = 125;// Max number of holding registers that can be read in a read/write message public const ushort MAX_HOLDING_REGISTERS_TO_WRITE_IN_READWRITE_MSG = 121;// Max number of holding registers that can be written in a read/write message //-------------------------------------------------------------------------------------------------------------- //全局变量 protected ConnectionType connection_type; // Connection type（SERIAL_RTU = 0;SERIAL_ASCII = 1;TCP_IP = 2;UDP_IP = 3） protected DeviceType device_type; // Device type(MASTER = 0;SLAVE = 1) protected int rx_timeout = DEFAULT_RX_TIMEOUT; // Reception timeout (milliseconds) protected Errors error;// Modbus errors protected int interframe_delay;// Delay between two Modbus serial RTU frame (milliseconds) protected int interchar_delay;// Delay between two Modbus serial RTU characters (milliseconds) #region Utility functions //-------------------------------------------------------------------------------------------------------------- // Get or set reception timeout (milliseconds) public int RxTimeout { get { return rx_timeout; } set { rx_timeout = value; } } //-------------------------------------------------------------------------------------------------------------- // Get last error code public Errors Error { get { return error; } } //-------------------------------------------------------------------------------------------------------------- //将一个16Bit无符号整型数(大端数据),转换成数组并返回。数据的高8位存储在数组的第一个元素中 // Return an array of bytes from an unsigned 16 bit integer using BIG ENDIAN codification // <param name="value">Value to convert</param> // <returns>Bytes array</returns> protected byte[] GetBytes(ushort value) { byte[] array = new byte[2]; array[0] = (byte)(value >> 8); array[1] = (byte)(value & 0x00FF); return array; } //-------------------------------------------------------------------------------------------------------------- //将输入数组中的每个元素，按高低4位分割，每个4个位的值与十六进制字符‘0’-‘F’对应。将一个数据字节转换成两个字节的字符数据(ASCII码)，并返回转换后的数组数据 // Return an array of bytes coded in ASCII according to Modbus specification // <param name="buffer">Buffer to codify</param> // <returns>Buffer codified</returns> // <remarks> // Example of codification : Byte = 0x5B // Codified in two chars : 0x35 = '5' and 0x42 = 'B' in ASCII // The returned vector is exactly the double of the introduced one. // </remarks> protected byte[] GetASCIIBytesFromBinaryBuffer(byte[] buffer) { List<char> chars = new List<char>(); for (int ii = 0, jj = 0; ii < buffer.Length * 2; ii++) { char ch; byte val = (byte)((ii % 2) == 0 ? buffer[jj] >> 4 : buffer[jj] & 0x0F); switch (val) { default: case 0x00: ch = '0'; break; case 0x01: ch = '1'; break; case 0x02: ch = '2'; break; case 0x03: ch = '3'; break; case 0x04: ch = '4'; break; case 0x05: ch = '5'; break; case 0x06: ch = '6'; break; case 0x07: ch = '7'; break; case 0x08: ch = '8'; break; case 0x09: ch = '9'; break; case 0x0A: ch = 'A'; break; case 0x0B: ch = 'B'; break; case 0x0C: ch = 'C'; break; case 0x0D: ch = 'D'; break; case 0x0E: ch = 'E'; break; case 0x0F: ch = 'F'; break; } chars.Add(ch); if ((ii % 2) != 0) jj++; } return Encoding.ASCII.GetBytes(chars.ToArray()); } //-------------------------------------------------------------------------------------------------------------- //将输入数组中的数据(十六进制字符的ASCII码)，两个数组元素一组，按序合成一个字节，低4位对应第一个元素(字符)的数值(0x00-0x0F),高4位对应第二个元素。返回转换后的字节型数组 // Return a binary buffer from a byte array codified in ASCII according to Modbus specification // <param name="buffer">ASCII codified buffer</param> // <returns>Binary buffer</returns> // <remarks> // Example of codification : Char1 = 0x35 ('5') and Char2 = 0x42 ('B') // Byte decodified : Byte = 0x5B // The returned vector is exactly the half of the introduced one // </remarks> protected byte[] GetBinaryBufferFromASCIIBytes(byte[] buffer) { List<byte> ret = new List<byte>(); char[] chars = Encoding.ASCII.GetChars(buffer); byte bt = 0; for (int ii = 0; ii < buffer.Length; ii++) { byte tmp; switch (chars[ii]) { default: case '0': tmp = 0x00; break; case '1': tmp = 0x01; break; case '2': tmp = 0x02; break; case '3': tmp = 0x03; break; case '4': tmp = 0x04; break; case '5': tmp = 0x05; break; case '6': tmp = 0x06; break; case '7': tmp = 0x07; break; case '8': tmp = 0x08; break; case '9': tmp = 0x09; break; case 'A': tmp = 0x0A; break; case 'B': tmp = 0x0B; break; case 'C': tmp = 0x0C; break; case 'D': tmp = 0x0D; break; case 'E': tmp = 0x0E; break; case 'F': tmp = 0x0F; break; } if (ii % 2 != 0) { bt |= tmp; ret.Add(bt); bt = 0; } else bt = (byte)(tmp << 4); } return ret.ToArray(); } //-------------------------------------------------------------------------------------------------------------- //将两个连续Byte数组的元超级流感，按大端格式合组一个16Bit整型无符号数 // Return a 16 bit unsigned integer from two bytes according to BIG ENDIAN codification // <param name="value">Source byte array</param> // <param name="offset">Buffer offset</param> // <returns>Integer returned</returns> protected ushort ToUInt16(byte[] value, int offset) { return (ushort)((value[offset] << 8) | (value[offset + 1] & 0x00FF)); } //-------------------------------------------------------------------------------------------------------------- //Bool数组转换为字节数据(输入数组长度减去偏置量后，必须大于等于8) // Return a byte from an 8-bit boolean array // <param name="array">Array booleano di 8 bit</param> // <param name="offset">Array offset</param> // <returns>Byte returned</returns> protected byte EightBitToByte(bool[] array, int offset) { if (array.Length < 8) throw new Exception(MethodInfo.GetCurrentMethod().Name + ": The array must be at least 8-bit length!"); byte ret = 0x00; for (int ii = 0; ii < 8; ii++) { switch (array[offset + ii]) { case true: ret |= (byte)(1 << ii); break; case false: ret &= (byte)(~(1 << ii)); break; } } return ret; } //-------------------------------------------------------------------------------------------------------------- //获取数据帧间延时 // Get delay time between two modbus RTU frame in milliseconds // <param name="sp">Serial Port</param> // <returns>Calculated delay (milliseconds)</returns> protected int GetInterframeDelay(SerialPort sp) { int ret_val; if (sp.BaudRate > 19200) ret_val = 2; // Fixed value = 1.75ms up rounded else { int nbits = 1 + sp.DataBits; nbits += sp.Parity == Parity.None ? 0 : 1; switch (sp.StopBits) { case StopBits.One: nbits += 1; break; case StopBits.OnePointFive: // Ceiling case StopBits.Two: nbits += 2; break; } ret_val = Convert.ToInt32(Math.Ceiling(1 / (((double)sp.BaudRate / ((double)nbits * 3.5d)) / 1000))); } return ret_val; } //-------------------------------------------------------------------------------------------------------------- //依据波特率，计算传输字符间延时 // Get max delay time in milliseconds between received chars in modbus RTU trasmission // <param name="sp">Serial Port</param> // <returns>Calculated delay (milliseconds)</returns> protected int GetIntercharDelay(SerialPort sp) { int ret_val; if (sp.BaudRate > 19200) ret_val = 1; // Fixed value = 0.75 ms up rounded else { int nbits = 1 + sp.DataBits; nbits += sp.Parity == Parity.None ? 0 : 1; switch (sp.StopBits) { case StopBits.One: nbits += 1; break; case StopBits.OnePointFive: // Ceiling case StopBits.Two: nbits += 2; break; } ret_val = Convert.ToInt32(Math.Ceiling(1 / (((double)sp.BaudRate / ((double)nbits * 1.5d)) / 1000))); } return ret_val; } #endregion } #endregion //----------------------------------------------------------------------------------------------------------------------------------------------------------- #region Base abstract class for Modbus master instances /// <summary> /// Base abstract class for Modbus master instances /// </summary> public abstract class ModbusMaster : ModbusBase { protected bool connected = false;// Remote host connection status protected List<byte> send_buffer = new List<byte>();// Trasmission buffer protected List<byte> receive_buffer = new List<byte>();// Reception buffer protected ushort transaction_id = 0;// Modbus transaction ID (only Modbus TCP/UDP) protected Stopwatch sw_ch;// Interchar timeout timer //-------------------------------------------------------------------------------------------------------------------------------------------- //项目中使用到的函数 // Get remote host connection status public bool Connected { get { return connected; } } #region Constructor // Constructor public ModbusMaster() { device_type = DeviceType.MASTER; // Device type sw_ch = new Stopwatch(); // Initialize interchar timeout timer } #endregion //----------------------------------------------------------------------------------------------------------------------------------------------------------- public abstract void Connect();// Open connection public abstract void Disconnect();// Close connection protected abstract void Send();// Function to send trasminission buffer protected abstract int ReceiveByte();// Function to read a byte from a device,returns a Byte readed or -1 if no data are present //----------------------------------------------------------------------------------------------------------------------------------------------------------- //Modbus协议实现功能函数 #region Protocol functions //------------------------------------------------------------------------------------------------------------------------------------------------------ // Init a new Modbus TCP/UDP message protected void InitTCPUDPMasterMessage() { transaction_id++;// Increase transaction_id send_buffer.Clear();// Tx buffer emptying } //------------------------------------------------------------------------------------------------------------------------------------------------------ // Build MBAP header for Modbus TCP/UDP // <param name="dest_address">Destination address</param> // <param name="message_len">Message length</param> protected void BuildMBAPHeader(byte dest_address, ushort message_len) { send_buffer.InsertRange(0, GetBytes(transaction_id));// Transaction ID (incremented by 1 on each trasmission) send_buffer.InsertRange(2, GetBytes(PROTOCOL_ID));// Protocol ID (fixed value) send_buffer.InsertRange(4, GetBytes(message_len));// Message length send_buffer.Insert(6, dest_address);// Remote unit ID } //------------------------------------------------------------------------------------------------------------------------------------------------------ //接收数据，并执行校验，地址检测等操作 // Exec a query to a destination master // <param name="unit_id">Salve device address</param> // <param name="msg_len">Message lenght</param> protected void Query(byte unit_id, ushort msg_len) { int rcv; long tmo; error = Errors.NO_ERROR; // Set errors to null switch (connection_type) // Start to build message { case ConnectionType.SERIAL_ASCII: send_buffer.Insert(0, unit_id);// Add destination device address byte[] lrc = GetASCIIBytesFromBinaryBuffer(new byte[] { LRC.CalcLRC(send_buffer.ToArray(), 0, send_buffer.Count) });// Calc message LCR send_buffer = GetASCIIBytesFromBinaryBuffer(send_buffer.ToArray()).ToList();// Convert 'send_buffer' from binary to ASCII send_buffer.AddRange(lrc);// Add LRC at the end of the message send_buffer.Insert(0, Encoding.ASCII.GetBytes(new char[] { ASCII_START_FRAME }).First());// Insert the start frame char char[] end_frame = new char[] { ASCII_STOP_FRAME_1ST, ASCII_STOP_FRAME_2ND };// Insert stop frame chars send_buffer.AddRange(Encoding.ASCII.GetBytes(end_frame)); break; case ConnectionType.SERIAL_RTU: send_buffer.Insert(0, unit_id);// Insert 'unit_id' in front of the message send_buffer.AddRange(BitConverter.GetBytes(CRC16.CalcCRC16(send_buffer.ToArray(), 0, send_buffer.Count)));// Append CRC16 Thread.Sleep(interframe_delay);// Wait for interframe delay break; case ConnectionType.UDP_IP: case ConnectionType.TCP_IP: BuildMBAPHeader(unit_id, msg_len); break; } Send();// Send trasmission buffer receive_buffer.Clear();// Start receiving... Thread.Sleep(50);// Wait bool done = false; bool in_ric = false; Stopwatch sw = new Stopwatch(); sw.Start(); do { rcv = ReceiveByte(); if (rcv > -1) { if (!in_ric) in_ric = true; //检测是否接收到了引导字符 if (connection_type == ConnectionType.SERIAL_ASCII) { if ((byte)rcv == Encoding.ASCII.GetBytes(new char[] { ASCII_START_FRAME }).First()) receive_buffer.Clear(); } receive_buffer.Add((byte)rcv); } else if ((rcv == -1) && in_ric) done = true; tmo = sw.ElapsedMilliseconds; } while ((!done) && (rx_timeout > tmo)); sw_ch.Stop(); sw.Stop(); if (tmo >= rx_timeout) { error = Errors.RX_TIMEOUT; return; } else { int min_frame_length; switch (connection_type) { default: case ConnectionType.SERIAL_RTU: min_frame_length = 5; break; case ConnectionType.SERIAL_ASCII: min_frame_length = 11; break; case ConnectionType.UDP_IP: case ConnectionType.TCP_IP: min_frame_length = 9; break; } if (receive_buffer.Count < min_frame_length) { error = Errors.WRONG_MESSAGE_LEN; return; } switch (connection_type) { case ConnectionType.SERIAL_ASCII: // Check and remove start char if (receive_buffer[0] != send_buffer[0]) { error = Errors.START_CHAR_NOT_FOUND; return; } receive_buffer.RemoveRange(0, 1); // Check and remove stop chars char[] orig_end_frame = new char[] { ASCII_STOP_FRAME_1ST, ASCII_STOP_FRAME_2ND }; char[] rec_end_frame = Encoding.ASCII.GetChars(receive_buffer.GetRange(receive_buffer.Count - 2, 2).ToArray()); if (!orig_end_frame.SequenceEqual(rec_end_frame)) { error = Errors.END_CHARS_NOT_FOUND; break; } receive_buffer.RemoveRange(receive_buffer.Count - 2, 2); // Convert receive buffer from ASCII to binary receive_buffer = GetBinaryBufferFromASCIIBytes(receive_buffer.ToArray()).ToList(); // Check and remove message LRC byte lrc_calculated = LRC.CalcLRC(receive_buffer.ToArray(), 0, receive_buffer.Count - 1); byte lrc_received = receive_buffer[receive_buffer.Count - 1]; if (lrc_calculated != lrc_received) { error = Errors.WRONG_LRC; break; } receive_buffer.RemoveRange(receive_buffer.Count - 1, 1); // Remove address byte receive_buffer.RemoveRange(0, 1); break; case ConnectionType.SERIAL_RTU: // Check message 16-bit CRC ushort calc_crc = CRC16.CalcCRC16(receive_buffer.ToArray(), 0, receive_buffer.Count - 2); ushort rec_crc = BitConverter.ToUInt16(receive_buffer.ToArray(), receive_buffer.Count - 2); if (rec_crc != calc_crc) { error = Errors.WRONG_CRC; return; } // Check message consistency byte addr = receive_buffer[0]; if (addr != send_buffer[0]) { error = Errors.WRONG_RESPONSE_ADDRESS; return; } // Remove address receive_buffer.RemoveRange(0, 1); // Remove CRC receive_buffer.RemoveRange(receive_buffer.Count - 2, 2); break; case ConnectionType.UDP_IP: case ConnectionType.TCP_IP: // Check MBAP header ushort tid = ToUInt16(receive_buffer.ToArray(), 0); if (tid != transaction_id) { error = Errors.WRONG_TRANSACTION_ID; return; } ushort pid = ToUInt16(receive_buffer.ToArray(), 2); if (pid != PROTOCOL_ID) { error = Errors.WRONG_TRANSACTION_ID; return; } ushort len = ToUInt16(receive_buffer.ToArray(), 4); if ((receive_buffer.Count - MBAP_HEADER_LEN + 1) < len) { error = Errors.WRONG_MESSAGE_LEN; return; } byte uid = receive_buffer[6]; if (uid != send_buffer[6]) { error = Errors.WRONG_RESPONSE_UNIT_ID; return; } // Let only useful bytes in receive buffer receive_buffer.RemoveRange(0, MBAP_HEADER_LEN); break; } // Controllo eventuali messaggi di errore if (receive_buffer[0] > 0x80) { // E' stato segnalato un errore, controllo l'exception code switch (receive_buffer[1]) { case 1: error = Errors.EXCEPTION_ILLEGAL_FUNCTION; break; case 2: error = Errors.EXCEPTION_ILLEGAL_DATA_ADDRESS; break; case 3: error = Errors.EXCEPTION_ILLEGAL_DATA_VALUE; break; case 4: error = Errors.EXCEPTION_SLAVE_DEVICE_FAILURE; break; } } } } //------------------------------------------------------------------------------------------------------------------------------------------------------ //读线圈寄存器 // Read coil registers // <param name="unit_id">Slave device address</param> // <param name="start_address">Address of first register to be read</param> // <param name="len">Number of registers to be read</param> // <returns>Array of readed registers</returns> public bool[] ReadCoils(byte unit_id, ushort start_address, ushort len) { if (len < 1) { error = Errors.ZERO_REGISTERS_REQUESTED; return null; } if (len > MAX_COILS_IN_READ_MSG) { error = Errors.TOO_MANY_REGISTERS_REQUESTED; return null; } ushort msg_len = 6; InitTCPUDPMasterMessage(); send_buffer.Add((byte)ModbusCodes.READ_COILS); send_buffer.AddRange(GetBytes(start_address)); send_buffer.AddRange(GetBytes(len)); Query(unit_id, msg_len); if (error != Errors.NO_ERROR) return null; BitArray ba = new BitArray(receive_buffer.GetRange(2, receive_buffer.Count - 2).ToArray()); bool[] ret = new bool[ba.Count]; ba.CopyTo(ret, 0); return ret; } //------------------------------------------------------------------------------------------------------------------------------------------------------ // Read a set of discrete inputs // <param name="unit_id">Slave device address</param> // <param name="start_address">Address of first register to be read</param> // <param name="len">Number of registers to be read</param> // <returns>Array of readed registers</returns> public bool[] ReadDiscreteInputs(byte unit_id, ushort start_address, ushort len) { if (len < 1) { error = Errors.ZERO_REGISTERS_REQUESTED; return null; } if (len > MAX_DISCRETE_INPUTS_IN_READ_MSG) { error = Errors.TOO_MANY_REGISTERS_REQUESTED; return null; } ushort msg_len = 6; InitTCPUDPMasterMessage(); send_buffer.Add((byte)ModbusCodes.READ_DISCRETE_INPUTS); send_buffer.AddRange(GetBytes(start_address)); send_buffer.AddRange(GetBytes(len)); Query(unit_id, msg_len); if (error != Errors.NO_ERROR) return null; BitArray ba = new BitArray(receive_buffer.GetRange(2, receive_buffer.Count - 2).ToArray()); bool[] ret = new bool[ba.Count]; ba.CopyTo(ret, 0); return ret; } //------------------------------------------------------------------------------------------------------------------------------------------------------ // Read a set of holding registers // <param name="unit_id">Slave device address</param> // <param name="start_address">Address of first register to be read</param> // <param name="len">Number of registers to be read</param> // <returns>Array of readed registers</returns> public ushort[] ReadHoldingRegisters(byte unit_id, ushort start_address, ushort len) { if (len < 1) { error = Errors.ZERO_REGISTERS_REQUESTED; return null; } if (len > MAX_HOLDING_REGISTERS_IN_READ_MSG) { error = Errors.TOO_MANY_REGISTERS_REQUESTED; return null; } ushort msg_len = 6; InitTCPUDPMasterMessage(); send_buffer.Add((byte)ModbusCodes.READ_HOLDING_REGISTERS); send_buffer.AddRange(GetBytes(start_address)); send_buffer.AddRange(GetBytes(len)); Query(unit_id, msg_len); if (error != Errors.NO_ERROR) return null; List<ushort> ret = new List<ushort>(); for (int ii = 0; ii < receive_buffer[1]; ii += 2) ret.Add(ToUInt16(receive_buffer.ToArray(), ii + 2)); return ret.ToArray(); } //------------------------------------------------------------------------------------------------------------------------------------------------------ // Read a set of input registers // <param name="unit_id">Slave device address</param> // <param name="start_address">Address of first register to be read</param> // <param name="len">Number of registers to be read</param> // <returns>Array of readed registers</returns> public ushort[] ReadInputRegisters(byte unit_id, ushort start_address, ushort len) { if (len < 1) { error = Errors.ZERO_REGISTERS_REQUESTED; return null; } if (len > MAX_INPUT_REGISTERS_IN_READ_MSG) { error = Errors.TOO_MANY_REGISTERS_REQUESTED; return null; } ushort msg_len = 6; InitTCPUDPMasterMessage(); send_buffer.Add((byte)ModbusCodes.READ_INPUT_REGISTERS); send_buffer.AddRange(GetBytes(start_address)); send_buffer.AddRange(GetBytes(len)); Query(unit_id, msg_len); if (error != Errors.NO_ERROR) return null; List<ushort> ret = new List<ushort>(); for (int ii = 0; ii < receive_buffer[1]; ii += 2) ret.Add(ToUInt16(receive_buffer.ToArray(), ii + 2)); return ret.ToArray(); } //------------------------------------------------------------------------------------------------------------------------------------------------------ // Write a coil register // <param name="unit_id">Slave device address</param> // <param name="address">Register address</param> // <param name="value">Value to write</param> public void WriteSingleCoil(byte unit_id, ushort address, bool value) { ushort msg_len = 6; InitTCPUDPMasterMessage(); send_buffer.Add((byte)ModbusCodes.WRITE_SINGLE_COIL); send_buffer.AddRange(GetBytes(address)); send_buffer.AddRange(GetBytes((ushort)(value == true ? 0xFF00 : 0x0000))); Query(unit_id, msg_len); if (error == Errors.NO_ERROR) { ushort addr = ToUInt16(receive_buffer.ToArray(), 1); ushort regval = ToUInt16(receive_buffer.ToArray(), 3); if (addr != address) { error = Errors.WRONG_RESPONSE_ADDRESS; return; } if ((regval == 0xFF00) && !value) { error = Errors.WRONG_RESPONSE_VALUE; return; } } } //------------------------------------------------------------------------------------------------------------------------------------------------------ // Write an holding register // <param name="unit_id">Slave device address</param> // <param name="address">Register address</param> // <param name="value">Value to write</param> public void WriteSingleRegister(byte unit_id, ushort address, ushort value) { ushort msg_len = 6; InitTCPUDPMasterMessage(); send_buffer.Add((byte)ModbusCodes.WRITE_SINGLE_REGISTER); send_buffer.AddRange(GetBytes(address)); send_buffer.AddRange(GetBytes(value)); Query(unit_id, msg_len); if (error == Errors.NO_ERROR) { ushort addr = ToUInt16(receive_buffer.ToArray(), 1); if (addr != address) { error = Errors.WRONG_RESPONSE_ADDRESS; return; } } } //------------------------------------------------------------------------------------------------------------------------------------------------------ // Write a set of coil registers // <param name="unit_id">Slave device address</param> // <param name="start_address">Address of first register to be write</param> // <param name="values">Array of values to write</param> public void WriteMultipleCoils(byte unit_id, ushort start_address, bool[] values) { if (values == null) { error = Errors.ZERO_REGISTERS_REQUESTED; return; } if (values.Length < 1) { error = Errors.ZERO_REGISTERS_REQUESTED; return; } if (values.Length > MAX_COILS_IN_WRITE_MSG) { error = Errors.TOO_MANY_REGISTERS_REQUESTED; return; } byte byte_cnt = (byte)((values.Length / 8) + ((values.Length % 8) == 0 ? 0 : 1)); ushort msg_len = (ushort)(1 + 6 + byte_cnt); byte[] data = new byte[byte_cnt]; BitArray ba = new BitArray(values); ba.CopyTo(data, 0); InitTCPUDPMasterMessage(); send_buffer.Add((byte)ModbusCodes.WRITE_MULTIPLE_COILS); send_buffer.AddRange(GetBytes(start_address)); send_buffer.AddRange(GetBytes((ushort)values.Length)); send_buffer.Add(byte_cnt); send_buffer.AddRange(data); Query(unit_id, msg_len); if (error == Errors.NO_ERROR) { ushort sa = ToUInt16(receive_buffer.ToArray(), 1); ushort nr = ToUInt16(receive_buffer.ToArray(), 3); if (sa != start_address) { error = Errors.WRONG_RESPONSE_ADDRESS; return; } if (nr != values.Length) { error = Errors.WRONG_RESPONSE_REGISTERS; return; } } } //------------------------------------------------------------------------------------------------------------------------------------------------------ // Write a set of holding registers // <param name="unit_id">Slave device address</param> // <param name="start_address">Address of first register to be write</param> // <param name="values">Array of values to write</param> public void WriteMultipleRegisters(byte unit_id, ushort start_address, ushort[] values) { if (values == null) { error = Errors.ZERO_REGISTERS_REQUESTED; return; } if (values.Length < 1) { error = Errors.ZERO_REGISTERS_REQUESTED; return; } if (values.Length > MAX_HOLDING_REGISTERS_IN_WRITE_MSG) { error = Errors.TOO_MANY_REGISTERS_REQUESTED; return; } ushort msg_len = (ushort)(7 + (values.Length * 2)); InitTCPUDPMasterMessage(); send_buffer.Add((byte)ModbusCodes.WRITE_MULTIPLE_REGISTERS); send_buffer.AddRange(GetBytes(start_address)); send_buffer.AddRange(GetBytes((ushort)values.Length)); send_buffer.Add((byte)(values.Length * 2)); for (int ii = 0; ii < values.Length; ii++) send_buffer.AddRange(GetBytes(values[ii])); Query(unit_id, msg_len); if (error == Errors.NO_ERROR) { ushort sa = ToUInt16(receive_buffer.ToArray(), 1); ushort nr = ToUInt16(receive_buffer.ToArray(), 3); if (sa != start_address) { error = Errors.WRONG_RESPONSE_ADDRESS; return; } if (nr != values.Length) { error = Errors.WRONG_RESPONSE_REGISTERS; return; } } } //------------------------------------------------------------------------------------------------------------------------------------------------------ // Read and write a set of holding registers in a single shot // <param name="unit_id">Slave device address</param> // <param name="read_start_address">Address of first registers to be read</param> // <param name="read_len">Number of registers to be read</param> // <param name="write_start_address">Address of first registers to be write</param> // <param name="values">Array of values to be write</param> // <returns>Array of readed registers</returns> // <remarks> // Write is the first operation, than the read operation // </remarks> public ushort[] ReadWriteMultipleRegisters(byte unit_id, ushort read_start_address, ushort read_len, ushort write_start_address, ushort[] values) { if (values == null) { error = Errors.ZERO_REGISTERS_REQUESTED; return null; } if ((read_len < 1) || (values.Length < 1)) { error = Errors.ZERO_REGISTERS_REQUESTED; return null; } if ((read_len > MAX_HOLDING_REGISTERS_TO_READ_IN_READWRITE_MSG) || (values.Length > MAX_HOLDING_REGISTERS_TO_WRITE_IN_READWRITE_MSG)) { error = Errors.TOO_MANY_REGISTERS_REQUESTED; return null; } ushort msg_len = (ushort)(11 + (values.Length * 2)); InitTCPUDPMasterMessage(); send_buffer.Add((byte)ModbusCodes.READ_WRITE_MULTIPLE_REGISTERS); send_buffer.AddRange(GetBytes(read_start_address)); send_buffer.AddRange(GetBytes(read_len)); send_buffer.AddRange(GetBytes(write_start_address)); send_buffer.AddRange(GetBytes((ushort)values.Length)); send_buffer.Add((byte)(values.Length * 2)); for (int ii = 0; ii < values.Length; ii++) send_buffer.AddRange(GetBytes(values[ii])); Query(unit_id, msg_len); if (error != Errors.NO_ERROR) return null; List<ushort> ret = new List<ushort>(); for (int ii = 0; ii < receive_buffer[1]; ii += 2) ret.Add(ToUInt16(receive_buffer.ToArray(), ii + 2)); return ret.ToArray(); } #endregion } #endregion //----------------------------------------------------------------------------------------------------------------------------------------------------------- #region Modbus Master TCP Class /// Modbus Master TCP Class public class ModbusMasterTCP : ModbusMaster { string _remote_host;// Remote hostname or IP address int _port;// Remote host Modbus TCP listening port TcpClient tcpc;// TCP Client NetworkStream ns;// Network stream #region Constructor // Constructor // <param name="remote_host">Remote hostname or IP address</param> // <param name="port">Remote host Modbus TCP listening port</param> public ModbusMasterTCP(string remote_host, int port) { connection_type = ConnectionType.TCP_IP;// Set device states _remote_host = remote_host;// Set socket client _port = port; } #endregion //Connect function public override void Connect() { if (tcpc == null) tcpc = new TcpClient(); tcpc.Connect(_remote_host, _port); if (tcpc.Connected) { ns = tcpc.GetStream(); connected = true; } } // Disconnect function public override void Disconnect() { ns.Close(); tcpc.Close(); tcpc = null; connected = false; } // Send trasmission buffer protected override void Send() { ns.Write(send_buffer.ToArray(), 0, send_buffer.Count); } // Read a byte from network stream // <returns>Readed byte or <c>-1</c> if there are any bytes</returns> protected override int ReceiveByte() { if (ns.DataAvailable) return ns.ReadByte(); else return -1; } } #endregion //----------------------------------------------------------------------------------------------------------------------------------------------------------- #region Modbus Serial Master Class /// <summary> /// Modbus serial master class /// </summary> public sealed class ModbusMasterSerial : ModbusMaster { SerialPort sp;// Serial port instance long char_tmo = 3000;// Char timeout #region Constructor // Constructor // <param name="type">Type of serial protocol</param> // <param name="port">Serial port name</param> // <param name="baudrate">Baudrate</param> // <param name="databits">Data bits</param> // <param name="parity">Parity</param> // <param name="stopbits">Stop bits</param> // <param name="handshake">Handshake</param> public ModbusMasterSerial(ModbusSerialType type, string port, int baudrate, int databits, Parity parity, StopBits stopbits, Handshake handshake) { // Set device states switch (type) { case ModbusSerialType.RTU: connection_type = ConnectionType.SERIAL_RTU; break; case ModbusSerialType.ASCII: connection_type = ConnectionType.SERIAL_ASCII; break; } // Set serial port instance sp = new SerialPort(port, baudrate, parity, databits, stopbits); sp.Handshake = handshake; // Get interframe delay interframe_delay = GetInterframeDelay(sp); // Get interchar delay interchar_delay = GetIntercharDelay(sp); } #endregion //----------------------------------------------------------------------------------------------------------------------------------------------------------- // Connect function public override void Connect() { sp.Open(); if (sp.IsOpen) { sp.DiscardInBuffer(); sp.DiscardOutBuffer(); connected = true; } } //----------------------------------------------------------------------------------------------------------------------------------------------------------- // Disconnect function public override void Disconnect() { sp.Close(); connected = false; } //----------------------------------------------------------------------------------------------------------------------------------------------------------- // Send trasmission buffer protected override void Send() { sp.Write(send_buffer.ToArray(), 0, send_buffer.Count); char_tmo = 0;// Reset timeout counter } //----------------------------------------------------------------------------------------------------------------------------------------------------------- // Read a byte from stream // <returns>Readed byte or <c>-1</c> if there are any bytes</returns> protected override int ReceiveByte() { bool done = false; int ret_val; // Await 1 char... if (!sw_ch.IsRunning) sw_ch.Start(); do { if (sp.BytesToRead > 0) { ret_val = sp.ReadByte(); done = true; } else ret_val = -1; } while ((!done) && ((sw_ch.ElapsedMilliseconds - char_tmo) < interchar_delay)); if (done) char_tmo = sw_ch.ElapsedMilliseconds; // Char received with no errors...reset timeout counter for next char! return ret_val; } } #endregion //----------------------------------------------------------------------------------------------------------------------------------------------------------- #region CRC16 Class //----------------------------------------------------------------------------------------------------------------------------------------------------------- // Static class for CRC16 compute internal static class CRC16 { const ushort POLY = 0xA001;// base poly static ushort[] crc_tab16;// CRC table //----------------------------------------------------------------------------------------------------------------------------------------------------------- // Initialize CRC table static void InitCRC16Tab() { ushort crc, c; if (crc_tab16 == null) { crc_tab16 = new ushort[256]; for (int ii = 0; ii < 256; ii++) { crc = 0; c = (ushort)ii; for (int jj = 0; jj < 8; jj++) { if (((crc ^ c) & 0x0001) == 0x0001) crc = (ushort)((crc >> 1) ^ POLY); else crc = (ushort)(crc >> 1); c = (ushort)(c >> 1); } crc_tab16[ii] = crc; } } } //----------------------------------------------------------------------------------------------------------------------------------------------------------- // Update CRC value // <param name="crc">Actual CRC value</param> // <param name="bt">Data byte</param> // <returns>Computed CRC</returns> static ushort UpdateCRC16(ushort crc, byte bt) { ushort tmp, ushort_bt; ushort_bt = (ushort)(0x00FF & (ushort)bt); InitCRC16Tab(); tmp = (ushort)(crc ^ ushort_bt); crc = (ushort)((crc >> 8) ^ crc_tab16[tmp & 0xff]); return crc; } //----------------------------------------------------------------------------------------------------------------------------------------------------------- // Calc buffer CRC16 // <param name="buffer">Data Buffer</param> // <param name="offset">Buffer offset</param> // <param name="length">Data length</param> // <returns>Computed CRC</returns> public static ushort CalcCRC16(byte[] buffer, int offset, int length) { ushort crc = 0xFFFF; for (int ii = 0; ii < length; ii++) crc = UpdateCRC16(crc, buffer[offset + ii]); return crc; } } #endregion //----------------------------------------------------------------------------------------------------------------------------------------------------------- #region LRC Class // LRC Class internal static class LRC { // Compute Buffer LRC // <param name="buffer">Data buffer</param> // <param name="offset">Buffer offset</param> // <param name="lenght">Data length</param> // <returns>Computed LRC</returns> public static byte CalcLRC(byte[] buffer, int offset, int lenght) { byte lrc = 0; for (int ii = 0; ii < lenght; ii++) lrc += buffer[ii + offset]; return (byte)(-(sbyte)lrc); } } #endregion } 结合这段代码分析一下
最新发布
08-10
这个库支持多种Modbus连接方式（RTU、ASCII、TCP、UDP）并实现了主站（Master）功能。代码结构清晰，分为以下几个主要部分： 1. **枚举定义**：定义了连接类型、设备类型、Modbus功能表、功能码、错误码等。 2. **...
D:\software\develop\java\jdk-1.8\jdk-1.8\bin\java.exe "-javaagent:D:\software\develop\ideal\IntelliJ IDEA 2022.1.3\lib\idea_rt.jar=61865:D:\software\develop\ideal\IntelliJ IDEA 2022.1.3\bin" -Dfile.encoding=UTF-8 -classpath D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\charsets.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\deploy.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\ext\access-bridge-64.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\ext\cldrdata.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\ext\dnsns.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\ext\jaccess.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\ext\jfxrt.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\ext\localedata.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\ext\nashorn.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\ext\sunec.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\ext\sunjce_provider.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\ext\sunmscapi.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\ext\sunpkcs11.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\ext\zipfs.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\javaws.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\jce.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\jfr.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\jfxswt.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\jsse.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\management-agent.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\plugin.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\resources.jar;D:\software\develop\java\jdk-1.8\jdk-1.8\jre\lib\rt.jar;D:\workspace\UserBehaviorAnalysis\HotItemsAnalysis\target\classes;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-table-planner-blink_2.12\1.10.1\flink-table-planner-blink_2.12-1.10.1.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-table-common\1.10.1\flink-table-common-1.10.1.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-table-api-java\1.10.1\flink-table-api-java-1.10.1.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-table-api-scala_2.12\1.10.1\flink-table-api-scala_2.12-1.10.1.jar;D:\software\develop\Apache\maven-repository\org\scala-lang\scala-compiler\2.12.7\scala-compiler-2.12.7.jar;D:\software\develop\Apache\maven-repository\org\scala-lang\modules\scala-xml_2.12\1.0.6\scala-xml_2.12-1.0.6.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-table-api-java-bridge_2.12\1.10.1\flink-table-api-java-bridge_2.12-1.10.1.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-table-api-scala-bridge_2.12\1.10.1\flink-table-api-scala-bridge_2.12-1.10.1.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-scala_2.12\1.10.1\flink-scala_2.12-1.10.1.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-streaming-scala_2.12\1.10.1\flink-streaming-scala_2.12-1.10.1.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-table-runtime-blink_2.12\1.10.1\flink-table-runtime-blink_2.12-1.10.1.jar;D:\software\develop\Apache\maven-repository\org\codehaus\janino\janino\3.0.9\janino-3.0.9.jar;D:\software\develop\Apache\maven-repository\org\codehaus\janino\commons-compiler\3.0.9\commons-compiler-3.0.9.jar;D:\software\develop\Apache\maven-repository\org\apache\calcite\avatica\avatica-core\1.15.0\avatica-core-1.15.0.jar;D:\software\develop\Apache\maven-repository\org\reflections\reflections\0.9.10\reflections-0.9.10.jar;D:\software\develop\Apache\maven-repository\org\javassist\javassist\3.19.0-GA\javassist-3.19.0-GA.jar;D:\software\develop\Apache\maven-repository\org\slf4j\slf4j-api\1.7.15\slf4j-api-1.7.15.jar;D:\software\develop\Apache\maven-repository\com\google\code\findbugs\jsr305\1.3.9\jsr305-1.3.9.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\force-shading\1.10.1\force-shading-1.10.1.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-java\1.10.1\flink-java-1.10.1.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-core\1.10.1\flink-core-1.10.1.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-annotations\1.10.1\flink-annotations-1.10.1.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-metrics-core\1.10.1\flink-metrics-core-1.10.1.jar;D:\software\develop\Apache\maven-repository\com\esotericsoftware\kryo\kryo\2.24.0\kryo-2.24.0.jar;D:\software\develop\Apache\maven-repository\com\esotericsoftware\minlog\minlog\1.2\minlog-1.2.jar;D:\software\develop\Apache\maven-repository\org\objenesis\objenesis\2.1\objenesis-2.1.jar;D:\software\develop\Apache\maven-repository\commons-collections\commons-collections\3.2.2\commons-collections-3.2.2.jar;D:\software\develop\Apache\maven-repository\org\apache\commons\commons-compress\1.18\commons-compress-1.18.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-shaded-asm-7\7.1-9.0\flink-shaded-asm-7-7.1-9.0.jar;D:\software\develop\Apache\maven-repository\org\apache\commons\commons-lang3\3.3.2\commons-lang3-3.3.2.jar;D:\software\develop\Apache\maven-repository\org\apache\commons\commons-math3\3.5\commons-math3-3.5.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-streaming-java_2.12\1.10.1\flink-streaming-java_2.12-1.10.1.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-runtime_2.12\1.10.1\flink-runtime_2.12-1.10.1.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-queryable-state-client-java\1.10.1\flink-queryable-state-client-java-1.10.1.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-hadoop-fs\1.10.1\flink-hadoop-fs-1.10.1.jar;D:\software\develop\Apache\maven-repository\commons-io\commons-io\2.4\commons-io-2.4.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-shaded-netty\4.1.39.Final-9.0\flink-shaded-netty-4.1.39.Final-9.0.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-shaded-jackson\2.10.1-9.0\flink-shaded-jackson-2.10.1-9.0.jar;D:\software\develop\Apache\maven-repository\commons-cli\commons-cli\1.3.1\commons-cli-1.3.1.jar;D:\software\develop\Apache\maven-repository\com\typesafe\akka\akka-actor_2.12\2.5.21\akka-actor_2.12-2.5.21.jar;D:\software\develop\Apache\maven-repository\com\typesafe\config\1.3.3\config-1.3.3.jar;D:\software\develop\Apache\maven-repository\org\scala-lang\modules\scala-java8-compat_2.12\0.8.0\scala-java8-compat_2.12-0.8.0.jar;D:\software\develop\Apache\maven-repository\com\typesafe\akka\akka-stream_2.12\2.5.21\akka-stream_2.12-2.5.21.jar;D:\software\develop\Apache\maven-repository\org\reactivestreams\reactive-streams\1.0.2\reactive-streams-1.0.2.jar;D:\software\develop\Apache\maven-repository\com\typesafe\ssl-config-core_2.12\0.3.7\ssl-config-core_2.12-0.3.7.jar;D:\software\develop\Apache\maven-repository\org\scala-lang\modules\scala-parser-combinators_2.12\1.1.1\scala-parser-combinators_2.12-1.1.1.jar;D:\software\develop\Apache\maven-repository\com\typesafe\akka\akka-protobuf_2.12\2.5.21\akka-protobuf_2.12-2.5.21.jar;D:\software\develop\Apache\maven-repository\com\typesafe\akka\akka-slf4j_2.12\2.5.21\akka-slf4j_2.12-2.5.21.jar;D:\software\develop\Apache\maven-repository\org\clapper\grizzled-slf4j_2.12\1.3.2\grizzled-slf4j_2.12-1.3.2.jar;D:\software\develop\Apache\maven-repository\com\github\scopt\scopt_2.12\3.5.0\scopt_2.12-3.5.0.jar;D:\software\develop\Apache\maven-repository\org\xerial\snappy\snappy-java\1.1.4\snappy-java-1.1.4.jar;D:\software\develop\Apache\maven-repository\com\twitter\chill_2.12\0.7.6\chill_2.12-0.7.6.jar;D:\software\develop\Apache\maven-repository\com\twitter\chill-java\0.7.6\chill-java-0.7.6.jar;D:\software\develop\Apache\maven-repository\org\lz4\lz4-java\1.5.0\lz4-java-1.5.0.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-clients_2.12\1.10.1\flink-clients_2.12-1.10.1.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-optimizer_2.12\1.10.1\flink-optimizer_2.12-1.10.1.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-shaded-guava\18.0-9.0\flink-shaded-guava-18.0-9.0.jar;D:\software\develop\Apache\maven-repository\org\apache\kafka\kafka_2.12\2.2.0\kafka_2.12-2.2.0.jar;D:\software\develop\Apache\maven-repository\org\apache\kafka\kafka-clients\2.2.0\kafka-clients-2.2.0.jar;D:\software\develop\Apache\maven-repository\com\github\luben\zstd-jni\1.3.8-1\zstd-jni-1.3.8-1.jar;D:\software\develop\Apache\maven-repository\com\fasterxml\jackson\core\jackson-databind\2.9.8\jackson-databind-2.9.8.jar;D:\software\develop\Apache\maven-repository\com\fasterxml\jackson\core\jackson-annotations\2.9.0\jackson-annotations-2.9.0.jar;D:\software\develop\Apache\maven-repository\com\fasterxml\jackson\core\jackson-core\2.9.8\jackson-core-2.9.8.jar;D:\software\develop\Apache\maven-repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.9.8\jackson-datatype-jdk8-2.9.8.jar;D:\software\develop\Apache\maven-repository\net\sf\jopt-simple\jopt-simple\5.0.4\jopt-simple-5.0.4.jar;D:\software\develop\Apache\maven-repository\com\yammer\metrics\metrics-core\2.2.0\metrics-core-2.2.0.jar;D:\software\develop\Apache\maven-repository\org\scala-lang\scala-library\2.12.8\scala-library-2.12.8.jar;D:\software\develop\Apache\maven-repository\org\scala-lang\scala-reflect\2.12.8\scala-reflect-2.12.8.jar;D:\software\develop\Apache\maven-repository\com\typesafe\scala-logging\scala-logging_2.12\3.9.0\scala-logging_2.12-3.9.0.jar;D:\software\develop\Apache\maven-repository\com\101tec\zkclient\0.11\zkclient-0.11.jar;D:\software\develop\Apache\maven-repository\org\apache\zookeeper\zookeeper\3.4.13\zookeeper-3.4.13.jar;D:\software\develop\Apache\maven-repository\org\apache\yetus\audience-annotations\0.5.0\audience-annotations-0.5.0.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-connector-kafka_2.12\1.10.1\flink-connector-kafka_2.12-1.10.1.jar;D:\software\develop\Apache\maven-repository\org\apache\flink\flink-connector-kafka-base_2.12\1.10.1\flink-connector-kafka-base_2.12-1.10.1.jar com.atguigu.hotitems_analysis.HotItems SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder". SLF4J: Defaulting to no-operation (NOP) logger implementation SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details. Exception in thread "main" java.util.concurrent.ExecutionException: org.apache.flink.runtime.client.JobExecutionException: Job execution failed. at java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:357) at java.util.concurrent.CompletableFuture.get(CompletableFuture.java:1908) at org.apache.flink.streaming.api.environment.StreamExecutionEnvironment.execute(StreamExecutionEnvironment.java:1640) at org.apache.flink.streaming.api.environment.LocalStreamEnvironment.execute(LocalStreamEnvironment.java:74) at org.apache.flink.streaming.api.environment.StreamExecutionEnvironment.execute(StreamExecutionEnvironment.java:1620) at com.atguigu.hotitems_analysis.HotItems.main(HotItems.java:89) Caused by: org.apache.flink.runtime.client.JobExecutionException: Job execution failed. at org.apache.flink.runtime.jobmaster.JobResult.toJobExecutionResult(JobResult.java:147) at org.apache.flink.client.program.PerJobMiniClusterFactory$PerJobMiniClusterJobClient.lambda$getJobExecutionResult$2(PerJobMiniClusterFactory.java:175) at java.util.concurrent.CompletableFuture.uniApply(CompletableFuture.java:616) at java.util.concurrent.CompletableFuture$UniApply.tryFire(CompletableFuture.java:591) at java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:488) at java.util.concurrent.CompletableFuture.complete(CompletableFuture.java:1975) at org.apache.flink.runtime.concurrent.FutureUtils$1.onComplete(FutureUtils.java:874) at akka.dispatch.OnComplete.internal(Future.scala:264) at akka.dispatch.OnComplete.internal(Future.scala:261) at akka.dispatch.japi$CallbackBridge.apply(Future.scala:191) at akka.dispatch.japi$CallbackBridge.apply(Future.scala:188) at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:64) at org.apache.flink.runtime.concurrent.Executors$DirectExecutionContext.execute(Executors.java:74) at scala.concurrent.impl.CallbackRunnable.executeWithValue(Promise.scala:72) at scala.concurrent.impl.Promise$DefaultPromise.$anonfun$tryComplete$1(Promise.scala:288) at scala.concurrent.impl.Promise$DefaultPromise.$anonfun$tryComplete$1$adapted(Promise.scala:288) at scala.concurrent.impl.Promise$DefaultPromise.tryComplete(Promise.scala:288) at akka.pattern.PromiseActorRef.$bang(AskSupport.scala:573) at akka.pattern.PipeToSupport$PipeableFuture$$anonfun$pipeTo$1.applyOrElse(PipeToSupport.scala:22) at akka.pattern.PipeToSupport$PipeableFuture$$anonfun$pipeTo$1.applyOrElse(PipeToSupport.scala:21) at scala.concurrent.Future.$anonfun$andThen$1(Future.scala:536) at scala.concurrent.impl.Promise.liftedTree1$1(Promise.scala:33) at scala.concurrent.impl.Promise.$anonfun$transform$1(Promise.scala:33) at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:64) at akka.dispatch.BatchingExecutor$AbstractBatch.processBatch(BatchingExecutor.scala:55) at akka.dispatch.BatchingExecutor$BlockableBatch.$anonfun$run$1(BatchingExecutor.scala:91) at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23) at scala.concurrent.BlockContext$.withBlockContext(BlockContext.scala:85) at akka.dispatch.BatchingExecutor$BlockableBatch.run(BatchingExecutor.scala:91) at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:40) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(ForkJoinExecutorConfigurator.scala:44) at akka.dispatch.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) at akka.dispatch.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) at akka.dispatch.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) at akka.dispatch.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) Caused by: org.apache.flink.runtime.JobException: Recovery is suppressed by NoRestartBackoffTimeStrategy at org.apache.flink.runtime.executiongraph.failover.flip1.ExecutionFailureHandler.handleFailure(ExecutionFailureHandler.java:110) at org.apache.flink.runtime.executiongraph.failover.flip1.ExecutionFailureHandler.getFailureHandlingResult(ExecutionFailureHandler.java:76) at org.apache.flink.runtime.scheduler.DefaultScheduler.handleTaskFailure(DefaultScheduler.java:192) at org.apache.flink.runtime.scheduler.DefaultScheduler.maybeHandleTaskFailure(DefaultScheduler.java:186) at org.apache.flink.runtime.scheduler.DefaultScheduler.updateTaskExecutionStateInternal(DefaultScheduler.java:180) at org.apache.flink.runtime.scheduler.SchedulerBase.updateTaskExecutionState(SchedulerBase.java:496) at org.apache.flink.runtime.jobmaster.JobMaster.updateTaskExecutionState(JobMaster.java:380) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.flink.runtime.rpc.akka.AkkaRpcActor.handleRpcInvocation(AkkaRpcActor.java:284) at org.apache.flink.runtime.rpc.akka.AkkaRpcActor.handleRpcMessage(AkkaRpcActor.java:199) at org.apache.flink.runtime.rpc.akka.FencedAkkaRpcActor.handleRpcMessage(FencedAkkaRpcActor.java:74) at org.apache.flink.runtime.rpc.akka.AkkaRpcActor.handleMessage(AkkaRpcActor.java:152) at akka.japi.pf.UnitCaseStatement.apply(CaseStatements.scala:26) at akka.japi.pf.UnitCaseStatement.apply(CaseStatements.scala:21) at scala.PartialFunction.applyOrElse(PartialFunction.scala:127) at scala.PartialFunction.applyOrElse$(PartialFunction.scala:126) at akka.japi.pf.UnitCaseStatement.applyOrElse(CaseStatements.scala:21) at scala.PartialFunction$OrElse.applyOrElse(PartialFunction.scala:175) at scala.PartialFunction$OrElse.applyOrElse(PartialFunction.scala:176) at scala.PartialFunction$OrElse.applyOrElse(PartialFunction.scala:176) at akka.actor.Actor.aroundReceive(Actor.scala:517) at akka.actor.Actor.aroundReceive$(Actor.scala:515) at akka.actor.AbstractActor.aroundReceive(AbstractActor.scala:225) at akka.actor.ActorCell.receiveMessage(ActorCell.scala:592) at akka.actor.ActorCell.invoke(ActorCell.scala:561) at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:258) at akka.dispatch.Mailbox.run(Mailbox.scala:225) at akka.dispatch.Mailbox.exec(Mailbox.scala:235) ... 4 more Caused by: java.lang.IllegalStateException: No entry found for connection 3 at org.apache.kafka.clients.ClusterConnectionStates.nodeState(ClusterConnectionStates.java:339) at org.apache.kafka.clients.ClusterConnectionStates.disconnected(ClusterConnectionStates.java:143) at org.apache.kafka.clients.NetworkClient.initiateConnect(NetworkClient.java:926) at org.apache.kafka.clients.NetworkClient.ready(NetworkClient.java:287) at org.apache.kafka.clients.consumer.internals.ConsumerNetworkClient.trySend(ConsumerNetworkClient.java:474) at org.apache.kafka.clients.consumer.internals.ConsumerNetworkClient.poll(ConsumerNetworkClient.java:255) at org.apache.kafka.clients.consumer.internals.ConsumerNetworkClient.poll(ConsumerNetworkClient.java:236) at org.apache.kafka.clients.consumer.internals.ConsumerNetworkClient.poll(ConsumerNetworkClient.java:215) at org.apache.kafka.clients.consumer.internals.Fetcher.getTopicMetadata(Fetcher.java:292) at org.apache.kafka.clients.consumer.KafkaConsumer.partitionsFor(KafkaConsumer.java:1803) at org.apache.kafka.clients.consumer.KafkaConsumer.partitionsFor(KafkaConsumer.java:1771) at org.apache.flink.streaming.connectors.kafka.internal.KafkaPartitionDiscoverer.getAllPartitionsForTopics(KafkaPartitionDiscoverer.java:77) at org.apache.flink.streaming.connectors.kafka.internals.AbstractPartitionDiscoverer.discoverPartitions(AbstractPartitionDiscoverer.java:131) at org.apache.flink.streaming.connectors.kafka.FlinkKafkaConsumerBase.open(FlinkKafkaConsumerBase.java:511) at org.apache.flink.api.common.functions.util.FunctionUtils.openFunction(FunctionUtils.java:36) at org.apache.flink.streaming.api.operators.AbstractUdfStreamOperator.open(AbstractUdfStreamOperator.java:102) at org.apache.flink.streaming.runtime.tasks.StreamTask.initializeStateAndOpen(StreamTask.java:990) at org.apache.flink.streaming.runtime.tasks.StreamTask.lambda$beforeInvoke$0(StreamTask.java:453) at org.apache.flink.streaming.runtime.tasks.StreamTaskActionExecutor$SynchronizedStreamTaskActionExecutor.runThrowing(StreamTaskActionExecutor.java:94) at org.apache.flink.streaming.runtime.tasks.StreamTask.beforeInvoke(StreamTask.java:448) at org.apache.flink.streaming.runtime.tasks.StreamTask.invoke(StreamTask.java:460) at org.apache.flink.runtime.taskmanager.Task.doRun(Task.java:708) at org.apache.flink.runtime.taskmanager.Task.run(Task.java:533) at java.lang.Thread.run(Thread.java:750) Process finished with exit code 1
06-23
| `No entry for connection` | 网络闪断/Kafka连接池管理异常 | ⭐⭐ | | `TimeoutException` | `advertised.listeners` 配置错误 | ⭐⭐⭐⭐ | | | 防火墙/端口阻塞 | ⭐⭐⭐ | | | DNS解析失败 | ⭐⭐ | > 统计...
SQLSERVER中的sp_reset_connection存储过程的作用
dingshen2767的博客
11-28 1014
SQLSERVER中的sp_reset_connection存储过程的作用 经常有人在论坛提问为什麽在使用SQL Trace的时候会看到大量的sp_reset_connection存储过程的执行 究竟sp_reset_connection存储过程有什么用？ 网上的资料很少 下面说一下这个存储过程是干嘛的 在介绍之前先说一下连接池和事务和阻塞，因为这个存储过程跟连接池、事务和阻塞...
Ado.net连接池 sp_reset_connection 概念
weixin_30602505的博客
05-26 183
什么是连接池？ 正常情况下，每次访问数据库都会打开和关闭，中断物理连接后需要再次进行物理连接。这样操作会浪费资源 使用连接池，主要的区别在于，不需要中断物理连接，即每次中断请求时spid还是存在！ 原理：不物理中断连接如何清理连接信息? 连接池会将上次使用的资源，通过回收机制进行连接信息清理的。 例如：当Ado.net中调用了Connection.Close()时，SQ...
ADO.NET连接池机制
a594455873的专栏
04-19 213
为什么需要连接池 剖析一个技术第一个要问的是，这项技术为什么存在。 对于每一个到SQL Server的连接，都需要经历TCP/IP协议的三次握手，身份认证，在SQL Server里建立连接，分配资源等。而当客户端关闭连接时，客户端就会和SQL Server终止物理连接。但是，我们做过数据库开发的人都知道，每次操作完后关闭连接是再正常不过的事了，一个应用程序...
SQLServer中的系统表,存储过程和函数的功能及应用
weixin_33672109的博客
06-08 230
SQLServer中的系统表,存储过程和函数的功能及应用 2009-05-31 15:17 sp_detach_db sp_setnetnamesp_dropdevice sp_settriggerordersp_dropextendedproc   sp_spaceusedsp_dropextendedproperty sp_tableoptionsp_dropmessage s...
非常老的话题 SQLSERVER连接池
mituan1234567的专栏
08-15 753
http://www.cnblogs.com/lyhabc/articles/2797351.html 写这篇文章不是说要炒冷饭，因为园子里有非常非常多关于SQLSERVER连接池的文章，但是他们说的都是引用MSDN里的解释 或者自己做一些测试试验一下连接池的性能。但是对于SQLSERVER连接池的内部机制，好像都没有非常清晰地说清楚。   连接池的作用就不说了，在园子
SQLServer-Report Server数据库
jingemperor的博客
09-14 2367
SQLServer-Report Server数据库 Report Server数据库： 是一个SQL Server数据库。它能够存储SSRS配置部分，报告定义，报告元数据，报告历史，缓存政策，快照，资源，安全设置，加密的数据，调度和提交数据，以及扩展信息。 注意事项：尽管用户能够直接存取在SSRS目录下的e799bee5baa6e4b893e5b19e31333431336131数据库并且能够直接修改SSRS使用的对象；但在实践中，不推荐（或不支持)这样做，因为在SSRS目录下的内在数据和结构不能被保证与
SQLServer查看及设置最大连接数
热门推荐
duanbeibei的专栏
01-21 2万+
1. 查询最大连接数 SELECT value_in_use FROM sys.configurations c WHERE c.name = 'user connections'; 默认值为：0，即无限制。 2. 查询当前连接数 select count(distinct(login_time)) from sys.sysprocesses 3. 设置最大连接数 exec sp_conf...
30分钟全面解析-SQL事务+隔离级别+阻塞+死锁
weixin_34347651的博客
07-05 255
以前总是追求新东西，发现基础才是最重要的，今年主要的目标是精通SQL查询和SQL性能优化。 本系列主要是针对T-SQL的总结。 【T-SQL基础】01.单表查询-几道sql查询题 【T-SQL基础】02.联接查询 【T-SQL基础】03.子查询 【T-SQL基础】04.表表达式-上篇 【T-SQL基础】04.表表达式-下篇 【T-SQL基础】05.集合运算 【T-SQL基础...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值