JDCB

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. (179)

Read More

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…

Read More

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…

Read More

11.What are JDBC driver types? There are four types of JDBC drivers JDBC-ODBC Bridge plus ODBC driver − also called Type 1 calls native code of the locally available ODBC driver. Native-API, partly Java driver − also called Type 2…

Read More

1.What is JDBC? JDBC stands for Java Database Connectivity, which is a standard Java API for database-independent connectivity between the Java programming language and a wide range of databases. (192)

Read More