public void Rollback(TestCaseResult result) { CheckDtcEnabled(result); worker.CheckTable(connection, result); XAction x = new XAction(); VirtuosoConnection xconn = null; try { string host = TestSettings.GetString("HOST", "localhost"); string connectionString = "HOST=" + host + ";UID=dba;PWD=dba;Pooling=True;"; xconn = x.Connect(connectionString); x.DoWork(xconn, worker); worker.CheckTable(xconn, result); x.Abort(); worker.DeleteRow(3); worker.DeleteRow(4); worker.CheckTable(connection, result); } finally { if (xconn != null) { xconn.Close(); } } }
protected override void TearDown() { DropTable(); connection.Close(); connection = null; }
public static int add_data(int nrows) { Object port = AppDomain.CurrentDomain.GetData("OpenLink.Virtuoso.InProcessPort"); if (port == null) { throw new Exception("not running as a hosted module"); } VirtuosoConnection c = new VirtuosoConnection("HOST=:in-process:" + port.ToString() + ";UID=dummy;PWD=dummy"); int i; c.Open(); new VirtuosoCommand("exec_result_names (vector ('x'))", c).ExecuteNonQuery(); VirtuosoCommand cmd = new VirtuosoCommand("result (?)", c); cmd.Parameters.Add(":1", SqlDbType.Int); for (i = 0; i < nrows; i++) { cmd.Parameters[":1"].Value = i; cmd.ExecuteNonQuery(); } cmd = null; c.Close(); return(0); }
public static int add_data (int nrows) { Object port = AppDomain.CurrentDomain.GetData("OpenLink.Virtuoso.InProcessPort"); if (port == null) throw new Exception ("not running as a hosted module"); VirtuosoConnection c = new VirtuosoConnection ("HOST=:in-process:" + port.ToString() + ";UID=dummy;PWD=dummy"); int i; c.Open(); new VirtuosoCommand ("exec_result_names (vector ('x'))", c).ExecuteNonQuery (); VirtuosoCommand cmd = new VirtuosoCommand ("result (?)", c); cmd.Parameters.Add (":1", SqlDbType.Int); for (i = 0; i < nrows; i++) { cmd.Parameters[":1"].Value = i; cmd.ExecuteNonQuery (); } cmd = null; c.Close(); return 0; }
private VirtuosoCommand CollectInfo() { if (adapter == null) { throw new InvalidOperationException("The DataAdapter property is not set."); } VirtuosoCommand selectCommand = (VirtuosoCommand)adapter.SelectCommand; if (selectCommand == null) { throw new InvalidOperationException("The SelectCommand property is not set."); } VirtuosoConnection connection = (VirtuosoConnection)selectCommand.Connection; if (connection == null) { throw new InvalidOperationException("The Connection property is not set."); } if (columns != null) { return(selectCommand); } bool close = false; if (connection.State == ConnectionState.Closed) { connection.Open(); close = true; } VirtuosoDataReader reader = null; try { reader = (VirtuosoDataReader)selectCommand.ExecuteReader(CommandBehavior.KeyInfo | CommandBehavior.SchemaOnly); tableName = GetTableName(reader.Columns); columns = reader.Columns; } finally { if (reader != null) { reader.Close(); } if (close) { connection.Close(); } } return(selectCommand); }
public Object get_var_data(String var, String part, String query, String vars, String xmlnss) { // Console.WriteLine ("get_var_data:0"); try { c.Open(); } catch (Exception e) { // Console.WriteLine("{0} Exception caught.", e); throw; } // Console.WriteLine ("get_var_data:1"); VirtuosoCommand cmd = new VirtuosoCommand("select BPEL.BPEL.get_var_from_dump (?, ?, ?, ?, ?)", c); // Console.WriteLine ("get_var_data:2"); cmd.Parameters.Add(":1", SqlDbType.VarChar); cmd.Parameters.Add(":2", SqlDbType.VarChar); cmd.Parameters.Add(":3", SqlDbType.VarChar); cmd.Parameters.Add(":4", SqlDbType.VarChar); cmd.Parameters.Add(":5", SqlDbType.VarChar); // Console.WriteLine ("get_var_data:3"); cmd.Parameters[":1"].Value = var; cmd.Parameters[":2"].Value = part; cmd.Parameters[":3"].Value = query; cmd.Parameters[":4"].Value = vars; cmd.Parameters[":5"].Value = xmlnss; // Console.WriteLine ("get_var_data:4"); String result = (String)cmd.ExecuteScalar(); // Console.WriteLine (result); // Console.WriteLine ("get_var_data:7"); c.Close(); // Console.WriteLine ("get_var_data:8"); return(result); }
public int Execute(string sparql) { if (connection.State == System.Data.ConnectionState.Open) { connection.Close(); } connection.Open(); var command = connection.CreateCommand(); //var db = connection.Database; command.CommandType = System.Data.CommandType.Text; command.CommandText = sparql; int val = command.ExecuteNonQuery(); connection.Close(); return(val); }
public void OdbcConnectionWithoutPooling(TestCaseResult result) { string host = TestSettings.GetString("HOST"); string connectionString = "HOST=" + host + ";UID=dba;PWD=dba;Pooling=False;"; VirtuosoConnection conn = new VirtuosoConnection(connectionString); try { conn.Open(); conn.Close(); } finally { conn.Dispose(); } }
protected virtual void Dispose(bool isDisposing) { if (_isDisposed) { return; } if (isDisposing) { if (Connection != null) { Connection.Close(); Connection.Dispose(); } } _isDisposed = true; }
private static void TestPooling(string connString) { const int n = 1000 /*, m = 100*/; string connStringPool = connString + ";Pooling=true"; string connStringNoPool = connString + ";Pooling=false"; VirtuosoConnection first, conn = null; DateTime start; int i; first = new VirtuosoConnection(connStringNoPool); start = DateTime.Now; System.Console.WriteLine("before Open(): {0}.{1:000}", DateTime.Now.Second, DateTime.Now.Millisecond); first.Open(); System.Console.WriteLine("after Open(): {0}.{1:000}", DateTime.Now.Second, DateTime.Now.Millisecond); System.Console.WriteLine("open first connection {0}", DateTime.Now - start); System.Console.WriteLine("With pooling enabled"); conn = new VirtuosoConnection(connStringPool); start = DateTime.Now; for (i = 0; i < n; i++) { //if ((i % m) == 0) // System.Console.WriteLine ("i={0}", i); conn.Open(); conn.Close(); } System.Console.WriteLine("{0} connections: {1}", n, DateTime.Now - start); System.Console.WriteLine("With pooling disabled"); conn = new VirtuosoConnection(connStringNoPool); start = DateTime.Now; for (i = 0; i < n; i++) { //if ((i % m) == 0) // System.Console.WriteLine ("i={0}", i); conn.Open(); conn.Close(); } System.Console.WriteLine("{0} connections: {1}", n, DateTime.Now - start); start = DateTime.Now; first.Close(); System.Console.WriteLine("close first connection {0}", DateTime.Now - start); }
public void State(TestCaseResult result) { string host = TestSettings.GetString("HOST"); string connectionString = "HOST=" + host + ";UID=dba;PWD=dba;"; VirtuosoConnection conn = new VirtuosoConnection(connectionString); try { result.FailIfNotEqual(ConnectionState.Closed, conn.State); conn.Open(); result.FailIfNotEqual(ConnectionState.Open, conn.State); conn.Close(); result.FailIfNotEqual(ConnectionState.Closed, conn.State); } finally { conn.Dispose(); } }
public void PersistSecurityInfo(TestCaseResult result) { string host = TestSettings.GetString("HOST"); string connectionString = "HOST=" + host + ";UID=dba;PWD=dba;Persist Security Info=true;"; VirtuosoConnection conn = new VirtuosoConnection(connectionString); try { result.FailIfNotEqual(connectionString, conn.ConnectionString); conn.Open(); result.FailIfNotEqual(connectionString, conn.ConnectionString); conn.Close(); result.FailIfNotEqual(connectionString, conn.ConnectionString); } finally { conn.Dispose(); } }
public void Close() #endif { Debug.WriteLineIf(CLI.FnTrace.Enabled, "VirtuosoDataReader.Close()"); if (open) { if (command != null) { command.CloseDataReader(); command = null; } if (connection != null && (commandBehavior & CommandBehavior.CloseConnection) != 0) { connection.Close(); connection = null; } columns = null; open = false; } }
private static void TestPooling (string connString) { const int n = 1000/*, m = 100*/; string connStringPool = connString + ";Pooling=true"; string connStringNoPool = connString + ";Pooling=false"; VirtuosoConnection first, conn = null; DateTime start; int i; first = new VirtuosoConnection (connStringNoPool); start = DateTime.Now; System.Console.WriteLine ("before Open(): {0}.{1:000}", DateTime.Now.Second, DateTime.Now.Millisecond); first.Open (); System.Console.WriteLine ("after Open(): {0}.{1:000}", DateTime.Now.Second, DateTime.Now.Millisecond); System.Console.WriteLine ("open first connection {0}", DateTime.Now - start); System.Console.WriteLine ("With pooling enabled"); conn = new VirtuosoConnection (connStringPool); start = DateTime.Now; for (i = 0; i < n; i++) { //if ((i % m) == 0) // System.Console.WriteLine ("i={0}", i); conn.Open (); conn.Close (); } System.Console.WriteLine ("{0} connections: {1}", n, DateTime.Now - start); System.Console.WriteLine ("With pooling disabled"); conn = new VirtuosoConnection (connStringNoPool); start = DateTime.Now; for (i = 0; i < n; i++) { //if ((i % m) == 0) // System.Console.WriteLine ("i={0}", i); conn.Open (); conn.Close (); } System.Console.WriteLine ("{0} connections: {1}", n, DateTime.Now - start); start = DateTime.Now; first.Close (); System.Console.WriteLine ("close first connection {0}", DateTime.Now - start); }
public void Dispose() { Connection.Close(); Connection.Dispose(); }