db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1517808 - in /db/derby/docs/trunk/src/devguide: cdevspecial41728.dita cdevspecial53165.dita
Date Tue, 27 Aug 2013 13:14:29 GMT
Author: chaase3
Date: Tue Aug 27 13:14:28 2013
New Revision: 1517808

URL: http://svn.apache.org/r1517808
Log:
DERBY-6316  Small typos in devguide examples 

Modified 2 Developer's Guide topics.

Patch: DERBY-6316.diff

Modified:
    db/derby/docs/trunk/src/devguide/cdevspecial41728.dita
    db/derby/docs/trunk/src/devguide/cdevspecial53165.dita

Modified: db/derby/docs/trunk/src/devguide/cdevspecial41728.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/devguide/cdevspecial41728.dita?rev=1517808&r1=1517807&r2=1517808&view=diff
==============================================================================
--- db/derby/docs/trunk/src/devguide/cdevspecial41728.dita (original)
+++ db/derby/docs/trunk/src/devguide/cdevspecial41728.dita Tue Aug 27 13:14:28 2013
@@ -60,12 +60,14 @@ as follows:</p>
 <codeblock>try {
     preparedStatement.execute();
 } catch (SQLException se ) {
-        String SQLState = se.getSQLState();
-    if ( SQLState.equals( "23505" ) ) 
-        { correctDuplicateKey(); }
-    else if ( SQLState.equals( "22003" ) ) {    
-        correctArithmeticOverflow(); }
-    else { throw se; }
+    String SQLState = se.getSQLState();
+    if ( SQLState.equals( "23505" ) ) {
+        correctDuplicateKey();
+    } else if ( SQLState.equals( "22003" ) ) {    
+        correctArithmeticOverflow();
+    } else {
+        throw se;
+    }
 }</codeblock>
 <p>Of course, users also have the choice of not wrapping SQL statements in
 try-catch blocks within methods. In that case, <i>SQLExceptions</i> are caught

Modified: db/derby/docs/trunk/src/devguide/cdevspecial53165.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/devguide/cdevspecial53165.dita?rev=1517808&r1=1517807&r2=1517808&view=diff
==============================================================================
--- db/derby/docs/trunk/src/devguide/cdevspecial53165.dita (original)
+++ db/derby/docs/trunk/src/devguide/cdevspecial53165.dita Tue Aug 27 13:14:28 2013
@@ -28,13 +28,15 @@ limitations under the License.
 </metadata></prolog>
 <conbody>
 <p>For example:</p>
-<codeblock>CREATE TRIGGER . . .
-DELETE FROM flightavailability 
-	WHERE flight_id IN (SELECT flight_id FROM flightavailability 
-		WHERE YEAR(flight_date) &lt; 2005);) </codeblock>
+<codeblock><b>CREATE TRIGGER . . .
+DELETE FROM FlightAvailability 
+  WHERE flight_id IN (SELECT flight_id FROM FlightAvailability 
+    WHERE YEAR(flight_date) &lt; 2005);</b>
+</codeblock>
 <p>A trigger action does have some limitations, though; for example, it cannot
 contain dynamic parameters or alter the table on which the trigger is defined.
-See "TriggerAction" in the <cite><ph conref="../conrefs.dita#pub/citref"></ph></cite>
for
+See the "Triggered-SQL-statement" section of the "CREATE TRIGGER statement"
+topic in the <cite><ph conref="../conrefs.dita#pub/citref"></ph></cite>
for
 details. </p>
 </conbody>
 </concept>



Mime
View raw message