Oracle9i SQLJ Programming - Softcover

Morisseau-Leroy, Nirva; Solomon, Martin K.; Momplaisir, Gerald P.

Softcover

ISBN 10: 0072190930 ISBN 13: 9780072190939

Publisher: McGraw-Hill Osborne Media, 2001

Synopsis

An updated handbook encompasses information on the new features of Oracle9i in regard to SQL program development, basic SQL programming, developing SQLJ stored programs and triggers, advanced SQLJ, and object-relational processing using SQLJ, with case studies that demonstrate the practical, real-world applications of SQLJ. Original. (Intermediate/Advanced)

About this title

About the Authors

Nirva Morisseau-Leroy, MSCS, is an Oracle Database Administrator and Application Developer at the National Oceanic and Atmospheric Administration (NOAA) University of Miami Cooperative Institute for Marine and Atmospheric Sciences, assigned to the Hurricane Research Division (HRD) of the Atlantic Oceanographic and Meteorological Laboratory (AOML). She has over sixteen years of information systems experience as an Oracle DBA, Application Developer, and MIS director utilizing, Java, JDBC, SQLJ, SQL, Oracle PL/SQL, and UNIX C/C++. Her major areas of expertise are in users' requirements elicitation, object-relational database analysis, design, implementation, and administration. She can be reached at nmorisseauleroy@data-i.com.

Dr. Martin K. Solomon is an Associate Professor of Computer Science and Engineering at Florida Atlantic University. His major areas of research include the design, implementation, and theory of database systems, computational complexity theory, and the philosophical aspects of computability. Dr. Solomon has published articles on these topics in such prestigious journals as ACM Transactions on Database Systems, Communications of the ACM, Journal of Symbolic Logic, and British Journal for the Philosophy of Science. He has a strong professional internet in all aspects of the Oracle RDBMS, and is a frequent contributor to the South Florida Oracle Users Group Newsletter. Dr. Solomon can be reached by e-mail at: marty@cse.fau.edu.

Gerald P. Momplaisir has been working professionally in the information technology field for over thirteen years. During this time, he served in the military in technical and management cpacities, and later at an NOAA environmental research laboratory where he functioned as a programmer/computer specialist--eventually ascending to Director of Computer Services. During the past eight years, he has specialized in Oracle, object-oriented systems, and internetworking technologies. His love for database systems and object-oriented technologies led him to attain a graduate degree in Computer Science after completing a thesis on the design and implementation of a financial system using a semantic (object-oriented) database and C++. A principal consultant and cofounder of Dati Inc., he currently works as a consultant, project manager, and certified trainer at midsize companies, government entities, and Fortune 500 corporations. He can be reached at gmomplaisir@data-i.com.

From the Back Cover

Create Powerful, Flexible Applications with SQLJ

Take advantage of greater programming capabilities with SQLJ--a standard language specification that embeds SQL statements in Java--in the Oracle9i environment. Officially authorized by Oracle Corporation, this authoritative resource explains how to develop hosted applications, achieve remarkable scalability, implement real-time business intelligence features, and reach a new level of programming functionality. Get comprehensive coverage of SQLJ programming techniques, including SQL programming and development, SQLJ stored programs, triggers, and object-relational processing. Oracle9i SQLJ Programming will help you control each piece of the development process. Discover the benefits of Oracle's highly developed SQL-embedded Java programming standard.

• Develop SQLJ programs, applets, stored procedures, and database triggers
• Build object-oriented applications to access SQL databases on any Java-compatible platform
• Manage multiple database connections with SQLJ
• Tune SQL and SQLJ source code to improve performance
• Learn SQLJ programming essentials, such as executing commands, statements, and transaction processing
• Distribute business and scientific object components over networks
• Deploy SQLJ components with Java Remote Method Invocation (RMI), Enterprise JavaBeans (EJB), and CORBA objects
• Connect to databases and run programs using JDBC drivers
• Use the JDBC 2.0 LOB (BLOB and CLOB) types and the Oracle BFILE data type in SQLJ
• Convert Java streams to SQLJ Streams to communicate with the Oracle database.
• Develop multi-threaded applications with SQLJ

Edition details

• Publisher: McGraw-Hill Osborne Media
• Publication date: 2001
• Language: English
• ISBN 10: 0072190930
• ISBN 13: 9780072190939
• Binding: Paperback
• Number of pages: 687