JAVA JDBC Programming Interview Questions and Answers

1 :: How you restrict a user to cut and paste from the html page using JAVA Programing?

Using JavaScript to lock keyboard keys. It is one of easiest solutions.

0/5 Rating (0 vote)

Is This Answer Correct?    0 Yes 0 No

2 :: What is Serialization and deserialization in JAVA Programming?

Serialization is the process of writing the state of an object to a byte stream.
Deserialization is the process of restoring these objects.

0/5 Rating (0 vote)

Is This Answer Correct?    0 Yes 0 No

3 :: How to Make Updates to Updatable Result Sets in JDBC?

Another new feature in the JDBC 2.0 API is the ability to update rows in a result set using methods in the Java programming language rather than having to send an SQL command. But before you can take advantage of this capability, you need to create a ResultSet object that is updatable. In order to do this, you supply the ResultSet constant CONCUR_UPDATABLE to the createStatement method.

E.g.
Connection con = DriverManager.getConnection(”jdbc:mySubprotocol:mySubName”);
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet uprs = (”SELECT COF_NAME, PRICE FROM COFFEES”);

0/5 Rating (0 vote)

Is This Answer Correct?    0 Yes 0 No

4 :: How to Retrieve Warnings in JDBC?

SQLWarning objects are a subclass of SQLException that deal with database access warnings. Warnings do not stop the execution of an application, as exceptions do; they simply alert the user that something did not happen as planned. A warning can be reported on a Connection object, a Statement object (including PreparedStatement and CallableStatement objects), or a ResultSet object. Each of these classes has a getWarnings method, which you must invoke in order to see the first warning reported on the calling object

E.g.

SQLWarning warning = stmt.getWarnings();
if (warning != null) {

while (warning != null) {
System.out.println(”Message: ” + warning.getMessage());
System.out.println(”SQLState: ” + warning.getSQLState());
System.out.print(”Vendor error code: “);
System.out.println(warning.getErrorCode());
warning = warning.getNextWarning();
}
}

0/5 Rating (0 vote)

Is This Answer Correct?    0 Yes 0 No

5 :: How to call a Stored Procedure from JDBC?

The first step is to create a CallableStatement object. As with Statement an and PreparedStatement objects, this is done with an open Connection object. A CallableStatement object contains a call to a stored procedure;

E.g.
CallableStatement cs = con.prepareCall(”{call SHOW_SUPPLIERS}”);
ResultSet rs = cs.executeQuery();

0/5 Rating (0 vote)

Is This Answer Correct?    0 Yes 0 No