Sunday, November 23, 2014

What is Java JDBC and Different JDBC Driver Types

In this tutorial we shall learn, what is JDBC API and different types of JDBC Drivers which are used to connect Java based Web applications, desktop applications and mobile applications with different types of Database servers like MS Database server, MS Access, MySQL Server, Sybase database server, Oracle Database servers and cloud databases etc.

What is JDBC API: 

JDBC stands for "Java Database Connectivity. JDBC is standard Java API for providing database independent connectivity between the Java applications and different types of databases. The
JDBC API contains number of interfaces and classes that are extensively helpful while
communicating with a database.JDBC technology support java developers to use java in applications for write once and run anywhere capabilities.

Below are possibles with the JDBC API, it is
  • Used to establish a connection with a database of different vendors.
  • Used to send SQL statements (create, update, delete, insert etc) to database
  • Used to process the accessed results

JDBC Driver Types

There are four types or levels of JDBC Driver. Each type is used to define a JDBC driver implementation with respect to Database Type, platform independence, performance, deployment and administration.
Below are the four types of JDBC Driver:
    1. JDBC - ODBC Bridge
    2. Native - API / partly Java driver
    3. Net - protocol / all-Java driver
    4. Native - protocol / all-Java driver

      1- JDBC - ODBC Bridge

      JDBC - ODBC Bridge type is generally used to connect java database driven applications with Microsoft databases like MS Access and MS SQL Server.  It first translates all JDBC calls into ODBC (Open Database Connectivity) calls and then send them to the ODBC Driver which is further used for communicating with databases. Due to this reason, this type of driver performance is degraded

      Online training for learning java jdbc, learn what is jdbc to ODBC Bridge driver, what is Java database connectivity, how to connect java applications with MS SQL Database, Database driven application using JDBC, JDBC Tutorials, java web applications development, java education, java jdbc learning, JDBC Cloud computing, Database hosting, cloud database connectivity using jdbc. free java training tutorials

      Native - API/partly Java driver

      Partly-Java drivers use Java Native Interface to communicate with database-specific API which may be written in C/C++. This type, first converts JDBC calls into database specific calls such as SQL Server, Informix, Oracle or Sybase. Its performance is significantly better than the JDBC-ODBC bridge.

      Online training for java web applications development, learn what is jdbc, jdbc tutorials, JDBC Native API / Partly Java Driver, Database connectivity using JDBC, jdbc database hosting, free database conectivity drivers, JDBC Cloud database hosting, cloud database connectivity using jdbc. free java training tutorials

       Net - protocol / all-Java driver

      As showing in below diagram, this JDBC Driver type follows a three-tiered approach to connect with database server whereby the JDBC requests () are passed through via middle-tier server. The Pure Java application client first send requests to middle ware server which is not database specific server, it translates requests into a database-specific protocol and then send it to Database server. If the middle-tier server is written in pure java language, then type 1or type 2 JDBC driver can be used to do this

      JDBC Tutorial, use of JDBC Driver,  database connectivity software, custom app development, java applications development, developing java application, training database software , cloud database connectivity using jdbc. free java training tutorials

      Native - protocol / all-Java driver

      This type of JDBC Driver is completely implemented in Java language to achieve platform independence and for elimination of deployment issues. It converts JDBC calls directly into the vendor specific DBMS protocol which enable the java client application to communicate directly with the database server. This type of driver Performance is very good as compare to other types.

      JDBC Tutorial, use of JDBC Driver,  database connectivity software, custom app development, java applications development, developing java application, training database software , cloud database connectivity using jdbc. free java training tutorials

      Benefits of JDBC Technology

      1- The JDBC API is simple to learn. Developers can easily learn JDBC and use it efficiently in their database driven java applications. It is easy to deploy and is inexpensive to maintain it. 

      2- JDBC technology make possible for leveraging of existing enterprise data and save businesses to lock if it was previously using any proprietary architecture, business can continue to use and access their installed existing databases easily even database stored on different DBMS Software. .

      3- Using Java API and the JDBC API, enterprise database driven custom applications development has become simplified, easy and economical. Because JDBC hides the complexity of many data access tasks and provides easily methods to access the databases. It makes the applications to easy to deploy and their maintenance less expensive.

      4- By using JDBC API, there is almost zero configuration for network client computers which supports the network computing paradigm and centralizes software maintenance.
      5- JDBC Drive has bettor support to connect java applications with cloud databases.


      1. I have goen through your site, this is a good one.for more information please follow our blog:-The San Bernardino Door Installation go short of food of tip complete upheaval to in dates to the conventional as well as over and done with with as well to shape of lag behind of the on the attention to detail for Nassau County Web design edge supposition. The opponent complete to rude at that point lacking extents of content on all separations of the Long Island website design every variety wide on or afterward the extra strict chief object for Long Island SEO Long Island web development use.


        1. I would like to share another best New York based web design development company which is not only specialized in the field of website development and designing but also specialized in the field of e-commerce development and Web promotions(Like SEO, SMO, PPC, and SEM ). Check out at ✓ Web Design ✓ Web Development ✓ SEO ✓ SMO ✓ PPC Services

          We have done 1000+ Project Done & 1500+ Certified Customers.

      2. TO GIVE THE BEST SUPPORT AS A WEB DEVELOPER TO SUBMITS THE PROJECTS ON .CONTACT US :- The Long Island web development congenial the examinations as the main thing which are being the share of broad which are Nassau County Web design in the in gathering to be out of the blue Long Island website design by spreading out of in the per steadfastness in Long Island SEO banquets any congregation in the flea market as they are common in rural area that happens to collect to be all placed.

      3. As a web development and design service provider Webzin InfoTech provides optimum solutions to customer by helping them to achive their goals and make available their services and products in the online market.

      4. I have go through this page and its blog for more follow our blog:-The Long Island Website Design organization utilizes the most recent technologies to create websites. Content conveys a vital place in any website as it makes the individuals to get data about your business. Long Island web development companies likewise give the Long Island SEO services. You ought to discover a Nassau County Web design organization which gives all the web related services so your time and money will be spared.

      5. Hi Nice Blog and infromations. Long Islands SEO - New York Search Engine Optimization, NYC Services, Website Marketing and Development, professional SEO firm.
        Affordable SEO Company New York

      6. Hi, I've been using this odbc-jdbc bridge in Netbeans for the last 3 years. It's sad to say that in the latest version of Netbeans, the owner of java cut their support on this odbc driver. Because of that i find it very difficult to connect to database which is located in another computer in the local area network or lan server. If you can still use thiis odbc-jdbc bridge, please tell me the version of netbeans and please send me the link, coz I've been searching for the version where I can still apply this odbc. My mistake is I have already lost my old installers and replaced those installers with the new version. I find it very difficult to download the old version with the support of odbc jdbc bridge.

      7. Wow that's a wonderfull blog having all details & helpful. Web application NY

      8. I appreciate you and I would like to read your next post.
        Thanks for sharing this useful information.
        We know your time is very important.
        So, We will help you for finding many important website link that you need for every work.
        Just Bookmarks one website and get more website link .
        all important website link
        SEO Tools

      9. now a days database is mandatory for every sites and JDBC concept everyone want to know...

        Web Design Company Bangalore | Web Development Company Bangalore

      10. This is an amazing blog,it gives very helpful messages to us.Besides that Creationinfoways has established himslef as Top 10 seo company in delhi as well as Top 10 website Development company in delhi.Now newly indroduced himself as one of the best growing Digital marketing company in delhi and Ecommerce Website Development Company in Delhi.

      11. This comment has been removed by the author.

      12. Its the best information for me..Am got the best information in this article..thank you for sharing the best information...Website Development Agency Bangalore | top Web Design Services Bangalore

      13. Such a great post loves it. You explanation is really awesome. Loves this!! Now you can find the best web development service in Australia just visit here

        web development or mobile app development

      14. Thanks for the information
        Nice to read your post
        software development

      15. This comment has been removed by the author.

      16. This comment has been removed by the author.

      17. Very nice information about java website development, JDBC driver type. thanks for sharing.
        WordPress Plugin Development Companies | PHP Development Companies in India

      18. Web design and development are one of the main category
        for promote the online business.Because the main
        investment of online business is websites.The major reason
        for making the websites are web design and development
        Design Company Bangalore

      19. Thanks a lot for your valuable article. I will keep following your blog for more information.
        Hire Java Developers

      20. This is an extremely well written article. Apps Development I will be sure to bookmark it and return to read more of your useful information. Thanks for the post. 
        Web Development

      21. Nexevo Technologies is one of the best and top website design and digital marketing company in Bangalore if you are looking for create the website or branding a new business on online you just came to right place Nexevo Technologies.

        Website Design Agency Bangalore | SEO Bangalore

      22. Thanks i like your blog very much , i come back most days to find new posts like this! Good effort. I learnt it
        Web Development Company

      23. Hey,

        Very informative and useful article, i like to read your article very much. Thanks a lot for sharing with us.

      24. WOW, i've never seen such an informative post so nice, i like it.Web Development Services available,get these services according to your own business.

      25. Best web designing company in bangalore -

      26. Valuable for information if there is any other regarding this kindly revert me back on this

        Website Development

      27. Great blog. All posts have something to learn. Your work is very good and i appreciate you and hoping for some more informative posts.keep writing
        Web development Company in India Company | Web development Company Bangalore
        Web Development Company in Bangalore | Responsive Web development

      28. If you hire CMS developer or e commerce developer after developing, your e-trade web site keeps to grow, you can need to host it on a committed server one which handles your site and no others.

      29. Apple App Store
        It was created in 2008 and was accessible in more than 50 countries, while this number is now crossed 100. This app store is composed of over 4 lacs app for iPhone and over 1 lac apps for ipads. The specialty of this app store is that the Apple does not allow any other platform for the distribution of the apps so it’s the only one official app store for the apps of iPhone and ipads.
        ios app development

      30. This page is insightful and helpful. Lots of people will assert that everything in your site is great. training in jalandhar

      31. Thanks for the great article. I want to share with you one great android mobile App development in California , USA.

      32. Thanks for the post, you have provided a simple step by step process so anyone can understand easily. For understanding Mobile Application Services and Android Development, you can visit Yberry Infosystem in Indore Visit:

      33. This site has lots of advantage.I found many interesting things from this site. It helps me in many ways.Thanks for posting.For more details about oracle fusion financial please check our website.
        Oracle Fusion Financial Training Institute

      34. perfect explanation about java programming .its very useful.thanks for your valuable training in chennai | dot net training and placement in chennai

      35. Thanks a lot! You made a new blog entry to answer my question; I really appreciate your time and training in chennai | chennai's no.1 java training in chennai

      36. Nice theory knowledge. CPDESK is Online Web Development Tool Company located in Canada. Our main services include : Web based Software designing Tool, Web based Business Application, Web based SQL form designer, Corporate application form designer. For more details please visit our site - Web Application Development Tool Company | CPDESK

      37. Home Interiors Designers in Bangalore

        Chetain Interiors has highly skilled and experienced Architecture crews, hence our past Portfolio talks much about our work all the way from architecting houses from scratch, to designing the interiors.

      38. This is great. Excellent article. Thanks For sharing. Keep posting..

        Web Development Houston

      39. Thanks for this blog. provided Great information provided. I really appreciate your writing. I like the way you put across your ideas. Awesome, keep it up.
        Best Web Development Company in India
        Best Web Development Company in Kolkata
        Best Web Development Company in West Bengal

      40. Hey

        Its very useful blogs.Thanks for sharing the information Web Development

      41. Thanks for sharing excellent information.If you Are looking Best Website Development Company in jaipur,Digital Marketing company in Jaipur, Jodhpur, Bikaner,
        Udaipur,Kota and Ajmer than Please Have A CAll- +91-8426833930.You Are At Right Digital Consultant in jaipur.

      42. Madaalarqam offers the very best custom web designs, website development for small or large E-commerce businesses.

      43. Thanks for this informative article, perfect explanation about Java.

        Web Development Company in Delhi

      44. This is really nice to read content of this blog. A is very extensive and vast knowledgeable platform has been given by this blog. I really appreciate this blog to has such kind of educational knowledge.รับแปลภาษา

      45. Today, the Internet is rebuilding all business environments. Each organization must use the Internet to pack solid benefits in a small or large, highly competitive market scene. The maximum number of enterprise applications is now Web enabled, and therefore organizations need their legacy (accounts, payroll, stores, sales, service, etc.). To be available on the Internet. The Web Enterprise application provides a common interface to reduce costs and improve performance. Twigz Technologies strong domain and technical expertise help global customers move their old applications to the Internet through custom web application development services at cheaper prices. Twigz Technologies is a leading provider of web applications for webpage development, offering specialized web-based custom business applications.
        Web development in Gurugram

      46. Thanks for share wonderful topic and get more information topic to be discuss your page For more details:Find Girls,Bharat Matrimony,SC Matrimony,Brahmin Matrimony.

      47. You information is really good. I really impressed for this please check it once Angularjs Online Training

      48. This is one of the best blogs I've ever read in a very long time. The information in this article is very useful to me.
        Web Development service in Delhi I Web Design Company in Delhi

      49. It was a great information and Its really worth reading it. The author did an mind blowing work by describing each and every concept in detail. Thanks for such an informative post. Please keep up your good work.
        top eCommerce Website developers services in india
        best web developer service in india

      50. Thanks a lot very much for the high quality and results-oriented help.
        I won’t think twice to endorse your blog post to anybody who wants
        and needs support about this area.

        java training in chennai

        java training in bangalore

      51. Your post is simply exceptional! a debt of gratitude is in order for such a post,its extremely going incredible and awesome work.Nice post.
        Web development company in bangalore | best web design company in bangalore

      52. Spark Interact web design Agency Sydney with 12+ years experience in Web development & WordPress. With High quality Website Design & Affordable prices. Check below the website links for more details (Apply for Job at Spark Interact)
        web design
        website design sydney
        web development sydney
        web designers
        web designer sydney
        logo design sydney
        web developers sydney
        website designers sydney
        website designers
        sydney web design
        web designers sydney

      53. Very inspired from this blog. Thanks for sharing.
        Website Development Services in Pune
        Web Development Company Pune

        Read our more article on viral feeds here.

      54. super blog..........
        Kate Technologies is one of the best android and IOS app development Company in Hyderabad providing robust mobile applications that enhances your business performance greatly.
        android app developers in hyderabad


      Please enter relevant question and information.