Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 25465 invoked from network); 5 Oct 2006 20:01:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 5 Oct 2006 20:01:16 -0000 Received: (qmail 3193 invoked by uid 500); 5 Oct 2006 20:01:16 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 3174 invoked by uid 500); 5 Oct 2006 20:01:16 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 3163 invoked by uid 99); 5 Oct 2006 20:01:15 -0000 Received: from idunn.apache.osuosl.org (HELO idunn.apache.osuosl.org) (140.211.166.84) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Oct 2006 13:01:15 -0700 X-ASF-Spam-Status: No, hits=0.0 required=5.0 tests= Received: from [192.87.106.226] ([192.87.106.226:36299] helo=ajax.apache.org) by idunn.apache.osuosl.org (ecelerity 2.1.1.8 r(12930)) with ESMTP id 22/99-04543-68465254 for ; Thu, 05 Oct 2006 13:01:11 -0700 Received: from ajax.apache.org (localhost [127.0.0.1]) by ajax.apache.org (Postfix) with ESMTP id 50BFF6ACAA for ; Thu, 5 Oct 2006 21:01:07 +0100 (BST) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: Apache Wiki To: derby-commits@db.apache.org Date: Thu, 05 Oct 2006 20:01:07 -0000 Message-ID: <20061005200107.10093.25332@ajax.apache.org> Subject: [Db-derby Wiki] Trivial Update of "ReferenceManualTenTwo" by LauraStewart X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Dear Wiki user, You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification. The following page has been changed by LauraStewart: http://wiki.apache.org/db-derby/ReferenceManualTenTwo ------------------------------------------------------------------------------ ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment''' ||'''Resolution''' || || || || || || || - ||java.sql.Blob and java.sql.Clob || [http://db.apache.org/derby/docs/10.2/ref/rrefjdbc96386.html] || Mamta || This section has a table titled Table 1. JDBC 2.0 java.sql.Blob Methods Supported. The first row, 3rd column of this table shows up empty in the html page but has an ' in the pdf format. The pdf format should also show the column empty. I think this happens for all the tables with no data in the pdf format || || + ||java.sql.Blob and java.sql.Clob || [http://db.apache.org/derby/docs/10.2/ref/rrefjdbc96386.html] || Mamta || This section has a table titled Table 1. JDBC 2.0 java.sql.Blob Methods Supported. The first row, 3rd column of this table shows up empty in the html page but has an ' in the pdf format. The pdf format should also show the column empty. I think this happens for all the tables with no data in the pdf format || Derby-1932 has been opened for this issue. https://issues.apache.org/jira/browse/DERBY-1932 || - ||DatabaseMetaData functionality not supported || [http://db.apache.org/derby/docs/10.2/ref/ref-single.html#N2E3A9] || Mamta || This section says that getColumnPrivileges and getTablePrivileges are not supported. But checkin r381109 has changes to metadata.properties for these 2 functions. So, looks like these methods are probably now supported with grant revoke functionality. || || + ||DatabaseMetaData functionality not supported || [http://db.apache.org/derby/docs/10.2/ref/ref-single.html#N2E3A9] || Mamta || This section says that getColumnPrivileges and getTablePrivileges are not supported. But checkin r381109 has changes to metadata.properties for these 2 functions. So, looks like these methods are probably now supported with grant revoke functionality. || Derby-1932 has been opened for this issue. https://issues.apache.org/jira/browse/DERBY-1932 || - || Data streaming || ^(1)^[http://db.apache.org/derby/docs/dev/ref/rrefjavsqlprst.html][[BR]] ^(2)^[http://db.apache.org/derby/docs/dev/ref/rrefjavsqlrssc.html][[BR]] ^(3)^[http://db.apache.org/derby/docs/dev/ref/crefjavbclobnot.html] [[BR]] ^(4)^[http://db.apache.org/derby/docs/dev/ref/rrefjdbc4_0summary.html]|| Kristian ||(1): Rewrite section to reflect a newer JDBC version than 1.2? Comment that getUnicodeStream is deprecated and no longer implemented in Derby. Add description of getCharacterStream. Could also add info about setNCharacterStream, which is JDBC 4 only and not supported. The note under the table is no longer accurate; it only applies when using the client driver (and also only for the client?).[[BR]](2): OK [[BR]] (3): Update list of methods (mark as deprecated, add getCharacterStream). [[BR]](4): OK.|| || + || Data streaming || ^(1)^[http://db.apache.org/derby/docs/dev/ref/rrefjavsqlprst.html][[BR]] ^(2)^[http://db.apache.org/derby/docs/dev/ref/rrefjavsqlrssc.html][[BR]] ^(3)^[http://db.apache.org/derby/docs/dev/ref/crefjavbclobnot.html] [[BR]] ^(4)^[http://db.apache.org/derby/docs/dev/ref/rrefjdbc4_0summary.html]|| Kristian ||(1): Rewrite section to reflect a newer JDBC version than 1.2? Comment that getUnicodeStream is deprecated and no longer implemented in Derby. Add description of getCharacterStream. Could also add info about setNCharacterStream, which is JDBC 4 only and not supported. The note under the table is no longer accurate; it only applies when using the client driver (and also only for the client?).[[BR]](2): OK [[BR]] (3): Update list of methods (mark as deprecated, add getCharacterStream). [[BR]](4): OK.|| Derby-1932 has been opened for this issue. https://issues.apache.org/jira/browse/DERBY-1932 || [[Anchor(settingattr)]]'''Setting attributes for the database connection URL: ''' ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment''' ||'''Resolution''' || || || || || || || - ||Attributes of the Derby database connection URL || [http://db.apache.org/derby/docs/10.2/ref/ref-single.html#N2D6D9] || Mamta || This section has 3 examples of setting attributes on database connection URL using Java. One minor suggestion is we should use Java commenting scheme ie /*..*/ instead of -- in this sample code. || || + ||Attributes of the Derby database connection URL || [http://db.apache.org/derby/docs/10.2/ref/ref-single.html#N2D6D9] || Mamta || This section has 3 examples of setting attributes on database connection URL using Java. One minor suggestion is we should use Java commenting scheme ie /*..*/ instead of -- in this sample code. || Derby-1933 has been opened for this issue. https://issues.apache.org/jira/browse/DERBY-1933 || - || encryptionKey section under Setting attributes for the database connection URL || [http://db.apache.org/derby/docs/10.2/ref/rrefattribencryptkey.html] || Mamta || The pdf page for encryptionKey has incomplete example. The pdf page only shows jdbc:derby:newDB;create=true;dataEncryption=true;encryptionAlgorithm=DES/CBC/NoPadding; The corresponding html page shows the correct example which looks as follows jdbc:derby:newDB;create=true;dataEncryption=true;encryptionAlgorithm=DES/CBC/NoPadding;encryptionKey=6162636465666768 || || + || encryptionKey section under Setting attributes for the database connection URL || [http://db.apache.org/derby/docs/10.2/ref/rrefattribencryptkey.html] || Mamta || The pdf page for encryptionKey has incomplete example. The pdf page only shows jdbc:derby:newDB;create=true;dataEncryption=true;encryptionAlgorithm=DES/CBC/NoPadding; The corresponding html page shows the correct example which looks as follows jdbc:derby:newDB;create=true;dataEncryption=true;encryptionAlgorithm=DES/CBC/NoPadding;encryptionKey=6162636465666768 || Derby-1933 has been opened for this issue. https://issues.apache.org/jira/browse/DERBY-1933 || [[Anchor(j2eecompliance)]]'''J2EE Compliance: Java Transaction API and javax.sql Extensions: ''' ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment''' ||'''Resolution''' || - || javax.sql:JDBC Extensions || [http://db.apache.org/derby/docs/dev/ref/rrefjta18596.html HTML Url] || Susan || This URL no longer exists: (For more details about these extensions, see http://java.sun.com/products/jdbc/jdbc20.stdext.javadoc/javax/sql/package-summary.html). The page that has this information, although you have to browse to the section called JDBC 2.0 Optional Package API is http://java.sun.com/products/jdbc/download.html || As noticed above, no changes have been made to the docs. || + || javax.sql:JDBC Extensions || [http://db.apache.org/derby/docs/dev/ref/rrefjta18596.html HTML Url] || Susan || This URL no longer exists: (For more details about these extensions, see http://java.sun.com/products/jdbc/jdbc20.stdext.javadoc/javax/sql/package-summary.html). The page that has this information, although you have to browse to the section called JDBC 2.0 Optional Package API is http://java.sun.com/products/jdbc/download.html || Derby-1934 has been opened for this issue. https://issues.apache.org/jira/browse/DERBY-1934 || [[Anchor(derbyapi)]]'''Derby API: ''' @@ -108, +108 @@ ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment''' ||'''Resolution''' || || DATE, TIME and TIMESTAMP || [http://db.apache.org/derby/docs/dev/ref/rrefdttlimits.html rrefdttlimits.html] || Susan || The largest TIMESTAMP value is incorrect, [http://issues.apache.org/jira/browse/DERBY-1803 DERBY-1803] || Fixed (Laura)|| - || Numeric limitations|| [http://db.apache.org/derby/docs/dev/ref/rrefnumericlimits.html rrefnumericlimits.html] || Susan || The largest decimal precision value is incorrect, it should be 31 instead of 31,255 || No patch has been submitted and this has not been fixed as of the 10.2.1.6 RC || + || Numeric limitations|| [http://db.apache.org/derby/docs/dev/ref/rrefnumericlimits.html rrefnumericlimits.html] || Susan || The largest decimal precision value is incorrect, it should be 31 instead of 31,255 || Derby-1935 has been opened for this issue. https://issues.apache.org/jira/browse/DERBY-1935 ||