skip to content
Java programming with Oracle SQLJ Preview this item
ClosePreview this item
Checking...

Java programming with Oracle SQLJ

Author: Jason Price
Publisher: Sebastopol, CA : O'Reilly, ©2001.
Edition/Format:   Print book : EnglishView all editions and formats
Summary:

SQLJ lets you access an Oracle database from a Java program. In this book, Jason Price explains SQLJ programming from a task-oriented point of view. It moves from the basics of getting connected and  Read more...

Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy online

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Material Type: Internet resource
Document Type: Book, Internet Resource
All Authors / Contributors: Jason Price
ISBN: 0596000871 9780596000875
OCLC Number: 47044897
Notes: Includes index.
Description: xiii, 381 pages : illustrations ; 24 cm
Contents: Comparing SQLJ and JDBC 1 --
SQLJ Components 3 --
Requirements for Using SQLJ 3 --
Configuring Your Environment 4 --
A "Hello World" Program for SQLJ 6 --
Sqlj Command-Line Utility 10 --
Oracle JDeveloper 11 --
2. Relational Databases, SQL, and PL/SQL 20 --
Relational Databases 20 --
Structured Query Language (SQL) 21 --
PL/SQL 37 --
3. Fundamental SQLJ Programming 54 --
SQLJ Programs 54 --
Database Connections 55 --
Simple SQLJ Statements 57 --
Transactions 67 --
Queries That Return Multiple Rows 72 --
Nested Cursors 87 --
PL/SQL in SQLJ 94 --
4. Database Objects 105 --
Defining Object Types 106 --
Object Columns and Object Tables 108 --
Creating Custom Classes 113 --
Accessing Database Objects Using SQLJ 124 --
Object Identifiers and REF Columns 137 --
5. Collections 149 --
VARRAYs 149 --
Nested Tables 151 --
Storing an Object Type in a Collection 154 --
Collection Custom Classes 156 --
Accessing Collections Using SQLJ 156 --
6. Deploying SQLJ in the JServer 176 --
Understanding the Oracle JServer 176 --
Designing Server-Based SQLJ Programs 177 --
Translating SQLJ Programs 184 --
Loading SQLJ Programs into the Database 185 --
Publishing Class Methods 187 --
Using Database Triggers 195 --
Using JDeveloper to Translate and Load SQLJ Programs 200 --
Using Enterprise JavaBeans 207 --
7. Large Objects 219 --
Example Files and Directories 219 --
Large Objects (LOBs) 221 --
LONG and LONG RAW Columns 248 --
8. Contexts and Multithreading 266 --
Connection Contexts 266 --
Execution Contexts 274 --
Multithreaded SQLJ Programs 283 --
9. Advanced Transaction Control 290 --
Transaction Processing Problems 290 --
Transaction Isolation Levels 291 --
SET TRANSACTION Statement 291 --
A Transaction Isolation Level Example 292 --
10. Performance Tuning 300 --
Row Prefetching 300 --
Batch Processing 305 --
Tuning SQL Statements 311 --
Oracle Optimizer 314 --
11. Combining JDBC, SQLJ, and Dynamic SQL 323 --
Static and Dynamic SQL 324 --
Sharing Database Connections 328 --
SQLJ Iterators and JDBC Result Sets 335 --
A. Java and Oracle Type Mappings 343 --
B. Oracle Java Utilities Reference 346 --
C. SQLJ in Applets, Servlets, and JavaServer Pages 356.
Responsibility: Jason Price.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/47044897> # Java programming with Oracle SQLJ
    a schema:Book, schema:CreativeWork ;
    library:oclcnum "47044897" ;
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/cau> ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/12594486#Place/sebastopol_ca> ; # Sebastopol, CA
    schema:about <http://experiment.worldcat.org/entity/work/data/12594486#CreativeWork/oracle_computer_file> ; # Oracle (Computer file)
    schema:about <http://id.worldcat.org/fast/1363816> ; # Oracle (Computer file)
    schema:about <http://id.worldcat.org/fast/982065> ; # Java (Computer program language)
    schema:about <http://id.worldcat.org/fast/1102869> ; # SQL (Computer program language)
    schema:about <http://dewey.info/class/005.133/e21/> ;
    schema:bookFormat bgn:PrintBook ;
    schema:copyrightYear "2001" ;
    schema:creator <http://experiment.worldcat.org/entity/work/data/12594486#Person/price_jason> ; # Jason Price
    schema:datePublished "2001" ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/12594486> ;
    schema:inLanguage "en" ;
    schema:name "Java programming with Oracle SQLJ"@en ;
    schema:productID "47044897" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/47044897#PublicationEvent/sebastopol_ca_o_reilly_2001> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/12594486#Agent/o_reilly> ; # O'Reilly
    schema:url <http://proquest.safaribooksonline.com/main.asp?bookname=orasqlj> ;
    schema:url <http://swbplus.bsz-bw.de/bsz094916993vlg.htm> ;
    schema:url <http://swbplus.bsz-bw.de/bsz094916993cov.htm> ;
    schema:workExample <http://worldcat.org/isbn/9780596000875> ;
    umbel:isLike <http://bnb.data.bl.uk/id/resource/GBA164455> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/47044897> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/12594486#CreativeWork/oracle_computer_file> # Oracle (Computer file)
    a schema:CreativeWork ;
    schema:name "Oracle (Computer file)" ;
    .

<http://experiment.worldcat.org/entity/work/data/12594486#Person/price_jason> # Jason Price
    a schema:Person ;
    schema:familyName "Price" ;
    schema:givenName "Jason" ;
    schema:name "Jason Price" ;
    .

<http://experiment.worldcat.org/entity/work/data/12594486#Place/sebastopol_ca> # Sebastopol, CA
    a schema:Place ;
    schema:name "Sebastopol, CA" ;
    .

<http://id.worldcat.org/fast/1102869> # SQL (Computer program language)
    a schema:Intangible ;
    schema:name "SQL (Computer program language)"@en ;
    .

<http://id.worldcat.org/fast/1363816> # Oracle (Computer file)
    a schema:CreativeWork ;
    schema:name "Oracle (Computer file)" ;
    .

<http://id.worldcat.org/fast/982065> # Java (Computer program language)
    a schema:Intangible ;
    schema:name "Java (Computer program language)"@en ;
    .

<http://worldcat.org/isbn/9780596000875>
    a schema:ProductModel ;
    schema:isbn "0596000871" ;
    schema:isbn "9780596000875" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.