How do you call a Stored Procedure from JDBC? - The first step is to create a CallableStatement object. As with Statement and PreparedStatement objects, this is done with an open Connection object. A CallableStatement object contains a call to a stored procedure.
CallableStatement cs =
con.prepareCall(”{call SHOW_SUPPLIERS}”);
ResultSet rs = cs.executeQuery();

Is the JDBC-ODBC Bridge multi-threaded? [...]

• 0 Comments

What is a Cartesian product? What causes it?Expected answer:
A Cartesian product is the result of an unrestricted join of two or more tables. The result set of a three table Cartesian product will have x * y * z number of rows where x, y, z correspond to the number of rows in each table [...]

• 0 Comments

Which of the following statements is true about implicit cursors?

Implicit cursors are used for SQL statements that are not named.
Developers should use implicit cursors with great care.
Implicit cursors are used in cursor for loops to handle data processing.
Implicit cursors are no longer a feature in Oracle.

Which of the following is not a feature of a [...]

• 0 Comments

Aaron Boodman took up a job with Microsoft (MSN division) and told the story of his interview in his Weblog. Below is an excerpt of questions potential candidates might find interesting.

Compare and contrast SQL Server with MySQL.
Compare and contrast stored procedures and dynamic SQL.
Describe a standard 3-tier architecture and the interfaces between each tier.
Compare and [...]

• 0 Comments