PgSqlDataReader throwing a System.FormatException

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
t_suzuki
Posts: 5
Joined: Wed 06 Apr 2011 07:50
Location: Japan

PgSqlDataReader throwing a System.FormatException

Post by 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.

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by 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

Post by 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/postgr ... nload.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

t_suzuki
Posts: 5
Joined: Wed 06 Apr 2011 07:50
Location: Japan

Post by 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.

Post Reply