Re: More to say about setTransactionIsolation and mysql?

[Ted Husted <te...@husted.com>]

The Berkley versions of the mySQL tables are suppose to support
transactions and rollback, but don't have several other features
available in the trusty myISAM tables. So that might be what you are
seeing.

I have since heard that using the Early Release rowsets for anything but
the simplest updates may be unreliable regardless of what DBMS you are
using. Seem solid on retrievals though, and that's 80% of it ...

Eventually, some other vendor will provide a better RowSet
implementation, and hopefully these problems will go away. For now, I'm
burying the fact I'm still using Statements for updates deep in my Data
Access objects, so I can switch over when that brave new day comes ;-)

-- Ted Husted, Husted dot Com, Fairport NY USA.
-- Custom Software ~ Technical Services.
-- Tel 716 737-3463.
-- http://www.husted.com/about/struts/


Cindy wrote:
> 
> Ted, while surfing for a solution to a mysql problem, I hit upon some
> email
> from you in which you wrote:
> 
> "Sadly, the current Sun implementations require transactions to update a
> JDBC table, and the (default) MySQL tables still don't support
> transactions. I tried turning transactions off
> (setTransactionIsolation(TRANSACTION_NONE), but it just laughed and
> tossed the exception anyway."
> 
> I realize that you are not in the business of providing free support,
> but hope
> you know that I appreciate any details you're willing to supply on the
> above.
> 
> I think I am encountering this problem, but don't understand why - the
> version of mysql I have is 3.23.39 for Solaris.  When I examine the
> properties
> of the driver (via Forte for Java), Transaction Support is set to True.
> Also,
> when I print out the result of getTransactionIsolation, I get "2".  So,
> it would
> seem to the uninitiated (me!) that transactions are supported by this
> version
> of MySQL.  But - I am getting the exception that you mentioned above, so
> I am misunderstanding something.
> 
> Can you elaborate on this problem - or can you steer me to some
> information?
> 
> Thanks,
>    Cindy
> 
> --
> Cindy Gold
> Conduant Corporation
> 1823 Sunset Place, Suite D
> Longmont, Colorado 80501   Tel: 303-485-2721 ext. 106