Although Java developers often use Object-Relational Mapping tools (e.g. Hibernate) to work with the database, it is useful to know “lower access”, i.e. JDBC.
ABSTRACT
Java Database Connectivity (JDBC) is an application programming interface (API) for the Java programming language, which defines how a Java client can work with a database.
Although Java developers often use Object-Relational Mapping tools (e.g. Hibernate) to work with the database, it is useful to know “lower access”, i.e. JDBC.
The author’s opinion is that it is generally better not to write SQL code on the Java side, but in stored procedures/functions in the database, so that Java programs retrieve the obtained data using ref cursors.
For the above reason, it could be concluded that it is desirable that PL/SQL developers also understand the basics of JDBC.
The paper presents 9 examples, mostly from simpler to more complex:
result set, prepared statement, callable statement, use of ref cursor, use of meta data, updatable result set, connections and connection pool, onnection pool and proxy user, cached row set.