click below
click below
Normal Size Small Size show me how
OCPJP709.1
Cert Obj Core Interfaces of the JDBC API
[9.1.1] Core interfaces of JDBC API | An abstract view of Driver, Connection, Statement, ResultSet |
[9.1.2] Two-Tier JDBC Architecture | In a two-tier configuration, a Java application along with a JDBC driver constitutes the first tier as a client. On the other hand, the database works as a server that fulfills the requirements sent from the clients. |
[9.1.3] Three-Tier JDBC Architecture | First is lightweight Java application (eg applet) Application server (second) forwards the request to database (third). Middle tier plays vital role - behavior of configuration can be fine-tuned based on the requirements (eg enforcing access control). |
[9.1.4] Types of JDBC Drivers | Read A page 283 |
[9.1.5] How to connect? | DriverManager class has getConnection(URL, username, password) |
[9.1.6] URL syntax PSSP | <protocol>:<subprotocol>://<server>:<port>/ |
[9.1.10]JDBC Product Components | The JDBC API ,JDBC Driver Manager,JDBC Test Suite,JDBC-ODBC Bridge |
[9.1.11]SQLException when JDBC driver not found | Add driver jar to classpath; < JDBC4.0 requires Class.forName() to load driver, > 4.0 JDBC API uses URL used to load driver. |