Re: meta data information returned for domains

On Fri, 3 Dec 2004, Iain wrote:

> I'm using the JDBC database metadata facilities to get information about
> tables for the purposes of auto generating program code. This has all been
> working fine until I got to testing it on a database that uses domains as
> the datatypes for the columns.
>
> I havn't had a chance to investigate it thoroughly yet, but it I'm getting a
> datatype code of 1111 when the columns datatype is a domain. , I don't know
> if this has any special meaning or not, but it doesn't correspond to any of
> the java.sql types that I was comparing it to, so for now my code is broken.


1111 = Types.OTHER.  We could consider resolving domains to their base
types and reporting that as the sql type.  That seems like it would be
helpful in this situation.

Kris Jurka