Re: DbMerger/MySQL compatibility

From: Tore Halset (halse..vv.ntnu.no)
Date: Thu Aug 28 2008 - 15:19:21 EDT

  • Next message: Andrus Adamchik: "Re: DbMerger/MySQL compatibility"

    On Aug 28, 2008, at 21:03, Scott Anderson wrote:

    >> Is it possible to detect this via jdbc?
    >
    > A rather long-winded way to detect table type is:
    > SHOW CREATE TABLE [table name];
    >
    > This will return the full CREATE TABLE instruction required to rebuild
    > that table. If this is already how you determine what the fields look
    > like, it should be trivial to add logic to parse the ENGINE parameter.

    Currently, I use jdbc metadata only.

      - Tore.

    This archive was generated by hypermail 2.0.0 : Thu Aug 28 2008 - 15:17:56 EDT