Skip to main content

Q) Explain about Types of java database connectivity approaches?



A)
->there are 2 types of connectivity from java application to database server.
1) JDBC-ODBC approach
2) JDBC approach

JDBC-ODBC approach:
->in this kind of connectivity sun Microsystems provided driver is used.
->this driver class is”sun.jdbc.odbc.JdbcOdbcDriver”.
->this driver translates JDBC method calls into ODBC function calls. It can’t translate them into ODBC understandable (SQL) calls.








->In order to associate sun driver with ODBC driver we need to externally make some configuration and give some name to that configuration which is known as DSN ( Data Source Name).

Note:
->DNS is a user defined name given to a configuration in which ODBC driver and underlying database are involved.
->Using ODBC data source Administrator which is a graphical tool. We configure the DNS.

Start->settings->control panel->Administrator tools->data sources(ODBC)->ODBC data source administrator graphical tool is displayed-> click ”add” button ->select the DB-> then oracle ODBC driver manager dialogue box is displayed->give the DNS name->click ok.
 

Comments

Post a Comment

Popular posts from this blog

Q) Explain repeated deletion of records.

A) //RepeatedDeletion.java import java.util.Scanner; import java.sql.*; class RepeatedDeletion {        public static void main(String[] args) {               Connection con= DriverManager. getConnection ( "jdbc:odbc:prince" , "scott" , "tiger" );               PreparedStatement ps=con.PreparedStatement( "DELETE FROM ACCOUNT WHERE ACCNO=?" );               Scanner s= new Scanner(System. in );               while ( true )               {                      System. out .println( "Enter accno : " );      ...
Post a Comment
Read more

Introduction

1) What is not JDBC? 2) What is the purpose of JDBC? 3) What is ODBC? 4) What is JDBC? 5) What is JDBC architecture? 6) What is JDBC client? What are its responsibilities? 7) What is JDBC API?  8) What is driver manager? 9) What is JDBC driver? What is its role in java database connection? 10) What is database server?
Post a Comment
Read more

Q) Retrieving data from database?

A)   ->to retrieve the data from database we need to submit SELECT statement from JDBC application. -> executeQuery() method of statement object is used for this purpose. This method has the fallowing ResultSet executeQuery(String sql) throws SQLException Ex: ResultSet rs = st.executeQuery(“SELECT * FROM ACCOUNT”); ->objectoriented representation of tables formate data is called ResultSet object. Ao the driver created one object i.e. ResultSet object. ->object orientation representation of a table of records returned from db is nothing but “ ResultSet ” object.  
Post a Comment
Read more