Accessing Oracle Server through Web Interface

JDBC Tutorials - Herong's Tutorial Examples

∟Oracle Express Edition Installation on Windows

∟Accessing Oracle Server through Web Interface

This section describes how to access an Oracle Server through its Web interface.

Warning: Oracle Application Express (APEX) Web portal is no longer included in the Oracle Database XE package. You need to download and install it separately. Or you can skip APEX and use SQL*Plus only.

After you have installed Oracle 10g XE, it will allow you access the server through a Web interface. In another word, the Oracle server is listening HTTP requests on a specific port, 8080, by default. Here is how I logged in to the Oracle server with Web browser:

Make sure the Oracle 11g XE server is running.
Open an Web browser, like Firefox.
Enter this URL: http://localhost:8080/apex/apex_admin. I got the Oracle Application Express administration Login page.
Enter "ADMIN" as Username and "HerongY@ng" as Password. Click the Login button. I got the reset password page.
Reset the password to "T0p$ecret".
Login again with the new password at http://localhost:8080/apex/apex_admin.

Oracle Application Express Admin Page

Table of Contents

About This Book

JDBC (Java Database Connectivity) Introduction

JDK (Java SE) Installation

Installing and Running Java DB - Derby

Derby (Java DB) JDBC Driver

Derby (Java DB) JDBC DataSource Objects

Java DB (Derby) - DML Statements

Java DB (Derby) - ResultSet Objects of Queries

Java DB (Derby) - PreparedStatement

MySQL Installation on Windows

MySQL JDBC Driver (MySQL Connector/J)

MySQL - PreparedStatement

MySQL - Reference Implementation of JdbcRowSet

MySQL - JBDC CallableStatement

MySQL CLOB (Character Large Object) - TEXT

MySQL BLOB (Binary Large Object) - BLOB

►Oracle Express Edition Installation on Windows

Oracle Database Express Edition (XE) Installation

►Accessing Oracle Server through Web Interface

Creating Oracle Database Users

SQL*Plus - Oracle Command Line Interface

SQL*Plus - Create New User and Login

Oracle JDBC Drivers

Oracle - Reference Implementation of JdbcRowSet

Oracle - PreparedStatement

Oracle - JBDC CallableStatement

Oracle CLOB (Character Large Object) - TEXT

Oracle BLOB (Binary Large Object) - BLOB

Microsoft SQL Server Express Edition

Microsoft JDBC Driver for SQL Server

Microsoft JDBC Driver - Query Statements and Result Sets

Microsoft JDBC Driver - DatabaseMetaData Object

Microsoft JDBC Driver - DDL Statements

Microsoft JDBC Driver - DML Statements

SQL Server - PreparedStatement

SQL Server CLOB (Character Large Object) - TEXT

SQL Server BLOB (Binary Large Object) - BLOB

JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver

JDBC-ODBC Bridge Driver - Flat Text Files

JDBC-ODBC Bridge Driver - MS Access

JDBC-ODBC Bridge Driver - MS SQL Server

Summary of JDBC Drivers and Database Servers

Using Connection Pool with JDBC

Archived Tutorials

Full Version in PDF/EPUB