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