db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "ReferenceManualTenTwo" by MamtaSatoor
Date Sun, 03 Sep 2006 06:07:41 GMT
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

------------------------------------------------------------------------------
  ||[#systemtables Derby System Tables] ||Yip || ||
  ||[#exceptionmessages Derby exception messages and SQL States] || jta, Yip || ||
  ||[#jdbcref JDBC Reference] || Mamta || ||
- ||[#settingattr Setting attributes for the database connection URL] || || ||
+ ||[#settingattr Setting attributes for the database connection URL] || Mamta || ||
  ||[#j2eecompliance J2EE Compliance: Java Transaction API and javax.sql Extensions] || Susan
|| ||
  ||[#derbyapi Derby API] || || ||
  ||[#derbylimits Derby limitations] || || ||
@@ -72, +72 @@

  
  ||'''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 || ||
- ||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 || ||
  
  
  [[Anchor(settingattr)]]'''Setting attributes for the database connection URL: '''
  
  ||'''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. 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. || ||
+ || 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
+  || ||
  
  
  [[Anchor(j2eecompliance)]]'''J2EE Compliance: Java Transaction API and javax.sql Extensions:
'''

Mime
View raw message