Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 54337 invoked from network); 3 Sep 2006 05:40:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 3 Sep 2006 05:40:34 -0000 Received: (qmail 80611 invoked by uid 500); 3 Sep 2006 05:40:34 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 80590 invoked by uid 500); 3 Sep 2006 05:40:34 -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 80579 invoked by uid 99); 3 Sep 2006 05:40:34 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 02 Sep 2006 22:40:34 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS X-Spam-Check-By: apache.org Received: from [192.87.106.226] (HELO ajax.apache.org) (192.87.106.226) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 02 Sep 2006 22:40:33 -0700 Received: from ajax.apache.org (localhost [127.0.0.1]) by ajax.apache.org (Postfix) with ESMTP id 6F0616ACA9 for ; Sun, 3 Sep 2006 06:40:12 +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: Sun, 03 Sep 2006 05:40:12 -0000 Message-ID: <20060903054012.18956.44536@ajax.apache.org> Subject: [Db-derby Wiki] Update of "ReferenceManualTenTwo" by MamtaSatoor X-Virus-Checked: Checked by ClamAV on apache.org 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 MamtaSatoor: http://wiki.apache.org/db-derby/ReferenceManualTenTwo ------------------------------------------------------------------------------ ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment''' ||'''Resolution''' || || || || || || || - ||Derby database connection URL syntax || [http://db.apache.org/derby/docs/10.2/ref/ref-single.html#N2D4F2] || Mamta || The syntax of the database connection URL shows databasename as optional. Is that correct? I tried following in ij connect 'jdbc:derby:'; and got exception ERROR XJ004: Database '' not found. || || + ||Derby database connection URL syntax || [http://db.apache.org/derby/docs/10.2/ref/ref-single.html#N2D4F2] || Mamta || The syntax of the database connection URL shows databasename as optional. Is that correct? I tried following in ij connect 'jdbc:derby:'; and got exception ERROR XJ004: Database '' not found. Actually, further reading of the reference manual shows this is not an issue. It is possible to not specify the databasename in the url and specify the database name information through a Properties object. This is covered in [http://db.apache.org/derby/docs/10.2/ref/rrefattrib17246.html] || || ||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. || || ||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. || || ||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 || ||