java.sql.Connection interface: supported JDBC 2.0 methods (rrefjdbc80004.dita): remove? It appears that the implementation notes are no longer valid. They state that ResultSet.TYPE_SCROLL_SENSITIVE is not supported and that if you specify it, "Derby issues an SQLWarning". However, I tried this and no warning seemed to be issued.

java.sql.ResultSet interface: supported JDBC 2.0 methods (rrefjdbc77156.dita): remove, after adding implementation notes to the topic "java.sql.ResultSet interface" (http://db.apache.org/derby/docs/dev/ref/rrefjdbc23502.html), assuming they are still valid. (Removing this file will allow us to resolve DERBY-2993, "Duplicated description of java.sql.ResultSet#beforeFirst() is written in reference manual".)

Activity

Some additional notes: In rrefjdbc23502.dita ("java.sql.ResultSet interface"), I think it makes sense to remove the following sentence:

"Derby provides all the required JDBC 1.2 type conversions of the getXXX methods."

In rrefjdbc59162.dita, the implementation note on the setMaxFieldSize method can be removed: "Has no effect on Blobs and Clobs." The Javadoc for the method states explicitly what types the method applies to, and it omits BLOBs and CLOBs.

Kim Haase
added a comment - 12/Feb/08 20:30 Some additional notes: In rrefjdbc23502.dita ("java.sql.ResultSet interface"), I think it makes sense to remove the following sentence:
"Derby provides all the required JDBC 1.2 type conversions of the getXXX methods."
In rrefjdbc59162.dita, the implementation note on the setMaxFieldSize method can be removed: "Has no effect on Blobs and Clobs." The Javadoc for the method states explicitly what types the method applies to, and it omits BLOBs and CLOBs.

Correction: Instead of modifying rrefjdbc59162.dita to be a general "java.sql.Statement interface" topic, the still-current information needs to be added to the existing "java.sql.Statement interface" topic, rrefjdbc40794.dita. I lost track of it because it's out of alphabetical order. Putting the topics in alphabetical order is yet another subtask.

Kim Haase
added a comment - 12/Feb/08 20:40 Correction: Instead of modifying rrefjdbc59162.dita to be a general "java.sql.Statement interface" topic, the still-current information needs to be added to the existing "java.sql.Statement interface" topic, rrefjdbc40794.dita. I lost track of it because it's out of alphabetical order. Putting the topics in alphabetical order is yet another subtask.

Two of the JDBC 2.0 files to be removed are cross-referenced from the topic rrefjdbc96386.dita, "Mapping of java.sql.Blob and java.sql.Clob interfaces". I will remove these cross-references. Other changes to rrefjdbc96386.dita can be part of another subtask.

Kim Haase
added a comment - 12/Feb/08 20:58 Two of the JDBC 2.0 files to be removed are cross-referenced from the topic rrefjdbc96386.dita, "Mapping of java.sql.Blob and java.sql.Clob interfaces". I will remove these cross-references. Other changes to rrefjdbc96386.dita can be part of another subtask.

Attaching a patch, DERBY-3409.diff, that removes the 8 JDBC 2.0 topics and modifies three more topics, by moving implementation-specific material into them. I would be very grateful if someone familiar with our current JDBC implementation would review the three modified topics to determine whether the implementation-specific material is still correct as of JDBC 3 and 4. The modified topics are in DERBY-3409.zip.

rrefjdbc96386.dita (Mapping of java.sql.Blob and java.sql.Clob interfaces): Remove mention of JDBC 2.0. Explain that Derby implements the Blob and Clob interfaces using locators and does not materialize LOBs when you use getBlob and getClob on ResultSets. Remove bullet list of Blob and Clob features; state only what is specific to the Derby implementation (the CallableStatement limitations). Remove mention of other SQL data types (irrelevant to this topic). Clarify the use of getBlob and getClob. Remove bullet item about static methods. Update the information about CLOB implementation. Revise tables to provide only implementation notes where needed.

Also added updated versions of rrefjdbc20485.dita (java.sql.CallableStatement interface), rrefjdbc29874.dita (java.sql.PreparedStatement interface), and rrefjavsqlprst.dita (Prepared statements and streaming columns), all of which contained old (JDBC 1.2) information.

Kim Haase
added a comment - 17/Apr/08 22:05 Here is a revised patch: DERBY-3409 -2.diff, DERBY-3409 -2.zip, and DERBY-3409 -2.stat.
Correspondence with Lance Andersen (JDBC expert) and Rick Hillegas, along with an examination of the source code for Derby's JDBC implementation, has resulted in the following additional changes.
rrefjdbc40794.dita (java.sql.Statement): Remove mention of JDBC 1.2. Also, the setEscapeProcessing and cancel methods are still not implemented, but all the others are supported.
rrefjdbc23502.dita (java.sql.ResultSet): Remove table row for setFetchSize; the implementation seems to allow for fetch sizes greater than 1.
rrefjdbc96386.dita (Mapping of java.sql.Blob and java.sql.Clob interfaces): Remove mention of JDBC 2.0. Explain that Derby implements the Blob and Clob interfaces using locators and does not materialize LOBs when you use getBlob and getClob on ResultSets. Remove bullet list of Blob and Clob features; state only what is specific to the Derby implementation (the CallableStatement limitations). Remove mention of other SQL data types (irrelevant to this topic). Clarify the use of getBlob and getClob. Remove bullet item about static methods. Update the information about CLOB implementation. Revise tables to provide only implementation notes where needed.
Also added updated versions of rrefjdbc20485.dita (java.sql.CallableStatement interface), rrefjdbc29874.dita (java.sql.PreparedStatement interface), and rrefjavsqlprst.dita (Prepared statements and streaming columns), all of which contained old (JDBC 1.2) information.
Please let me know if further corrections are needed.

Kim Haase
added a comment - 06/May/08 21:44 Checked with Lance Andersen, who recommended that the patch be committed. Any fixes needed can be made later.
Committed DERBY-3409 -2.diff to docs trunk at revision 653913.