Oracle9i SQLJ Programming [Paperback]

Nirva Morisseau-Leroy (Author), Gerald P. Momplaisir (Author), Martin K. Solomon (Author)

Book Description

Series: Oracle | Publication Date: June 27, 2001

From the official publishers of Oracle Press books, here is an essential handbook for developers and administrators working with Oracle Portal. The book explains how to build and deploy portal-driven Web sites using Oracle Portal. Step-by-step walkthroughs and significant code samplesdemonstrate methods for rapidly creating robust forms, reports, charts, and content management applications. Written by a member of the Oracle Portal Customer Advisory Board (CAB) and a member of the IOUG-A Portal Special Interest Group (SIG), this Oracle-authorized resource includes Oracle 9i Application Server 1.0.2.2 on CD-ROM.

Editorial Reviews

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

About the Author

Nirva Morisseau-Leroy (Miami, FL) works as an Oracle DBA/Application developer in the Meteorological department at the University of Miami. She has over 16 years experience with database installation, database analysis, design, and implementation. She's a frequent contributor to the South Florida Oracle User's Group including many journal and conference publications in ACM Transactions on Database Systems and associated with the 14th International Conference On Interactive Information and Processing Systems for Meteorology. She has co-authored the following Osborne titles: Oracle8i SQLJ Programming and Orace8i Java Component Programming with EJB, CORBA and JSP. Martin K. Solomon (Miami, FL) has over twenty years database management systems experience as Associate Professor and Assistant Professor at Florida Atlantic University. Gerald Momplaisir (Miami, FL) is a principal consultant and cofounder of Datai Inc. and works as a consultant, project manager, and certified trainer at midsize companies, governmental entities, and Fortune 500 corporations.

Product Details

• Paperback: 687 pages
• Publisher: McGraw-Hill Companies (June 27, 2001)
• Language: English
• ISBN-10: 0072190930
• ISBN-13: 978-0072190939
• Product Dimensions: 8.8 x 7.2 x 1.8 inches
• Shipping Weight: 3.2 pounds
• Average Customer Review: 3.3 out of 5 stars  See all reviews (9 customer reviews)
• Amazon Best Sellers Rank: #3,541,131 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

8 of 8 people found the following review helpful:

1.0 out of 5 stars Most of the programs do not work, August 31, 2001

By A Customer

This review is from: Oracle9i SQLJ Programming (Paperback)

I bought this book, got it home, and ended up spending most of my time fixing the programs and scripts which did not work. The result? Time wasted. I returned this book. It sucks.

6 of 6 people found the following review helpful:

1.0 out of 5 stars Poorly organized, poor programs, August 31, 2001

By A Customer

This review is from: Oracle9i SQLJ Programming (Paperback)

I managed to learn SQLJ from this book, but it was an uphill battle. The authors skip around a lot, and there's a lot of duplication. I had some problems with compiling some of the programs also.

10 of 13 people found the following review helpful:

1.0 out of 5 stars I love SQLJ, but I don't like this book!, August 9, 2001

By A Customer

This review is from: Oracle9i SQLJ Programming (Paperback)

I didn't think much of this book, I'm sorry to say.

I found the organization of the book haphazard and poorly thought out. Also, the database schemas used in this book were somewhat confusing, even for an advanced user of the Oracle database and SQLJ like me. The book does a poor job explaining the simple aspects of SQLJ, but also doesn't cover the advanced aspects of the language well either.

This book suffers from having too many authors, none of whom really seem to understand the details of SQLJ very well, or at least, they don't do a good job explaining them to the reader!

I like SQLJ, and there's no doubt that SQLJ is a more efficient way to access a database from Java than using JDBC, but I wouldn't want to learn SQLJ from this book.

I hate to say this, save your money: buy a different book on SQLJ