DB monitor and Raw

peledkfir · Post by **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.

Shalex · Post by **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.

peledkfir · Post by **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?

AndreyR · Post by **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 · Post by **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 · Post by **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.