A JDBC-ODBC bridge provides JDBC API access via one or more ODBC drivers. Note that some ODBC native code and in many cases native database client code must be loaded on each client machine that uses this type of driver. Hence, this kind of driver is generally most appropriate when automatic installation and downloading of a Java technology application is not important. For information on the JDBC-ODBC bridge driver provided by Sun, see JDBC-ODBC Bridge Driver.A native-API partly Java technology-enabled driver converts JDBC calls into calls on the client API for Oracle, Sybase, Informix, DB2, or other DBMS. Note that, like the bridge driver, this style of driver requires that some binary code be loaded on each client machine.A net-protocol fully Java technology-enabled driver translates JDBC API calls into a DBMS-independent net protocol which is then translated to a DBMS protocol by a server. This net server middleware is able to connect all of its Java technology-based clients to many different databases. The specific protocol used depends on the vendor. In general, this is the most flexible JDBC API alternative. It is likely that all vendors of this solution will provide products suitable for Intranet use. In order for these products to also support Internet access they must handle the additional requirements for security, access through firewalls, etc., that the Web imposes. Several vendors are adding JDBC technology-based drivers to their existing database middleware products.A native-protocol fully Java technology-enabled driver converts JDBC technology calls into the network protocol used by DBMSs directly. This allows a direct call from the client machine to the DBMS server and is a practical solution for Intranet access. Since many of these protocols are proprietary the database vendors themselves will be the primary source for this style of driver. Several database vendors have these in progress.
Java
Topic: JDBC
What are available drivers in JDBC?
Browse random answers:
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<String,Class<?>> getTypeMap()?
Explain method setTypeMappublic void setTypeMap(Map<String,Class<?>> 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 ?
