JDBC Section Index | Page 19
How can I make batch updates using JDBC?
One of the more advanced features of JDBC 2.0 is the ability to submit multiple update statements to the database for processing as a single unit. This batch updating can be significantly more eff...more
What are SQL3 data types?
The next version of the ANSI/ISO SQL standard defines some new datatypes, commonly referred to as the SQL3 types. The primary SQL3 types are:
STRUCT: This is the default mapping for any SQL struc...more
What does ResultSet actually contain? Is it the actual data of the result or some links to databases? If it is the actual data then why can't we access it after connection is closed?
A ResultSet is an interface. Its implementation depends on the driver and hence
,what it "contains" depends partially on the driver and what the query returns.
For example with the Odbc bridge wh...more
Do I need to commit after an INSERT call in JDBC or does JDBC do it automatically in the DB?
If your autoCommit flag (managed by the Connection.setAutoCommit method) is false, you are required to call the commit() method - and vice versa.
How can I retrieve only the first n rows, second n rows of a database using a particular WHERE clause ?
How can I retrieve only the first n rows, second n rows of a database using a particular WHERE clause ?
For example, if a SELECT typically returns a 1000 rows, how do first retrieve the 100 rows, ...more
Where can I find a comprehensive list of JDBC drivers, including the databases they support?
Sun maintains a fairly current list of JDBC drivers that support the JDBC 2.x and JDBC 1.x APIs, at:
http://industry.java.sun.com/products/jdbc/driversmore
Which is the preferred collection class to use for storing database result sets?
When retrieving database results, the best collection
implementation to use is the LinkedList. The benefits include:
Retains the original retrieval order
Has quick insertion at the head/tail
Doe...more
How do I extract a BLOB from a database?
A BLOB (Binary Large OBject) is essentially an array of bytes (byte[]), stored in the database. You extract the data in two steps:
Call the getBlob method of the Statement class to retrieve ...more
I have the choice of manipulating database data using a byte[] or a java.sql.Blob. Which has best performance?
java.sql.Blob, since it does not extract any data from the database until you explicitly ask it to. The Java platform 2 type
Blob wraps a database locator (which is essentially a pointer to byte)....more
I have the choice of manipulating database data using a String or a java.sql.Clob. Which has best performance?
java.sql.Clob, since it does not extract any data from the database until you explicitly ask it to. The Java platform 2 type Clob wraps a database locator (which is essentially a pointer to char)....more
What properties should I supply to a database driver in order to connect to a database?
Most JDBC drivers should accept 3 properties:
user
password
hostname
However, a JDBC driver may accept an arbitrary number of
properties thrown at it. Drivers can be interrogated...more
How can I investigate the parameters to send into and receive from a database stored procedure?
Use the method getProcedureColumns in interface
DatabaseMetaData to probe a stored procedure for metadata. The
exact usage is described in the code below.
NOTE! This method can only discover para...more
How do I check what table types exist in a database?
Use the getTableTypes method of interface
java.sql.DatabaseMetaData to probe the database for table types.
The exact usage is described in the code below.
public static void main(S...more
How do I extract the SQL statements required to move all tables and views from an existing database to another database?
Boy, this is a big one. :) The operation is performed in 9
steps:
Open a connection to the source database. Use the
DriverManager class.
Find the entire physical layout of the cu...more
How do I find all database stored procedures in a database?
Use the getProcedures method of interface
java.sql.DatabaseMetaData to probe the database for stored
procedures. The exact usage is described in the code below.
public static void...more
