Oracle Database Programming Using Java and Web Services or The C Answer Book

Oracle Database Programming Using Java and Web Services

Author: Kuassi Mensah

Data Management /OracleAudience: DBAs and Developers
Oracle Database Programming using Java and Web Services
Pragmatic Solutions for DBA, Database Developers, Data Architects, Java Developers and Web Services Assemblers


"If you are a Java programmer looking to exploit Oracle, or a database developer looking to exploit Java — this is the book for you." -- Thomas Kyte, VP Oracle

Oracle's support for Java in the database has continued to break new ground since it was first introduced in Oracle8i. More importantly, however, it has continued to find a larger audience over time, as people discover just how useful it is in solving their real world problems both efficiently and easily. This book is an important and welcome step forward to helping Java developers make even better use of the Oracle database."
Steven G. Harris -- VP, Java Platform Group

"The book impressed me with its in-depth coverage on practical techniques essential to Java and Web services development across database boundary." -- Quan Wang.

"This book provides a wealth of information regarding the Oracle embedded JVM and how to use it, that is simply not available anywhere else."
" Avi Abrami, Senior Software Engineer, InterSystems (http://www.intersystemsww.com/

Steven G. Harris, VP Java Platform Group, Oracle

The traditional division of labor between the database (which only stores and manages SQL and XML data for fast, easy data search and retrieval) and the application server (which runs application or business logic, and presentation logic) is obsolete. Although the books primary focus is on programming the Oracle Database, the concepts and techniquesprovided apply to most RDBMS that support Java including Oracle, DB2, Sybase, MySQL, and PostgreSQL. This is the first book to cover new Java, JDBC, SQLJ, JPublisher and Web Services features in Oracle Database 10g Release 2 (the coverage starts with Oracle 9i Release 2). This book is a must-read for database developers audience (DBAs, database applications developers, data architects), Java developers (JDBC, SQLJ, J2EE, and OR Mapping frameworks), and to the emerging Web Services assemblers.

Key Features:
*Describes pragmatic solutions, advanced database applications, as well as provision of a wealth of code samples
*Addresses programming models which run within the database as well as programming models which run in middle-tier or client-tier against the database.
*Discusses languages for stored procedures: when to use proprietary languages such as PL/SQL and when to use standard languages such as Java; also running non-Java scripting languages in the database
*Describes the Java runtime in the Oracle database 10g (i.e., OracleJVM), its architecture, memory management, security management, threading, Java execution, the Native Compiler (i.e., NCOMP), how to make Java known to SQL and PL/SQL, data types mapping, how to call-out to external Web components, EJB components, ERP frameworks, and external databases.
*Describes JDBC programming and the new Oracle JDBC 10g features, its advanced connection services (pooling, failover, load-balancing, and the fast database event notification mechanism) for clustered databases (RAC) in Grid environments.
*Describes SQLJ programming and the latest Oracle SQLJ 10g features , contrasting it with JDBC
*Describes the latest Database Web services features, Web services concepts and Services Oriented Architecture (SOA) for DBA, the database as Web services provider and the database as Web services consumer.
*Abridged coverage of JPublisher 10g, a versatile complement to JDBC, SQLJ and Database Web Services.


Kuassi Mensah (kuassi360.blogspot.com) is Group Product Manager within the Java and Web services products group, part of Oracle's server technologies.. He joined Oracle France in 1989 where he sets up the Center of Expertise specializing in systems architecture, performance as well as massively parallel systems. In 1999, he moved to Oracle headquarters . Mr Mensah holds a MS in Computer Sciences and Post graduate degree from the Programming Institute of University of Paris VI. He lives with his wife and two sons in San Francisco.
www.digitalpressbooks.com

Table of Contents:

Pt. I	Java in the database	1
1	Stored procedures as database programming model	3
2	OracleJVM : under the hood	23
3	Developing and running Java in the database	105
4	Pragmatic applications using Java in the database	231
5	Database scripting using non-Java languages	287
Pt. II	Java persistence and Java SQL data access	317
6	Introducing the JDBC technology and Oracle's implementation	319
7	URL, DataSource, connection, and statements	345
8	SQL data access and manipulation	471
9	JDBC quality of services and best practices	625
Pt. III	Oracle database programming with SQLJ	667
10	Introducing the SQLJ technology and Oracle's implementation	669
11	The SQLJ language and Oracle extensions	701
12	SQLJ data access and best practices	755
Pt. IV	Oracle database programming with JPublisher	815
13	Abridged Oracle JPublisher	817
Pt. V	Programming the Oracle database with Web services	875
14	Web services and SOA for DBA, data architects, and others	879
15	Database as Web services provider service	899
16	Database as Web services consumer	945
Pt. VI	Putting everything together	965
17	360-degree programming the Oracle database	967

Look this: Magro Para Maniquíes

The C Answer Book: C Programming Language

Author: Clovis L Tondo

Provides solutions to all exercises in Kernighan & Ritchie's new ANSI C book. Ideal for use with K&R in any course on C. Careful study of this answer book will help understand ANSI C and enhance programming skills. Tondo & Gimpel describe each solution and completely format programs to show the logical flow.

Booknews

Here are solutions to the exercises in The C programming language, 2d ed. by Kernigan and Ritchie. Annotation c. Book News, Inc., Portland, OR (booknews.com)