Learn Java: Jdbc

What are the steps involved in establishing a JDBC connection? 

How can you load the drivers?

What will Class.forName do while loading drivers?

How can you make the connection?

How can you create JDBC statements and what are they?

How can you retrieve data from the ResultSet?

What are the different types of Statements?

How can you use PreparedStatement?

What does setAutoCommit do?

How do you call a stored procedure from JDBC?

How do I retrieve warnings?

How can you move the cursor in scrollable result sets?

What’s the difference between TYPE_SCROLL_INSENSITIVE , and TYPE_SCROLL_SENSITIVE?

How to Make Updates to Updatable Result Sets?

What are available drivers in JDBC?

What is a stored procedure? How to call stored procedure using JDBC API?

What is Connection pooling? What are the advantages of using a connection pool?

How to do database connection using JDBC thin driver ?

What is Metadata and why should I use it?

Explain method PooledConnection getPooledConnection() in java                                     throws SQLException?

Explain method Class DriverManager in java?

Explain method public static PrintWriter getLogWriter() in java?

Explain method public static void setLogWriter(PrintWriter out) in java?

Explain method public static Connection getConnection(String url,                       Properties info)                                throws SQLException in java?

Explain public static Connection getConnection(String url,                       String user,                       String password) in java?

Explain public static Connection getConnection(String url) in java                                throws SQLException?

 Explain public static Driver getDriver(String url) in java                        throws SQLException?

Explain public static void registerDriver(Driver driver) in java?                           throws SQLException

Explain public static void deregisterDriver(Driver driver) in java?                             throws SQLException

Explain public static Enumeration getDrivers() in  java?

Explain public static void setLoginTimeout(int seconds) in java?

Explain public static int getLoginTimeout() in java?

Explain public static void setLogStream(PrintStream out) in java?

Explain public static PrintStream getLogStream()?

What are the main components of JDBC ?

How the JDBC application works? 

How do I load a database driver with JDBC 4.0 / Java 6?

What is JDBC Driver interface?

What does the connection object represents?

What is Statement ?

What is PreparedStatement?

How to call a stored procedure from JDBC ?

What does the connection object represents?

Explain method Creating a CachedRowSet Object?

Explain Retrieving Data from a CachedRowSet Object?

Explain method Retrieving RowSetMetaData?

Explain method Updating a CachedRowSet Object?

Explain method Updating the Underlying Data Source?

Explain method Registering and Notifying Listeners?

Explain method Passing Data to Thin Clients?

Explain Scrolling and Updating?

Explain Getting Universal Data Access?

Explain Setting Properties?

Explain Paging Data?

Explain Background?

Explain  Predicate Sharing?

Explain Updating a FilteredRowSet Object?

Explain Behavior of Rows Outside the Filter?

Explain Creating a JdbcRowSet Object?

Explain boolean getShowDeleted() throws SQLException?

Explain void setShowDeleted(boolean b) throws SQLException?

Explain about getRowSetWarningsRowSetWarning getRowSetWarnings()                                throws SQLException?

Explain about  void commit() throws SQLException?

Explain getAutoCommitboolean getAutoCommit()                      throws SQLException?

Explain void setAutoCommit(boolean autoCommit)                   throws SQLException?

Explain about void rollback()              throws SQLException?

Explain void rollback(Savepoint s)              throws SQLException?

Explain about  Managing Multiple Match Columns?

Explain about void setMatchColumn(int columnIdx)                    throws SQLException?

Explain setMatchColumnvoid setMatchColumn(int[] columnIdxes)                    throws SQLException

Explain about setMatchColumnvoid setMatchColumn(String columnName)                    throws SQLException?

Explain about setMatchColumnvoid setMatchColumn(String[] columnNames)                    throws SQLException?

Explain about getMatchColumnIndexesint[] getMatchColumnIndexes()                            throws SQLException

Explain about getMatchColumnNamesString[] getMatchColumnNames()                             throws SQLException?

Explain about unsetMatchColumnvoid unsetMatchColumn(int columnIdx)                      throws SQLException

Explain about unsetMatchColumnvoid unsetMatchColumn(int[] columnIdxes)                      throws SQLException?

Explain unsetMatchColumnvoid unsetMatchColumn(String columnName)                      throws SQLException?

UnsetMatchColumnvoid unsetMatchColumn(String[] columnName)                      throws SQLException

Using a JoinRowSet Object for Creating a JOIN

JoinRowSet Methods

Explain method CROSS_JOIN?

Explain about INNER_JOINstatic final int INNER_JOIN?

Explain the difference between LEFT_OUTER_JOINstatic final int LEFT_OUTER_JOIN?

Explain method RIGHT_OUTER_JOIN?

Explain the difference between FULL_JOINstatic final int FULL_JOIN

Explain about addRowSetvoid addRowSet(Joinable rowset)               throws SQLException?

Explain about addRowSetvoid addRowSet(RowSet rowset,             int columnIdx)               throws SQLException?

Explain about addRowSetvoid addRowSet(RowSet rowset,             String columnName)               throws SQLException?

Explain about addRowSetvoid addRowSet(RowSet[] rowset,             int[] columnIdx)               throws SQLException?

Explain about addRowSetvoid addRowSet(RowSet[] rowset,             String[] columnName)               throws SQLException?

Explain about getRowSetsCollection getRowSets()                         throws SQLException?

Explain getRowSetNamesString[] getRowSetNames()                        throws SQLException?

Explain toCachedRowSetCachedRowSet toCachedRowSet()                            throws SQLException?

Explain aboutpublic abstract class BaseRowSetextends Objectimplements Serializable, Cloneable?

Explain the difference between UNICODE_STREAM_PARAMpublic static final int UNICODE_STREAM_PARAM?

Explain the difference between BINARY_STREAM_PARAMpublic static final int BINARY_STREAM_PARAM?

Explain the difference between ASCII_STREAM_PARAMpublic static final int ASCII_STREAM_PARAM?

Explain the difference between binaryStreamprotected InputStream binaryStream?

Explain the difference between unicodeStreamprotected InputStream unicodeStream?

Explain the difference between asciiStreamprotected InputStream asciiStream?

Explain the difference between charStreamprotected Reader charStream?

Explain the difference between BaseRowSetpublic BaseRowSet()?

Explain the difference between initParamsprotected void initParams()?

Explain about addRowSetListenerpublic void addRowSetListener(RowSetListener listener)?

Explain about removeRowSetListenerpublic void removeRowSetListener(RowSetListener listener)?

Explain notifyCursorMovedprotected void notifyCursorMoved()                          throws SQLException?

Explain notifyRowChangedprotected void notifyRowChanged()                         throws SQLException?

Explain notifyRowSetChangedprotected void notifyRowSetChanged()                            throws SQLException?

Explain getCommandpublic String getCommand()

Explain about public void setCommand(String cmd)                throws SQLException

Explain about public String getUrl()              throws SQLException?

Explain about setUrlpublic void setUrl(String url)            throws SQLException?

Explain getDataSourceNamepublic String getDataSourceName()?

Explain setDataSourceNamepublic void setDataSourceName(String name)                       throws SQLException ?

Explain getUsernamepublic String getUsername( ) ?

Explain setUsernamepublic void setUsername(String name)?

Explain getPasswordpublic String getPassword()?

Explain method setPasswordpublic void setPassword(String pass)?

Explain method setTypepublic void setType(int type)             throws SQLException ?

Explain method getTypepublic int getType()            throws SQLException ?

Explain method setConcurrencypublic void setConcurrency(int concurrency)                    throws SQLException ?

Explain method isReadOnlypublic boolean isReadOnly()?

Explain method setReadOnlypublic void setReadOnly(boolean value) ?

Explain method getTransactionIsolationpublic int getTransactionIsolation() ?

Explain method setTransactionIsolationPublic void setTransactionIsolation(int level)                             throws SQLException

Explain method getTypeMappublic Map> getTypeMap()?

Explain method setTypeMappublic void setTypeMap(Map> map)?

Explain method getMaxFieldSizepublic int getMaxFieldSize()                    throws SQLException?

Explain method setMaxFieldSizepublic void setMaxFieldSize(int max)                     throws SQLException ?

Explain method getMaxRowspublic int getMaxRows()               throws SQLException?

Explain method setMaxRowspublic void setMaxRows(int max)                throws SQLException?

Explain method setEscapeProcessingpublic void setEscapeProcessing(boolean enable)                         throws SQLException ?

Explain method getQueryTimeoutpublic int getQueryTimeout()                    throws SQLException ?

Explain setQueryTimeoutpublic void setQueryTimeout(int seconds)                     throws SQLException ?

Explain method getShowDeletedpublic boolean getShowDeleted()                       throws SQLException ?

Explain public void setShowDeleted(boolean value)                    throws SQLException ?

Explain method getEscapeProcessingpublic boolean getEscapeProcessing()                            throws SQLException ?

Explain method setFetchDirectionpublic void setFetchDirection(int direction)                       throws SQLException ?

Explain method getFetchDirectionpublic int getFetchDirection()                      throws SQLException ?

Explain method setFetchSizepublic void setFetchSize(int rows)                  throws SQLException ?

Explain method getFetchSizepublic int getFetchSize()                 throws SQLException ?

Explain method getConcurrencypublic int getConcurrency()                   throws SQLException ?

Explain method setNullpublic void setNull(int parameterIndex,           int sqlType)             throws SQLException ?

Explain method setBooleanpublic void setBoolean(int parameterIndex,              boolean x)                throws SQLException ?

Explain method setBytepublic void setByte(int parameterIndex,           byte x)             throws SQLException ?

Explain method setShortpublic void setShort(int parameterIndex,            short x)              throws SQLException ?

Explain method setIntpublic void setInt(int parameterIndex,          int x)            throws SQLException ?

Explain method setLongpublic void setLong(int parameterIndex,           long x)             throws SQLException ?

Explain method setFloatpublic void setFloat(int parameterIndex,            float x)              throws SQLException ?

Explain setDoublepublic void setDouble(int parameterIndex,             double x)               throws SQLException ?

Explain about public void setBigDecimal(int parameterIndex,                 BigDecimal x)                   throws SQLException ?

Explain method setStringpublic void setString(int parameterIndex,             String x)               throws SQLException ?

Explain method setBytespublic void setBytes(int parameterIndex,            byte[] x)              throws SQLException ?

Explain about setDatepublic void setDate(int parameterIndex,           Date x)             throws SQLException ?

Explain about setTimepublic void setTime(int parameterIndex,           Time x)             throws SQLException ?

Explain method setTimestamppublic void setTimestamp(int parameterIndex,                Timestamp x)                  throws SQLException ?

Explain about setAsciiStreampublic void setAsciiStream(int parameterIndex,                  InputStream x,                  int length)                    throws SQLException ?

Explain about setAsciiStreampublic void setAsciiStream(int parameterIndex,                  InputStream x)                    throws SQLException ?

Explain method setBinaryStreampublic void setBinaryStream(int parameterIndex,                   InputStream x,                   int length)                     throws SQLException ?

Explain method setBinaryStreampublic void setBinaryStream(int parameterIndex,                   InputStream x)                     throws SQLException

Explain method setUnicodeStreampublic void setUnicodeStream(int parameterIndex,                    InputStream x,                    int length)                      throws SQLException ?

Explain method setCharacterStreampublic void setCharacterStream(int parameterIndex,                      Reader reader,                      int length)                        throws SQLException ?

Explain method setCharacterStreampublic void setCharacterStream(int parameterIndex,                      Reader reader)                        throws SQLException ?

Explain method setObjectpublic void setObject(int parameterIndex,             Object x,             int targetSqlType,             int scale)               throws SQLException ?

Explain method setObjectpublic void setObject(int parameterIndex,             Object x,             int targetSqlType)               throws SQLException ?

Explain method setRefpublic void setRef(int parameterIndex,          Ref ref)            throws SQLException ?

Explain method setBlobpublic void setBlob(int parameterIndex,           Blob x)             throws SQLException

Explain method setClobpublic void setClob(int parameterIndex,           Clob x)             throws SQLException

Explain method setArraypublic void setArray(int parameterIndex,            Array array)              throws SQLException ?

Explain method setDatepublic void setDate(int parameterIndex,           Date x,           Calendar cal)             throws SQLException ?

Explain method setTimestamppublic void setTimestamp(int parameterIndex,                Timestamp x,                Calendar cal)                  throws SQLException ?

Explain method clearParameterspublic void clearParameters()                     throws SQLException ?

Explain method getParamspublic Object[] getParams()                   throws SQLException ?

Explain method setNullpublic void setNull(String parameterName,           int sqlType)             throws SQLException ?

Explain method setBooleanpublic void setBoolean(String parameterName,              boolean x)                throws SQLException

Explain method setBytepublic void setByte(String parameterName,           byte x)             throws SQLException ?

Explain method setShortpublic void setShort(String parameterName,            short x)              throws SQLException ?

Explain method setIntpublic void setInt(String parameterName,          int x)            throws SQLException ?

Explain method setLongpublic void setLong(String parameterName,           long x)             throws SQLException ?

Explain method setFloatpublic void setFloat(String parameterName,            float x)              throws SQLException ?

Explain method setDoublepublic void setDouble(String parameterName,             double x)               throws SQLException ?

Explain method setBigDecimalpublic void setBigDecimal(String parameterName,                 BigDecimal x)                   throws SQLException ?

Explain method setBytespublic void setBytes(String parameterName,            byte[] x)              throws SQLException ?

Explain method setTimestamppublic void setTimestamp(String parameterName,                Timestamp x)                  throws SQLException ?

Explain method setAsciiStreampublic void setAsciiStream(String parameterName,                  InputStream x,                  int length)                    throws SQLException ?

Explain method setBinaryStreampublic void setBinaryStream(String parameterName,                   InputStream x,                   int length)                     throws SQLException ?

Explain method setCharacterStreampublic void setCharacterStream(String parameterName,                      Reader reader,                      int length)                        throws SQLException ?

Explain setAsciiStreampublic void setAsciiStream(String parameterName,                  InputStream x)                    throws SQLException ?

Explain method  setBinaryStreampublic void setBinaryStream(String parameterName,                   InputStream x)                     throws SQLException ?

Explain method setCharacterStreampublic void setCharacterStream(String parameterName,                      Reader reader)                        throws SQLException ?

Explain method setObjectpublic void setObject(String parameterName,             Object x,             int targetSqlType,             int scale)               throws SQLException ?

Explain method  setBlobpublic void setBlob(String parameterName,           Blob x)             throws SQLException

Explain method setBlobpublic void setBlob(String parameterName,           InputStream inputStream)             throws SQLException ?

Explain about setClobpublic void setClob(int parameterIndex,           Reader reader)             throws SQLException ?

Explain method setClobpublic void setClob(String parameterName,           Reader reader,           long length)             throws SQLException ?

Explain method setClobpublic void setClob(String parameterName,           Clob x)             throws SQLException ?

Explain method setClobpublic void setClob(String parameterName,           Reader reader)             throws SQLException ?

Explain setDatepublic void setDate(String parameterName,           Date x)             throws SQLException ?

Explain setDatepublic void setDate(String parameterName,           Date x,           Calendar cal)             throws SQLException ?

Explain setTimepublic void setTime(String parameterName,           Time x)             throws SQLException ?

Explain setTimepublic void setTime(String parameterName,           Time x,           Calendar cal)             throws SQLException ?

Explain method setTimestamppublic void setTimestamp(String parameterName,                Timestamp x,                Calendar cal)                  throws SQLException ?

Explain method setSQLXMLpublic void setSQLXML(int parameterIndex,             SQLXML xmlObject)               throws SQLException ?

Explain method setSQLXMLpublic void setSQLXML(String parameterName,             SQLXML xmlObject)               throws SQLException ?

Explain method setRowIdpublic void setRowId(int parameterIndex,            RowId x)              throws SQLException ?

Explain method setRowIdpublic void setRowId(String parameterName,            RowId x)              throws SQLException ?

Explain method setNStringpublic void setNString(int parameterIndex,              String value)                throws SQLException ?

Explain method setNCharacterStreampublic void setNCharacterStream(int parameterIndex,                       Reader value,                       long length)                         throws SQLException ?

Explain method setNCharacterStreampublic void setNCharacterStream(String parameterName,                       Reader value,                       long length)                         throws SQLException ?

Explain method setURLpublic void setURL(int parameterIndex,          URL x)            throws SQLException ?