| View: | [ 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 ] |
| Articles Interview Transcripts | Tips |
- The power of table-oriented programming by Fredrik Bertilsson - [Clicks: 50]
Since the introduction of object-oriented programming languages and three-tier architectures, enterprise application designers have tried to hide the relational database structure deep in the application stack. But this increases the software's complexity and forces developers to spend time making extra and, in most cases, unnecessary layers that do little, except delegate to the layer below. This article introduces Butler, a table-oriented Java component library. Butler has an object model on top of Java Database Connectivity (JDBC), which can be used instead of hand-written SQL statements. Butler also has numerous data-aware Swing components, which releases the burden of writing low-level GUI logics in enterprise client applications.
http://www.javaworld.com/javaworld/jw-10-2004/jw-1018-butler.html - Oct, 2004 - Best Practices for JDBC Programming by Derek Ashmore - [Clicks: 88]
While many new database persistence methods for Java programmers have been developed in recent years (e.g., entity beans, JDO, Hibernate, and many others), most database access code is still native JDBC. This statement doesn't express a preference, just an observation.
http://www.sys-con.com/story/?storyid=46653&DE=1 - Oct, 2004 - Using JDBC with MySQL, Getting Started by Richard G. Baldwin - [Clicks: 96]
Baldwin shows you how to download, install, and prepare a MySQL database as a localhost server on a Windows platform for use with JDBC. He then shows you how to write JDBC programs to administer the database server and to manipulate data stored on the MySQL database server.
http://www.developer.com/java/data/article.php/3417381 - Oct, 2004 - Performance Tips for the Data Tier (JDBC) - Part IV - Managing Connections and Updates by John Goodson - [Clicks: 39]
In this JDBC Performance Tip, Part 4 of the JDBC Peformance Series, John Goodson looks at how to manage connections and updates to improve system performance for your JDBC applications. He shows you how to manage transactions, commits in transactions, choose the right transaction model, use updateXXX methods and getBestRowIdentifier().
http://www.theserverside.com/articles/article.tss?l=JDBCPerformance_PartIV - Jul, 2004 - JDBC scripting, Part 2 by James Jianbo Huang - [Clicks: 19]
In Part 2, I concisely introduce JudoScript's programming and Java scripting features, which are all used in a real-world J2EE case study that involves SQL, XML, Enterprise JavaBeans, email, and Web services abstracted as a Java API. The resultant program is short, obvious, and rich in functionality. In the end, I use various criteria to compare JudoScript to other languages.
[Includes source code]
http://www.javaworld.com/javaworld/jw-07-2004/jw-0705-jdbc2.html - Jul, 2004 - Using CachedRowSet to Transfer JDBC Query Results Between Classes by Sean Eidemiller - [Clicks: 67]
JDBC developers have always needed to keep a database connection open while pulling query results. But with the CachedRowSet in J2SE 1.5, it's now possible to disconnect and then get results. Sean Eidmiller shows the advantages of this approach.
[Includes sample code]
http://www.onjava.com/pub/a/onjava/2004/06/23/cachedrowset.html - Jun, 2004 - JDBC scripting by James Jianbo Huang - [Clicks: 15]
… Data processing is one of JudoScript's most important applications. Today's enterprise applications deal with rich data formats such as relational databases, XML, SGML (Standard Generalized Markup Language), abstract data types like EJBs (Enterprise JavaBeans), Web services, as well as spreadsheets and flat files. JudoScript is ideal for multiformat, multisource data processing. This two-part series focuses on JudoScript's JDBC (Java Database Connectivity) scripting support, introduces JudoScript the language, and demonstrates its data processing power with a J2EE case study. Part 1 details JudoScript's JDBC scripting support.
[Includes source code]
http://www.javaworld.com/javaworld/jw-06-2004/jw-0621-jdbc.html - Jun, 2004 - Using the Java CachedRowSet implementation with DB2 UDB by Kulvir Singh Bhogal - [Clicks: 55]
Cached Row Sets are a new offering of Java(tm) 1.5 emerging from the efforts of JSR114. This new capability enables you to have a serializable disconnected object. This means you can connect to the database, grab your data in the form of a result set, release the connection and manipulate it locally, then resume your connection to complete the transaction, thus using far less connection and server resources. This article shows you how to make it work with DB2® Universal Database(tm). Sample code included.
[Includes source code]
http://www-106.ibm.com/developerworks/db2/library/techarticle/dm-0406bhogal/ - Jun, 2004 - Interruptible Database Queries by Slav Boleslawski - [Clicks: 69]
One typical software design goal is responsiveness, understood as how easy and quick it is for the user to interrupt the current operation. Certain operations -- such as complex database queries; network I/O handling; extensive calculations; sorting of, or searching in, large data sets -- can take seconds or even minutes before they complete. Well-designed software allows the user to cancel such a long operation in progress. In this article I will demonstrate how to cancel a time-consuming database query by simply interrupting the thread in which the query runs. Such an interruptible database query will enable you to develop truly interactive programs that respond promptly even to the most impatient users.
[Includes example code]
http://www.onjava.com/pub/a/onjava/2004/06/16/dbcancel.html - Jun, 2004 - Simple classes for JDBC by Madhu Siddalingaiah - [Clicks: 43]
Just about every J2EE application accesses data from a relational database. For this reason, Java Database Connectivity (JDBC) is probably one of the more popular APIs available for the Java platform. JDBC is conceptually simple and easy to use, but in production applications, numerous details can make even the most trivial create/read/update/delete (CRUD) application a chore. Although many frameworks, tools, and APIs can simplify development, they are often too complex. As an alternative, in this article, author Madhu Siddalingaiah presents a small set of classes that is easy use, maintain, and extend.
[Includes source code]
http://www.javaworld.com/javaworld/jw-06-2004/jw-0607-sql.html - Jun, 2004 - Data management and persistence in J2EE applications by G.V.B. Subrahmanyam, Shankar Itchapurapu - [Clicks: 11]
This article examines two data management strategies available on the Java platform: Java object serialization and Java Database Connectivity (JDBC). While neither data management strategy is inherently superior or inferior to the other, when it comes to managing enterprise information systems, JDBC wins hands down. In this article Java developers G.V.B. Subrahmanyam and Shankar Itchapurapu look at both serialization and JDBC, and through discussion and example show you why JDBC is your best bet.
http://www-106.ibm.com/developerworks/java/library/j-datman/ - Jun, 2004 - Performance Tips for the Data Tier (JDBC) - Part 3: Selecing Functions that Optimize Performance by John Goodson - [Clicks: 28]
In this JDBC Performance Tip, Part 3 of the JDBC Peformance Series, John Goodson discusses JDBC objects and methods that improve performance. He looks at how to use parameter markers as arguments to stored procedures, the benefits of using the Statement vs. PreparedStatement object, how to reduce network overhead by using the addBatch() method and more.
http://www.theserverside.com/articles/article.tss?l=JDBCPerformance_PartIII - Jun, 2004 - Performance Tips for the Data Tier (JDBC) Part II - Retrieving Only Required Data by John Goodson - [Clicks: 15]
In this article, Part 2 of the JDBC Peformance Series, John Goodson shows us how to optimize system performance by retrieving data efficiently. He looks at the costs of retrieving long data, how to reduce the size of the data retrieved, choosing the right data types when designing your schema, and gives tips on working with Result Sets.
http://www.theserverside.com/articles/article.tss?l=JDBCPerformance_PartII - May, 2004 - Simple Solution for Complex Java Web Applications: Connection Pools and JDBC by Olexiy Prokhorenko, Alexander Prohorenko - [Clicks: 19]
To the extent that servlets enable you to store information between user requests, connection pools and JDBC can help generate Web content dynamically, quickly loading data from your database to your Web site without exhausting system resources.
http://www.devx.com/Java/Article/20891 - Apr, 2004 - Performance Tips for the Data Tier (JDBC) - Part 1: Using Database MetaData Methods Appropriately by John Goodson - [Clicks: 13]
This series of articles presents some general guidelines for improving JDBC application performance that have been compiled by examining the JDBC implementations of numerous shipping JDBC applications. These guidelines include: - Using Database MetaData methods appropriately; - Retrieve only required data; - Select functions that optimize performance; - Manage connections and updates.
http://www.theserverside.com/articles/article.tss?l=JDBCPerformance - Apr, 2004 - Configuring the SQuirrel JDBC client for use with MySQL by Preeti Iyer - [Clicks: 29]
SQuirrel is an SQL client written in Java that can greatly ease development efforts by permitting the developer to glance at a database’s contents without explicitly issuing query statements, and also view the contents of tables. Additionally, SQuirrel’s friendly GUI provides a SQL area within which to execute and test out SQL commands. This article describes step by step, the process of setting-up and using SQuirrel with another very popular open source offering we should all be familiar with MySQL.
http://javaboutique.internet.com/tutorials/squirrel/ - Mar, 2004 - Converting JDBC Result Sets to XML by Jeff Ryan - [Clicks: 22]
XML is a common data format for passing data between components on disparate platforms. Relational databases are the most common way of persisting operational data. How do you bridge the gap between the two standard structures ?
http://www.developer.com/java/data/article.php/3329001 - Mar, 2004 - Configuring JBoss 4.0 JDBC Connectivity by Deepak Vohra - [Clicks: 162]
JBoss 4.0, developer edition, is an open source application server configured to use HypersonicDB by default. However, some Java 2 Platform Enterprise Edition (J2EE) developers would like to use databases other than HypersonicDB to develop and deploy applications. In this tutorial, we'll look at how to configure JBoss to use other databases.
http://www.onjava.com/pub/a/onjava/2004/02/25/jbossjdbc.html - Feb, 2004 - The Effective Use of Joins in Select Statements by Satya Komatineni - [Clicks: 14]
The story of one such journey from a simple select to a practical, everyday select is presented here in a set of 11 principles. I am hoping this article will be a good companion to non-relational programming languages such as Java, C#, and Perl. The provided examples use SQL Server syntax, but should be applicable to most databases.
http://www.onjava.com/pub/a/onjava/2004/01/07/SQLJoins.html - Jan, 2004
- Database Access Technologies by John Goodson - [Clicks: 18]
John Goodson discusses different methods for accessing data such as JDBC, Rowsets, SQL/XML, XQuery and the criteria for choosing between these differnet technologies. He looks at the proposed changes, performance enhancements and the new connection mechanism in JDBC 4.O. He examines the impact SQL:2003 will have on developers, how applications will use the SQL/XML standard, and the advantages of using a disconnected model for database access.
http://www.theserverside.com/talks/library.jsp#goodson - Mar, 2004
- Closing JDBC Objects Explicitly Can Save You Headaches! by Keith Naas - [Clicks: 10]
http://www.devx.com/tips/Tip/21601 - Jul, 2004 - Experimenting with JDBC by Mark Johnson - [Clicks: 17]
As most people know, JDBC is a mechanism for portable access to relational databases from Java programs. You can use JDBC in your J2EE applications to access relational databases. This tip presents a sample application that uses JDBC. The tip also recommends some good JDBC practices for portability and flexibility.
[Includes sample code]
http://java.sun.com/developer/EJTechTips/2004/tt0426.html#2 - Apr, 2004 - Retrieve the rowCount Without Looping by Shyamala Krishnan - [Clicks: 50]
Use this code to obtain the rowcount in JDBC without looping through the resultset.
http://www.devx.com/tips/Tip/20384 - Mar, 2004
