OracleNotificationEventArgs incorrect Details

OracleNotificationEventArgs incorrect Details

Postby teckerstorfer » Wed 08 Oct 2014 10:03

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
teckerstorfer
 
Posts: 4
Joined: Thu 24 May 2012 05:52

Re: OracleNotificationEventArgs incorrect Details

Postby Pinturiccio » Tue 14 Oct 2014 08:51

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.
Pinturiccio
Devart Team
 
Posts: 1955
Joined: Wed 02 Nov 2011 09:44

Re: OracleNotificationEventArgs incorrect Details

Postby Feneck91 » Tue 07 Apr 2015 11:15

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

Thanks.
Feneck91
 
Posts: 37
Joined: Mon 12 Aug 2013 13:52

Re: OracleNotificationEventArgs incorrect Details

Postby Pinturiccio » Tue 07 Apr 2015 13:28

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.
Pinturiccio
Devart Team
 
Posts: 1955
Joined: Wed 02 Nov 2011 09:44

Re: OracleNotificationEventArgs incorrect Details

Postby Feneck91 » Tue 07 Apr 2015 14:57

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 !
Feneck91
 
Posts: 37
Joined: Mon 12 Aug 2013 13:52

Re: OracleNotificationEventArgs incorrect Details

Postby Pinturiccio » Wed 08 Apr 2015 11:02

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.
Pinturiccio
Devart Team
 
Posts: 1955
Joined: Wed 02 Nov 2011 09:44

Re: OracleNotificationEventArgs incorrect Details

Postby Feneck91 » Thu 09 Apr 2015 06:09

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.
Feneck91
 
Posts: 37
Joined: Mon 12 Aug 2013 13:52

Re: OracleNotificationEventArgs incorrect Details

Postby Pinturiccio » Fri 10 Apr 2015 14:25

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).
Pinturiccio
Devart Team
 
Posts: 1955
Joined: Wed 02 Nov 2011 09:44

Re: OracleNotificationEventArgs incorrect Details

Postby Feneck91 » Mon 13 Apr 2015 09:18

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...
Feneck91
 
Posts: 37
Joined: Mon 12 Aug 2013 13:52

Re: OracleNotificationEventArgs incorrect Details

Postby Pinturiccio » Tue 14 Apr 2015 15:04

Feneck91 wrote: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.

Feneck91 wrote: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/revision_history.html
http://www.devart.com/dotconnect/postgresql/revision_history.html

Feneck91 wrote: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.
Pinturiccio
Devart Team
 
Posts: 1955
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle