PgSqlDataReader throwing a System.FormatException

PgSqlDataReader throwing a System.FormatException

Postby t_suzuki » Wed 06 Apr 2011 08:10

serial type, including tables, Fill () is executed.

we are using:
Devart.Data: 5.0.227.0
Devart.Data.PostgreSql: 5.10.126.0
PostgreSQL 8.4

Code: Select all
CREATE TABLE table1
(
   id serial,
    PRIMARY KEY (id)
)


Use the DataSet Wizard, DataSet1 created.

Code: Select all
DataSet1 ds = new DataSet1();

try
{
   ds.table1.Fill();
}
catch (Exception ex)
{
   System.Diagnostics.Debug.WriteLine(ex.Message);
}


For System.FormatException is inside thrown, Fill() is slow.
We can not avoid the exception coding can improve performance.
t_suzuki
 
Posts: 5
Joined: Wed 06 Apr 2011 07:50
Location: Japan

Postby StanislavK » Fri 08 Apr 2011 17:06

Thank you for the report, we have reproduced the issue. We will analyze the situation and inform you about the results.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby StanislavK » Tue 19 Apr 2011 12:11

We have fixed this issue, no FormatExceptions should be thrown now (provided that no actual errors occurred). The fix is available in the new 5.10.141 version of dotConnect for PostgreSQL. The new build can be downloaded from
http://www.devart.com/dotconnect/postgresql/download.html
(the trial version) or from Registered Users' Area (for users with active subscription only):
http://secure.devart.com/

For more information about the fixes and improvements available in dotConnect for PostgreSQL 5.10.141, please refer to
http://www.devart.com/forums/viewtopic.php?t=20791
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby t_suzuki » Mon 25 Apr 2011 06:40

Thanks for the quick response.

The query performance has improved!
Personally I am glad that became clear the output window.
t_suzuki
 
Posts: 5
Joined: Wed 06 Apr 2011 07:50
Location: Japan


Return to dotConnect for PostgreSQL