Web hosting for InnoDB

2002-02-13 Thread Kevin McBrearty
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

Delphi, Kylix, DbExpress, MySQL, Transactions...

2001-08-01 Thread Kevin McBrearty
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

RE: Kylix with MySQL

2001-06-25 Thread 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

InnoDB, BDB, and Gemini

2001-05-11 Thread Kevin McBrearty
, 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

RE: AUTO_INCREMENT Confusion

2001-05-08 Thread Kevin McBrearty
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

RE: AUTO_INCREMENT Confusion

2001-05-08 Thread Kevin McBrearty
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

AUTO_INCREMENT Confusion

2001-05-07 Thread Kevin McBrearty
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