{"id":48914,"date":"2017-08-03T11:00:34","date_gmt":"2017-08-03T08:00:34","guid":{"rendered":"http:\/\/examples.javacodegeeks.com\/?p=48914"},"modified":"2019-03-05T13:04:17","modified_gmt":"2019-03-05T11:04:17","slug":"jdbc-oracle-thin-driver-example","status":"publish","type":"post","link":"https:\/\/examples.javacodegeeks.com\/java-development\/core-java\/sql\/jdbc-oracle-thin-driver-example\/","title":{"rendered":"JDBC with Oracle Thin Driver Example"},"content":{"rendered":"

Java Database Connectivity<\/strong> (JDBC) is a Java-based data access technology that defines how a client may access a database. It provides methods for querying and updating the data in a database. The JDBC classes are contained in the Java package i.e. java.sql<\/code> and javax.sql<\/code>.
\n 
\n 
\n 
\n 
\n 
\n 
\n 
\n \n<\/p>\n

1. Introduction<\/h2>\n

In this JDBC Oracle connectivity example, we will see how to setup a JDBC environment and create a simple Java database application to connect to Oracle Database Express Edition using JDBC API.<\/p>\n

1.1 What is JDBC?<\/h3>\n

The JDBC API is a Java API that can access any kind of tabular data, especially the data stored in a relational database. The JDBC API defines interfaces and classes for writing the database applications in Java by making the database connections. Using JDBC one can send statements<\/em> to almost any relational database. Thus, JDBC is a Java API for executing SQL<\/code> statements and supports basic SQL<\/code> functionality.<\/p>\n

In short, JDBC is an API which provides communication between a Java application and the database in a database independent and platform independent manner<\/em>.<\/p>\n

\"Fig.<\/a>
Fig. 1: Java Database Connectivity (JDBC) Architecture<\/figcaption><\/figure><\/p>\n

JDBC lets a developer manage the below three important programming activities, i.e.:<\/p>\n

    \n
  1. Connection to a database.<\/li>\n
  2. Sending queries and update statements to the database.<\/li>\n
  3. Retrieving and processing the results received from the database in answer to the SQL<\/code> query.<\/li>\n<\/ol>\n

    The following simple code fragment gives an example of these three steps,<\/p>\n

    Example.java<\/em><\/span><\/p>\n

    Connection connObj = DriverManager.getConnection(\"jdbc:myDriver:testDb\", \"myLoginId\", \"myPassword\");\n\t\t\t  \nStatement stmtObj = connObj.createStatement();\nResultSet resObj = stmtObj.executeQuery(\"SELECT test_id, test_name, test_salary FROM testTable\");\nwhile (resObj.next()) {\n\tint id = resObj.getInt(\"test_id \");\n\tString name = resObj.getString(\"test_name \");\n\tfloat salary = resObj.getFloat(\"test_salary \");\n}\n<\/pre>\n
    1.2 What Is ODBC?<\/h3>\n
    Before JDBC, ODBC<\/strong> API was used to communicate with the databases. ODBC API uses ODBC Drivers<\/em> to interact with the databases. Since ODBC drivers are entirely written in C<\/code> language, therefore, they are platform dependent and cause the portability issues.<\/p>\n
    That is why Java has defined its own JDBC API and uses the JDBC drivers (written entirely in the Java language) to interact with the databases.<\/p>\n
    1.3 What are JDBC Drivers?<\/h3>\n
    A JDBC Driver is a software component that enables the Java application to interact with the database. The four different types of JDBC drivers are:<\/p>\n