Oracle8i JDBC Developer's Guide and Reference -- Index

applets

coding, 5-7

for JDK 1.0.2 browser, 5-8

for JDK 1.1.1 browser, 5-8

connecting to a database, 5-9

deploying in an HTML page, 5-19

packages needed, 5-7

packaging, 5-17

for JDK 1.0.2 browser, 5-17

for JDK 1.1.1 browser, 5-18

packaging and deploying, 3-28

signed applets

browser security, 5-20

example program, 7-31

object-signing certificate, 5-14

using, 5-13

using with firewalls, 5-14

working with, 5-7

ARCHIVE, parameter for APPLET tag, 5-20

ARRAY

class, 4-14

descriptors, 4-15

objects, creating, 4-15, 4-16

array descriptor

creating, 4-93

ArrayDescriptor object, 4-15, 4-93

creating, 4-16

get methods, 4-17

arrays

defined, 4-87

example program, 7-16

getting, 4-92

named, 4-87

passing to callable statement, 4-94

retrieving from a result set, 4-88

retrieving partial arrays, 4-91

using type maps, 4-94

working with, 4-87

AUTHENTICATION_LEVEL parameter, 5-12

auto-commit mode

disabling, 6-5

result set behavior, 6-5

batching values, 4-97, 6-6

and streaming data, 4-100

connection-wide, 4-103

default batch size, 4-100

not supported by OracleCallableStatement, 4-100

overriding default value, 4-102

restrictions on, 4-100

setting batch value, 4-101

BFILE

accessing data, 4-60

class, 4-17

creating and populating columns, 4-58

defined, 3-24

example program, 7-10

locators, 4-55

getting from a result set, 4-55

getting from callable statement, 4-56

passing to callable statements, 4-56

passing to prepared statements, 4-56

manipulating data, 4-60

reading data, 4-57

working with, 4-45

BFILE locator, selecting, 4-18

BLOB, 4-48

class, 4-17

creating and populating, 4-52

creating columns, 4-52

getting locators, 4-46

locators

getting from result set, 4-46

selecting, 4-18

manipulating data, 4-54

populating columns, 4-53

reading data, 4-48, 4-50

working with, 4-45

writing data, 4-51

Boolean parameters, restrictions, 6-7

browser security, 5-20

callable statement

getting a BFILE locator, 4-56

getting LOB locators, 4-47

passing BFILE locator, 4-56

passing LOB locators, 4-48

using getOracleObject() method, 4-36

casting return values, 4-39

catalog arguments (DatabaseMetaData), 4-116

CHAR

object, creating, 4-20

CHAR class, 4-19

conversions with KPRB driver, 5-25

CHAR columns

space padding, 6-7

character sets, 4-21

conversions with KPRB driver, 5-25

Class.forName method, 3-3

CLASSPATH, specifying, 2-7

clearDefines() method, 4-105

client installation, 3-27

CLOB

class, 4-17

creating and populating, 4-52

creating columns, 4-52

locators, 4-46

getting from result set, 4-46

passing to callable statements, 4-48

passing to prepared statement, 4-48

locators, selecting, 4-18

manipulating data, 4-54

populating columns, 4-53

reading data, 4-48, 4-50

working with, 4-45

writing data, 4-51

close() method, 4-25, 4-26, 4-27, 6-7

for database connection, 5-23

closeFile() method, 4-19

CMAN.ORA file, creating, 5-11

CODE, parameter for APPLET tag, 5-19

CODEBASE, parameter for APPLET tag, 5-19

collections, 4-87

collections (nested tables and arrays), 4-15

column types

redefining, 4-97, 4-105

restrictions on, 4-105

COMMIT operation, 5-24

connect string

for KPRB driver, 5-23

for the Oracle8 Connection Manager, 5-12

connection

closing, 3-10

from KPRB driver, 3-26

opening, 3-3

opening for JDBC OCI driver, 3-6

opening for JDBC Thin driver, 3-7

Properties object, 3-6

Connection Manager, 3-28, 5-9, 5-10

browser security, 5-20

installing, 5-11

starting, 5-12

using multiple managers, 5-13

writing the connect string, 5-12

connection properties, 4-109

database, 4-110

defaultBatchValue, 4-110

defaultRowPrefetch, 4-110

password, 4-110

put() method, 4-110

remarksReporting, 4-110

user, 4-110

connections

read-only, 4-116

constants for SQL types, 4-28

CREATE DIRECTORY statement

for BFILEs, 4-58

CREATE TABLE statement

to create BFILE columns, 4-58

to create BLOB, CLOB columns, 4-52

create() method

for CustomDatumFactory interface, 4-75

createDescriptor() method, 4-13

createStatement() method, 4-24

CursorName

custom Java classes

custom Java types

CustomDatum interface, 4-3

advantages, 4-65

example program, 7-26

reading data, 4-79

writing data, 4-80

data conversions, 4-32

LONG, 3-15

LONG RAW, 3-15

data streaming

avoiding, 3-18

example program, 7-2

database

connecting

from an applet, 5-10

through multiple Connection Managers, 5-13

with KPRB, 5-22

connection testing, 2-8

database connection

connection property, 4-110

database URL

including userid and password, 3-5

database URL, specifying, 3-4

DatabaseMetaData calls, 4-116

DatabaseMetaData class, 5-28

entry points for applets, 5-18

datatype classes, 4-7

datatype mappings, 3-11

datatypes

Java, 3-11, 3-12

Java native, 3-11, 3-12

JDBC, 3-11, 3-12

JDBC extensions for Oracle SQL datatypes, 3-12

Oracle SQL, 3-11, 3-12

DATE class, 4-22

DBMS_LOB package, 4-49

debugging JDBC programs, 6-9

DEFAULT_CHARSET character set value, 4-21

defaultBatchValue connection property, 4-110

defaultConnection() method, 5-22

defaultRowPrefetch connection property, 4-110

defineColumnType() method, 3-19, 4-25, 4-106

dnldthin sub-protocol, 5-8

DriverManager class, 3-3

dynamic SQL, 1-2

encryption

applets, 3-28

applications, 3-27

environment variables

specifying, 2-7

error handling and messages, 3-25

exception trapping, 6-9

executeBatch() method

restrictions on, 4-100

executeQuery() method, 4-25

executeUpdate() method, 4-101

extensions to JDBC, Oracle, 4-1

external file

defined, 3-24

finalizer methods, 6-7

firewalls

configuring for applets, 5-15

connect string, 5-16

described, 5-15

required rule list items, 5-15

using with applets, 3-28, 5-14

floating-point compliance, 4-115

function call syntax, SQL92 syntax, 5-30

getARRAY() method, 4-88

getArray() method, 4-15, 4-88

using type maps, 4-90

getArrayDescriptor() method, 4-15

getAsciiOutputStream() method, 4-18

for writing CLOB data, 4-50

getAsciiStream() method, 4-18

for reading CLOB data, 4-49

getAttributes() method, 4-11, 4-63

used by Structs, 4-69

getBaseName() method, 4-17

getBaseType() method, 4-15, 4-17, 4-92

getBaseTypeName() method, 4-14, 4-15

used with object references, 4-83

getBinaryOutputStream() method, 4-18

for writing BLOB data, 4-49

getBinaryStream() method, 3-17, 4-18, 4-19

for reading BFILE data, 4-57

for reading BLOB data, 4-49

getBLOB() method, 4-46

getBytes() method, 3-18, 4-10, 4-18, 4-19

getCharacterOutputStream() method, 4-18

for writing CLOB data, 4-50

getCharacterStream() method, 4-18

for reading CLOB data, 4-49

getChars() method, 4-18

getChunkSize() method, 4-53

getCLOB() method, 4-46

getColumnCount() method, 4-28

getColumnName() method, 4-28

getColumns() method, 4-108

getColumnType() method, 4-28, 4-44

getColumnTypeName() method, 4-28, 4-44

getConnection() method, 3-4, 4-12, 5-22

connection properties, 4-109

for applets, 5-8

getCursor() method, 4-113, 4-114

getCursorName() method, 4-111

limitations, 4-115

getCustomDatum() method, 4-76, 4-79

getDefaultExecuteBatch() method, 4-24

getDefaultRowPrefetch() method, 4-24, 4-98

getDescriptor() method, 4-12

getDirAlias() method, 4-19, 4-60

getExecuteBatch() method, 4-26, 4-101

returning current batch value, 4-103

getMap() method, 4-12

getName() method, 4-19, 4-60

getNumericFunctions() method, 5-28

getObject() method

casting return values, 4-39

for BLOBs and CLOBs, 4-46

for CustomDatum objects, 4-76

for object references, 4-84

for SQLInput streams, 4-70

for SQLOutput streams, 4-71

for Struct objects, 4-64

return types, 4-34, 4-36

to get BFILE locators, 4-55

to get Oracle objects, 4-63

used with CustomDatum interface, 4-80

getOracleArray() method, 4-15, 4-88, 4-92

getOracleAttributes() method, 4-12, 4-64

getOracleObject() method, 4-26, 4-27

casting return values, 4-39

for BLOBs and CLOBs, 4-46

return types, 4-35, 4-36

using in callable statement, 4-36

using in result set, 4-35

getProcedureColumns() method, 4-108

getProcedures() method, 4-108

getREF() method, 4-85

getRemarksReporting() method, 4-25

getResultSet() method, 4-15, 4-25

getRowPrefetch() method, 4-25, 4-98

getSQLTypeName() method, 4-12, 4-15, 4-63, 4-92

getString() method, 4-21

to get ROWIDs, 4-111

getStringFunctions() method, 5-28

getStringWithReplacement() method, 4-21

getSTRUCT() method, 4-64

getSubString() method, 4-19

for reading CLOB data, 4-50

getSystemFunctions() method, 5-28

getTableName() method, 4-28

getTimeDateFunctions() method, 5-28

getTransactionIsolation() method, 4-24, 6-13

getTypeMap() method, 4-25, 4-67

getValue() method, 4-14

for object references, 4-84

getXXX() methods

casting return values, 4-39

for specific datatypes, 4-37

HEIGHT, parameter for APPLET tag, 5-19

HTML tags, to deploy applets, 5-19

HTTP protocol, 1-5

IEEE 754 floating-point compliance, 4-115

INSERT INTO statement

for creating BFILE columns, 4-59

inserts to database, accumulating, 6-6

installation

client, 3-27

directories and files, 2-6

verifying on the client, 2-6

instanceOf() method, 4-35

intValue() method, 4-10

isConvertableTo() method, 4-12

Java

compiling and running, 2-7

datatypes, 3-11, 3-12

native datatypes, 3-11, 3-12

stored procedures, 3-25

stream data, 3-14

Java Sockets, 2-2

java.math, Java math packages, 3-2

java.sql, JDBC packages, 3-2

java.sql.SQLException() method, 3-25

java.sql.Types class, 4-106

java.util.Dictionary class

used by type maps, 4-67

java.util.Hashtable class

used by type maps, 4-67

java.util.Map class, 4-91

JDBC

and IDEs, 1-7

and Oracle Application Server, 1-6

basic program, 3-2

datatypes, 3-11, 3-12

defined, 1-2

error handling and messages, 3-25

guidelines for using, 1-3

importing packages, 3-2

limitations of Oracle extensions, 4-115

Oracle extensions, 1-6

sample files, 2-7

testing, 2-8

versions supported, 1-6

JDBC calls, logging, 6-10

JDBC drivers

and NLS, 5-2

applets, 3-27

applications, 3-27

basic architecture, 1-4

choosing a driver for your needs, 2-4

common features, 2-2

common problems, 6-6

compatibilities, 2-5

determining driver version, 2-8

registering, 3-3

registering for an applet, 5-7

JDBC KPRB driver

JDBC mapping (for attributes), 4-82

JDBC OCI driver

applications, 3-27

architecture, 1-5

described, 2-3

NLS considerations, 5-3

JDBC Thin driver

NLS considerations, 5-4

JdbcCheckup program, 2-8

JDeveloper, 1-7

JDK

version considerations, 5-20

versions supported, 1-6

JPublisher utility, 4-3, 4-65

data mapping options, 4-82

using with JDBC, 4-82

KPRB driver

connection string for, 5-23

connection to database, 5-22

described, 5-22

NLS considerations, 5-4

relation to the SQL engine, 5-22

session context, 5-23

support for NLS, 5-25

testing, 5-24

transaction context, 5-23

LD_LIBRARY_PATH variable, specifying, 2-7

length() method, 4-18, 4-19

LIKE escape characters, SQL92 syntax, 5-29

LOB

LOB locators

getting from callable statements, 4-47

passing, 4-47

LOBs

example program, 7-4

locators

getting for BFILEs, 4-55

getting for BLOBs, 4-46

getting for CLOBs, 4-46

LOB, 4-45

passing to callable statements, 4-48

passing to prepared statement, 4-48

LONG

data conversions, 3-15

LONG RAW

data conversions, 3-15

makeDatumArray() method, 4-12

memory leaks, 6-7

multi-threaded applications

on the client, 6-2

named arrays, 4-87

defined, 4-15

National Language Support (NLS), 4-21

Net8

name-value pair, 3-4

protocol, 1-5

network events, trapping, 6-10

next() method, 4-27

NLS

and JDBC drivers, 5-2

conversions, 5-2

data size restrictions, 5-5

for JDBC OCI drivers, 5-3

for JDBC Thin drivers, 5-4

for KPRB driver, 5-4

Java methods that employ, 5-2

using, 5-2

NLS Ratio, 5-5

NLS_LANG environment variable, 5-3

NULL data

converting, 4-33

NUMBER class, 4-22

Object JDBC mapping (for attributes), 4-82

object references

accessing object values, 4-84, 4-85

defined, 4-83

passing to callable statement, 4-85

passing to prepared statements, 4-86

redefining columns containing, 4-105

updating object values, 4-84, 4-85

working with, 4-83

openFile() method, 4-19

optimization, performance, 6-5

Oracle Application Server, 1-6

Oracle datatypes

using, 4-32

Oracle extensions

datatype support, 4-2

limitations, 4-115

catalog arguments to DatabaseMetaData calls, 4-116

CursorName, 4-115

IEEE 754 floating-point compliance, 4-115

PL/SQL TABLE, BOOLEAN, RECORD types, 4-115

read-only connection, 4-116

SQL92 outer join escapes, 4-115

SQLWarning class, 4-116

object support, 4-3

packages, 4-2

performance extensions, 4-97

result sets, 4-33

schema naming support, 4-4

statements, 4-33

to JDBC, 4-1

Oracle mapping (for attributes), 4-82

Oracle objects

and JDBC, 4-62

converting with CustomDatum interface, 4-75

converting with SQLData interface, 4-69

defining with Java classes, 4-65

getting with getObject() method, 4-63

Java classes which support, 4-62

reading data by using SQLData interface, 4-72

working with, 4-62

writing data by using SQLData interface, 4-74

Oracle SQL datatypes, 3-11, 3-12

Oracle8 Connection Manager, 5-9

OracleCallableStatement class, 4-26

getXXX() methods, 4-37

registerOutParameter() method, 4-42

OracleConnection class, 4-24

OracleDatabaseMetaData class, 5-28

and applets, 5-18

OracleDriver class, 4-24

oracle.jdbc2 package, described, 4-6

oracle.jdbc2.Struct class, 4-10, 4-63

getAttributes() method, 4-63

getSQLTypeName() method, 4-63

oracle.jdbc.driver package, 4-22

stream classes, 4-28

oracle.jdbc.driver, Oracle JDBC extensions, 3-3

oracle.jdbc.driver.OracleCallableStatement class, 4-26

close() method, 4-27

getOracleObject() method, 4-26

getXXX() methods, 4-26

registerOutParameter() method, 4-27

setNull() method, 4-27

setOracleObject() methods, 4-27

setXXX() methods, 4-27

oracle.jdbc.driver.OracleConnection class, 4-24

createStatement() method, 4-24

getDefaultExecuteBatch() method, 4-24

getDefaultRowPrefetch() method, 4-24

getRemarksReporting() method, 4-25

getTransactionIsolation() method, 4-24, 6-13

getTypeMap() method, 4-25

prepareCall() method, 4-24

prepareStatement() method, 4-24

setDefaultExecuteBatch() method, 4-24

setDefaultRowPrefetch() method, 4-25

setRemarksReporting() method, 4-25

setTransactionIsolation() method, 4-24, 6-13

setTypeMap() method, 4-25

oracle.jdbc.driver.OracleDriver class, 4-24, 5-7

oracle.jdbc.driver.OraclePreparedStatement class, 4-25

close() method, 4-26

getExecuteBatch() method, 4-26

setCustomDatum() method, 4-26

setExecuteBatch() method, 4-26

setNull() method, 4-26

setOracleObject() method, 4-26

setXXX() methods, 4-26

oracle.jdbc.driver.OracleResultSet class, 4-27

getOracleObject() method, 4-27

getXXX() methods, 4-27

next() method, 4-27

oracle.jdbc.driver.OracleResultSetMetaData class, 4-28, 4-44

getColumnCount() method, 4-28

getColumnName() method, 4-28

getColumnType() method, 4-28

getColumnTypeName() method, 4-28

getTableName() method, 4-28

using, 4-44

oracle.jdbc.driver.OracleStatement class, 4-25

close() method, 4-25

defineColumnType(), 4-25

executeQuery() method, 4-25

getResultSet() method, 4-25

getRowPrefetch() method, 4-25

setRowPrefetch() method, 4-25

oracle.jdbc.driver.OracleTypes class, 4-28, 4-106

OraclePreparedStatement class, 4-25

OracleResultSet class, 4-27

getXXX() methods, 4-37

OracleResultSet object, 3-9

OracleResultSetMetaData class, 4-28

OracleServerDriver class

defaultConnection() method, 5-22

oracle.sql datatype classes, 4-7

oracle.sql package

data conversions, 4-32

described, 4-7

oracle.sql.ARRAY class, 4-87

and nested tables, 4-14

and VARRAYs, 4-14

getArray() method, 4-15

getArrayDescriptor() method, 4-15

getBaseType() method, 4-15

getBaseTypeName() method, 4-15

getOracleArray() method, 4-15

getResultSet() method, 4-15

getSQLTypeName() method, 4-15

oracle.sql.ArrayDescriptor class

getBaseName() method, 4-17

getBaseType() method, 4-17

oracle.sql.BFILE class, 4-17

closeFile() method, 4-19

getBinaryStream() method, 4-19

getBytes() method, 4-19

getDirAlias() method, 4-19

getName() method, 4-19

length() method, 4-19

openFile() method, 4-19

position() method, 4-19

oracle.sql.BLOB class, 4-17

getBinaryOutputStream() method, 4-18

getBinaryStream() method, 4-18

getBytes() method, 4-18

length() method, 4-18

position() method, 4-18

putBytes() method, 4-18

oracle.sql.CHAR class, 4-19, 5-25

getString() method, 4-21

getStringWithReplacement() method, 4-21

toString() method, 4-21

oracle.sql.CharacterSet class, 4-20

oracle.sql.CLOB class, 4-17

getAsciiOutputStream() method, 4-18

getAsciiStream() method, 4-18

getCharacterOutputStream() method, 4-18

getCharacterStream() method, 4-18

getChars() method, 4-18

getSubString() method, 4-19

length() method, 4-19

position() method, 4-19

putChars() method, 4-19

putString() method, 4-19

supported character sets, 4-18

oracle.sql.CustomDatum interface, 4-75

oracle.sql.CustomDatumFactory interface, 4-75

oracle.sql.datatypes

support, 4-10

oracle.sql.DATE class, 4-22

oracle.sql.Datum class, described, 4-7

oracle.sql.NUMBER class, 4-22

OracleSql.parse() method, 5-30

oracle.sql.RAW class, 4-22

oracle.sql.REF class, 4-14, 4-83

getBaseTypeName() method, 4-14

getValue() method, 4-14

setValue() method, 4-14

oracle.sql.REFCURSOR class, 4-112

oracle.sql.ROWID class, 4-10, 4-22, 4-111

oracle.sql.STRUCT class, 4-10, 4-63

getConnection() method, 4-12

getDescriptor() method, 4-12

getMap() method, 4-12

getOracleAttributes() method, 4-12

getSQLTypeName() method, 4-12

isConvertibleTo() method, 4-12

makeJdbcArray() method, 4-12

methods, 4-11

getAttributes() method, 4-11

setDatumArray() method, 4-12

setDescriptor() method, 4-12

stringValue() method, 4-12

toBytes() method, 4-12

toClass() method, 4-12

toJDBC() method, 4-12

toSTRUCT() method, 4-12

oracle.sql.StructDescriptor class, 4-13

createDescriptor() method, 4-13

OracleStatement class, 4-25

OracleTypes class, 4-28

OracleTypes.ARRAY class, 4-28, 4-44

OracleTypes.BFILE class, 4-29

OracleTypes.BLOB class, 4-28

OracleTypes.CLOB class, 4-28

OracleTypes.CURSOR variable, 4-113

OracleTypes.REF class, 4-28

OracleTypes.ROWID class, 4-29

OracleTypes.STRUCT class, 4-28, 4-44

outer joins, SQL92 syntax, 5-29

password connection property, 4-110

password, specifying, 3-4

PATH variable, specifying, 2-7

performance extensions

batching updates, 4-100

connection properties, 4-109

prefetching rows, 4-98

redefining column types, 4-105

TABLE_REMARKS reporting, 4-108

to JDBC, 4-97

performance optimization, 6-5

batching values, 6-6

prefetching rows, 6-6

PL/SQL

restrictions, 6-7

space padding, 6-7

stored procedures, 3-24

PL/SQL stored procedures, 3-24

PL/SQL types

limitations, 4-115

position() method, 4-18, 4-19

prefetching rows, 4-97, 4-98, 6-6

suggested default, 4-98

prepareCall() method, 4-24

prepared statement

passing BFILE locator, 4-56

passing LOB locators, 4-48

using setObject() method, 4-41

using setOracleObject() method, 4-41

prepareStatement() method, 4-24

printStackTrace() method, 6-9

put() method

for Properties object, 4-110

for type maps, 4-67

putBytes() method, 4-18

putChars() method, 4-19

putString() method, 4-19

query, executing, 3-8

RAW class, 4-22

readSQL() method, 4-69, 4-70

implementing, 4-70

REF class, 4-14

REFCURSORs, 4-112

example program, 7-14

materialized as result set objects, 4-112

reference classes, and JPublisher, 4-83

registerDriver() method, 4-24

registering Oracle JDBC drivers, class for, 4-24

registerOutParameter() method, 4-27, 4-42

remarksReporting connection property, 4-110

remarksReporting flag, 4-97

result set

auto-commit mode, 6-5

getting BFILE locators, 4-55

getting LOB locators, 4-46

metadata, 4-28

Oracle extensions, 4-33

using getOracleObject() method, 4-35

result set object

closing, 3-9

result set, processing, 3-9

ResultSet class, 3-8

return types

for getXXX() methods, 4-38

getObject() method, 4-36

getOracleObject() method, 4-36

return values

casting, 4-39

ROLLBACK operation, 5-24

row prefetching, 4-98

and data streams, 3-23

ROWID class, 4-22

CursorName methods, 4-115

defined, 4-111

scalar functions, SQL92 syntax, 5-28

schema naming conventions, 4-4

security, for browsers, 5-20

SELECT statement

to retrieve object references, 4-84

to select LOB locator, 4-54

sendBatch() method, 4-102

session context, 3-26

for KPRB driver, 5-23

setAutoCommit() method, 6-5

setBFILE() method, 4-56

setBLOB() method, 4-47

setCLOB() method, 4-48

setCursorName() method, 4-111, 4-115

setCustomDatum() method, 4-26, 4-77, 4-81

setDatumArray() method, 4-12

setDefaultExecuteBatch() method, 4-24

setDefaultRowPrefetch() method, 4-25, 4-98

setDescriptor() method, 4-12

setEscapeProcessing() method, 5-26

setExecuteBatch() method, 4-26

setLogStream() method, for logging JDBC calls, 6-10

setMaxFieldSize() method, 4-106, 6-7

setNull() method, 4-26, 4-27, 4-42

setObejct() method, 4-40

setObject() method

for BFILES, 4-56

for BLOBs and CLOBs, 4-47

for CustomDatum objects, 4-77

for object references, 4-86

to write object data, 4-81

using in prepared statements, 4-41

setOracleObject() method, 4-26, 4-27, 4-40

for BFILES, 4-56

for BLOBs and CLOBs, 4-47

for Struct objects, 4-64

using in prepared statements, 4-41

setREF() method, 4-86

setRemarksReporting() method, 4-25, 4-108

setRowPrefetch() method, 4-25, 4-98

setString() method

to bind ROWIDs, 4-111

setTransactionIsolation() method, 4-24, 6-13

setTypeMap() method, 4-25, 4-68

setValue() method, 4-14

setXXX() methods, for specific datatypes, 4-41

signed applets, 3-28

SQL

data converting to Java datatypes, 4-32

primitive types, 4-7

structured types, 4-7

types, constants for, 4-28

SQL engine

relation to the KPRB driver, 5-22

SQL syntax (Oracle), 5-26

SQL92 syntax, 5-26

function call syntax, 5-30

LIKE escape characters, 5-29

outer joins, 5-29

scalar functions, 5-28

time and date literals, 5-26

translating to SQL example, 5-30

SQLData interface, 4-3

advantages, 4-66

described, 4-69

example program, 7-20

Oracle implementation, 4-6

reading data from Oracle objects, 4-72

using with type map, 4-69

writing data from Oracle objects, 4-74

SQLException() method, 6-9

SQLInput interface, 4-69

described, 4-70

SQLInput streams, 4-70

SQLJ

advantages over JDBC, 1-3

guidelines for using, 1-3

SQLNET.ORA

parameters for tracing, 6-10

SQLOutput interface, 4-69

described, 4-70

SQLOutput streams, 4-71

SQLWarning class, limitations, 4-116

Statement object

closing, 3-9

creating, 3-8

statements

Oracle extensions, 4-33

static SQL, 1-2

stored procedures

Java, 3-25

PL/SQL, 3-24

stream classes, 4-28

stream data, 3-14, 4-48

LOBs, 3-23

LONG RAW columns, 3-14

multiple columns, 3-20

RAW columns, 3-19

row prefetching, 3-23

UPDATE/COMMIT statements, 4-50

VARCHAR columns, 3-19

stream data column

bypassing, 3-21

stringValue() method, 4-10, 4-12

STRUCT class, 4-10

STRUCT descriptor, 4-13

embedded object, 4-14

nested objects, 4-11

using, 4-63

StructDescriptor object

creating, 4-13

get methods, 4-13

structured objects, 4-9

class for binding, 4-26

TABLE_REMARKS columns, 4-97

TABLE_REMARKS reporting

restrictions on, 4-108

TCP/IP protocol, 1-5, 3-7

time and date literals, SQL92 syntax, 5-26

TNSNAMES entries, 3-4

toBytes() method, 4-12

toClass() method, 4-12

toDatum() method

applied to CustomDatum objects, 4-65, 4-75

called by setCustomDatum() method, 4-81

toJDBC() method, 4-12

toJdbc() method, 4-10

toString() method, 4-21

toSTRUCT() method, 4-12

trace facility, 6-10

trace parameters

client-side, 6-11

server-side, 6-12

transaction context, 3-26

for KPRB driver, 5-23

TTC protocol, 1-5

type map, 4-3, 4-34, 4-65

adding entries, 4-67

and STRUCTs, 4-69

creating a new map, 4-68

defining mappings, 4-67

described, 4-66

used with arrays, 4-91

used with SQLData interface, 4-69

using with arrays, 4-94

type maps

relationship to database connection, 5-23

updates to database, accumulating, 6-6

user connection property, 4-110

userid, specifying, 3-4

using, 5-10

VARCHAR2 columns, 6-7

varrays

example program, 7-16

WIDTH, parameter for APPLET tag, 5-19

writeSQL() method, 4-69, 4-71

implementing, 4-70