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 - 15:41:03 EDT