JDBC - Intermed

JDBC Intermed

	Released	Beta	Frozen
Connection 2 questions Use Data Sources and Connection Pooling Understand Jakarta Commons DBCP simple usage Write code that handles ClassNotFoundException and SQLException Retrieve and use DatabaseMetadata.	2	40	24	Add a question Beta questions
Statement & Resultset
Scrollable and Updatable ResultSet 2 questions Create a scrollable and updatable ResultSet Move the cursor forward and backward Move the cursor to a designated row Update a ResultSet programmatically Insert and delete rows programmatically	2	20	15	Add a question Beta questions
ResultSetMetaData 2 questions Obtain ResultSetMetaData: What you can/can't find out via ResultSetMetaData Obtaining column data types, names, labels, and display sizes Obtaining the column count	3	8	14	Add a question Beta questions
Batch Updates 1 question Use Statement Objects for Batch Updates Handle Batch Update Exceptions	1	18	11	Add a question Beta questions
RowSet 2 questions Write code that use different kinds of RowSet Objects: JdbcRowSet, CachedRowSet, WebRowSet, JoinRowSet, FilteredRowSet.	2	47	12	Add a question Beta questions
SQL3 Data Types 1 question Know usage of SQL3 Data Types (Blob, Clob, Array, Struct, Ref and DISTINCT) Insert SQL3 Types into a Table	1	11	5	Add a question Beta questions
JDBC Transactions 3 questions Turn the committing of transactions on or off Commit and roll back transactions Use Save points Understand transaction/isolation levels Control transaction behavior	6	35	16	Add a question Beta questions
Misc 2 questions Use Ad-Hoc SQL queries with Statement and PreparedStatement. Open and close the connection. Connect the database, using information supplied by JNDI (the Java Naming and Directory Interface). Use methods of Statement, PreparedStatement and ResultSet (such as getGeneratedKeys(), clearWarnings(), getMaxRows(), getWarnings(), getArray(), refreshRow() and wasNull() )	0	36	17	Add a question Beta questions