Shravan Mahendra

 Profile Answers by Shravan Mahendra 

• Mar 31st, 2010

 

Here I'm Using Type-4 Driver to connect to Oracle 10g application and there it goes

Step-1: JDBC Driver loading which will be as follows 

       Class.forName("oracle.jdbc.OracleDriver");

Step 2 : Establishing Connection to the loaded Driver 

       Connection con=DriverManager.getConnection ("jdbc:oracle:thin:@127.0.0.1:1521:xe","username","password");

Step 3: Creating the Statements for established Connection

       Statement st=con.createStatement();

       st.executeQuery("SQL QUERY");

Thus how you create a connection to Database from Java Application

Here is the sample code for JDBC Connection  using Type 4 Driver

import java.sql.*;

class ConnectDatabase 

{

public static void main(String[] args) throws Exception

{

Connection con;

Statement st;

Class.forName("oracle.jdbc.OracleDriver");

con= DriverManager.getConnection ("jdbc:oracle:thin:@127.0.0.1:1521:xe","system","tiger");

st=con.createStatement();

st.executeQuery("create table std(id number(1),name varchar2(25))");

}

} 

mfsi_chinmayb

 Profile Answers by mfsi_chinmayb Questions by mfsi_chinmayb

• Apr 6th, 2012

 

For more details go through this site URL : http://scornik.blogspot.in/2011/05/sql-query-performance-test-with-jmeter.html