JDBC FAQ

Author: java.sun.com | Published: 13th Aug 2005 | Visited: 866 times | Add Comment
Filed in: Java FAQ

Frequently Asked Questions about JDBC: The JDBC 3.0 API is the latest update of the JDBC API. It contains many features, including scrollable result sets and the SQL:1999 data types.The JDBC-ODBC Bridge provides a limited subset of the JDBC 3.0 API.

Read Article

Sponsored Links

• Using JDBC in Web Applications Built with Sun Java Studio Creator 2 Learn when and how best to add your own JDBC dtabase access code to web applications developed with Sun Java Studio Creator 2 in this tech tip by Mikhail Matveev and Beth Ste ...

• J2EE and SQL Server: Making a JDBC Connection Using a SQL Server back end with a Java application server may sound like an unnatural proposition but there's no need to bow to such arbitrary limitations. In this article you'll get step-by-step instructions on making a JDBC connection between the four most popular Java application serve ...

• New JDBC SQL/XML Features Improve XML Data Handling One of the most noteworthy updates to JDBC 4 is the support for the XML data type, which improves XML data handling and reduces development t ...

• Inserting rows & getting the generated primary key in JDBC (in one transaction) Tom I have a table with a auto-incrementing id. From time to time I want to insert rows to this table, but want to be able to know what the pk of the newly inserted row is. One way I could do this is: SQL> variable var1 number; SQL> insert i ...

• Developing JDBC Applications with DB2's pureXML Combining XML's features with JDBC provides powerful choices for manipulating data within your Java applications. Find out which new DB2 features simplify this integrat ...

• Build a Low Overhead Test Bed for Your JDBC Code Testing your Java applications against a database can be a pretty painless endeavor thanks to the Cloudscape database built in to IBM's Rational Application Developer. For those who have an interest in this platform, this article will show you the ropes of setting up a simple test bed for your ...

• JDBC 4.0 Enhancements in Java SE 6 Java SE 6 (aka Mustang) brings with it a new set of improvements to the JDBC API for accessing databases. Improvements include support for the RowID interface, better exception handling, annotation-based queries, and (finally!) and end to the clumsy Class.forName() system of loading database dr ...

• Making the Most of JDBC with WebRowSet Database to XML and back again. If everyone's doing some or all of this, then shouldn't we write it once, get it right, and standardize? JDBC 3.0's WebRowSet offers a profound increase in power over the old ResultSet. Sharad Acharya shows you what's possible. ...

Next: JavaBeans FAQs - EJB Faq