Darin Ohashi wrote:
>>As I've mention before they _are_ supported and as _per standard_.
>>The standard allows implementations to provide a higher
>>isolation level
>>in place of any lower level that is not implemented.
>>
>
>
> With 7.3.3, if you try to set the isolation level to
> TRANSACTION_READ_UNCOMMITTED or TRANSACTION_REPEATABLE_READ an exception is
> raised. For these levels to be supported shouldn't the driver accept them and
> set the actual level to the higher one?
>
Yes, the JDBC standard assumes the SQL standard, so to be JDBC compliant
one is assumed to be SQL compliant as well.
We could do this in the driver to make it for the older backends (we are
going to support 7.3 and 7.2 in the 74 driver still). On the other
hand, people using 7.3 backends have other non-SQL compliances that we
cannot mask with the driver, so I wonder if this is worthy of the extra
if statement. But that is for Barry and Dave to decide, if someone
submits a patch.
Regards,
Fernando
--
Fernando Nasser
Red Hat Canada Ltd. E-Mail: fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9