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 :

Object-relational Mapping with Cayenne ORM

by Benoy Jose

As databases and applications become increasingly complex, application architects see value in having system-generated classes, compared to hard written value objects and data access objects. This trend towards using system-generated classes has fueledthe market for JDO-based systems and object-relational mapping (ORM) tools. Cayenne falls into the same category and competes with the best of the tools in this arena. Cayenne is an open source, production-quality ORM tool that provides an object-based access to relational databases. Cayenne's stand-out features are the fact that it's open source and its ease-of-use.

This article will take you through some of the features that make Cayenne a powerful choice for your ORM needs. Cayenne comes with a GUI-based ORM tool that generates Java classes and also provides an API to access thosesame classes.

Features

  • Automatic code generation
  • Support for multiple databases
  • Support for non-RBDMS data sources like flat files and XML schemas
  • Automatically manages batched transactions with integrity constraints
  • Expression language support
  • In-memory sorting for quicker pagination
  • Query pre-fetching
  • A Java Query API
  • Simultaneously commits to multiple databases
  • Local and distributed caching
  • DataViews for composite user defined objects
  • Integrated ANT support
  • Validation of data objects before committing them to the database
  • User Interface (CayenneModeler) for modeling
  • Support for container managed transactions
  • Generic event handling support
  • Transparent and automatic primary key generation

Architecture

The heart of a Cayenne application is the cayenne.xml file. This file contains all the meta-data information about the underlying database. The cayenne.xml file contains information about the DataContext, DataDomian, and the DataNode. It also has information on where the DataMap .xml file is stored. The DataMap has information about the database tables, views, and their relationships with other tables.

The DataNode is the lowest layer of abstraction in Cayenne and represents a physical data source. It directly interacts with the physical database and performs the actual database operations. The DataNode converts Cayenne queries into the target database specific queries and executes them against the target database. It then converts the resultant JDBC ResultSet into objects and sends them back to the calling program. It also takes handles target, database-specific features like, sequences, outer joins, and primary key generation.

The DataDomain is the next layer of abstraction that lies above the DataNode. It acts as a controller to multiple DataNodes and routes requests to appropriate DataNodes. DataDomain can abstract multiple databases and database types and transparently manage the connection to these different data sources.

The next higher level of abstraction is the DataContext and is directly exposed to the developer. The DataContext acts as a bridge to multiple data sources through the DataDomain. The DataContext keeps track of changes made to the database records (DataObjects) and synchronizes the changes with the database when the user commits the changes. You can batch multiple database operations without writing any SQLs and then decide to commit all of them to the database at one shot. The DataContext will analyze the changes and order them so that database integrity constraints are respected and data inconsistencies are resolved. You can also use the DataContext to pre-fetch primary data and use lazy loading to load the rest of the related data.

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.

 Avaya Developer Showcase
 MSDN Spotlight
 PHP for Windows Showcase
XML error: undefined entity at line 34
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%.

IBM Brings Developers Into the Cloud
Apache at 10: You Can't Buy Us
Microsoft's CodePlex Foundation Moving Forward
Apple Claims 100,000 Apps, Google Analyzes Them
Nokia Latest to Play Opera Mobile 10 Browser
PayPal Opens Up Payment Platform to Devs
Ubuntu Linux 9.10 'Karmic Koala' Starts Its Climb
IBM Links Rational Developer Tools, Tivoli Apps
Libraries Give Vista Apps a Windows 7 Look
Ubuntu: The 'Default Alternative' to Windows?

Delivering Web-based Embedded Fonts in CSS 3
Adobe Helps PHP Developers Create Rich Internet Applications
Java Developers Finding a Home at Adobe Flex
Virtualization Delivers a Dynamic Infrastructure
Consuming XML Web Services in iPhone Applications
Build a More Agile Business with IBM
POJO-Based Solutions for LDAP Access: One Good, One Better
IBM Offers Enhanced Measurement and Management for Energy Usage
IBM Helps Transformation to an Information-Based Enterprise
Top Five Touch UI-Related Design Guidelines

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

internet.commediabistro.comJusttechjobs.comGraphics.com

Search:

WebMediaBrands Corporate Info

Legal Notices, Licensing, Reprints, Permissions, Privacy Policy.
Advertise | Newsletters | Shopping | E-mail Offers | Freelance Jobs