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.

      48 comments:

      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.

        ReplyDelete
        Replies


        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.

          Delete
      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.

        ReplyDelete
      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.

        ReplyDelete
      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.

        ReplyDelete
      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

        ReplyDelete
      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.

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

        ReplyDelete
      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

        ReplyDelete
      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

        ReplyDelete
      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.

        ReplyDelete
      11. This comment has been removed by the author.

        ReplyDelete
      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

        ReplyDelete
      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

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

        ReplyDelete
      15. This comment has been removed by the author.

        ReplyDelete
      16. This comment has been removed by the author.

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

        ReplyDelete
      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
        only.
        Website
        Design Company Bangalore

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

        ReplyDelete
      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

        ReplyDelete
      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

        ReplyDelete
      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

        ReplyDelete
      23. Hey,

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

        ReplyDelete
      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.

        ReplyDelete
      25. Best web designing company in bangalore - http://aarusys.com

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


        Website Development

        ReplyDelete
      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

        ReplyDelete
      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.

        ReplyDelete
      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

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

        ReplyDelete
      31. Thanks for the great article. I want to share with you one great android mobile App development in California , USA.
        Visit: www.hvantagetechnologies.com

        ReplyDelete
      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: www.yberryinfosystem.com

        ReplyDelete
      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

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

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

        ReplyDelete
      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

        ReplyDelete

      Please enter relevant question and information.