Skip to Main Content
JDBC Pocket Reference
book

JDBC Pocket Reference

by Donald Bales
January 2003
Intermediate to advanced content levelIntermediate to advanced
176 pages
5h 3m
English
O'Reilly Media, Inc.
Content preview from JDBC Pocket Reference
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
44
|
JDBC Pocket Reference
Java classes (not
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Pro Couchbase Server, Second Edition

Pro Couchbase Server, Second Edition

David Ostrovsky, Mohammed Haji, Yaniv Rodenski
Pro Couchbase Server

Pro Couchbase Server

David Ostrovsky, Yaniv Rodenski

Publisher Resources

ISBN: 9780596528713