JDBC Tutorials - Herong's Tutorial Examples - v3.12, by Dr. Herong Yang
Archived: Oracle Database Express Edition (XE) Installation
This section describes how to download, install, and start Oracle Database 11g/10g Express Edition (XE).
Oracle offers free releases called Oracle Database Express Edition (XE), which are great starter databases for any Java JDBC developers who wants to try it on their own system.
Here is what I did to download and install Oracle Database 11g Express Edition on my Windows XP computer:
1. Go to Oracle Express Edition Website at https://www.oracle.com/database/technologies/appdev/xe.html.
2. Click on "Downloads" and select "Oracle Database Express Edition 11g Release 2 for Windows x32" to start the download.
3. Save the downloaded file, OracleXE112_Win32.zip (216,933,372 bytes), to \temp folder.
4. Unzip the downloaded file to \temp\oracle folder.
5. Double click the \temp\oracle\DISK1\setup.exe. The installation wizard starts. Follow instructions given by the wizard to continue.
6. Enter "HerongY@ng" as admin password, and select \local\oraclexe as the installation destination folder. You should see the following on the confirmation screen:
Destination Folder: C:\local\orablexe\ Oracle Home: C:\local\orablexe\app\oracle\product\11.2.0\server\ Oracle Base:C:\local\orablexe\ Port for 'Oracle Database Listener': 1521 Port for 'Oracle Services for Microsoft Transaction Server': 2030 Port for 'Oracle HTTP Listener': 8080
7. Click "Next" to finish the installation.
To start Oracle XE server, Click on Start > All Programs > Oracle Database 11g Express Edition > Start Database.
To stop Oracle XE server, Click on Start > All Programs > Oracle Database 11g Express Edition > Stop Database.
Here is what I did to download and install Oracle Database 10g Express Edition on my Windows XP computer:
1. Go to the Oracle Express Edition page.
2. Download the Oracle Database 10g Express Edition (Universal) - Multi-byte Unicode database for all language deployment, with the Database Homepage user interface available in the following languages: Brazilian Portuguese, Chinese (Simplified and Traditional), English, French, German, Italian, Japanese, Korean and Spanish.
3. Save the download file, OracleXEUniv.exe (216,933,372 bytes), to a temporary directory.
4. Double click on OracleXEUniv.exe. Follow the installation wizard to finish the installation. Remember to change the destination directory, set the SYTEM password and take some notes like:
SYSTEM password: Yang Destination Folder: C:\local\oraclexe\ Port for 'Oracle Database Listener': 1521 Port for 'Oracle Services for Microsoft Transaction Server': 2030 Port for HTTP Listener: 8080
To start Oracle XE server, Click on Start > All Programs > Oracle Database 10g Express Edition > Start Database.
To stop Oracle XE server, Click on Start > All Programs > Oracle Database 10g Express Edition > Stop Database.
Table of Contents
JDBC (Java Database Connectivity) Introduction
Installing and Running Java DB - Derby
Derby (Java DB) JDBC DataSource Objects
Java DB (Derby) - DML Statements
Java DB (Derby) - ResultSet Objects of Queries
Java DB (Derby) - PreparedStatement
MySQL JDBC Driver (MySQL Connector/J)
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 - Reference Implementation of JdbcRowSet
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: Downloading and Installing JDK on Windows
Archived: Java SE 8 Installation
Archived: Java SE 1.6 Update 2 Installation
Archived: JDK 1.6 Documentation Installation
Archived: Downloading/Installing Java DB (Derby) 10.2.2
Archived: "sysinfo" - Checking Java DB Installation 10.2.2
Archived: MySQL Connector/J 5.1 - Download and Installation
Archived: MySQL 5.0 Download, Installation and Start
Archived: mysqladmin - MySQL 5.0 Admin Tool
Archived: MySQL Connector/J 5.0 - Download and Installation
Archived: Loading MySQL Connector Java 5.0
Archived: Installation of JdbcRowSet Reference Implementation
►Archived: Oracle Database Express Edition (XE) Installation
Archived: Accessing Oracle Server through Web Interface
Archived: Creating Oracle Database Users
Archived: SQL*Plus - Oracle Command Line Interface
Archived: JDBC Thin Client-Side Driver Installation
Archived: Downloading Microsoft SQL Server 2005 Express Edition
Archived: Installing Microsoft SQL Server 2005 Express Edition
Archived: Installing AdventureWorksLT Sample Database
Archived: Installing Microsoft JDBC Driver 4.2