private SednaSession(string dbname, string host, int port, string userName, string password) { currentDatabase = dbname; try { socket = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp); socket.Connect(new IPEndPoint(Dns.GetHostEntry(host).AddressList[0], port)); } catch (IOException ex) { throw new SednaException("No connection could be made to that host: " + ex.Message); } outputStream = new NetworkStream(socket, FileAccess.Write); inputStream = new NetworkStream(socket, FileAccess.Read); // send startup message. NetworkOperations.WriteMessage(InstructionCode.StartUp, outputStream, inputStream, InstructionCode.SendSessionParameters); // send parameters. NetworkOperations.Message msg = CreateParametersMessage(dbname, userName, password); NetworkOperations.WriteMessage(msg, outputStream); // get the response... NetworkOperations.ReadMessage(msg, inputStream); // need to send the password if (msg.Instruction == InstructionCode.SendAuthenticationParameters) { NetworkOperations.WriteMessage(InstructionCode.AuthenticationResponse, outputStream, inputStream, new string[] { password }, InstructionCode.AuthenticationOK); } else if (msg.Instruction == InstructionCode.AuthenticationFailed || msg.Instruction == InstructionCode.GeneralError) { throw new SednaException("Authentication failed"); } }
/// <summary> /// Terminates a session, rolling back any transactions that were not committed. /// </summary> public void Close() { // for reason the server rejects this message. NetworkOperations.WriteMessage(InstructionCode.CloseConnection, outputStream, inputStream, InstructionCode.ConnectionClosed, InstructionCode.TransactionRollback); inputStream.Close(); outputStream.Close(); isClosed = true; }
public static bool BulkLoad(Stream input, NetworkStream bufInputStream, NetworkStream outputStream) { Message msg = new Message(); int bytes_read = -1; try { while (bytes_read != 0) { byte[] buffer = new byte[BulkLoadPortionSize]; bytes_read = input.Read(buffer, 0, BulkLoadPortionSize); if (bytes_read != 0) { // crop the array to the correct size msg.Body = new byte[bytes_read + IntSize + StringTypeSize]; Array.Copy(buffer, 0, msg.Body, IntSize + StringTypeSize, bytes_read); msg.Instruction = InstructionCode.BulkLoadPortion; msg.Body[0] = 0; NetworkOperations.WriteInt(bytes_read, msg.Body, 0 + StringTypeSize); NetworkOperations.WriteMessage(msg, outputStream); } } NetworkOperations.WriteMessage(InstructionCode.BulkLoadEnd, outputStream, bufInputStream, InstructionCode.BulkLoadSucceeded, InstructionCode.UpdateSucceeded); return(true); } catch (IOException e) { msg.Instruction = InstructionCode.BulkLoadError; try { NetworkOperations.WriteMessage(msg, outputStream); NetworkOperations.ReadMessage(msg, bufInputStream); } catch (IOException ex) { throw new SednaException(InstructionCode.BulkLoadFailed, "Unable to bulk load: IO error: " + ex.Message); } throw new SednaException(InstructionCode.BulkLoadFailed, NetworkOperations.GetErrorInfo(msg.Instruction, msg.Body) + " : " + e.Message); } }
/// <summary> /// Retrieves the next part of the result. /// </summary> /// <returns></returns> public string Next() { if (!hasNextItem) { return(null); } NetworkOperations.Message msg = new NetworkOperations.Message(); msg.Instruction = InstructionCode.GetNextItem; NetworkOperations.WriteMessage(msg, outputStream); NetworkOperations.StringItem item = NetworkOperations.ReadStringItem(inputStream); if (item.Item == null) { hasNextItem = false; return(null); } else { text += item.Item; return(item.Item); } }
/// <summary> /// Executes a query that is read from a stream. /// </summary> public QueryResult Execute(TextReader queryReader) { try { if (!inTransaction) { BeginTransaction(); } string query = queryReader.ReadToEnd(); NetworkOperations.Message msg = new NetworkOperations.Message(); msg.Instruction = InstructionCode.Execute; MemoryStream stream = new MemoryStream(); BinaryWriter writer = new BinaryWriter(stream); writer.Write((byte)0); // xml is 0, scheme xml is 1 NetworkOperations.WriteString(writer, query); writer.Close(); msg.Body = stream.ToArray(); NetworkOperations.WriteMessage(msg, outputStream); NetworkOperations.ReadMessage(msg, inputStream); if (msg.Instruction == InstructionCode.QuerySucceeded) { return(new QueryResult(NetworkOperations.ReadStringItem(inputStream), inputStream, outputStream)); } else if (msg.Instruction == InstructionCode.QueryFailed || msg.Instruction == InstructionCode.UpdateFailed || msg.Instruction == InstructionCode.GeneralError) { throw NetworkOperations.GetErrorInfo(msg.Instruction, msg.Body); } else if (msg.Instruction == InstructionCode.UpdateSucceeded) { haveUpdated = true; return(null); } else if (msg.Instruction == InstructionCode.BulkLoadFileRequest) { try { haveUpdated = true; string filename = NetworkOperations.ReadString(msg, 0); Stream fileStream = File.OpenRead(filename); if (!NetworkOperations.BulkLoad(fileStream, inputStream, outputStream)) { throw new SednaException(InstructionCode.BulkLoadFailed, "Bulk load failed"); } return(null); } finally { stream.Close(); } } else if (msg.Instruction == InstructionCode.BulkLoadStreamRequest) { if (!NetworkOperations.BulkLoad(Console.OpenStandardInput(), inputStream, outputStream)) { throw new SednaException("Bulk load failed"); } return(null); } else { throw new SednaException("Unexpected error"); } } catch (Exception ex) { inTransaction = false; haveUpdated = false; throw ex; } }
/// <summary> /// Commits the current transaction /// </summary> public void CommitTransaction() { inTransaction = false; haveUpdated = false; NetworkOperations.WriteMessage(InstructionCode.CommitTransaction, outputStream, inputStream, InstructionCode.CommitSucceeded); }
public void RollbackTransaction() { inTransaction = false; haveUpdated = false; NetworkOperations.WriteMessage(InstructionCode.RollbackTransaction, outputStream, inputStream, InstructionCode.TransactionRollback); }
/// <summary> /// Begins a new transaction manually /// </summary> public void BeginTransaction() { NetworkOperations.WriteMessage(InstructionCode.BeginTransaction, outputStream, inputStream, InstructionCode.BeginTransactionOk); inTransaction = true; haveUpdated = false; }