Skip to Main Content
Oracle and Open Source
book

Oracle and Open Source

by Andy Duncan, Sean Hull
April 2001
Intermediate to advanced content levelIntermediate to advanced
432 pages
13h 2m
English
O'Reilly Media, Inc.
Content preview from Oracle and Open Source

Chapter 8. Building Oracle Applications with Java

Although Java itself isn’t an open source technology, more and more Java developers are building open source environments and applications with this popular language. In this chapter, we’ll focus on two main areas of Java open source activity as they relate to Oracle open source applications. First, we’ll look at three JDBC-based Oracle GUI applications:

jDBA

Provides Oracle database administrators with a complete toolkit of DBA tools for browsing and manipulating database objects. jDBA is similar in concept to the Orac tool, which is based on Perl/Tk and described in Chapter 4. jDBA provides a familiar set of functions that allow you to browse tablespaces, synonyms, views, tables, and other objects, and to manipulate the data within these objects.

ViennaSQL

A Java GUI built with the very latest Java Swing components. ViennaSQL provides an excellent Java-based substitute for SQL*Plus. Like jDBA, this tool lets you examine and manipulate objects in an Oracle database.

DBInspector

A client for Oracle that allows you to browse the data in your Oracle database and to execute SQL.

Later in the chapter, we’ll turn our attention to a trailblazing open source project that combines the best of Oracle and Java:

DB Prism

An open source framework, DB Prism is a servlet engine that can work either as a standalone servlet or plugged into Cocoon. It makes use of Apache JServ, Oracle, PL/SQL, and Java. Using DB Prism, applications built using the ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Procure-to-Pay Guide

Oracle Procure-to-Pay Guide

Melanie Cameron
Expert Oracle Exadata

Expert Oracle Exadata

Kerry Osborne, Randy Johnson, Tanel Pöder
Expert PL/SQL Practices for Oracle Developers and DBAs

Expert PL/SQL Practices for Oracle Developers and DBAs

John Beresniewicz, Adrian Billington, Martin Büchi, Melanie Caffrey, Ron Crisco, Lewis Cunningham, Dominic Delmolino, Sue Harper, Torben Holm, Connor McDonald, Arup Nanda, Stephan Petit, Michael Rosenblum, Robyn Sands, Riyaj Shamsudeen
Achieving Extreme Performance with Oracle Exadata

Achieving Extreme Performance with Oracle Exadata

Rick Greenwald, Robert Stackowiak, Maqsood Alam, Mans Bhuller

Publisher Resources

ISBN: 0596000189Catalog PageErrata