Home Page Icon
Home Page
Table of Contents for
Oracle & Open Source
Close
Oracle & Open Source
by Sean Hull, Andy Duncan
Oracle and Open Source
Oracle & Open Source
Preface
Audience for This Book
About This Book
Structure of This Book
About the Software
Conventions Used in This Book
Comments and Questions
Acknowledgments
From Andy
From Sean
1. Oracle Meets Open Source
Introduction to Open Source
What Is Open Source?
Why Open Source?
The Motivation Behind Open Source
The gift culture
The need for innovation
The developer’s itch
A Brief History of Open Source
The early days of artificial intelligence
The rise of the Internet
The birth of Unix
Obstacles
Richard Stallman, GNU, and the Free Software Foundation
Enter Linux
The best of open source
Open source in the commercial world
Eric Raymond and The Cathedral and the Bazaar
The Open Source Definition
The Open Source Crown Jewels
Perl
Tcl
Python
Apache
Oracle and Open Source
Open Source Summary
The Open Source Definition
Conformance
2. Connecting to Oracle
The Oracle Call Interface API
ODBC: Open DataBase Connectivity
JDBC: Java DataBase Connectivity
OCI Functions
Perl
Installing Perl on Unix and Linux
Finding Perl already installed on your system
Building Perl from a prebuilt package
Perl and Linux
Building Perl from source: Phase 1
If you don’t have a C compiler . . .
Building Perl from source: Phase 2
Installing Perl on Windows
Perl DBI
Oraperl
ODBC and Perl DBI
Private DBD::Oracle database handle functions
Installing Perl DBI and DBD::Oracle
Installing Perl DBI on Unix and Linux
Installing Perl DBI on Windows
Perl DBI and OCI
Basic Perl DBI example
Understanding how Perl DBI works with OCI
Perl DBI and PL/SQL
DBD::Oracle private methods
3. Tcl, Perl, and Python
Why Scripted GUIs?
VHLS Languages
Comparing Tcl, Perl, and Python
Object orientation
Linkage to C libraries
Speed
Rapid Application Development ( RAD)
Regular expression handling
Connecting to Oracle
Tcl/Tk
Tk: The GUI Toolkit for Tcl
Installing Tcl/Tk
Installing Tcl/Tk under Unix
Installing Tcl/Tk under Windows
Wish: The Windowing Shell
The Unix widget tour
A Wish example
TclX: Extended Tcl
Installing TclX on Unix
Installing TclX on Windows
Oratcl
Oratcl functions and oramsg global message array
Jobs, events, and the Intelligent Agent
Installing Oratcl
Installing Oratcl on Unix
Installing Oratcl on Windows
Wosql: Oratcl’s Wish SQL Processor
IUD Maker: Oratcl’s Table Maintenance Program
Perl/Tk
Unix and Win32 Perl
Installing Perl/Tk over Perl 5
Installing Perl/Tk on Unix
Installing Perl/Tk on Windows
Installing Perl/Tk on Mac OS X
Program Structure in Perl/Tk
Connecting Perl/Tk to Oracle
OraExplain
Perl/Tk and Perl DBI combined
Perlplus Plug-in
Installing Perlplus on Linux
Python
Installing Python
Installing Python on Unix/Linux
Installing Python on Windows
ActivePython
Using Tkinter with a GUI Example
DCOracle
Installing DCOracle on Unix
Using DCOracle
wxPython
4. Building Oracle Applications with Perl/Tk and Tcl/Tk
Orac
Installing Orac
Installing Orac on Unix
Installing Orac on Linux
Installing Orac on Windows
Customizing ORAC_HOME for multiple users on Unix and Windows
Using Orac
File Menu
File options
Plain Old Documentation
Structure Menu
Press me
DBA Tables Viewer
Object Menu
Tables option drill-downs
User Menu
Sids and addresses
Lock Menu
Tune Menu
Reporting options
SQL Browser/Explain Plan menu option
SQL Menu
The Orac Shell interface
Transaction control
My Tools Menu
Icon Bar
Print Selection button
Database Monitor button
Running Orac over the Web Using Perlplus
Extending Orac
Oddis
Installing Oddis
Using Oddis
File Menu
Options Menu
SQL-Options Menu
User-Objects Menu and All-Objects Menu
System Menu
Optimize Menu
Help Menu
Building Applications with Oratcl and BLT
BLT
Installing BLT on Unix
Installing BLT on Windows
Using BLT
Coding TableSpacer
Running on Unix
Running on Windows
TableSpacer in action
5. Web Technologies
Databases and the Web
Dynamic Content
Personalization
CGI and Web Programming
Caching
The Apache Web Server
Apache and Oracle
Installing Apache
Apache and HTTP
Apache Security
Using Perl with Oracle Web Applications
Installing mod_perl
Connecting to the Database
Using Java with Oracle Web Applications
JavaServer Pages and Java Servlets
JServ
Turbine
Ars Digita Community System
Using HTML Embedded Scripting with Oracle Web Applications
PHP
Installing PHP
Using PHP
PHP and Oracle
EmbPerl
Installing EmbPerl
Using EmbPerl
Mason
Aquarium
6. Building Web-Based Oracle Applications
Karma
Installing Karma
Using Karma
Using Karma for email notification
Running Karma on Windows
Using Karma with multiple databases
Extending Karma
Oracletool
Installing Oracletool
Using Oracletool
OraSnap
Installing OraSnap
Using OraSnap
Extending OraSnap
DB_Browser
Installing DB_Browser
PhpMyAdmin and PhpOracleAdmin
Installing PhpMyAdmin
Using PhpMyAdmin
WWWdb
Installing WWWdb
Installing special Perl modules
Installing WWWdb itself
Using WWWdb
Extending WWWdb
Big Brother
Installing Big Brother
Using Big Brother
7. Java
Java Foundations
The Road to Java
Installing Java
Unix-specific downloads
Installing Java on Unix and Linux
Installing Java on Windows
Java Programming
Portability and the JVM
Bytecode versus object code
Running applets
Writing a full Java program
JAR files and the jar utility
Java environment variables
JDBC: Java DataBase Connectivity
java.sql Drivers for JDBC and Oracle
Types of drivers
Which driver?
Connecting Oracle and Java
The JDBC API
Datatypes
Preparing SQL and using cache optimization
Java GUIs
Java Swing
Developing the GUI Program
Compiling and Running the GUI Program
Combining Java Swing with Java JDBC
Java and the Web
Java Servlets
JavaServer Pages ( JSP)
Installing JSDK
Servlet Runners and Other Web Servers
Apache JServ
Apache JServ, the Jakarta Project, and Tomcat
Installing Apache JServ on Unix
Installing Apache JServ on Windows
Running JServ on Unix
Testing the configuration
Setting up servlet zones
Running JServ on Windows
Running an Oracle Servlet
Configuring the Oracle servlet on Unix
Configuring the Oracle servlet on Windows
Running the servlet
8. Building Oracle Applications with Java
jDBA
Installing jDBA
Installing jDBA on Unix and Linux
Installing jDBA on Windows
Configuring JDBC
Using jDBA
ViennaSQL
Installing ViennaSQL
Using ViennaSQL
Schema objects
ViennaSQL and XML
DBInspector
Installing DBInspector
Using DBInspector
DB Prism
Installing DB Prism
Required HTP, HTF, and OWA packages
Installing DB Prism on Unix
Using DB Prism
Oracle Adapters for DB Prism
Cocoon
Installing Cocoon
Configuring Cocoon
Testing Cocoon
Demonstrating Cocoon and DB Prism
9. GNOME and GTK+
Windowing Foundations
The GNOME Project
GNOME
GTK+
GIMP
Installing Gnome/GTK+
Using GNOME/GTK+
GTK+ on Windows
GTK+ on BeOS
Programming with GTK+
Sample Program
Events
Callbacks
Signals
Widgets
Classes
Datatypes
User Interface Builders
GTK+ Language Support
10. Building Oracle Applications with GNOME and GTK+
Orasoft Applications Suite
Installing Orasoft
Installing Orasoft with an RPM
Installing Orasoft from source
Using Orasoft
Object Manager
SQLWork
Procedit
Session Monitor
Table Browser
Extending Orasoft
GNOME-DB
Installing GNOME-DB
Using GNOME-DB
Extending GNOME-DB
gASQL
Installing gASQL
Using gASQL
Extending gASQL
Gnome Transcript
Installing Gnome Transcript
Using Gnome Transcript
Extending Gnome Transcript
Gaby
Installing Gaby
Using Gaby
A. Oracle8i And Linux
Downloading Oracle8i for Linux
Installing Oracle8i on Linux
Q & A for Oracle on Linux
Improving Performance on Linux
B. PL/SQL and Open Source
PLNet.org
utPLSQL
More PL/SQL Links
C. For Further Reading
Chapter 1
Chapter 2
Chapter 3
Chapter 4
Chapter 5
Chapter 6
Chapter 7
Chapter 8
Chapter 9
Chapter 10
Appendix A
Appendix B
Index
Colophon
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Cover
Next
Next Chapter
Preface
Oracle & Open Source
Andy Duncan
Sean Hull
Editor
Debby Russell
Copyright © 2001 O'Reilly Media, Inc.
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset