protected override void Dispose(bool disposing) { if (!_disposed) { try { if (disposing) { Release(); Clear(); _db = null; _fields = null; _parameters = null; _transaction = null; _outputParams = null; _statusVector = null; _allRowsFetched = false; _state = StatementState.Deallocated; _statementType = DbStatementType.None; _recordsAffected = 0; _handle.Dispose(); FetchSize = 0; } } finally { _disposed = true; base.Dispose(disposing); } } }
protected DbStatementType ProcessStatementTypeInfoBuffer(byte[] buffer) { DbStatementType stmtType = DbStatementType.None; int pos = 0; int length = 0; int type = 0; while ((type = buffer[pos++]) != IscCodes.isc_info_end) { length = IscHelper.VaxInteger(buffer, pos, 2); pos += 2; switch (type) { case IscCodes.isc_info_sql_stmt_type: stmtType = (DbStatementType)IscHelper.VaxInteger(buffer, pos, length); pos += length; break; default: pos += length; break; } } return(stmtType); }
public override void Prepare(string commandText) { ClearAll(); try { if (_state == StatementState.Deallocated) { SendAllocateToBuffer(); _database.XdrStream.Flush(); ProcessAllocateResponce(_database.ReadGenericResponse()); } SendPrepareToBuffer(commandText); _database.XdrStream.Flush(); ProcessPrepareResponse(_database.ReadGenericResponse()); SendInfoSqlToBuffer(StatementTypeInfoItems, IscCodes.STATEMENT_TYPE_BUFFER_SIZE); _database.XdrStream.Flush(); _statementType = ProcessStatementTypeInfoBuffer(ProcessInfoSqlResponse(_database.ReadGenericResponse())); _state = StatementState.Prepared; } catch (IOException ex) { if (_state == StatementState.Allocated) { _state = StatementState.Error; } throw IscException.ForErrorCode(IscCodes.isc_net_read_err, ex); } }
protected void ProcessAllocateResponce(GenericResponse response) { _handle = response.ObjectHandle; _allRowsFetched = false; _state = StatementState.Allocated; _statementType = DbStatementType.None; }
public override void Prepare(string commandText) { ClearAll(); ClearStatusVector(); if (_state == StatementState.Deallocated) { Allocate(); } _fields = new Descriptor(1); var sqlda = XsqldaMarshaler.MarshalManagedToNative(_db.Charset, _fields); var trHandle = _transaction.HandlePtr; var buffer = _db.Charset.GetBytes(commandText); _db.FbClient.isc_dsql_prepare( _statusVector, ref trHandle, ref _handle, (short)buffer.Length, buffer, _db.Dialect, sqlda); var descriptor = XsqldaMarshaler.MarshalNativeToManaged(_db.Charset, sqlda); XsqldaMarshaler.CleanUpNativeData(ref sqlda); _db.ProcessStatusVector(_statusVector); _fields = descriptor; if (_fields.ActualCount > 0 && _fields.ActualCount != _fields.Count) { Describe(); } else { if (_fields.ActualCount == 0) { _fields = new Descriptor(0); } } _fields.ResetValues(); _statementType = GetStatementType(); _state = StatementState.Prepared; }
private void Allocate() { ClearStatusVector(); var dbHandle = _db.HandlePtr; _db.FbClient.isc_dsql_allocate_statement( _statusVector, ref dbHandle, ref _handle); _db.ProcessStatusVector(_statusVector); _allRowsFetched = false; _state = StatementState.Allocated; _statementType = DbStatementType.None; }
public override void Prepare(string commandText) { // Clear data this.Clear(); this.parameters = null; this.fields = null; lock (this.db) { if (this.state == StatementState.Deallocated) { // Allocate statement this.Allocate(); } try { this.db.Send.Write(IscCodes.op_prepare_statement); this.db.Send.Write(this.transaction.Handle); this.db.Send.Write(this.handle); this.db.Send.Write((int)this.db.Dialect); this.db.Send.Write(commandText); this.db.Send.WriteBuffer(DescribeInfoItems, DescribeInfoItems.Length); this.db.Send.Write(IscCodes.MAX_BUFFER_SIZE); this.db.Send.Flush(); GdsResponse r = this.db.ReadGenericResponse(); this.fields = this.ParseSqlInfo(r.Data, DescribeInfoItems); // Determine the statement type this.statementType = this.GetStatementType(); this.state = StatementState.Prepared; } catch (IOException) { this.state = StatementState.Error; throw new IscException(IscCodes.isc_net_read_err); } } }
private void Allocate() { lock (_db) { // Clear the status vector ClearStatusVector(); DatabaseHandle dbHandle = _db.HandlePtr; _db.FbClient.isc_dsql_allocate_statement( _statusVector, ref dbHandle, ref _handle); _db.ProcessStatusVector(_statusVector); _allRowsFetched = false; _state = StatementState.Allocated; _statementType = DbStatementType.None; } }
private void Allocate() { lock (this.db) { int[] statusVector = ExtConnection.GetNewStatusVector(); int dbHandle = this.db.Handle; int stmtHandle = this.handle; SafeNativeMethods.isc_dsql_allocate_statement( statusVector, ref dbHandle, ref stmtHandle); this.db.ParseStatusVector(statusVector); this.handle = stmtHandle; this.allRowsFetched = false; this.state = StatementState.Allocated; this.statementType = DbStatementType.None; } }
protected override void Dispose(bool disposing) { lock (this) { if (!IsDisposed) { try { // release any unmanaged resources Release(); } catch { } finally { // release any managed resources if (disposing) { Clear(); _rows = null; _outputParams = null; _database = null; _fields = null; _parameters = null; _transaction = null; _allRowsFetched = false; _state = StatementState.Deallocated; _statementType = DbStatementType.None; _handle = 0; _fetchSize = 0; RecordsAffected = 0; } base.Dispose(disposing); } } } }
public override void Prepare(string commandText) { // Clear data ClearAll(); lock (_database.SyncObject) { try { if (_state == StatementState.Deallocated) { // Allocate statement SendAllocateToBuffer(); _database.XdrStream.Flush(); ProcessAllocateResponce(_database.ReadGenericResponse()); } SendPrepareToBuffer(commandText); _database.XdrStream.Flush(); ProcessPrepareResponse(_database.ReadGenericResponse()); // Grab statement type SendInfoSqlToBuffer(StatementTypeInfoItems, IscCodes.STATEMENT_TYPE_BUFFER_SIZE); _database.XdrStream.Flush(); _statementType = ProcessStatementTypeInfoBuffer(ProcessInfoSqlResponse(_database.ReadGenericResponse())); _state = StatementState.Prepared; } catch (IOException ex) { // if the statement has been already allocated, it's now in error if (_state == StatementState.Allocated) { _state = StatementState.Error; } throw IscException.ForErrorCode(IscCodes.isc_net_read_err, ex); } } }
protected override void Dispose(bool disposing) { lock (this) { if (!this.IsDisposed) { try { // release any unmanaged resources this.Release(); } catch { } finally { // release any managed resources if (disposing) { this.Clear(); this.rows = null; this.outputParams = null; this.database = null; this.fields = null; this.parameters = null; this.transaction = null; this.allRowsFetched = false; this.state = StatementState.Deallocated; this.statementType = DbStatementType.None; this.handle = 0; this.fetchSize = 0; this.RecordsAffected = 0; } base.Dispose(disposing); } } } }
public override void Prepare(string commandText) { // Clear data this.ClearAll(); lock (this.database.SyncObject) { try { if (this.state == StatementState.Deallocated) { // Allocate statement this.SendAllocateToBuffer(); this.database.Flush(); this.ProcessAllocateResponce(this.database.ReadGenericResponse()); } this.SendPrepareToBuffer(commandText); this.database.Flush(); this.ProcessPrepareResponse(this.database.ReadGenericResponse()); // Grab statement type this.SendInfoSqlToBuffer(StatementTypeInfoItems, IscCodes.STATEMENT_TYPE_BUFFER_SIZE); this.database.Flush(); this.statementType = this.ProcessStatementTypeInfoBuffer(this.ProcessInfoSqlResponse(this.database.ReadGenericResponse())); this.state = StatementState.Prepared; } catch (IOException) { // if the statement has been already allocated, it's now in error if (this.state == StatementState.Allocated) { this.state = StatementState.Error; } throw new IscException(IscCodes.isc_net_read_err); } } }
public override void Dispose() { if (!_disposed) { _disposed = true; Release(); Clear(); _rows = null; _outputParams = null; _database = null; _fields = null; _parameters = null; _transaction = null; _allRowsFetched = false; _state = StatementState.Deallocated; _statementType = DbStatementType.None; _handle = 0; _fetchSize = 0; RecordsAffected = 0; base.Dispose(); } }
private void Allocate() { lock (this.db) { try { this.db.Send.Write(IscCodes.op_allocate_statement); this.db.Send.Write(this.db.Handle); this.db.Send.Flush(); this.handle = this.db.ReadGenericResponse().ObjectHandle; this.allRowsFetched = false; this.state = StatementState.Allocated; this.statementType = DbStatementType.None; } catch (IOException) { this.state = StatementState.Deallocated; throw new IscException(IscCodes.isc_net_read_err); } } }
private void Allocate() { lock (this.db) { // Clear the status vector this.ClearStatusVector(); int dbHandle = this.db.Handle; int stmtHandle = this.handle; db.FbClient.isc_dsql_allocate_statement( this.statusVector, ref dbHandle, ref stmtHandle); this.db.ParseStatusVector(this.statusVector); this.handle = stmtHandle; this.allRowsFetched = false; this.state = StatementState.Allocated; this.statementType = DbStatementType.None; } }
private void Allocate() { lock (_db) { // Clear the status vector ClearStatusVector(); int dbHandle = _db.Handle; int stmtHandle = _handle; _db.FbClient.isc_dsql_allocate_statement( _statusVector, ref dbHandle, ref stmtHandle); _db.ParseStatusVector(_statusVector); _handle = stmtHandle; _allRowsFetched = false; _state = StatementState.Allocated; _statementType = DbStatementType.None; } }
protected void ProcessAllocateResponce(GenericResponse response) { this.handle = response.ObjectHandle; this.allRowsFetched = false; this.state = StatementState.Allocated; this.statementType = DbStatementType.None; }
public override void Prepare(string commandText) { // Clear data ClearAll(); lock (_db) { // Clear the status vector ClearStatusVector(); // Allocate the statement if needed if (_state == StatementState.Deallocated) { Allocate(); } // Marshal structures to pointer // Setup fields structure _fields = new Descriptor(1); IntPtr sqlda = XsqldaMarshaler.MarshalManagedToNative(_db.Charset, _fields); TransactionHandle trHandle = _transaction.HandlePtr; byte[] buffer = _db.Charset.GetBytes(commandText); _db.FbClient.isc_dsql_prepare( _statusVector, ref trHandle, ref _handle, (short)buffer.Length, buffer, _db.Dialect, sqlda); // Marshal Pointer Descriptor descriptor = XsqldaMarshaler.MarshalNativeToManaged(_db.Charset, sqlda); // Free memory XsqldaMarshaler.CleanUpNativeData(ref sqlda); // Parse status vector _db.ProcessStatusVector(_statusVector); // Describe fields _fields = descriptor; if (_fields.ActualCount > 0 && _fields.ActualCount != _fields.Count) { Describe(); } else { if (_fields.ActualCount == 0) { _fields = new Descriptor(0); } } // Reset actual field values _fields.ResetValues(); // Get Statement type _statementType = GetStatementType(); // Update state _state = StatementState.Prepared; } }
public override void Prepare(string commandText) { // Clear data this.ClearAll(); lock (this.db) { if (this.state == StatementState.Deallocated) { // Allocate statement this.Allocate(); } // Marshal structures to pointer XsqldaMarshaler marshaler = XsqldaMarshaler.Instance; // Setup fields structure this.fields = new Descriptor(1); IntPtr sqlda = marshaler.MarshalManagedToNative(this.db.Charset, this.fields); int[] statusVector = ExtConnection.GetNewStatusVector(); int trHandle = this.transaction.Handle; int stmtHandle = this.handle; byte[] buffer = this.db.Charset.GetBytes(commandText); SafeNativeMethods.isc_dsql_prepare( statusVector, ref trHandle, ref stmtHandle, (short)buffer.Length, buffer, this.db.Dialect, sqlda); // Marshal Pointer Descriptor descriptor = marshaler.MarshalNativeToManaged(this.db.Charset, sqlda); // Free memory marshaler.CleanUpNativeData(ref sqlda); // Parse status vector this.db.ParseStatusVector(statusVector); // Describe fields this.fields = descriptor; if (this.fields.ActualCount > 0 && this.fields.ActualCount != this.fields.Count) { this.Describe(); } else { if (this.fields.ActualCount == 0) { this.fields = new Descriptor(0); } } // Reset actual field values this.fields.ResetValues(); // Get Statement type this.statementType = this.GetStatementType(); // Update state this.state = StatementState.Prepared; } }
private void Allocate() { lock (this.db) { int[] statusVector = ExtConnection.GetNewStatusVector(); int dbHandle = this.db.Handle; int stmtHandle = this.handle; SafeNativeMethods.isc_dsql_allocate_statement( statusVector, ref dbHandle, ref stmtHandle); this.db.ParseStatusVector(statusVector); this.handle = stmtHandle; this.allRowsFetched = false; this.state = StatementState.Allocated; this.statementType = DbStatementType.None; } }
public override void Prepare(string commandText) { // Clear data this.ClearAll(); lock (this.db) { if (this.state == StatementState.Deallocated) { // Allocate statement this.Allocate(); } // Marshal structures to pointer XsqldaMarshaler marshaler = XsqldaMarshaler.Instance; // Setup fields structure this.fields = new Descriptor(1); IntPtr sqlda = marshaler.MarshalManagedToNative(this.db.Charset, this.fields); int[] statusVector = ExtConnection.GetNewStatusVector(); int trHandle = this.transaction.Handle; int stmtHandle = this.handle; byte[] buffer = this.db.Charset.GetBytes(commandText); SafeNativeMethods.isc_dsql_prepare( statusVector, ref trHandle, ref stmtHandle, (short)buffer.Length, buffer, this.db.Dialect, sqlda); // Marshal Pointer Descriptor descriptor = marshaler.MarshalNativeToManaged(this.db.Charset, sqlda); // Free memory marshaler.CleanUpNativeData(ref sqlda); // Parse status vector this.db.ParseStatusVector(statusVector); // Describe fields this.fields = descriptor; if (this.fields.ActualCount > 0 && this.fields.ActualCount != this.fields.Count) { this.Describe(); } else { if (this.fields.ActualCount == 0) { this.fields = new Descriptor(0); } } // Reset actual field values this.fields.ResetValues(); // Get Statement type this.statementType = this.GetStatementType(); // Update state this.state = StatementState.Prepared; } }
public override void Prepare(string commandText) { // Clear data this.Clear(); this.parameters = null; this.fields = null; lock (this.db) { if (this.state == StatementState.Deallocated) { // Allocate statement this.Allocate(); } try { this.db.Send.Write(IscCodes.op_prepare_statement); this.db.Send.Write(this.transaction.Handle); this.db.Send.Write(this.handle); this.db.Send.Write((int)this.db.Dialect); this.db.Send.Write(commandText); this.db.Send.WriteBuffer(DescribeInfoItems, DescribeInfoItems.Length); this.db.Send.Write(IscCodes.MAX_BUFFER_SIZE); this.db.Send.Flush(); GdsResponse r = this.db.ReadGenericResponse(); this.fields = this.ParseSqlInfo(r.Data, DescribeInfoItems); // Determine the statement type this.statementType = this.GetStatementType(); this.state = StatementState.Prepared; } catch (IOException) { this.state = StatementState.Error; throw new IscException(IscCodes.isc_net_read_err); } } }
private void Allocate() { lock (this.db) { try { this.db.Send.Write(IscCodes.op_allocate_statement); this.db.Send.Write(this.db.Handle); this.db.Send.Flush(); this.handle = this.db.ReadGenericResponse().ObjectHandle; this.allRowsFetched = false; this.state = StatementState.Allocated; this.statementType = DbStatementType.None; } catch (IOException) { this.state = StatementState.Deallocated; throw new IscException(IscCodes.isc_net_read_err); } } }
public override void Prepare(string commandText) { // Clear data this.ClearAll(); lock (this.database.SyncObject) { try { if (this.state == StatementState.Deallocated) { // Allocate statement this.SendAllocateToBuffer(); this.database.Flush(); this.ProcessAllocateResponce(this.database.ReadGenericResponse()); } this.SendPrepareToBuffer(commandText); this.database.Flush(); this.ProcessPrepareResponse(this.database.ReadGenericResponse()); // Grab statement type this.SendInfoSqlToBuffer(StatementTypeInfoItems, IscCodes.STATEMENT_TYPE_BUFFER_SIZE); this.database.Flush(); this.statementType = this.ProcessStatementTypeInfoBuffer(this.ProcessInfoSqlResponse(this.database.ReadGenericResponse())); this.state = StatementState.Prepared; } catch (IOException) { // if the statement has been already allocated, it's now in error if (this.state == StatementState.Allocated) this.state = StatementState.Error; throw new IscException(IscCodes.isc_net_read_err); } } }
private void Allocate() { lock (_db) { // Clear the status vector ClearStatusVector(); int dbHandle = _db.Handle; int stmtHandle = _handle; _db.FbClient.isc_dsql_allocate_statement( _statusVector, ref dbHandle, ref stmtHandle); _db.ParseStatusVector(_statusVector); _handle = stmtHandle; _allRowsFetched = false; _state = StatementState.Allocated; _statementType = DbStatementType.None; } }
protected override void Dispose(bool disposing) { if (!IsDisposed) { try { Release(); } catch { } finally { if (disposing) { Clear(); _db = null; _fields = null; _parameters = null; _transaction = null; _outputParams = null; _statusVector = null; _allRowsFetched = false; _state = StatementState.Deallocated; _statementType = DbStatementType.None; _recordsAffected = 0; _handle = 0; FetchSize = 0; } base.Dispose(disposing); } } }
protected override void Dispose(bool disposing) { lock (this) { if (!IsDisposed) { try { // release any unmanaged resources Release(); } catch { } finally { // release any managed resources if (disposing) { Clear(); _rows = null; _outputParams = null; _database = null; _fields = null; _parameters = null; _transaction = null; _allRowsFetched = false; _state = StatementState.Deallocated; _statementType = DbStatementType.None; _handle = 0; _fetchSize = 0; RecordsAffected = 0; } base.Dispose(disposing); } } } }
protected override void Dispose(bool disposing) { if (!this.IsDisposed) { try { // release any unmanaged resources this.Release(); } catch { } finally { // release any managed resources if (disposing) { this.Clear(); this.db = null; this.fields = null; this.parameters = null; this.transaction = null; this.outputParams = null; this.statusVector = null; this.allRowsFetched = false; this.state = StatementState.Deallocated; this.statementType = DbStatementType.None; this.recordsAffected = 0; this.handle = 0; this.FetchSize = 0; } base.Dispose(disposing); } } }
private void Allocate() { lock (this.db) { // Clear the status vector this.ClearStatusVector(); int dbHandle = this.db.Handle; int stmtHandle = this.handle; db.FbClient.isc_dsql_allocate_statement( this.statusVector, ref dbHandle, ref stmtHandle); this.db.ParseStatusVector(this.statusVector); this.handle = stmtHandle; this.allRowsFetched = false; this.state = StatementState.Allocated; this.statementType = DbStatementType.None; } }
public override void Prepare(string commandText) { // Clear data ClearAll(); lock (_db) { // Clear the status vector ClearStatusVector(); // Allocate the statement if needed if (_state == StatementState.Deallocated) { Allocate(); } // Marshal structures to pointer // Setup fields structure _fields = new Descriptor(1); IntPtr sqlda = XsqldaMarshaler.MarshalManagedToNative(_db.Charset, _fields); int trHandle = _transaction.Handle; int stmtHandle = _handle; byte[] buffer = _db.Charset.GetBytes(commandText); _db.FbClient.isc_dsql_prepare( _statusVector, ref trHandle, ref stmtHandle, (short)buffer.Length, buffer, _db.Dialect, sqlda); // Marshal Pointer Descriptor descriptor = XsqldaMarshaler.MarshalNativeToManaged(_db.Charset, sqlda); // Free memory XsqldaMarshaler.CleanUpNativeData(ref sqlda); // Parse status vector _db.ParseStatusVector(_statusVector); // Describe fields _fields = descriptor; if (_fields.ActualCount > 0 && _fields.ActualCount != _fields.Count) { Describe(); } else { if (_fields.ActualCount == 0) { _fields = new Descriptor(0); } } // Reset actual field values _fields.ResetValues(); // Get Statement type _statementType = GetStatementType(); // Update state _state = StatementState.Prepared; } }
public override void Prepare(string commandText) { // Clear data ClearAll(); lock (_database.SyncObject) { try { if (_state == StatementState.Deallocated) { // Allocate statement SendAllocateToBuffer(); _database.XdrStream.Flush(); ProcessAllocateResponce(_database.ReadGenericResponse()); } SendPrepareToBuffer(commandText); _database.XdrStream.Flush(); ProcessPrepareResponse(_database.ReadGenericResponse()); // Grab statement type SendInfoSqlToBuffer(StatementTypeInfoItems, IscCodes.STATEMENT_TYPE_BUFFER_SIZE); _database.XdrStream.Flush(); _statementType = ProcessStatementTypeInfoBuffer(ProcessInfoSqlResponse(_database.ReadGenericResponse())); _state = StatementState.Prepared; } catch (IOException ex) { // if the statement has been already allocated, it's now in error if (_state == StatementState.Allocated) _state = StatementState.Error; throw IscException.ForErrorCode(IscCodes.isc_net_read_err, ex); } } }