We are working on a Java web application and are thinking about using
InnoDB. Does anybody know any hosting companies in the US/Canada that
support InnoDB table types in MySQL. Most that I have checked with don't.
--
Kevin McBrearty
ATG Automation Technologies Group Ltd
to the server directly (SET AUTOCOMMIT=0,
BEGIN, COMMIT,
ROLLBACK) using TSQLConnection.Execute but this does not work (although the
Delphi Help seems to indicate that it should).
Has anyone succeeded in getting MySQL transaction support to work in either
Delphi or Kylix using DbExpress ?
Kevin McBrearty
The problem is that Kylix does not yet support libmysqlclient.so.10, only
libmysqlclient.so.6. You only have to replace the client libs. I used the
ones from 3.22.32 and they work fine.
Kevin McBrearty
ATG Automation Technologies Group Ltd.
-Original Message-
From: Bagi kos [mailto
, etc.).
I am leaning toward InnoDB at this point but was wondering if anyone could
offer any information, other than what is in the manual, regarding the pros
and cons of these table types.
TIA
Kevin McBrearty
ATG Automation Technologies Group Ltd
Absolutely. I am using BDB tables and accessing them through mm.mysql JDBC.
In a way I'm relieved; for a while there I thought I was losing my ability
to read and understand a good technical book...
Kevin McBrearty
ATG Automation Technologies Group Ltd.
-Original Message-
From: Paul
Absolutely. I am using BDB tables and accessing them through mm.mysql JDBC.
In a way I'm relieved; for a while there I thought I was losing my ability
to read and understand a good technical book...
Kevin McBrearty
ATG Automation Technologies Group Ltd.
-Original Message-
From: Paul
deleting row by row (DELETE FROM tbl_name WHERE...). Shouldn't the
sequence be preserved, i.e. if the last record in the table has value 43 and
I delete it, shouldn't the next record get 44 ?
I am running 3.23.37 on Suse 7.0
Thanks.
Kevin McBrearty
ATG Automation Technologies Group Ltd