Chapter 7. URL, DataSource, Connection, and Statements

This chapter describes how the Oracle JDBC supports URL, datasources, connections, and associated services, including connection wrapping, connection caching, connection scalability/load balancing, and connection fail-over, proxy connection. Finally, we’ll address JDBC statements (Statement, PreparedStatement, CallableStatement) and Oracle extensions, statement caching, and statement batching.

JDBC URL

A JDBC URL is the connect string used during database connection requests. It specifies the JDBC driver type, authentication information, the database instance, the host, the protocol, the port, service name, and so on. It contains either the complete authentication information or partial information ...

Get Oracle Database Programming using Java and Web Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.