Listing 18 - Listing 18.1 initCSAJSP.ora (database...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Listing 18.1 initCSAJSP.ora (database initialization parameter file) # Initialization parameter file for Oracle9i database # on Windows XP. # Database Identification db_domain=coreservlets.com db_name=csajsp # Instance Identification instance_name=csajsp # Cache and I/O db_block_size=8192 db_cache_size=25165824 db_file_multiblock_read_count=16 # Cursors and Library Cache open_cursors=300 # Diagnostics and Statistics background_dump_dest=C:\oracle\admin\csajsp\bdump core_dump_dest=C:\oracle\admin\csajsp\cdump timed_statistics=TRUE user_dump_dest=C:\oracle\admin\csajsp\udump # File Configuration control_files=("C:\oracle\oradata\csajsp\CONTROL01.CTL", "C:\oracle\oradata\csajsp\CONTROL02.CTL", "C:\oracle\oradata\csajsp\CONTROL03.CTL") # Job Queues job_queue_processes=10 # MTS dispatchers="(PROTOCOL=TCP) (SERVICE=csajspXDB)" # Miscellaneous aq_tm_processes=1 compatible=9.2.0.0.0 # Optimizer hash_join_enabled=TRUE query_rewrite_enabled=FALSE star_transformation_enabled=FALSE # Pools
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
java_pool_size=33554432 large_pool_size=8388608 shared_pool_size=50331648 # Processes and Sessions processes=150 # Redo Log and Recovery fast_start_mttr_target=300 # Security and Auditing remote_login_passwordfile=EXCLUSIVE # Sort, Hash Joins, Bitmap Indexes pga_aggregate_target=25165824 sort_area_size=524288 # System Managed Undo and Rollback Segments undo_management=AUTO undo_retention=10800 undo_tablespace=undotbs Listing 18.2 create_csajsp.sql /* SQL command to create an Oracle9i database named csajsp. */ CREATE DATABASE csajsp USER SYS IDENTIFIED BY csajspDBA USER SYSTEM IDENTIFIED BY csajspMAN LOGFILE GROUP 1 ('C:\oracle\oradata\csajsp\redo01.log') SIZE 100M, GROUP 2 ('C:\oracle\oradata\csajsp\redo02.log') SIZE 100M, GROUP 3 ('C:\oracle\oradata\csajsp\redo03.log') SIZE 100M MAXLOGFILES 5 MAXDATAFILES 100 MAXINSTANCES 1 CHARACTER SET WE8MSWIN1252 NATIONAL CHARACTER SET AL16UTF16 DATAFILE 'C:\oracle\oradata\csajsp\system01.dbf' SIZE 325M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
Background image of page 2
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE 'C:\oracle\oradata\csajsp\temptbs01.dbf' SIZE 20M REUSE EXTENT MANAGEMENT LOCAL UNDO TABLESPACE undotbs DATAFILE 'C:\oracle\oradata\csajsp\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED; Listing 18.3 TestDatabase.java package coreservlets; import java.sql.*; /** Perform the following tests on a database: * <OL> * <LI>Create a JDBC connection to the database and report * the product name and version. * <LI>Create a simple "authors" table containing the * ID, first name, and last name for the two authors * of Core Servlets and JavaServer Pages, 2nd Edition. * <LI>Query the "authors" table for all rows. * <LI>Determine the JDBC version. Use with caution:
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/14/2011 for the course MATH 401 taught by Professor H.ayad during the Spring '11 term at Cairo University.

Page1 / 12

Listing 18 - Listing 18.1 initCSAJSP.ora (database...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online