Hi Friends,
This article will help you to identify basic connectivity using JDBC driver in Java. There are only four categories of JDBC driver provided by SUN, Type 1, 2, 3, and 4, which is explained below −
Type 1: JDBC-ODBC (Bridge Driver)
In a Type 1 driver, a JDBC bridge is used to access ODBC drivers installed on each system. One can configure ODBC on his system in a DSN ( Data Source Name) which will represent target of that database.
It was mostly used driver as it configures database in Access. But nowadays it is used only for test purpose besides that other DBMS drivers are being used.
Type 2: JDBC-Native API Driver
In a Type 2 driver, JDBC API calls are converted into native C/C++ API calls, which are unique to the database. These drivers are basically provided by the database vendors only and used in the same manner as the JDBC-ODBC Bridge. So vendor specific driver needs to be used on user system.
For full blog about Java connectivity JDBC driver Visit Findnerd.
FindNerd -A platform/social network that covers all of your needs like tech queries, post blogs,can schedule a meeting,record your desktop and share, post tech jobs etc.
On Findnerd, most of the queries asked from the section of Android, iPhone, HTML and Java developer forums.
This article will help you to identify basic connectivity using JDBC driver in Java. There are only four categories of JDBC driver provided by SUN, Type 1, 2, 3, and 4, which is explained below −
Type 1: JDBC-ODBC (Bridge Driver)
In a Type 1 driver, a JDBC bridge is used to access ODBC drivers installed on each system. One can configure ODBC on his system in a DSN ( Data Source Name) which will represent target of that database.
It was mostly used driver as it configures database in Access. But nowadays it is used only for test purpose besides that other DBMS drivers are being used.
Type 2: JDBC-Native API Driver
In a Type 2 driver, JDBC API calls are converted into native C/C++ API calls, which are unique to the database. These drivers are basically provided by the database vendors only and used in the same manner as the JDBC-ODBC Bridge. So vendor specific driver needs to be used on user system.
For full blog about Java connectivity JDBC driver Visit Findnerd.
FindNerd -A platform/social network that covers all of your needs like tech queries, post blogs,can schedule a meeting,record your desktop and share, post tech jobs etc.
On Findnerd, most of the queries asked from the section of Android, iPhone, HTML and Java developer forums.
No comments:
Post a Comment