Using SQLJ with application servers

SQLJ is an alternative to using JDBC for providing persistence to the J2EE application server platform. Because SQLJ is built, in part, on JDBC, it shares many of the same issues JDBC has with data conversion. For more information on the SQLJ interface, see the discussion of Part 0 for SQLJ (new window). Also see the discussion of using JDBC with application servers (new window).

The following diagram is the same one used with the discussion of JDBC and application servers. It is the same because SQLJ sits on top of the JDBC interface. 

Also, be sure to check out how SQLJ can be part of integrated J2EE architecture solutions (new window).

Like JDBC, SQLJ will require data conversion in either the application server or in the applications. See SQLJ data conversion.

SQLJ with application servers

 

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: 4 stars 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: 3 stars 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: 4 stars 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,...

Oracle9i SQLJ Programming
by Nirva Morisseau-Leroy, Martin K. Solomon, Gerald P. Momplaisir
Average Customer Review: 3.5 stars based on 9 reviews.
Customer Review: I wanted to learn more about SQLJ, specifically Oracle SQLJ. I bought this book and I must say, it's worth every penny. I specifically enjoyed the chapters on SQLJ Update Batching and how to handle BLOB and CLOB. It's an excellent book and I recommend it to anyone who wants to learn about SQLJ in general and specifically Oracle SQLJ.

Oracle8i SQLJ Programming
by Nirva Morisseau-Leroy, Martin K. Solomon, Gerald P. Momplaisir
Average Customer Review: 3.5 stars based on 14 reviews.
Customer Review: I found this book delightful reading. The clear exposition, program examples with detailed explanations, clear definitions, and well stated principals makes this a must have book for those wishing to use Java with Oracle8i. The detailed style is reminiscent of the well-known text books by authors Harvey and Paul Deitel. This book is...

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

 

 Information on becoming a sponsor

 

 

Google

 

Barry & Associates, Inc.