JDBC for MySQL - Herong's Tutorial Examples - v3.13, by 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
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
Using Connection Pool with JDBC
Archived: Downloading and Installing JDK 13 on Mac
Archived: Downloading and Installing JDK 12 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: 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