[DERBY-6316] Small typos in devguide examples - ASF JIRA

XML

Word

Printable

JSON

I came across two examples with small typos in the developer's guide.

try {
preparedStatement.execute();
} catch (SQLException se ) {
String SQLState = se.getSQLState();
if ( SQLState.equals( "23505" ) )

{ correctDuplicateKey(); }

else if ( SQLState.equals( "22003" ) )

{ correctArithmeticOverflow(); }

else

{ throw se; }

}

Here, the first line in the catch block is not at the same indentation level as the other statements in the block.

CREATE TRIGGER . . .
DELETE FROM flightavailability
WHERE flight_id IN (SELECT flight_id FROM flightavailability
WHERE YEAR(flight_date) < 2005)

This example has an unmatched closing parenthesis. And even if it were matched, it should have come before the semicolon.

(By the way, should the semicolon be kept or removed? Derby's SQL dialect doesn't accept statements that end with a semicolon, but ij does.)