Re: VMS x86-64 database server

On 7/10/2025 8:29 PM, Lawrence D'Oliveiro wrote:

On Thu, 10 Jul 2025 20:23:08 -0400, Arne Vajhøj wrote:

And in PHP (at least for the most common database extensions)
the developer have the choice - do they want exceptions or do
they want to test on the return status. Everybody should be happy.

 Except the default is not to raise exceptions.

The default in recent versions (and that includes all supported
versions) is exceptions.

Python makes it easy to catch exceptions. Not only that, it makes it easy
to filter the ones you want to catch, by a) subclassing so you can be more
specific, and b) if even that is not enough, you can query parameters of
the exception object and do a “raise” statement without arguments to pass
it on if your handler doesn’t want to handle it.

The ability to subclass exceptions to catch specific and the ability
to rethrow exceptions are quite common. Not Python specific at all.
Java use sub-classing extensively for database. A little simplified:
              |->SQLNonTransientException->non transient exception classses
SQLException-|
              |->SQLTransientException->transient exception classses
Arne