JDBC Faqs

JDBC Interview Faqs
# How do I check what table-like database objects (table, view, temporary table,

# How do I create a database connection?

# How do I create a java.sql.Date object?

# How do I create a java.sql.Time object?

# How do I create an updatable ResultSet?

# How do I disallow NULL values in a table?

# How do I display and parse a date?

# How do I execute stored procedures?

# How do I extract SQL table column type information?

# How do I extract a BLOB from a database?

# How do I extract the SQL statements required to move all tables and views from an existing database to another database?

# How do I find all database stored procedures in a database?

# How do I get runtime information about the JDBC Driver?

# How do I implement a RowSetReader? I want to populate a CachedRowSet myself and the documents specify that a RowSetReader should be used.The single method accepts a RowSetInternal caller and returns void. What can I do in the readData method?

# How do I insert a .jpg into a mySQL data base?

# How do I insert an image file (or other raw data) into a database?

# How do I receive a ResultSet from a stored procedure?

# How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getX.X.X method for each column?

# How do I set properties for a JDBC driver and where are the properties stored?

# How do I start debugging problems related to the JDBC API?

# How do I write Greek ( or other non-ASCII/8859-1 ) characters to a database?

# How do you handle your own transaction ?

# How does a custom RowSetReader get called from a CachedRowSet?

# How does one get column names for rows returned in a ResultSet?

# How does the Java Database Connectivity (JDBC) work?

# How many types of JDBC Drivers are present and what are they?

# How to insert and delete a row programmatically? (new feature in JDBC 2.0)

# How to move the cursor in scrollable resultsets?(new feature in JDBC 2.0)

# How to update a resultset programmatically? (new feature in JDBC 2.0)

# I have an application that queries a database and retreives the results into a

# I need to have result set on a page where the user can sort on the column headers. Any ideas?

# I would like to download the JDBC-ODBC Bridge for the Java 2 SDK, Standard Edition (formerly JDK 1.2). I'm a beginner with the JDBC API, and I would like to start with the Bridge. How do I do it?

# If I use the JDBC API, do I have to use ODBC underneath?

# Is is possible to open a connection to a database with exclusive mode with JDBC?

# Is the JDBC-ODBC Bridge multi-threaded?

# Is there a practical limit for the number of SQL statements that can be added to an instance of a Statement object
# JTable ...

# Many connections from an Oracle8i pooled connection returns statement closed. I am using import oracle.jdbc.pool.* with thin driver. If I test with many simultaneous connections, I get an SQLException that the statement is closed. How can I overwrite blob data in an Oracle database? ...

# Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?

# The java.sql package contains mostly interfaces. When and how are these

# There is a method getColumnCount in the JDBC API. Is there a similar method to find the number of rows in a result set?

# Update fails without blank padding. Alhough a particular row is present in the database for a given key, executeUpdate() shows 0 rows updated and, in fact, the table is not updated. If I pad the Key with spaces for the column length (eg if the key column is 20 characters long, and key is msgID, length 6, I pad it with 14 spaces), the update then works!!! Is there any solution to this problem without padding?What isolation level is used by the DBMS when inserting, updating and

# Whan happens when I close a Connection application obtained from a connection Pool? How does a connection pool maintain the Connections that I had closed through the application?

# What JDBC objects generate SQLWarnings?

# What are four types of JDBC driver?

# What are stored procedures?

# What are the common tasks of JDBC?

# What are the components of the JDBC URL for Oracle's "thin" driver and how do I use them?

# What are the considerations for deciding on transaction boundaries?

# What are the different JDB drivers available?

# What are the standard isolation levels defined by JDBC?

# What are the steps required to execute a query in JDBC?

# What are the two major components of JDBC?

# What causes the "No suitable driver" error?

# What does Class.forName return?

# What does it mean to "materialize" data?

# What does normalization mean for java.sql.Date and java.sql.Time?

# What does setFetchSize() really do?

# What driver should I use for scalable Oracle JDBC applications?

# What is Connection pooling?

# What is Connection?

# What is DML?

# What is DriverManager ?

# What is JDBC Driver ?

# What is JDBC Driver interface?

# What is JDBC?

# What is JDO?

# What is Metadata and why should I use it?

# What is a JDBC 2.0 DataSource?

# What is a ResultSet ?

# What is an SQL Locator?

# What is cold backup, hot backup, warm backup recovery?

# What is new in JDBC 2.0?

# What is optimistic concurrency?

# What is pessimistic concurrency?

# What is the JDBC syntax for using a date literal or variable in a standard Statement?

# What is the JDBC syntax for using a literal or variable in a standard Statement?

# What is the advantage of denormalization?

# What is the advantage of using a PreparedStatement?

# What is the best way to generate a universally unique object ID? Do I need to

# What is the difference between client and server database cursors?

# What is the difference between setMaxRows(int) and SetFetchSize(int)? Can either reduce processing time?

# What is the fastest type of JDBC driver?

# What is the most efficient method of replicating data betwen databases using JDBC?

# What is the query used to display all tables names in SQL Server (Query analyzer)?

# What is the significance of DataBaseMetaData.tableIndexStatistics? How to

# What scalar functions can I expect to be supported by JDBC?

# What types of DataSource objects are specified in the Optional Package?

# What's the JDBC 3.0 API?

# What's the best way, in terms of performance, to do multiple insert/update statements, a PreparedStatement or Batch Updates?

# What's the fastest way to normalize a Time object?

# When I intersperse table creation or other DDL statements with DML statements ....

# When an SQL select statement doesn't return any rows, is an SQLException thrown?

# Where can I find info, frameworks and example source for writing a JDBC driver?

# Which Java and java.sql data types map to my specific database types?

# Which is the preferred collection class to use for storing database result sets?

# Which type of JDBC driver is the fastest one?

# Why can't I invoke the ResultSet methods afterLast and beforeFirst when the method next works?

# Why can't Tomcat find my Oracle JDBC drivers in classes111.zip?

# Why do I have to reaccess the database for Array, Blob, and Clob data?

# Why does the ODBC driver manager return 'Data source name not found and no default driver specified Vendor: 0' How to use JDBC to connect Microsoft Access?

# Why doesn't JDBC accept URLs instead of a URL string?

# Why isn't the java.sql.DriverManager class being found?

# Why should I consider optimistic versus pessimistic approaches to database

# alias) are present in a particular database?