mySqlMonitor - Not visible parameters

[rafael_moreno]

Good afternoon,

mySqlMonitor not visible parameters in event TraceEvent. I am need for developer aplication log.

Exemplo

mySqlConnection1.Open();
try
{
MySqlCommand objMySqlCommand = mySqlConnection1.CreateCommand();
objMySqlCommand.CommandText = "INSERT INTO Cargo(CarCodigoEmpresa, CarDescricao) VALUES (:ACarCodigoEmpresa, :ACarDescricao)";
objMySqlCommand.Parameters.Clear();
objMySqlCommand.Parameters.Add("ACarDescricao", MySqlType.VarChar).Value = "Teste de Cargo";
objMySqlCommand.Parameters.Add("ACarCodigoEmpresa", MySqlType.VarChar).Value = "1";
objMySqlCommand.ExecuteNonQuery();
}
finally
{
mySqlConnection1.Close();
}

In the event TraceEvent not visible parameters.

Thank.

Ass.: Rafael

[Alexey]

Please specify what is meant by

mySqlMonitor not visible parameters in event TraceEvent

and by

In the event TraceEvent not visible parameters.

Unfortunately we were unable to translate this successfully.

[Guest]

How to visualize the parameter in instruction SQL in the MySQLMonitor?

[Alexey]

Please describe what exactly you need or what is the problem.

[KW]

Please describe what exactly you need or what is the problem.

I am also wondering if it is possible to view the parameters. Basically, the MysqlMonitor only shows output such as:

Code: Select all

Execute: UPDATE `newschema`.`dept` SET `DNAME` = :p1 WHERE ((`DEPTNO` = :p2) AND ((:p3 = 1 AND `DNAME` IS NULL) OR (`DNAME` = :p4)) AND ((:p5 = 1 AND `LOC` IS NULL) OR (`LOC` = :p6)))

However, is it possible to view the parameters? What IS p1? What IS p2? Not very helpful knowing the placeholders and not the actual inputted parameters when debugging a sql statement. If I could view the paramters that would be extremely useful.

[Alexey.mdr]

You have got two options:
1) Listen for the TraceEvent event and when it occurs cast the sender to the MySqlCommand. Then iterate on the parameters collection.
2) You can use DBMonitor tool. Note, the tool works with MyDirect .NET Pro edition only.

[KW]

You have got two options:
1) Listen for the TraceEvent event and when it occurs cast the sender to the MySqlCommand. Then iterate on the parameters collection.
2) You can use DBMonitor tool. Note, the tool works with MyDirect .NET Pro edition only.

Perfect thanks.