
The JDBC API
|
43
Outer join
{ oj outerJoinClause }
Use this syntax to specify portable outer joins.
SQL LIKE
value1 LIKE value2 { escape 'character' }
Use this syntax to specify an escape character to be used to escape
one of the SQL wildcard characters.
Stored procedure
{ call procedureName[( ?, ?, ...)] }
{ ? = call functionName[( ?, ?, ...)] }
Use this syntax to escape a stored procedure call. The first syntax
is for stored procedures that do not return a value. The second
syntax is for procedures that do return a value.
The square brackets ( [ ] ) indicate that what lies between them is
optional. The question marks (?) are placeholders for IN, OUT,
and IN/OUT parameters.
Transaction Management
By default, new connections are in autocommit mode. In
autocommit mode, every SQL statement is committed imme-
diately after it is executed. You can turn autocommit on or
off by executing
Connection’s setAutoCommit( ) method. true
turns autocommit on, while false turns it off. If autocommit
is off, then you must manage transactions manually. To com-
mit, execute
Connection’s commit( ) method. To roll back,
execute
Connection’s rollback( ) method.
The JDBC API
This section of the book provides a quick reference to the
JDBC API. Keep in mind as you go through the API that all