JDBC

41.How will you insert multiple rows into a database in a single transaction? Follow steps as below //turn off the implicit commit Connection.setAutoCommit(false); //..your insert/update/delete goes here Connection.Commit(); //a new transaction is implicitly started.

31.How do you handle SQL NULL values in Java? SQL’s use of NULL values and Java’s use of null are different concepts. There are three tactics you can use Avoid using getXXX( ) methods that return primitive data types. Use…

21.What do you mean by fastest type of JDBC driver? JDBC driver performance or fastness depends on a number of issues Quality of the driver code, size of the driver code, database server and its load, Network topology, Number of…