public String set_var_data(String var, String part, String query, Object val, String vars, String xmlnss)
{
c.Open();
VirtuosoCommand cmd = new VirtuosoCommand("select BPEL.BPEL.set_var_to_dump (?, ?, ?, ?, ?, ?)", c);
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);
cmd.Parameters.Add(":6", SqlDbType.VarChar);
cmd.Parameters[":1"].Value = var;
cmd.Parameters[":2"].Value = part;
cmd.Parameters[":3"].Value = query;
cmd.Parameters[":4"].Value = val;
cmd.Parameters[":5"].Value = vars;
cmd.Parameters[":6"].Value = xmlnss;
String result = (String)cmd.ExecuteScalar();
c.Close();
return(result);
}
/// <summary>
/// Executes a Query SQL Command against the database and returns the scalar result (first column of first row of the result)
/// </summary>
/// <param name="sqlCmd">SQL Command</param>
/// <returns>First Column of First Row of the Results</returns>
public override object ExecuteScalar(string sqlCmd)
{
//Get Thread ID
int thread = Thread.CurrentThread.ManagedThreadId;
//Create the SQL Command
VirtuosoCommand cmd = new VirtuosoCommand(sqlCmd, this._dbConnections[thread]);
if (this._dbTrans[thread] != null)
{
//Add to the Transaction if required
cmd.Transaction = this._dbTrans[thread];
}
//Execute the Scalar
return(cmd.ExecuteScalar());
}
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 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 String set_var_data (String var, String part, String query, Object val, String vars, String xmlnss)
{
c.Open();
VirtuosoCommand cmd = new VirtuosoCommand ("select BPEL.BPEL.set_var_to_dump (?, ?, ?, ?, ?, ?)", c);
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);
cmd.Parameters.Add (":6", SqlDbType.VarChar);
cmd.Parameters[":1"].Value = var;
cmd.Parameters[":2"].Value = part;
cmd.Parameters[":3"].Value = query;
cmd.Parameters[":4"].Value = val;
cmd.Parameters[":5"].Value = vars;
cmd.Parameters[":6"].Value = xmlnss;
String result = (String) cmd.ExecuteScalar();
c.Close();
return result;
}
