[
https://issues.apache.org/jira/browse/DERBY-6376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kim Haase updated DERBY-6376:
-----------------------------
Attachment: DERBY-6376.zip
DERBY-6376.stat
DERBY-6376.diff
Thanks again for all the suggestions, Knut.
Attaching DERBY-6376.diff, DERBY-6376.stat, and DERBY-6376.zip, with the
following changes:
D src/ref/rrefpgc1.dita
M src/ref/rrefcrsrgpc1.dita
M src/ref/rrefdmdfns1.dita
M src/ref/refderby.ditamap
M src/ref/rrefjdbc15905.dita
D src/ref/rrefgpc1.dita
I made an additional table for getFunctionColumns that includes the columns
that still seemed useful to include (as well as for getProcedureColumns). I
hope what's there makes sense for both.
I decided not to include the info about the % wildcard, since that is actually
in the java.sql.DatabaseMetaData description, with a little more detail:
"Within a pattern String, "%" means match any substring of 0 or more
characters, and "_" means match any one character." I hope we also support the
underscore?
I removed the shortdesc element from the last topic in the group and made it a
paragraph, so that the topic list in the main topic looks consistent.
Thanks for any comments!
> Revise DatabaseMetaData section of Reference Manual
> ---------------------------------------------------
>
> Key: DERBY-6376
> URL: https://issues.apache.org/jira/browse/DERBY-6376
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.10.1.1
> Reporter: Kim Haase
> Priority: Minor
> Attachments: DERBY-6376.diff, DERBY-6376.stat, DERBY-6376.zip
>
>
> In a comment on DERBY-6369, Knut Anders Hatlen suggests that the topic
> "Parameters to getProcedureColumns"
> (http://db.apache.org/derby/docs/10.10/ref/rrefpgc1.html) might be removed.
> The purpose of the topics under "JDBC Reference" is to provide Derby-specific
> implementation information. In this topic, however, the Derby-specific
> information seems to apply to other methods as well: the information on
> catalogs and the information on name patterns.
> It may be that another topic in the same section,
> "java.sql.DatabaseMetaData.getProcedureColumns method"
> (http://db.apache.org/derby/docs/10.10/ref/rrefgpc1.html), could also be
> removed. Derby presumably supports other DatabaseMetaData methods that are
> not mentioned, such as getFunctionColumns and, more recently, getAttributes
> (of UDTS) and getUDTs. Why mention this one only?
> The topic "Columns in the ResultSet returned by getProcedureColumns"
> (http://db.apache.org/derby/docs/10.10/ref/rrefcrsrgpc1.html) does contain
> Derby-specific information, listing a couple of columns that are not listed
> in the Java SE documentation on this method (see
> http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html). So
> this topic needs to be retained.
> Some information could be added to the top-level "java.sql.DatabaseMetaData
> interface" topic
> (http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html)
> about needing to specify null for catalog columns and perhaps about using the
> "%" wildcard to obtain a list of all items in a particular namePattern field.
> Let me know if these changes don't make sense.
--
This message was sent by Atlassian JIRA
(v6.1#6144)
