Skip site navigation (1) Skip section navigation (2)

Porting and Exception handling

From: tom12167 <tom12167(at)web(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Porting and Exception handling
Date: 2007-04-07 17:47:41
Message-ID: 4617D93D.7090901@web.de (view raw or flat)
Thread:
Lists: pgsql-admin
There is a difference between PostgreSQL and other DBMSs (like MySQL and 
Oracle) that makes it difficult to to stabilize ported applications. 
When an SQLException occurs, and is caught by the application logic, the 
other DBMSs are processing the following SQL commands of the 
transaction. This makes sense because the SQLException is caught by the 
application logic.

With PostgreSQL all further SQL commands are failing because PostgreSQL 
rolls back the current transaction and makes it unusable. That means the 
application is crashing although the SQLException ist caught.

The developer  has to identify places where this could happen and change 
the code. When porting large applications this can be a very difficult. 
It would help a lot if PostgreSQL would behave like the other DBMS in 
this case.

-- tom

pgsql-admin by date

Next:From: Michael FuhrDate: 2007-04-07 17:51:00
Subject: Re: rowcount function in postgres???
Previous:From: Karthikeyan SundaramDate: 2007-04-07 17:33:19
Subject: rowcount function in postgres???

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group