HW3 - Client server architecture Client-Server...

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

View Full Document Right Arrow Icon
PL/SQL & JDBC OVERVIEW All materials can be found at: http://www.utdallas.edu/~maa013600/cs6360/
Background image of page 1

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

View Full DocumentRight Arrow Icon
PL/SQL Overview Outline Stored Procedures. Functions. Packages. Triggers.
Background image of page 2
Listing your oracle objects User_objects table: contains all the user created objects in oracle.
Background image of page 3

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

View Full DocumentRight Arrow Icon
Stored Procedures. Local variables Procedure parameters. Procedure body Run the definition on oracle
Background image of page 4
Stored Procedure/ out parameter. Notice the difference between select statements using pl/sql
Background image of page 5

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

View Full DocumentRight Arrow Icon
Functions. Cursor definition
Background image of page 6
Running Stored Procedure and Functions.
Background image of page 7

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

View Full DocumentRight Arrow Icon
JDBC Overview Outline 3 tier Client/Server Architecture. JDBC driver setup. Create Oracle objects.
Background image of page 8
Background image of page 9

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

View Full DocumentRight Arrow Icon
Background image of page 10
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Client server architecture Client-Server architectures: 2 tier 3 tier Layer 1: user interface Layer 2: Middleware Layer 3: DB server Middleware: Server for client Client for DB Setting up JDBC driver. Download the classes12.zip from Dr.Khan website. Set the classpath. Windows http://java.sun.com/j2se/1.4.2/docs/tooldocs/windows/classpath.html Unix: http://java.sun.com/j2se/1.3/docs/tooldocs/solaris/classpath.html Sample Code http://utdallas.edu/~maa013600/cs6360/common/oracle_plsql_examples.zip...
View Full Document

Page1 / 10

HW3 - Client server architecture Client-Server...

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

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