mySqlMonitor - Not visible parameters

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
rafael_moreno
Posts: 1
Joined: Tue 15 Aug 2006 17:46

mySqlMonitor - Not visible parameters

Post by rafael_moreno » Tue 15 Aug 2006 17:50

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
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Wed 16 Aug 2006 09:20

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

Post by Guest » Wed 16 Aug 2006 11:38

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

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Wed 16 Aug 2006 13:14

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

KW
Posts: 125
Joined: Tue 19 Feb 2008 19:12

Post by KW » Mon 26 May 2008 20:16

Alexey wrote: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
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Tue 27 May 2008 06:35

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
Posts: 125
Joined: Tue 19 Feb 2008 19:12

Post by KW » Tue 27 May 2008 18:10

Alexey.mdr wrote: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.

Post Reply