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 jt...@apache.org on 2005/06/20 20:06:47 UTC
svn commit: r191526 - in /incubator/derby/docs/trunk/src/adminguide:
cadminapps.dita derbyadmin.ditamap radminappsresultsetdiffs.dita
Author: jta
Date: Mon Jun 20 11:06:46 2005
New Revision: 191526
URL: http://svn.apache.org/viewcvs?rev=191526&view=rev
Log:
DERBY-370 Applied Jeff Levitt's patch that documents the differences between
Embedded and Network Server for Updatable ResultSets.
Added:
incubator/derby/docs/trunk/src/adminguide/radminappsresultsetdiffs.dita
Modified:
incubator/derby/docs/trunk/src/adminguide/cadminapps.dita
incubator/derby/docs/trunk/src/adminguide/derbyadmin.ditamap
Modified: incubator/derby/docs/trunk/src/adminguide/cadminapps.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/adminguide/cadminapps.dita?rev=191526&r1=191525&r2=191526&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/adminguide/cadminapps.dita (original)
+++ incubator/derby/docs/trunk/src/adminguide/cadminapps.dita Mon Jun 20 11:06:46 2005
@@ -1,4 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE concept PUBLIC "-//IBM//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
<!--
Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
@@ -14,9 +16,6 @@
See the License for the specific language governing permissions and
limitations under the License.
-->
-
-<!DOCTYPE concept PUBLIC "-//IBM//DTD DITA Concept//EN"
- "../dtd/concept.dtd">
<concept id="cadminapps" xml:lang="en-us">
<title>Differences between running Derby in embedded mode and using the network
server</title>
@@ -25,8 +24,9 @@
in</indexterm></indexterm></keywords>
</metadata></prolog>
<conbody>
-<p>This section contains information on the differences between running <ph conref="adminconrefs.dita#prod/productshortname"></ph>
-in embedded mode and using the Network Server.</p>
+<p>This section contains information on the differences between running <ph
+conref="adminconrefs.dita#prod/productshortname"></ph> in embedded mode and
+using the Network Server. Note that there may be undocumented differences
+that have not yet been identified.</p>
</conbody>
</concept>
-
Modified: incubator/derby/docs/trunk/src/adminguide/derbyadmin.ditamap
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/adminguide/derbyadmin.ditamap?rev=191526&r1=191525&r2=191526&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/adminguide/derbyadmin.ditamap (original)
+++ incubator/derby/docs/trunk/src/adminguide/derbyadmin.ditamap Mon Jun 20 11:06:46 2005
@@ -110,6 +110,7 @@
</topicref>
<topicref href="cadminapps.dita" navtitle="Differences between running Derby in embedded mode and using the Network Server">
<topicref href="cadminappsisolationlev.dita" navtitle="Isolation level"></topicref>
+<topicref href="radminappsresultsetdiffs.dita" navtitle="Updatable Result Sets"></topicref>
<topicref href="radminapps811974.dita" navtitle="Error messages"></topicref>
<topicref href="cadminapps49914.dita" navtitle="User authentication">
<topicref href="cadminapps811631.dita" navtitle="Network Server user authentication when user authentication is on in Derby">
Added: incubator/derby/docs/trunk/src/adminguide/radminappsresultsetdiffs.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/adminguide/radminappsresultsetdiffs.dita?rev=191526&view=auto
==============================================================================
--- incubator/derby/docs/trunk/src/adminguide/radminappsresultsetdiffs.dita (added)
+++ incubator/derby/docs/trunk/src/adminguide/radminappsresultsetdiffs.dita Mon Jun 20 11:06:46 2005
@@ -0,0 +1,71 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE concept PUBLIC "-//IBM//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed under the Apache License, Version 2.0 (the "License");
+you may not use this file except in compliance with the License.
+You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+<concept id="radminappsresultsetdiffs" xml:lang="en-us">
+<title>Updatable Result Sets</title>
+<conbody>
+<p>The functionality of updatable resultsets in a server environment are similar
+to an embedded environment in <ph conref="adminconrefs.dita#prod/productshortname"></ph>,
+with the exception of the following differences:<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 resultset on the statement object. This is not supported in a server
+environment.</li>
+</ul>Other differences between updatable resultsets in a server or embedded
+environment can be found in the following table.<table><title>Comparison of
+updatable resultsets features in server and embedded environments</title>
+<tgroup cols="2"><colspec colname="col1"/><colspec colname="col2"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Embedded environment</entry>
+<entry colname="col2">Server environment</entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">updateString on SMALLINT, INTEGER, BIGINT, DECIMAL datatypes
+supported.</entry>
+<entry colname="col2">Not supported</entry>
+</row>
+<row>
+<entry colname="col1">updateBytes on CHAR, VARCHAR, LONG VARCHAR datatypes
+supported.</entry>
+<entry colname="col2">Not supported</entry>
+</row>
+<row>
+<entry colname="col1">updateTime on TIMESTAMP datatypes supported.</entry>
+<entry colname="col2">Not supported</entry>
+</row>
+<row>
+<entry colname="col1">updateObject with null values supported.</entry>
+<entry colname="col2">Not supported</entry>
+</row>
+<row>
+<entry colname="col1">updateClob and updateBlob supported.</entry>
+<entry colname="col2">Not supported</entry>
+</row>
+</tbody>
+</tgroup>
+</table></p>
+</conbody>
+</concept>