You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by ch...@apache.org on 2013/10/30 15:12:31 UTC
svn commit: r1537098 - in /db/derby/docs/branches/10.10/src:
adminguide/cadminappsclientdiffs.dita adminguide/cadminappsjdbcdiffs.dita
adminguide/derbyadmin.ditamap adminguide/radminappsresultsetdiffs.dita
ref/rrefjdbc27734.dita ref/rrefjdbc40794.dita
Author: chaase3
Date: Wed Oct 30 14:12:31 2013
New Revision: 1537098
URL: http://svn.apache.org/r1537098
Log:
DERBY-6389 Update adminguide's list of differences between client and embedded
Merged DERBY-6389.diff to 10.10 doc branch from trunk revision 1537081.
Modified:
db/derby/docs/branches/10.10/src/adminguide/cadminappsclientdiffs.dita
db/derby/docs/branches/10.10/src/adminguide/cadminappsjdbcdiffs.dita
db/derby/docs/branches/10.10/src/adminguide/derbyadmin.ditamap
db/derby/docs/branches/10.10/src/adminguide/radminappsresultsetdiffs.dita
db/derby/docs/branches/10.10/src/ref/rrefjdbc27734.dita
db/derby/docs/branches/10.10/src/ref/rrefjdbc40794.dita
Modified: db/derby/docs/branches/10.10/src/adminguide/cadminappsclientdiffs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.10/src/adminguide/cadminappsclientdiffs.dita?rev=1537098&r1=1537097&r2=1537098&view=diff
==============================================================================
--- db/derby/docs/branches/10.10/src/adminguide/cadminappsclientdiffs.dita (original)
+++ db/derby/docs/branches/10.10/src/adminguide/cadminappsclientdiffs.dita Wed Oct 30 14:12:31 2013
@@ -29,12 +29,7 @@ driver and the network client driver. No
differences that have not yet been identified. Some differences with the network
client may be changed in future releases to match the embedded driver functionality.<ul>
<li>Error messages and SQLStates can differ between the network client and
-embedded driver. Some SQLStates may be null when using the network client,
-particularly for data conversion errors.</li>
-<li>Multiple SQL exceptions and warnings will only return the SQLState of
-the first exception when using the network client. The text of the additional
-exceptions will be appended to the text of the first exception. See <xref
-href="radminapps811974.dita#radminapps811974"></xref>.</li>
+embedded driver.</li>
<li>Treatment of error situations encountered during batch processing with java.sql.Statement, java.sql.PreparedStatement and java.sql.CallableStatement is different. With the embedded driver processing stops when an error is encountered; with the network client driver processing continues, but an appropriate value as defined in the java.sql.Statement api is returned in the resulting update count array.</li>
<li>To use an encrypted user id and password, you need to have the IBM's Java
Cryptography Extension (JCE) Version 1.2.1 or later.</li>
Modified: db/derby/docs/branches/10.10/src/adminguide/cadminappsjdbcdiffs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.10/src/adminguide/cadminappsjdbcdiffs.dita?rev=1537098&r1=1537097&r2=1537098&view=diff
==============================================================================
--- db/derby/docs/branches/10.10/src/adminguide/cadminappsjdbcdiffs.dita (original)
+++ db/derby/docs/branches/10.10/src/adminguide/cadminappsjdbcdiffs.dita Wed Oct 30 14:12:31 2013
@@ -18,29 +18,25 @@ See the License for the specific languag
limitations under the License.
-->
<concept id="cadminappsjdbcdiffs" xml:lang="en-us">
-<title>Differences in JDBC 3.0 methods</title>
+<title>Differences in JDBC methods</title>
+<shortdesc>A few JDBC methods behave differently with the embedded driver from
+the way they behave with the client driver.</shortdesc>
<prolog><metadata>
-<keywords><indexterm>JDBC 3.0 methods<indexterm>differences with embedded
-driver</indexterm></indexterm></keywords>
+<keywords><indexterm>JDBC methods<indexterm>differences with embedded
+and client driver</indexterm></indexterm></keywords>
</metadata></prolog>
<conbody>
-<p>The following JDBC 3.0 methods are supported only with the
-<ph conref="../conrefs.dita#prod/productshortname"></ph> embedded driver.
-Attempts to call these methods with the network client driver will result in
-a "not implemented" error.
-</p>
+<p>These methods are as follows:</p>
<pre>
Connection.prepareStatement(String sql, String[] columnNames)
Connection.prepareStatement(String sql, int[] columnIndexes)
-Statement.execute(String sql, String[] columNames)
-Statement.execute(String sql, int[] columIndexes)
+Statement.execute(String sql, String[] columnNames)
+Statement.execute(String sql, int[] columnIndexes)
Statement.executeUpdate(String sql, String[] columnNames)
Statement.executeUpdate(String sql, int[] columnIndexes)
</pre>
-<p>For more on the use of these methods, see the sections "java.sql.Connection
-interface: supported JDBC 3.0 methods", "java.sql.Statement interface:
-supported JDBC 3.0 methods", and "Autogenerated keys" in the
+<p>The differences in behavior are described in "Autogenerated keys" in the
<ph conref="../conrefs.dita#pub/citref"></ph>.</p>
</conbody>
</concept>
Modified: db/derby/docs/branches/10.10/src/adminguide/derbyadmin.ditamap
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.10/src/adminguide/derbyadmin.ditamap?rev=1537098&r1=1537097&r2=1537098&view=diff
==============================================================================
--- db/derby/docs/branches/10.10/src/adminguide/derbyadmin.ditamap (original)
+++ db/derby/docs/branches/10.10/src/adminguide/derbyadmin.ditamap Wed Oct 30 14:12:31 2013
@@ -242,8 +242,6 @@ Server">
</topicref>
<topicref href="radminappsresultsetdiffs.dita" navtitle="Updatable Result Sets">
</topicref>
-<topicref href="radminapps811974.dita" navtitle="Error message differences">
-</topicref>
<topicref collection-type="family" href="cadminapps49914.dita" navtitle="User authentication differences">
<topicref href="cadminapps811631.dita" navtitle="Network Server user authentication when user authentication is on in Derby">
</topicref>
@@ -252,7 +250,7 @@ in Derby"></topicref>
<topicref href="cadminapps811695.dita" navtitle="Enabling the encrypted user ID and password security mechanism">
</topicref>
</topicref>
-<topicref href="cadminappsjdbcdiffs.dita" navtitle="Differences in JDBC 3.0 methods">
+<topicref href="cadminappsjdbcdiffs.dita" navtitle="Differences in JDBC methods">
</topicref>
<topicref href="cadminappsdiffsreadonly.dita" navtitle="Differences using the Connection.setReadOnly method">
</topicref>
Modified: db/derby/docs/branches/10.10/src/adminguide/radminappsresultsetdiffs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.10/src/adminguide/radminappsresultsetdiffs.dita?rev=1537098&r1=1537097&r2=1537098&view=diff
==============================================================================
--- db/derby/docs/branches/10.10/src/adminguide/radminappsresultsetdiffs.dita (original)
+++ db/derby/docs/branches/10.10/src/adminguide/radminappsresultsetdiffs.dita Wed Oct 30 14:12:31 2013
@@ -25,51 +25,12 @@ functionality of updatable result sets i
embedded environment are similar, with the exception of the following
differences:</p>
<ul>
-<li>The Network Client requires that there be at least one column in the select
-list from the target table. For example, the following statement will fail
-in a server environment:<codeblock>select 1, 2 from t1 for update of c11</codeblock>The
-Network Client driver looks at both of the columns in the select list and
-cannot determine the target table for update/delete by looking at the column
-metadata. This requirement is not necessary in an embedded environment.</li>
<li>The embedded driver allows for statement name changes when there is an
open result set on the statement object. This is not supported in a server
environment.</li>
+<li>Use of the <codeph>updateBytes</codeph> method on the CHAR, VARCHAR, and
+LONG VARCHAR datatypes is supported in an embedded environment, but is not
+supported in a server environment.</li>
</ul>
-<p>Other differences between updatable result sets in a server or embedded
-environment can be found in the following table.</p>
-<table>
-<title>Comparison of updatable result sets features in server and embedded
-environments</title>
-<desc>This table lists the support for updatable result sets features in server and embedded environments.</desc>
-<tgroup cols="3" colsep="1" rowsep="1">
-<colspec colname="col0" colnum="1" colwidth="40*"/>
-<colspec colname="col1" colnum="2" colwidth="30*"/>
-<colspec colname="col2" colnum="3" colwidth="30*"/>
-<thead>
-<row valign="bottom">
-<entry colname="col0">Feature</entry>
-<entry colname="col1">Embedded Environment</entry>
-<entry colname="col2">Server Environment</entry>
-</row>
-</thead>
-<tbody>
-<row>
-<entry colname="col0">updateBytes on CHAR, VARCHAR, LONG VARCHAR datatypes</entry>
-<entry colname="col1">Supported</entry>
-<entry colname="col2">Not supported</entry>
-</row>
-<row>
-<entry colname="col0">updateTime on TIMESTAMP datatypes</entry>
-<entry colname="col1">Supported</entry>
-<entry colname="col2">Not supported</entry>
-</row>
-<row>
-<entry colname="col0">updateClob and updateBlob</entry>
-<entry colname="col1">Supported</entry>
-<entry colname="col2">Not supported</entry>
-</row>
-</tbody>
-</tgroup>
-</table>
</conbody>
</concept>
Modified: db/derby/docs/branches/10.10/src/ref/rrefjdbc27734.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.10/src/ref/rrefjdbc27734.dita?rev=1537098&r1=1537097&r2=1537098&view=diff
==============================================================================
--- db/derby/docs/branches/10.10/src/ref/rrefjdbc27734.dita (original)
+++ db/derby/docs/branches/10.10/src/ref/rrefjdbc27734.dita Wed Oct 30 14:12:31 2013
@@ -81,14 +81,14 @@ specific to <ph conref="../conrefs.dita#
<entry colname="2"><i>prepareStatement(String sql, int [] columnIndexes)</i></entry>
<entry colname="3">Every column index in the array must correlate to an
<xref href="rrefsqlj37836.dita#rrefsqlj37836">auto-increment</xref>
-column within the target table of the INSERT. Supported in embedded mode only.</entry>
+column within the target table of the INSERT.</entry>
</row>
<row>
<entry colname="1"><i>PreparedStatement</i></entry>
<entry colname="2"><i>prepareStatement(String sql, String [] columnNames)</i></entry>
<entry colname="3">Every column name in the array must designate an
<xref href="rrefsqlj37836.dita#rrefsqlj37836">auto-increment</xref>
-column within the target table of the INSERT. Supported in embedded mode only.</entry>
+column within the target table of the INSERT.</entry>
</row>
</tbody>
</tgroup>
Modified: db/derby/docs/branches/10.10/src/ref/rrefjdbc40794.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.10/src/ref/rrefjdbc40794.dita?rev=1537098&r1=1537097&r2=1537098&view=diff
==============================================================================
--- db/derby/docs/branches/10.10/src/ref/rrefjdbc40794.dita (original)
+++ db/derby/docs/branches/10.10/src/ref/rrefjdbc40794.dita Wed Oct 30 14:12:31 2013
@@ -57,28 +57,28 @@ function. Otherwise this method returns
<entry colname="2"><i>execute(String sql, int [] columnIndexes)</i></entry>
<entry colname="3">Every column index in the array must correlate to an
<xref href="rrefsqlj37836.dita#rrefsqlj37836">auto-increment</xref>
-column within the target table of the INSERT. Supported in embedded mode only.</entry>
+column within the target table of the INSERT.</entry>
</row>
<row>
<entry colname="1"><i>boolean</i></entry>
<entry colname="2"><i>execute(String sql, String [] columnNames)</i></entry>
<entry colname="3">Every column name in the array must designate an
<xref href="rrefsqlj37836.dita#rrefsqlj37836">auto-increment</xref>
-column within the target table of the INSERT. Supported in embedded mode only.</entry>
+column within the target table of the INSERT.</entry>
</row>
<row>
<entry colname="1"><i>int</i></entry>
<entry colname="2"><i>executeUpdate(String sql, int [] columnIndexes)</i></entry>
<entry colname="3">Every column index in the array must correlate to an
<xref href="rrefsqlj37836.dita#rrefsqlj37836">auto-increment</xref>
-column within the target table of the INSERT. Supported in embedded mode only.</entry>
+column within the target table of the INSERT.</entry>
</row>
<row>
<entry colname="1"><i>int</i></entry>
<entry colname="2"><i>executeUpdate(String sql, String [] columnNames)</i></entry>
<entry colname="3">Every column name in the array must designate an
<xref href="rrefsqlj37836.dita#rrefsqlj37836">auto-increment</xref>
-column within the target table of the INSERT. Supported in embedded mode only.</entry>
+column within the target table of the INSERT.</entry>
</row>
</tbody>
</tgroup>