Skip to main content

Q) What is Batch updates?



A)
->Batch updates is a formality given by JDBC using which, DML SQL statement can be grouped physically into one unit and at a time submitted to the DBMS for processing as a batch.
->Batch updates mechanism improves performance some times by reducing the number of client/server interaction.
->we have 2 kinds of business Systems.
1) OLTPS (Online Transaction Processing Systems)
2) Batch processing System.
To support batch processing systems, batch updates is given in JDBC.
->In case of OLTP, end user waits the system responds after giving input into the system.
->in case of batch processing system, end user doesn’t wait for the systems responds.
ATM application is an example for OLTP.
->At the end of every month, all accounts must be created by their earned interest is an example use case of batch processing.

Comments

Popular posts from this blog

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.  

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 : " );      ...

Q) Develop a JDBC application that prompts the end-user to enter an employee number and displays the salary details.

A) //Retrieval.java import java.util.Scanner; import java.sql.DriverManager; import java.sql.Connection; import java.sql.Statement; import java.sql.ResultSet; class Retrieval {        public static void main(String[] args) {               Scanner s= new Scanner(System. in );System. out .println( "Enter employee number" );               int eno =s.nextInt();               Connection con=DriverManager. getConnection ( "jdbc:odbc:mydsn" , "scott" , "tiger"");" +                            Statement st=con.createStatement();                  ...