advertisement
javaboutique
Search Tips
Articles  |   Tutorials  |   Reviews  |   Tools  |   by Category  |   by Date  |   by Name  |   Submit  |   Source  |   Forums  |  
javaboutique
Browse DevX


Partners & Affiliates











advertisement

Reviews : Object-relational Mapping with Cayenne ORM :

Major Components

The major components in Cayenne are:
  • DataAdapter
  • DataObjects
  • Object Graphs
  • DataContext

DataAdapter

The biggest hurdle for any ORM tool is working with multiple databases. Though most databases in the market claim they follow a common standard—similar to the JDBC standard—in reality, they differ greatly from one to the other. Most databases have different sizes and precisions for common datatypes like character, number, and BLOBs and conversions between databases is not straightforward. Additionally, vendors differ in the syntax used for common transactions like outer join, primary key generation, and sequences. To overcome these differences and provide a portable framework, Cayenne provides separate data adapters for each database. The database adapter converts the vendor-specific features of the database into standard JDBC features so that they can be used by any J2EE-based application. Having a standard JDBC format shields you from having to make major changes to the code when data sources have to be swapped.

The DataAdapter acts as a factory for a specific database type. Cayenne comes packaged with adapters for common database types like Oracle, Sybase, MySQL, DB2, and SQL Server. Apart from the common databases, Cayenne has a generic database adapter called JDBCAdapter that can be used to support other databases. This adapter maps the target database's specific datatypes into standard JDBC datatypes. It also acts as a query translator that converts the generic Cayenne query into the target database's specific query. It also provides a list of features supported by the target database and facilitates primary key generation.

DataObjects

DataObjects abstract you from the complexities of the database and allows you to represent data into easy-to-understand Java objects. DataObjects represent database tables, views, and composite relationships as Java objects. DataObjects have attributes that represent the fields in the table and relationships the table has with other tables. In the case of complex DataObjects, they can also contain more DataObjects. These attributes within the DataObject can be accessed using getters and setters. If the accessed attribute is a DataObject, the corresponding DataObject with data is fetched and loaded in memory.

One of the greatest benefits of DataObjects is their ability to represent flattened relationships. Two tables that are not directly related, but are related through a join query, can be flattened and represented in a single DataObject. Cayenne takes care of the join query and keeps you abstracted from the relationships between the tables.

By default, primary and foreign keys are not represented as attributes in the DataObject. This avoids accidental modification of the primary keys. To include primary keys and foreign keys in the DataObject, you need to extend the DataObject class and write getter methods to access the keys. Cayenne provides a DataObjectUtils class to get objects for a primary key and vice-versa. Compound primary keys are also supported.

Object Graphs

The relationships between DataObjects are represented in an object graph. You create an object graph when you make a select query to retrieve data for DataObjects. As more DataObjects are fetched, their relationships are added to the existing graph. Having object graphs ensures that multiple DataObjects representing the same row in the database are not stored in memory. You can make multiple modifications on the DataObjects in the object graph and have all the changes committed to the database at the same time. If, for some reason, all the changes have to be discarded, simply deleting the object graph will do the trick.

DataContext

DataContext is the primary point of entry for your access to Cayenne functionality. The DataContext in turn interacts with the lower-level abstractions like the DataNode and DataAdapters to service user requests. It also manages the state information for the user and isolates changes between user sessions. To maintain session state, DataObjects must be registered with the DataContext. When a query is made directly through the DataContext, any DataObjects returned in the query response are automatically registered with the DataContext. When a DataObject is registered with the DataContext, it keeps a snapshot of the DataObject and tracks any changes made to it by the user. When you've finished with your modifications,call the DataContext's commitChanges() method to persist the changes to the database. The DataContext now reviews all the DataObjects registered with it and creates the select, update, create, or delete queries required for the operations. It also takes care of any primary keys that need to be generated. Once it gets a list of all the changes that are required, it orders them to honor database integrity constraints. It then begins a new transaction with the database and commits all the changes back to the database. If a problem is encountered, all the changes are rolled back and you are notified of the errors.

How to Add Java Applets to Your Site

New on the Java Boutique:

New Review:

Time Management Made Easy with the Quartz Enterprise Job Scheduler
Why not just use the Java timer API? This open source scheduling API boasts simplicity, ease-of-integration, a well-rounded feature set, and it's free!

New Applet:

Reverse Complement
Reverse Complement is a simple applet that converts DNA or RNA sequences into three useful formats.

Elsewhere on internet.com:

WebDeveloper Java
Lots of Java information on webdeveloper.com

WDVL Java
Thorough Java resource at the Web Developer's Virtual Library.

ScriptSearch Java
Hundreds of free Java code files to download.

jGuru: Your View of the Java Universe
Customizable portal with online training, FAQs, regular news updates, and tutorials.

 DevX Skillbuilding from IBM developerWorks
 Avaya DevConnect Center
 Intel Go Parallel Portal
 Internet.com eBook Library
 Microsoft RIA Development Center
 Destination .NET
XML error: not well-formed (invalid token) at line 48
advertisement
Receive Articles via our XML/RSS feed
Receive Articles via our XML/RSS feed

JavaBytes
Internet Cyclone
This powerful, easy-to-use, internet optimizer is for Windows 95, 98, ME, NT, 2000 and XP. It's designed to automatically optimize your Windows settings, boosting your Internet connection up to 200%.

Apple Details iPhone-Mac Developer Event
RIM Ups Ante With Mobile Software Push
Novell Readies Silverlight Clone for Linux
Yahoo Pitches The 'Next Generation of Search'
Alfresco's Latest ECM: Prying Open a Sector?
SaaS Tool Offers Custom Database Development
Microsoft’s Automated Agent: Can We Talk?
Borland Finally Sells CodeGear
Red Hat Heads for the JON 2.0
Out with the Old, in with the New at JavaOne

OpenSocial: The Power of Social Networks in Your Applications
Managing the Modern Network
Virtual Earth?What's New in the Latest Release
Everything You Need to Know About Your iPhone
PerformancePoint 2007: Installing Planning Server
Create Secure Java Applications Productively, Part 1: Use Rational Application Developer and Data Studio
.NET Building Blocks: Custom User Control Fundamentals
Secure Internet File-Sharing with PHP, MySQL, and JavaScript
Getting Started with TBB on Windows
Moving to VoIP: Should You Go It Alone?

Advertising Info  |   Member Services  |   Contact Us  |   Help  |   Feedback  |   Site Map  |   Network Map  |   About



JupiterOnlineMedia

internet.comearthweb.comDevx.commediabistro.comGraphics.com

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info


Legal Notices, Licensing, Reprints, & Permissions, Privacy Policy.

Advertise | Newsletters | Tech Jobs | Shopping | E-mail Offers

Solutions
Whitepapers and eBooks
Microsoft Article: Will Hyper-V Make VMware This Decade's Netscape?
Microsoft Article: 7.0, Microsoft's Lucky Version?
Microsoft Article: Hyper-V--The Killer Feature in Windows Server 2008
Avaya Article: How to Feed Data into the Avaya Event Processor
Microsoft Article: Install What You Need with Windows Server 2008
HP eBook: Putting the Green into IT
Whitepaper: HP Integrated Citrix XenServer for HP ProLiant Servers
Intel Go Parallel Portal: Interview with C++ Guru Herb Sutter, Part 1
Intel Go Parallel Portal: Interview with C++ Guru Herb Sutter, Part 2--The Future of Concurrency
Avaya Article: Setting Up a SIP A/S Development Environment
IBM Article: How Cool Is Your Data Center?
Microsoft Article: Managing Virtual Machines with Microsoft System Center
HP eBook: Storage Networking , Part 1
Microsoft Article: Solving Data Center Complexity with Microsoft System Center Configuration Manager 2007
MORE WHITEPAPERS, EBOOKS, AND ARTICLES
Webcasts
Intel Video: Are Multi-core Processors Here to Stay?
On-Demand Webcast: Five Virtualization Trends to Watch
HP Video: Page Cost Calculator
Intel Video: APIs for Parallel Programming
HP Webcast: Storage Is Changing Fast - Be Ready or Be Left Behind
Microsoft Silverlight Video: Creating Fading Controls with Expression Design and Expression Blend 2
MORE WEBCASTS, PODCASTS, AND VIDEOS
Downloads and eKits
Sun Download: Solaris 8 Migration Assistant
Sybase Download: SQL Anywhere Developer Edition
Red Gate Download: SQL Backup Pro and free DBA Best Practices eBook
Red Gate Download: SQL Compare Pro 6
Iron Speed Designer Application Generator
MORE DOWNLOADS, EKITS, AND FREE TRIALS
Tutorials and Demos
How-to-Article: Preparing for Hyper-Threading Technology and Dual Core Technology
eTouch PDF: Conquering the Tyranny of E-Mail and Word Processors
IBM Article: Collaborating in the High-Performance Workplace
HP Demo: StorageWorks EVA4400
Intel Featured Algorhythm: Intel Threading Building Blocks--The Pipeline Class
Microsoft How-to Article: Get Going with Silverlight and Windows Live
MORE TUTORIALS, DEMOS AND STEP-BY-STEP GUIDES