Java201.com

• Using Global/Distributed Transactions in Java/JDBC with Oracle Real Application Clusters by Sachin Shetty   - [Clicks: 54]
  This document describes some of the ways to leverage the high availability features of Oracle Real Application Cluster (RAC) databases by moving the load balancing functionality from the Oracle server/Oracle driver to your application. In this article, I discuss the ways to achieve load balancing of connections across RAC nodes and yet maintain the sticky nature to the same RAC node for the all of the participants of a single global transaction. I have used Java examples wherever possible, but most of the programming constructs can be mapped to other sufficiently advanced programming languages.
  http://www.onjava.com/pub/a/onjava/2005/12/21/global-distributed-transactions-with-oracle-rac.html - Dec, 2005
• Connecting to a Database with JDBC by Matt Weisfeld   - [Clicks: 74]
  Create an application that demonstrates how to use JDBC to connect to a Microsoft Access database.
  http://www.developer.com/java/data/article.php/3571661 - Dec, 2005
• How To Copy Database Data Using JDBC by Jeff Heaton   - [Clicks: 76]
  Copying database data is a basic, yet endlessly complex task, because not all data copy operations are alike. But the sample database-copy classes you'll find here provide a basic template for nearly every type of copy you need to perform.
  [Includes sample code]
  http://www.devx.com/Java/Article/29873 - Nov, 2005
• Use Stored Procedures for Java Persistence by Eric Bruno   - [Clicks: 60]
  Find out why you should use stored procedures to build your Java persistence layer instead of embedded SQL, entity beans, or tools such as Hibernate. Then learn how to do it.
  [Includes source code]
  http://www.devx.com/Java/Article/29337 - Sep, 2005
• Upcoming Features in JDBC 4 by Frank Sommers   - [Clicks: 44]
  JDBC 4 is the forthcoming release of the Java Database Connectivity API. Currently in Early Draft Review in the JCP (JSR 221), JDBC 4 is a major new release with a strong focus on ease-of-use and programmer productivity. The new JDBC version also introduces support for SQL 2003 data types, including SQL's native XML type. This article surveys the key JDBC 4 features.
  http://www.artima.com/lejava/articles/jdbc_four.html - Sep, 2005
• Gather Crucial JDBC Connection Information with Database Metadata by Kulvir Singh Bhogal   - [Clicks: 36]
  JDBC database connections can provide useful database and ResultSet object information through metadata. Learn how to use JDBC's database-agnostic approach for gathering database metadata.
  [Includes source code]
  http://www.devx.com/dbzone/Article/27992 - Apr, 2005
• Using JDBC and the Template Method Pattern for Database Access by Keith Reilly   - [Clicks: 63]
  JDBC is a simple and flexible way to access a relational database. The knock on JDBC is that it forces a developer to familiarize himself with its API, whose use can often result in reams of duplicate or similar code: get a connection, execute a statement, parse a result set, etc. All of which needs to be wrapped in a try-catch block and synchronized. However, in this article, I'll describe how to use the template method pattern to centralize an application's JDBC code into a single class that can be extended using a minimum of JDBC knowledge.
  http://www.sys-con.com/story/?storyid=48540&DE=1 - Mar, 2005
• JDBC Performance Best Practices by John Goodson   - [Clicks: 86]
  JDBC is at the heart of most Java applications. World-class db expert, John Goodson, explains this crucial API and tells how to get more performance and better results from your JDBC code. If you use JDBC, then you owe it to yourself to watch this one!
  http://www.javalobby.org/eps/jdbc-performance/ - Feb, 2005
• Heterogeneous database replication with SyncML by Jayanthi Suryanarayana, Neil Tunnicliffe   - [Clicks: 63]
  Availability and performance are primary considerations when you're developing distributed applications. But using data stores to address these concerns can result in problems with data synchronization between heterogeneous data stores. In this article, Jayanthi Suryanarayana and Neil Tunnicliffe offer a solution using JDBC APIs and the SyncML standard to achieve generic database data replication.
  http://www-106.ibm.com/developerworks/java/library/j-sync4j/ - Jan, 2005

[Top]

• Writing Database Independent JDBC Applications by Mark Biamonte   - [Clicks: 29]
  Mark Biamonte of DataDirect Technologies explains how to write high performance, database neutral applications with JDBC as we continue our Expert series on improving your database applications.
  http://www.javalobby.org/eps/db-independent-jdbc/ - Mar, 2005

[Top]