Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Date: Mon, 10 Sep 2007 06:28:18 -0700
From: Rick Hillegas <Richard.Hillegas@Sun.COM>
Subject: Re: REMARKS column
In-reply-to: <595227.80688.qm@web31810.mail.mud.yahoo.com>
Sender: Richard.Hillegas@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <46E54672.4030605@sun.com>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7BIT
References: <595227.80688.qm@web31810.mail.mud.yahoo.com>
User-Agent: Thunderbird 2.0.0.6 (Macintosh/20070728)

Hi Geoff,

You're welcome to create a JIRA issue, describing this new feature. 
Instructions on how to create a JIRA can be found in the "Provide 
Feedback" section at the top of the following webpage: 
http://db.apache.org/derby/derby_comm.html At a minimum, other people 
may be able to help you brainstorm what you need here. For instance, do 
you want to set the contents of REMARKS when you create the table or do 
you want to be able to change the REMARKS dynamically at run time?

This would be a good introductory feature for someone who wants to learn 
how to extend Derby. Naturally, you're welcome to try this yourself!

Regards,
-Rick

Geoff hendrey wrote:
> Thanks for your reply. The "REMARKS" column I am interested in would 
> be the one returned in the ResultSet for getColumns().
>
> I was hoping there was a way to write content into the REMARKS for a 
> given column without having to build my own version of Derby. It seems 
> like it would be a very convenient and useful feature, to be able to 
> write the REMARKS. This could be used to annotate the columns of one's 
> data model.
>
> Is there any chance you would consider adding this as a feature? There 
> could be a system call that would allow the REMARK to be written for a 
> given column.
>
> Thanks!
> -geoff
>
>
> ===============
> Hi Geoff,
>
> Several DatabaseMetaData methods return ResultSets which have a column 
> named REMARKS. For instance, getColumns(), getTables(), and
>  
> getProcedures() return ResultSets which contain a REMARKS column. The 
> contents of these columns are determined by queries stored in the 
> following Derby source file: 
> java/engine/org/apache/derby/impl/jdbc/metadata.properties. In order to 
> change the contents of these columns, you would have to edit those 
> queries and build your own Derby engine.
>
> Hope this helps,
> -Rick
>
> Geoff hendrey wrote:
> > I want to use the REMARKS column of DatabaseMetaData to store remarks 
> > about a column.
> > I see how to retrieve the REMARKS, but how would I go about *setting* 
> > the REMARKS.
> >
> > -geoff
> >
> >
>   
>