OracleNotificationEventArgs incorrect Details

[teckerstorfer]

Currently I am trying to use OracleDependency in order to get notifications for queries and have the problem that the "Details" DataTable contains incorrect data. It seems as if it only contains the first letter of the rowid. In the debugger it looks like the following:

Code: Select all

dataTable.Rows[row]["Info"] = 4	
dataTable.Rows[row]["RowId"] = "A"
dataTable.Rows[row]["Name"] = "D"

I also attached a screenshot to show some more details: http://screencast.com/t/SlNWs4jc9

Edit: this should be moved to dotConnect for Oracle

[Pinturiccio]

We could not reproduce the issue with your sample. Could you please specify the following:
1. The version of your Oracle Client;
2. The version of your Oracle Database;
3. NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET parameters of Oracle server. You can get this information by executing the following query:
SELECT * FROM NLS_DATABASE_PARAMETERS.

4. connection strings (roughly, without credentials);
5. DDL/DML scripts of your table;
6. dotConnect for Oracle version.

[Feneck91]

I have exactly same problem !
Do you find a workaround ?

Thanks.

[Pinturiccio]

We have not reproduced the issue, so we can't provide a workaround for now. For reproducing the issue please provide us the following information:
1. The version of your Oracle Client;
2. The version of your Oracle Database;
3. NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET parameters of Oracle server. You can get this information by executing the following query:
SELECT * FROM NLS_DATABASE_PARAMETERS.

4. connection strings (roughly, without credentials);
5. dotConnect for Oracle version.

If possible, please create and send us a small test project with the corresponding DDL/DML script.

[Feneck91]

Path : Get the connection, make a clone and set Unicode to False.
It's work but...
Cannot use the rowid ! I record ONLY the ID (primary keys) of each row displayed to the user !

[Pinturiccio]

Please provide the following information:
1. The version of your Oracle Database;
2. NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET parameters of Oracle server. You can get this information by executing the following query:
SELECT * FROM NLS_DATABASE_PARAMETERS.

3. connection strings (roughly, without credentials);
4. DDL/DML scripts of your table;
5. dotConnect for Oracle version.

[Feneck91]

SELECT * FROM NLS_DATABASE_PARAMETERS =

Code: Select all

PARAMETER                      VALUE                                  
------------------------------ ----------------------------------------
NLS_LANGUAGE                   AMERICAN                                 
NLS_TERRITORY                  AMERICA                                  
NLS_CURRENCY                   $                                        
NLS_ISO_CURRENCY               AMERICA                                  
NLS_NUMERIC_CHARACTERS         .,                                       
NLS_CHARACTERSET               WE8MSWIN1252                             
NLS_CALENDAR                   GREGORIAN                                
NLS_DATE_FORMAT                DD-MON-RR                                
NLS_DATE_LANGUAGE              AMERICAN                                 
NLS_SORT                       BINARY                                   
NLS_TIME_FORMAT                HH.MI.SSXFF AM                           
NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM                 
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR                       
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR             
NLS_DUAL_CURRENCY              $                                        
NLS_COMP                       BINARY                                   
NLS_LENGTH_SEMANTICS           BYTE                                     
NLS_NCHAR_CONV_EXCP            FALSE                                    
NLS_NCHAR_CHARACTERSET         AL16UTF16                                
NLS_RDBMS_VERSION              11.2.0.1.0

dotConnect for Oracle version = 8.1.26.0
Connection string = User Id=xxx;Password=xxx;Server="(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)))";Unicode=True;Direct=False;Persist Security Info=True

I have fix it : making a connection clone dans set the Unicode to False.
After I can read the ROWID.

[Pinturiccio]

We have reproduced the issue with dotConnect for Oracle 8.1.26, but the issue is not reproduced with the latest version of dotConnect for Oracle. Try running your application with the latest version of dotConnect for Oracle.
It can be downloaded at http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).

[Feneck91]

I'm currently use a register version that we payed 18 months ago. What about the licence if I download this trial version ?
Currently we are buying too the PostgreSQL licence....

With this version I have some other problems with DbGemotry too but it is another problem...

[Pinturiccio]

What about the licence if I download this trial version ?

If you download trial version of dotConnect for Oracle it will be trial version. It will provide you with a 30-day trial period starting from the moment when it is installed.

If you want a licensed version you can renew your subscription to download the latest versions from Registered Users' Area. For more information, please refer to http://www.devart.com/dotconnect/oracle/ordering.html, the Renewals & Upgrades tab, or you can ask our sales team by e-mail sales at devart dot com.

Currently we are buying too the PostgreSQL licence....

Please note that if you want to install several dotConnect providers on the same computer, the providers must have compatible versions.

All Devart data providers use a common assembly (Devart.Data.dll). We release our ADO.NET data providers simultaneously, thus releases with the same date are compatible. The compatibility of providers depends on their release date. For more information, please refer to
http://www.devart.com/dotconnect/oracle ... story.html
http://www.devart.com/dotconnect/postgr ... story.html

With this version I have some other problems with DbGeometry too but it is another problem...

Can this issue be reproduced with the latest version of dotConnect for Oracle. If it can be reproduced, please send us the following information:
1. What issue do you encounter? Is it an exception, or does the applications freeze or return wrong value? If it is an exception than please provide us the message and call stack of an exception;
2. Please describe the steps for reproducing the issue;
3. If possible, please create and send us a small test project with the corresponding DDL/DML script.