/// <summary>
/// Instantiate a Table by directly deserializing byte data from the given Deserializer.
/// </summary>
/// <param name="input">The Deserializer providing the data for the table.</param>
internal SingleRowTable(Deserializer input)
: base(input)
{
// Validate row count.
if (this.RowCount > 1)
{
throw new VoltInvalidDataException(Resources.InvalidRowCount, this.RowCount);
}
else if (this.RowCount == 0)
{
return;
}
// Total byte length of the row (ignored).
int rowLength = input.ReadInt32();
// Read data and push in storage.
for (short c = 0; c < this.ColumnCount; c++)
{
switch (ColumnType[c])
{
case DBType.TINYINT:
Column.SetValue(input.ReadSByteN(), c);
break;
case DBType.SMALLINT:
Column.SetValue(input.ReadInt16N(), c);
break;
case DBType.INTEGER:
Column.SetValue(input.ReadInt32N(), c);
break;
case DBType.BIGINT:
Column.SetValue(input.ReadInt64N(), c);
break;
case DBType.FLOAT:
Column.SetValue(input.ReadDoubleN(), c);
break;
case DBType.DECIMAL:
Column.SetValue(input.ReadVoltDecimalN(), c);
break;
case DBType.TIMESTAMP:
Column.SetValue(input.ReadDateTimeN(), c);
break;
case DBType.VARBINARY:
Column.SetValue(input.ReadByteArray(), c);
break;
default:
Column.SetValue(input.ReadString(), c);
break;
}
}
}
/// <summary>
/// Instantiate a Table by directly deserializing byte data from the given Deserializer.
/// </summary>
/// <param name="input">The Deserializer providing the data for the table.</param>
internal SingleRowTable(Deserializer input)
: base(input)
{
// Validate row count.
if (this.RowCount > 1)
throw new VoltInvalidDataException(Resources.InvalidRowCount, this.RowCount);
else if (this.RowCount == 0)
return;
// Total byte length of the row (ignored).
int rowLength = input.ReadInt32();
// Read data and push in storage.
for (short c = 0; c < this.ColumnCount; c++)
{
switch (ColumnType[c])
{
case DBType.TINYINT:
Column.SetValue(input.ReadSByteN(), c);
break;
case DBType.SMALLINT:
Column.SetValue(input.ReadInt16N(), c);
break;
case DBType.INTEGER:
Column.SetValue(input.ReadInt32N(), c);
break;
case DBType.BIGINT:
Column.SetValue(input.ReadInt64N(), c);
break;
case DBType.FLOAT:
Column.SetValue(input.ReadDoubleN(), c);
break;
case DBType.DECIMAL:
Column.SetValue(input.ReadVoltDecimalN(), c);
break;
case DBType.TIMESTAMP:
Column.SetValue(input.ReadDateTimeN(), c);
break;
case DBType.VARBINARY:
Column.SetValue(input.ReadByteArray(), c);
break;
default:
Column.SetValue(input.ReadString(), c);
break;
}
}
}
/// <summary>
/// Parses the returned server message to read properties.
/// </summary>
/// <param name="input">The deserializer holding the data form the server message.</param>
internal void ParseHeader(Deserializer input)
{
try
{
// Skip the client executionId: the caller (background network thread) already verified a match and
// we recorded it at the start.
input.Skip(8);
// Check field map for status header parsing.
this._HasFields = (HasFields)input.ReadByte();
// Read the Status (and optional associated message).
this.ServerStatus = (ResponseServerStatus)input.ReadSByte();
if ((this._HasFields & HasFields.Status) == HasFields.Status)
this.ServerStatusString = input.ReadString();
// Read the Application Status (and optional associated message).
this.ServerApplicationStatus = input.ReadSByte();
if ((this._HasFields & HasFields.ApplicationStatus) == HasFields.ApplicationStatus)
this.ServerApplicationStatusString = input.ReadString();
// Track query duration (ms).
this.ExecutionDuration = input.ReadInt32();
// Skip exception data (currently not used and initialized to the same value as the Status string!).
if ((this._HasFields & HasFields.Exception) == HasFields.Exception)
//this.ServerExceptionString = input.ReadString();
input.SkipString();
// Figure out whether to move forward or kill over - note that we don't *really* kill over, but simply
// report the Exception in the response's Exception field - the caller should validate that the
// response is in good status before proceeding to read the results.
switch (this.ServerStatus)
{
case ResponseServerStatus.Success:
break;
case ResponseServerStatus.UserAbort:
this.Exception = new VoltAbortException(
Resources.RequestAborted
, this.Status
, this.ServerStatusString
);
break;
case ResponseServerStatus.GracefulFailure:
this.Exception = new VoltRequestFailureException(
Resources.RequestFailure
, this.Status
, this.ServerStatusString
);
break;
case ResponseServerStatus.UnexpectedFailure:
this.Exception = new VoltCriticalRequestFailureException(
Resources.RequestFailure
, this.Status
, this.ServerStatusString
);
break;
default:
this.Exception = new VoltCriticalRequestFailureException(
Resources.ServerFailure
, this.Status
, this.ServerStatusString
);
break;
}
}
catch (Exception x)
{
this.Exception = new VoltSerializationException(Resources.ResponseDeserializationFailure, x);
}
}
/// <summary>
/// Instantiate a Table by directly deserializing byte data from the given Deserializer.
/// </summary>
/// <param name="input">The Deserializer providing the data for the table.</param>
internal Table(Deserializer input)
: base(input)
{
// Allocate column-based data storage.
for (short c = 0; c < this.ColumnCount; c++)
{
switch (ColumnType[c])
{
case DBType.TINYINT:
Column[c] = new sbyte?[this.RowCount];
break;
case DBType.SMALLINT:
Column[c] = new short?[this.RowCount];
break;
case DBType.INTEGER:
Column[c] = new int?[this.RowCount];
break;
case DBType.BIGINT:
Column[c] = new long?[this.RowCount];
break;
case DBType.FLOAT:
Column[c] = new double?[this.RowCount];
break;
case DBType.DECIMAL:
Column[c] = new VoltDecimal?[this.RowCount];
break;
case DBType.TIMESTAMP:
Column[c] = new DateTime?[this.RowCount];
break;
case DBType.STRING:
Column[c] = new string[this.RowCount];
break;
case DBType.VARBINARY:
Column[c] = new byte[this.RowCount][];
break;
default:
throw new VoltUnsupportedTypeException(Resources.UnsupportedDBType, ColumnType[c]);
}
}
// Get data and push to storage.
for (int r = 0; r < this.RowCount; r++)
{
// Total byte length of the row (ignored).
input.Skip(4);
// Read data and push in storage.
for (short c = 0; c < this.ColumnCount; c++)
{
switch (ColumnType[c])
{
case DBType.TINYINT:
(Column[c] as sbyte?[])[r] = input.ReadSByteN();
break;
case DBType.SMALLINT:
(Column[c] as short?[])[r] = input.ReadInt16N();
break;
case DBType.INTEGER:
(Column[c] as int?[])[r] = input.ReadInt32N();
break;
case DBType.BIGINT:
(Column[c] as long?[])[r] = input.ReadInt64N();
break;
case DBType.FLOAT:
(Column[c] as double?[])[r] = input.ReadDoubleN();
break;
case DBType.DECIMAL:
(Column[c] as VoltDecimal?[])[r] = input.ReadVoltDecimalN();
break;
case DBType.TIMESTAMP:
(Column[c] as DateTime?[])[r] = input.ReadDateTimeN();
break;
case DBType.VARBINARY:
(Column[c] as byte[][])[r] = input.ReadByteArray();
break;
default:
(Column[c] as string[])[r] = input.ReadString();
break;
}
}
}
// Attach the enumerable row collection.
this._Rows = new RowCollection(this);
}
/// <summary>
/// Parses the returned server message to read properties.
/// </summary>
/// <param name="input">The deserializer holding the data form the server message.</param>
internal void ParseHeader(Deserializer input)
{
try
{
// Skip the client executionId: the caller (background network thread) already verified a match and
// we recorded it at the start.
input.Skip(8);
// Check field map for status header parsing.
this._HasFields = (HasFields)input.ReadByte();
// Read the Status (and optional associated message).
this.ServerStatus = (ResponseServerStatus)input.ReadSByte();
if ((this._HasFields & HasFields.Status) == HasFields.Status)
{
this.ServerStatusString = input.ReadString();
}
// Read the Application Status (and optional associated message).
this.ServerApplicationStatus = input.ReadSByte();
if ((this._HasFields & HasFields.ApplicationStatus) == HasFields.ApplicationStatus)
{
this.ServerApplicationStatusString = input.ReadString();
}
// Track query duration (ms).
this.ExecutionDuration = input.ReadInt32();
// Skip exception data (currently not used and initialized to the same value as the Status string!).
if ((this._HasFields & HasFields.Exception) == HasFields.Exception)
{
//this.ServerExceptionString = input.ReadString();
input.SkipString();
}
// Figure out whether to move forward or kill over - note that we don't *really* kill over, but simply
// report the Exception in the response's Exception field - the caller should validate that the
// response is in good status before proceeding to read the results.
switch (this.ServerStatus)
{
case ResponseServerStatus.Success:
break;
case ResponseServerStatus.UserAbort:
this.Exception = new VoltAbortException(
Resources.RequestAborted
, this.Status
, this.ServerStatusString
);
break;
case ResponseServerStatus.GracefulFailure:
this.Exception = new VoltRequestFailureException(
Resources.RequestFailure
, this.Status
, this.ServerStatusString
);
break;
case ResponseServerStatus.UnexpectedFailure:
this.Exception = new VoltCriticalRequestFailureException(
Resources.RequestFailure
, this.Status
, this.ServerStatusString
);
break;
default:
this.Exception = new VoltCriticalRequestFailureException(
Resources.ServerFailure
, this.Status
, this.ServerStatusString
);
break;
}
}
catch (Exception x)
{
this.Exception = new VoltSerializationException(Resources.ResponseDeserializationFailure, x);
}
}
/// <summary>
/// Open the connection.
/// </summary>
/// <returns>A reference to the current connection instance for action chaining.</returns>
public override VoltConnection Open()
{
// Synchronize access.
lock (this.SyncRoot)
{
// Validate connection status.
if (this.Status != ConnectionStatus.Closed)
{
throw new InvalidOperationException(string.Format(Resources.InvalidConnectionStatus, this.Status));
}
// Set status to "connecting".
this.Status = ConnectionStatus.Connecting;
// Connect to the default endpoint (there should only be one anyways if this is a managed pool
// connection, otherwise, you're on your own - this is a connection, not a Pool!).
IPEndPoint endPoint = this.Settings.DefaultIPEndPoint;
try
{
// Create new socket stream and wrap a core protocol stream manager around it.
this.BaseStream = new VoltProtocolStream(endPoint, this.Settings.ConnectionTimeout);
// Now send login message.
using (Serializer serializer = new Serializer())
{
var msg = serializer
.Write(this.Settings.ServiceType.ToString().ToLowerInvariant())
.Write(this.Settings.UserID)
.WriteRaw(SHA1.Create().ComputeHash(Encoding.UTF8.GetBytes(this.Settings.Password)))
.GetBytes();
this.BaseStream.WriteMessage(msg.Array, msg.Offset, msg.Count);
}
// Receive and process login response message.
var deserializer = new Deserializer(this.BaseStream.ReadMessage());
LoginResponseStatus status = (LoginResponseStatus)deserializer.ReadSByte();
if (status != LoginResponseStatus.Connected)
{
// Re-package server response in an appropriate exception.
switch (status)
{
case LoginResponseStatus.ConnectionHandshakeTimeout:
throw new VoltConnectionException(
Resources.LRS_ConnectionHandshakeTimeout
, endPoint
, status
);
case LoginResponseStatus.CorruptedHandshake:
throw new VoltConnectionException(
Resources.LRS_CorruptedHandshake
, endPoint
, status
);
case LoginResponseStatus.InvalidCredentials:
throw new VoltPermissionException(
Resources.LRS_InvalidCredentials
, endPoint
, status
);
case LoginResponseStatus.ServerTooBusy:
throw new VoltConnectionException(
Resources.LRS_ServerTooBusy
, endPoint
, status
);
default:
throw new VoltConnectionException(Resources.LRS_Unknown, endPoint, status);
}
}
// Parse the rest of the response the get core cluster information.
try
{
this.ServerHostId = deserializer.ReadInt32();
this.ConnectionId = deserializer.ReadInt64();
this.ClusterStartTimeStamp = deserializer.ReadDateTimeFromMilliseconds();
this.LeaderIPEndPoint = new IPEndPoint(
new IPAddress(deserializer.ReadRaw(4))
, endPoint.Port
);
this.BuildString = deserializer.ReadString();
}
catch (Exception x)
{
throw new VoltConnectionException(Resources.LR_FailedParsingResponse, x, endPoint);
}
// Now that we are successfully connected, set the socket timeout to infinite (we are constantly
// listening for new messages).
this.BaseStream.ResetTimeout(Timeout.Infinite);
// Create background threads.
this.BackgroundNetworkThread = new Thread(this.BackgroundNetworkThreadRun)
{
IsBackground = true,
Priority = ThreadPriority.AboveNormal
};
this.BackgroundTimeoutThread = new Thread(this.BackgroundTimeoutThreadRun)
{
IsBackground = true
};
// Starting background processing threads.
this.BackgroundNetworkThread.Start();
this.BackgroundTimeoutThread.Start();
// Start Callback executor
this.CallbackExecutor.Start();
// Ensure terminal exception is reset
this.TerminalException = null;
// Connection is now ready.
this.Status = ConnectionStatus.Connected;
// Initialize statistics as needed.
if (this.Settings.StatisticsEnabled)
{
this.Stats = new Dictionary <string, Statistics>(StringComparer.OrdinalIgnoreCase);
// For lifetime statistics, keep track of previous connection cycles, if any.
if (this.LifetimeStats != null)
{
if (this.PastLifetimeStats != null)
{
this.PastLifetimeStats.SummarizeWith(this.LifetimeStats);
}
else
{
this.PastLifetimeStats = this.LifetimeStats;
}
}
this.LifetimeStats = new Statistics();
}
// Trace as needed
if (this.Settings.TraceEnabled)
{
VoltTrace.TraceEvent(
TraceEventType.Information
, VoltTraceEventType.ConnectionOpened
, Resources.TraceConnectionOpened
, this.ServerHostId
, this.ConnectionId
, endPoint
, this.LeaderIPEndPoint
, this.ClusterStartTimeStamp
, this.BuildString
);
}
}
catch (Exception x)
{
try
{
// In case of failure, terminate everything immediately (will correct status).
this.Terminate();
}
catch { }
// Re-throw exception, wrapping if needed.
if (x is VoltException)
{
throw new VoltConnectionException(Resources.ConnectionFailure, x, endPoint);
}
else
{
throw x;
}
}
}
return(this);
}
/// <summary>
/// Instantiate a Table by directly deserializing byte data from the given Deserializer.
/// </summary>
/// <param name="input">The Deserializer providing the data for the table.</param>
internal Table(Deserializer input)
: base(input)
{
// Allocate column-based data storage.
for (short c = 0; c < this.ColumnCount; c++)
{
switch (ColumnType[c])
{
case DBType.TINYINT:
Column[c] = new sbyte?[this.RowCount];
break;
case DBType.SMALLINT:
Column[c] = new short?[this.RowCount];
break;
case DBType.INTEGER:
Column[c] = new int?[this.RowCount];
break;
case DBType.BIGINT:
Column[c] = new long?[this.RowCount];
break;
case DBType.FLOAT:
Column[c] = new double?[this.RowCount];
break;
case DBType.DECIMAL:
Column[c] = new VoltDecimal?[this.RowCount];
break;
case DBType.TIMESTAMP:
Column[c] = new DateTime?[this.RowCount];
break;
case DBType.STRING:
Column[c] = new string[this.RowCount];
break;
case DBType.VARBINARY:
Column[c] = new byte[this.RowCount][];
break;
default:
throw new VoltUnsupportedTypeException(Resources.UnsupportedDBType, ColumnType[c]);
}
}
// Get data and push to storage.
for (int r = 0; r < this.RowCount; r++)
{
// Total byte length of the row (ignored).
input.Skip(4);
// Read data and push in storage.
for (short c = 0; c < this.ColumnCount; c++)
{
switch (ColumnType[c])
{
case DBType.TINYINT:
(Column[c] as sbyte?[])[r] = input.ReadSByteN();
break;
case DBType.SMALLINT:
(Column[c] as short?[])[r] = input.ReadInt16N();
break;
case DBType.INTEGER:
(Column[c] as int?[])[r] = input.ReadInt32N();
break;
case DBType.BIGINT:
(Column[c] as long?[])[r] = input.ReadInt64N();
break;
case DBType.FLOAT:
(Column[c] as double?[])[r] = input.ReadDoubleN();
break;
case DBType.DECIMAL:
(Column[c] as VoltDecimal?[])[r] = input.ReadVoltDecimalN();
break;
case DBType.TIMESTAMP:
(Column[c] as DateTime?[])[r] = input.ReadDateTimeN();
break;
case DBType.VARBINARY:
(Column[c] as byte[][])[r] = input.ReadByteArray();
break;
default:
(Column[c] as string[])[r] = input.ReadString();
break;
}
}
}
// Attach the enumerable row collection.
this._Rows = new RowCollection(this);
}
/// <summary>
/// Open the connection.
/// </summary>
/// <returns>A reference to the current connection instance for action chaining.</returns>
public override VoltConnection Open()
{
// Synchronize access.
lock (this.SyncRoot)
{
// Validate connection status.
if (this.Status != ConnectionStatus.Closed)
throw new InvalidOperationException(string.Format(Resources.InvalidConnectionStatus, this.Status));
// Set status to "connecting".
this.Status = ConnectionStatus.Connecting;
// Connect to the default endpoint (there should only be one anyways if this is a managed pool
// connection, otherwise, you're on your own - this is a connection, not a Pool!).
IPEndPoint endPoint = this.Settings.DefaultIPEndPoint;
try
{
// Create new socket stream and wrap a core protocol stream manager around it.
this.BaseStream = new VoltProtocolStream(endPoint, this.Settings.ConnectionTimeout);
// Now send login message.
using (Serializer serializer = new Serializer())
{
var msg = serializer
.Write(this.Settings.ServiceType.ToString().ToLowerInvariant())
.Write(this.Settings.UserID)
.WriteRaw(SHA1.Create().ComputeHash(Encoding.UTF8.GetBytes(this.Settings.Password)))
.GetBytes();
this.BaseStream.WriteMessage(msg.Array, msg.Offset, msg.Count);
}
// Receive and process login response message.
var deserializer = new Deserializer(this.BaseStream.ReadMessage());
LoginResponseStatus status = (LoginResponseStatus)deserializer.ReadSByte();
if (status != LoginResponseStatus.Connected)
{
// Re-package server response in an appropriate exception.
switch (status)
{
case LoginResponseStatus.ConnectionHandshakeTimeout:
throw new VoltConnectionException(
Resources.LRS_ConnectionHandshakeTimeout
, endPoint
, status
);
case LoginResponseStatus.CorruptedHandshake:
throw new VoltConnectionException(
Resources.LRS_CorruptedHandshake
, endPoint
, status
);
case LoginResponseStatus.InvalidCredentials:
throw new VoltPermissionException(
Resources.LRS_InvalidCredentials
, endPoint
, status
);
case LoginResponseStatus.ServerTooBusy:
throw new VoltConnectionException(
Resources.LRS_ServerTooBusy
, endPoint
, status
);
default:
throw new VoltConnectionException(Resources.LRS_Unknown, endPoint, status);
}
}
// Parse the rest of the response the get core cluster information.
try
{
this.ServerHostId = deserializer.ReadInt32();
this.ConnectionId = deserializer.ReadInt64();
this.ClusterStartTimeStamp = deserializer.ReadDateTimeFromMilliseconds();
this.LeaderIPEndPoint = new IPEndPoint(
new IPAddress(deserializer.ReadRaw(4))
, endPoint.Port
);
this.BuildString = deserializer.ReadString();
}
catch (Exception x)
{
throw new VoltConnectionException(Resources.LR_FailedParsingResponse, x, endPoint);
}
// Now that we are successfully connected, set the socket timeout to infinite (we are constantly
// listening for new messages).
this.BaseStream.ResetTimeout(Timeout.Infinite);
// Create background threads.
this.BackgroundNetworkThread = new Thread(this.BackgroundNetworkThreadRun)
{
IsBackground = true,
Priority = ThreadPriority.AboveNormal
};
this.BackgroundTimeoutThread = new Thread(this.BackgroundTimeoutThreadRun)
{
IsBackground = true
};
// Starting background processing threads.
this.BackgroundNetworkThread.Start();
this.BackgroundTimeoutThread.Start();
// Start Callback executor
this.CallbackExecutor.Start();
// Ensure terminal exception is reset
this.TerminalException = null;
// Connection is now ready.
this.Status = ConnectionStatus.Connected;
// Initialize statistics as needed.
if (this.Settings.StatisticsEnabled)
{
this.Stats = new Dictionary<string, Statistics>(StringComparer.OrdinalIgnoreCase);
// For lifetime statistics, keep track of previous connection cycles, if any.
if (this.LifetimeStats != null)
{
if (this.PastLifetimeStats != null)
this.PastLifetimeStats.SummarizeWith(this.LifetimeStats);
else
this.PastLifetimeStats = this.LifetimeStats;
}
this.LifetimeStats = new Statistics();
}
// Trace as needed
if (this.Settings.TraceEnabled)
VoltTrace.TraceEvent(
TraceEventType.Information
, VoltTraceEventType.ConnectionOpened
, Resources.TraceConnectionOpened
, this.ServerHostId
, this.ConnectionId
, endPoint
, this.LeaderIPEndPoint
, this.ClusterStartTimeStamp
, this.BuildString
);
}
catch (Exception x)
{
try
{
// In case of failure, terminate everything immediately (will correct status).
this.Terminate();
}
catch { }
// Re-throw exception, wrapping if needed.
if (x is VoltException)
throw new VoltConnectionException(Resources.ConnectionFailure, x, endPoint);
else
throw x;
}
}
return this;
}