You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-user@db.apache.org by watch sound <wa...@gmail.com> on 2008/02/27 00:57:18 UTC
can not get column description
I need to get column description from ddlUtils.
I used mssqlserver jdbc jar included with ddlUtils.
but aColumn.getDescription() always return null.
any idea? Thanks in advance
hanning
--
View this message in context: http://www.nabble.com/can-not-get-column-description-tp15703029p15703029.html
Sent from the Apache DdlUtils - User mailing list archive at Nabble.com.
Re: can not get column description
Posted by watch sound <wa...@gmail.com>.
Thank you,Thomas!
How about oracle?
I added the comments to the table using
comment on table some_table is 'some comments';
but when I try to get table description for this table, DdlUtils returns
null?
Any idea how to get table description through DdlUtils? (for Oracle)
Thanks!
Hanning
Thomas Dudziak wrote:
>
> On Tue, Feb 26, 2008 at 3:57 PM, watch sound <wa...@gmail.com> wrote:
>
>> I need to get column description from ddlUtils.
>
> I don't think the Microsoft Sql Server JDBC driver supports column
> descriptions set via sp_addextendedproperty (into the property
> MS_Description) so the standard JDBC metadata does not work and
> DdlUtils will have to add special support via fn_listextendedproperty.
> Please add an issue for that in DdlUtils' JIRA.
>
>> I used mssqlserver jdbc jar included with ddlUtils.
>> but aColumn.getDescription() always return null.
>
> DdlUtils does not come with any JDBC driver, so I'm not sure what
> driver you are referring to. But as I said, the Sql Server 2005 JDBC
> driver does not seem to support this anyways.
>
> Tom
>
>
--
View this message in context: http://www.nabble.com/can-not-get-column-description-tp15703029p15768991.html
Sent from the Apache DdlUtils - User mailing list archive at Nabble.com.
Re: can not get column description
Posted by Thomas Dudziak <to...@gmail.com>.
On Tue, Feb 26, 2008 at 3:57 PM, watch sound <wa...@gmail.com> wrote:
> I need to get column description from ddlUtils.
I don't think the Microsoft Sql Server JDBC driver supports column
descriptions set via sp_addextendedproperty (into the property
MS_Description) so the standard JDBC metadata does not work and
DdlUtils will have to add special support via fn_listextendedproperty.
Please add an issue for that in DdlUtils' JIRA.
> I used mssqlserver jdbc jar included with ddlUtils.
> but aColumn.getDescription() always return null.
DdlUtils does not come with any JDBC driver, so I'm not sure what
driver you are referring to. But as I said, the Sql Server 2005 JDBC
driver does not seem to support this anyways.
Tom