And is the table with which you're dealing a BDB table?  MyISAM tables 
don't support transactions - only BDB tables do.

Will Stranathan

John McNally wrote:

> Are you using a version of MySQL that includes transactions?  And are
> you using a version of JDBC driver that was written to be used with a
> new version of MySQL?  I would not be surprised at all that an earlier
> driver might have hardcoded no transaction support as MySQL has only
> recently introduced them. 
> 
> Gareth Coltman wrote:
> 
>>> on 1/11/01 5:30 AM, "fanyun" <[EMAIL PROTECTED]> wrote:
>>> 
>>> 
>>>> As I know, mysql do not support transactions.
>>> 
>>> Yes it does.
>>> 
>> 
>> It seems you are right Jon. IN which cae, why doesn't the mysql jdbc driver
>> support it? Or am I being an idiot. Do I have to set autocommit to false?
>> I'm sure I've already tried this though and it made no difference. As I
>> said, the application does not raise any errors/exceptions, just ignores the
>> fact I have suspended the commit...
>> 
>> Gareth
>> 
>> ------------------------------------------------------------
>> To subscribe:        [EMAIL PROTECTED]
>> To unsubscribe:      [EMAIL PROTECTED]
>> Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
>> Problems?:           [EMAIL PROTECTED]
> 
> 
> 
> ------------------------------------------------------------
> To subscribe:        [EMAIL PROTECTED]
> To unsubscribe:      [EMAIL PROTECTED]
> Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
> Problems?:           [EMAIL PROTECTED]



------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?:           [EMAIL PROTECTED]

Reply via email to