Optimizing Database Transactions with Java Database Connection (JDBC)

Introduction

Currently, Java developers are delivering enterprise database applications. By using the Java Database Connection (JDBC) developers are able to query and update enterprise information stored in databases. However, the issue that continues to surface with database applications is performance. Application performance is critical when developing an enterprise application because typically the application sends database queries to a remote database server.

In a quest to increase performance, this article will discuss the Java classes available in the JDBC Application Programming Interface (API) for optimizing database access. There are two methods available for optimization: prepared statements and stored procedures. This article examines the implementation of prepared statements and stored procedures by analyzing a sample application.

• Read the complete article on-line.

Source Code

Individual Files

• Listing 1
  • JobSelect.java
• Listing 2
  • DataDialog.java
• Listing 3
  • SearchActionListener.java
• Listing 4
  • UpdateActionListener.java
• Listing 5
  • DataDialogActionListener.java

Above Files in Compressed Format

• Windows 95/NT
  • JobSelect.zip
• UNIX
  • JobSelect.tar.gz

Related Books Recommended by Chád Darby

• JDBC Books