When to use SQLJ with Java application servers

Because of the issues related to multiple mappings of Java objects to tables and vice versa, it is best to use SQLJ with Java application servers when the data being mapped is quite simple. For example, SQLJ would be an excellent way to look up simple account information based on an account number. There would be little mapping of data needed in this case.

If your data mapping may be complex, however, you should look at either JDO or EJB accelerators:

There is one exception to this recommendation; if you do not have an existing database and plan on entering new data directly from an application server, see how SQLJ can be one of the options for EJB accelerators (new window).

For more information on SQLJ issues related to data mapping, see SQLJ data conversion (new window). 

Also, if you are not familiar with the concept of complex data, see complex data (new window).

Web Services and Service-Oriented Architectures Online articles > Consulting Mentoring Speaking Suggested programs Stencils for the Savvy Manager's Guide Links Mail list Privacy policy Sitemap Contact

Web Services articles XML standards and vocabularies Application server articles > Database concepts and standards Object database articles Relational database articles Object-relational mapping articles XML database articles XML middleware articles Article Sponsorship Reprint policy

Application server definition When an application server should be used Application server achitectures > J2EE architecture solutions Article suggestions

Using JDBC with application servers Using SQLJ with application servers > Using JDO with application servers Using EJB accelerators with application servers

SQLJ data conversion When to use SQLJ with Java application servers >

Related books at Amazon.com

	Professional Java Server Programming J2EE Edition by Subrahmanyam Allamaraju, Andrew Longshaw, Daniel O'Connor, Gordon Van Huizen, Jason Diamond, John Griffin, Mac Holden, Marcus Daley, Mark Wilcox, Richard Browett Average Customer Review: based on 30 reviews. Customer Review: This book is one the most comprehensive ones that I've bought. It provides you with most of the possible technologies that you could use in a basic J2EE application. I love the section on the J2EE architecture. For newbies I typcially request that they read that section first. It does justice to basic topics like JDBC & Servlets & t...
	Understanding SQL and Java Together : A Guide to SQLJ, JDBC, and Related Technologies (The Morgan Kaufmann Series in Data Management Systems) by Jim Melton, Andrew Eisenberg Average Customer Review: based on 4 reviews. Customer Review: In the pletoria of books on Java and databases, this is the one book that just must be read. It gives a thourough enough introduction to JDBC 1.0 and 2.0 and SQLJ Parts 0-2. Very readable! Covers the subjects to just the right level for developers and database experts.
	Professional Java Data: RDBMS, JDBC, SQLJ, OODBMS, JNDI, LDAP, Servlets, JSP, WAP, XML, EJBs, CMP2.0, JDO, Transactions, Performance, Scalability, Object and Data Modeling by Thomas Bishop, Glenn E. Mitchell, John Bell, Bjarki Holm, Danny Ayers, Carl Calvert Bettis, Sean Rhody, Tony Loton, Michael Bogovich, Mark Wilcox, Lin Kelly Poon, Nitin Nanda, Rick Grehan, Matthew Ferris, Kelly Lin Poon Average Customer Review: based on 2 reviews. Customer Review: For the past 2 years Wrox has been publishing books dedicated to Windows-based data access (ADO etc.), but the same cannot be said about their Java/database collection. Although you find chapters on JDBC scattered all-over almost all server-side Java related books by Wrox, there was no single volume from them that teaches JDBC first,...

More related books: Search Amazon.com for SQLJ

Copyright © 2000-2008 Barry & Associates, Inc. All Rights Reserved.
You can use this material for your work or classes. Click here for our reprint policy.
www.service-architecture.com