DB monitor and Raw

DB monitor and Raw

Postby peledkfir » Sun 24 Apr 2011 12:42

Hey,
In some tables I work with Raw16 for representing Guid.
When working with db monitor, looking at executed sql statement parameters, instead of showing the value of the Guid or the values in the byte array it just shows "System.Byte[]".

It will be helpful if it will be fixed.
Thanks,
Kfir.
peledkfir
 
Posts: 22
Joined: Sat 15 Jan 2011 11:06

Postby Shalex » Tue 26 Apr 2011 13:44

I have tried dotConnect for Oracle v 6.10.141, dbMonitor v 3.0.3, and Visual Studio 2010 SP1 v 10.0.40219.1.
Code: Select all
// CREATE TABLE RAWTABLE (
//   ID NUMBER(38),
//   RAWCOLUMN RAW(16),
//   CONSTRAINT PK_RAWTABLE PRIMARY KEY (ID));

[MTAThread]
static void Main(string[] args) {
    OracleMonitor monitor = new OracleMonitor();
    monitor.IsActive = true;
    using (OracleConnection conn = new OracleConnection()) {
        conn.ConnectionString = "server=orcl1120;uid=***;pwd=***;";
        conn.Open();
        OracleCommand cmd = conn.CreateCommand();
        cmd.CommandText = "insert into rawtable values (1, :p1)";
        cmd.Parameters.Add("p1", OracleDbType.Raw).Value = Guid.NewGuid();
        int i = Convert.ToInt32(cmd.ExecuteNonQuery());
    }
}

Here is my output from the Parameters tab of DbMonitor:
Name - p1
Type - Input
Data Type - Raw
In Value - c729d794-c430-4406-9e13-0e0df230a3c1
Out Value - c729d794-c430-4406-9e13-0e0df230a3c1

Please tell us the versions of your dotConnect for Oracle (x.xx.xxx), dbMonitor (x.x.x), and Visual Studio, and the steps we should follow to reproduce the problem.
Shalex
Devart Team
 
Posts: 7824
Joined: Thu 14 Aug 2008 12:44

Postby peledkfir » Tue 26 Apr 2011 18:14

I'm using dbMonitor version 3.0.3. dotConnect 6.10.96 and Visual Studio 2010 SP1.

I'm using EF.

Maybe it's because the queries are done through EF and not directly ADO.NET?
peledkfir
 
Posts: 22
Joined: Sat 15 Jan 2011 11:06

Postby AndreyR » Fri 29 Apr 2011 13:31

Thank you for the report, I have reproduced the issue.
I will let you know about the results of our investigation.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby AndreyR » Tue 10 May 2011 15:19

The problem is fixed in the upcoming build. It will be available in a week or so.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby AndreyR » Thu 19 May 2011 13:26

We have released the new 6.30.160 build of dotConnect for Oracle that includes the fix for the Guid problem. This build can be dowloaded from here (the trial version) or from Registered Users' Area (for users with active subscription only).
For the detailed information about the improvements and fixes available in dotConnect for Oracle 6.30.160, please refer to this announcement.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle