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


Partners & Affiliates











advertisement

tutorials : Using CASTOR for DB Access from STRUTS :

Using CASTOR for DB Access from STRUTS

Objective:

In this article we will look at CASTOR JDO, a data access or Object to relational (‘OR’) mapping framework and how it improves the data access code. Our goals should be:

  • Improve the data access code written in the last article using JDBC
  • Discuss how to use CASTOR with the STRUTS application.
  • Demo use of a mapping tool to generate the mapping file for CASTOR.
  • Finally quickly refer to some of the potential limitations of CASTOR as discussed on some other website and discuss possible solutions
For a very good introduction to CASTOR and some details about its capabilities please read: Mapping Java Objects to a Database with Castor-JDO: by Keld H. Hansen, and keep an eye on his next article for additional CASTOR features. Lets get started.

Pre-requisite:

Before starting this you should have read the part 1 and part2. As a starting point for this article, we will use the completed code from part 2 from The Open Stack website look for the Part 2 ZIP file.

Quick Overview:

In part 1 and 2 we built a simple web application with STRUTS and we added a database access code--directly using JDBC. The JDBC code was useful for learning the basics of DB access from STRUTS and looking at how we create the data source using STRUTS, but for a real life application writing JDBC code may not be the best idea. Specifically as it includes the table name and column names as part of the code.

Preparation:

  • You will need to download the starting STRUTS code from The Open Stack website, look for the Part 2 ZIP file. You should also have a database and create the sample table as described in part 2. You will need a JDBC driver for your database. Refer to Part 2 for instruction on setting up MySQL database, creating and populating the sample table and setting up the JDBC driver. We will use the sample EMPLOYEE table that has these three fields: shortname CHAR(5), firstname VARCHAR(25), lastname VARCHAR (30). In part 2, we have provided a sample SQL file ,‘emp.sql’ to create the table in MySQL and add some test data.
  • Download and install CASTOR-–basically this is as simple as downloading the CASTOR zip/tar from Castor web site and extracting the following two jar files: castor- 0.9.4.2.jar and xercesImpl.jar. Add these 2 jars under the WEB- INF/lib directory of the sample web application.

OK! Now we are ready to change our web application for database access!

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.

XML error: undefined entity at line 19
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%.

Linux Vendors Head to the Cloud in Search of Cash
iPhone 3GS: Overheating Fears, OS Update Nears
PostgreSQL 8.4 Revs Up Database Admin, Security
PHP 5.3 Accelerates PHP
Sun Releases NetBeans 6.7 IDE for Java, PHP
Why Firefox Doesn't Take Google Chrome Features
First Major PHP Update in Years Coming Soon
Red Hat CEO Calls on Oracle to Keep Java Open
Google Widens AdSense for iPhone, Android Apps
Eclipse Galileo Releases 33 Open Source Projects

A Taste of JavaFX for the Uninitiated
A Guide to Caching and Compression for High Performance Web Applications
How User-Centered Design Can Put User Stories in Proper Context
Explore C# 4's New Dynamic Types and Named/Optional Parameters
Enterprise Architecture: The Journey Begins Here, Part 2
Create a Syslog Sender/Receiver Using the MS Winsock Control
AMD CodeAnalyst Helps Developers Optimize and Tune Applications
Securing Microsoft's Cloud Infrastructure
Introducing the Azure Services Platform
An Introduction to Microsoft .NET Services for Developers

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