Re: What's up with this?!? Re: Another JDBC (and by extension, JDBCR4) meta-data retrieval question

On 05 Apr 2013 15:47, James H. H. Lampert wrote:

On 4/5/13 3:20 PM, CRPence wrote:

The last sentence in the following snippet of the doc for the
method may be apropos
<<SNIP>>
This method is supported only if the user has set the driver
property "extended metadata" to true.

<eyebrows crawling up forehead and down back of neck> Uh, what doc
would that be? I don't see it in the Java 5 or Java 6 Javadocs.

Fascinating. Now, I just need to figure out how to set that
property.

Normally I would have included a link, but the v6r1 and v7r1 InfoCenters were not responding when I replied; I had to retrieve that snippet from v6r4. The older documentation was not as accurate bidirectionally between the method and the class. Here is the info again, with links:

http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/rzaha/conprop.htm
IBM i 7.1 Information Center -> Programming -> Java -> IBM Developer Kit for Java -> Database access from Java programs -> Accessing your IBM i database with the Java JDBC driver -> Connections
_i JDBC driver connection properties i_
"This table contains valid JDBC driver connection properties, their values, and their descriptions.
...

Property: extended metadata
Value: true, false
Meaning: The property specifies if the driver should request extended metadata from the database. Setting this property to true increases the accuracy of the information returned from the following ResultSetMetaData methods:

* getColumnLabel(int)
* getSchemaName(int)
* getTableName(int)
* isReadOnly(int)
* isSearchable(int)
* isWriteable(int)

Setting this property to true may slow performance because it requires retrieving more information from the database.
..."

http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/rzahh/javadoc/com/ibm/as400/access/AS400JDBCResultSetMetaData.html
"com.ibm.as400.access
Class AS400JDBCResultSetMetaData
...
Method Summary
Modifier and Type Method and Description
...
String getTableName(int columnIndex)
...
..."

http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/rzahh/javadoc/com/ibm/as400/access/AS400JDBCResultSetMetaData.html#getTableName(int)
"_getTableName_

public String getTableName(int columnIndex)
throws SQLException

Returns the column's table name. This method is supported only if the user has set the driver property "extended metadata" to true.

Specified by:
getTableName in interface ResultSetMetaData

Parameters:
columnIndex - The column index (1-based).
Returns:
The base table name if the user set the driver property "extended metadata" to true and the system returns us a table name, otherwise "".
Throws:
SQLException - If the column index is not valid."

The below doc has the same deficiency as past doc, whereby the methods that require the "extended metadata property" are not properly listed:
http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/rzahh/jdbcrs.htm
IBM i 7.1 Information Center -> Programming -> Java -> IBM Toolbox for Java -> IBM Toolbox for Java classes -> Access classes -> JDBC classes
_ResultSet class_

http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/rzahh/jdbcproperties.htm#jdbcproperties__other
_extended metadata property_