RE: DbMerger/MySQL compatibility

From: Scott Anderson (sanderso..irvana.com)
Date: Fri Sep 12 2008 - 16:06:21 EDT

  • Next message: Stephen Winnall: "Cayenne, XML objects and JDBC 4"

    Disregard the previous email, I spoke too soon. This is looking like a
    bug in the MySQL/J driver; it's reporting the field as nullable when it
    isn't.

    -----Original Message-----
    From: Scott Anderson [mailto:sanderso..irvana.com]
    Sent: Friday, September 12, 2008 3:40 PM
    To: use..ayenne.apache.org
    Subject: RE: DbMerger/MySQL compatibility

    In DbLoader.java, circa line 380, there is a reference to the NULLABLE
    field. In the ResultSet I'm looking at, there's no such field - there is
    however an IS_NULLABLE field.

    -----Original Message-----
    From: Tore Halset [mailto:halse..vv.ntnu.no]
    Sent: Thursday, August 28, 2008 3:19 PM
    To: use..ayenne.apache.org
    Subject: 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 : Fri Sep 12 2008 - 16:07:37 EDT