Installing and Configuring Oracle XE for JDBC Hands On

 

We will write a simple JDBC program to get started with JDBC concepts we learned at javajee.com/introduction-to-jdbcRefer to the notes on particular database for installation and configuration prerequesites.

 

Step 1 - Downloading, installing and configuring Oracle 11g express edition

  1. Download and install Oracle Xpress Edition (free)
    1. Find the latest url using a simple google search, download, unzip and install from setup.exe.
  2. Download and install SqlDeveloper (free) as above.
  3. Start database from start menu under Oracle 11g database express edition or from windows services (if not already started).
  4. Create a connection for system user in the SqlDeveloper with the password specified during the install.
  5. Then create a regular user as:
    1. create user username identified by password;

where username is the new username and password is the password for the new user.

  1. Grant permission for the user to create session, create table and space resource on the table space.
    1. grant create session, create table, unlimited tablespace to username

NOTE: CREATE SESSION allows user to connect to the database and other two permissions are needed to create a table. Granting UNLIMITED_TABLESPACE or RESOURCE to a user enables him to create tables of ANY size on ANY tablespace( including SYSTEM) and hence is undesirable. Allocating quota on specific tablespaces is the more appropriate way to control quota allocation.

 

Step 2 - Create table and insert data

Create table employee(empName varchar(20), id int PRIMARY KEY)

insert into employee values (‘name1’,1)

insert into employee values (‘name2’,2)

 

Step 3 - Installing required jar files

Download and add the correct jdbc driver jars (ojdbc6.jar) into eclipse class path using ‘Add External Jars’ under ‘Configure Java Build Path’. 

You can search for Oracle Database 11g Release 2 JDBC Drivers in google. The current download link is: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-11201...

 

Quick Notes Finder Tags

Activities (1) advanced java (1) agile (3) App Servers (6) archived notes (2) Arrays (1) Best Practices (12) Best Practices (Design) (3) Best Practices (Java) (7) Best Practices (Java EE) (1) BigData (3) Chars & Encodings (6) coding problems (2) Collections (15) contests (3) Core Java (All) (55) course plan (2) Database (12) Design patterns (8) dev tools (3) downloads (2) eclipse (9) Essentials (1) examples (14) Exception (1) Exceptions (4) Exercise (1) exercises (6) Getting Started (18) Groovy (2) hadoop (4) hibernate (77) hibernate interview questions (6) History (1) Hot book (5) http monitoring (2) Inheritance (4) intellij (1) java 8 notes (4) Java 9 (1) Java Concepts (7) Java Core (9) java ee exercises (1) java ee interview questions (2) Java Elements (16) Java Environment (1) Java Features (4) java interview points (4) java interview questions (4) javajee initiatives (1) javajee thoughts (3) Java Performance (6) Java Programmer 1 (11) Java Programmer 2 (7) Javascript Frameworks (1) Java SE Professional (1) JPA 1 - Module (6) JPA 1 - Modules (1) JSP (1) Legacy Java (1) linked list (3) maven (1) Multithreading (16) NFR (1) No SQL (1) Object Oriented (9) OCPJP (4) OCPWCD (1) OOAD (3) Operators (4) Overloading (2) Overriding (2) Overviews (1) policies (1) programming (1) Quartz Scheduler (1) Quizzes (17) RabbitMQ (1) references (2) restful web service (3) Searching (1) security (10) Servlets (8) Servlets and JSP (31) Site Usage Guidelines (1) Sorting (1) source code management (1) spring (4) spring boot (3) Spring Examples (1) Spring Features (1) spring jpa (1) Stack (1) Streams & IO (3) Strings (11) SW Developer Tools (2) testing (1) troubleshooting (1) user interface (1) vxml (8) web services (1) Web Technologies (1) Web Technology Books (1) youtube (1)