Page 1 of 1
OracleNotificationEventArgs incorrect Details
Posted: Wed 08 Oct 2014 10:03
by 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
Re: OracleNotificationEventArgs incorrect Details
Posted: Tue 14 Oct 2014 08:51
by 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.
Re: OracleNotificationEventArgs incorrect Details
Posted: Tue 07 Apr 2015 11:15
by Feneck91
I have exactly same problem !
Do you find a workaround ?
Thanks.
Re: OracleNotificationEventArgs incorrect Details
Posted: Tue 07 Apr 2015 13:28
by 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.
Re: OracleNotificationEventArgs incorrect Details
Posted: Tue 07 Apr 2015 14:57
by 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 !
Re: OracleNotificationEventArgs incorrect Details
Posted: Wed 08 Apr 2015 11:02
by 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.
Re: OracleNotificationEventArgs incorrect Details
Posted: Thu 09 Apr 2015 06:09
by 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.
Re: OracleNotificationEventArgs incorrect Details
Posted: Fri 10 Apr 2015 14:25
by 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).
Re: OracleNotificationEventArgs incorrect Details
Posted: Mon 13 Apr 2015 09:18
by 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...
Re: OracleNotificationEventArgs incorrect Details
Posted: Tue 14 Apr 2015 15:04
by Pinturiccio
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 ... story.html
http://www.devart.com/dotconnect/postgr ... story.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.