Oracle8i JDBC Developer's Guide and Reference
Release 8.1.5

A64685-01

Library

Product

Contents

Prev

Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z 


A

addBatch() method, restrictions on, 4-100
ANO (Advanced Networking Option), 3-27
APPLET HTML tag, 5-19
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

B

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

C

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
limitations, 4-115
cursors, 6-7
custom Java classes
defining, 4-65
custom Java types
creating, 7-20, 7-26
CustomDatum interface, 4-3
advantages, 4-65
example program, 7-26
reading data, 4-79
writing data, 4-80

D

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

E

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

F

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

G

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

H

HEIGHT, parameter for APPLET tag, 5-19
HTML tags, to deploy applets, 5-19
HTTP protocol, 1-5

I

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

J

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
requirements, 2-5
restrictions, 6-7
SQL92 syntax, 5-26
JDBC KPRB driver
architecture, 1-6
described, 2-4
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
applets, 3-27, 5-7
applications, 3-27
architecture, 1-5
described, 2-2
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

K

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

L

LD_LIBRARY_PATH variable, specifying, 2-7
length() method, 4-18, 4-19
LIKE escape characters, SQL92 syntax, 5-29
limitations, 4-116
LOB
defined, 3-23
locators, 4-45
reading data, 4-48
working with, 4-45
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

M

makeDatumArray() method, 4-12
memory leaks, 6-7
multi-threaded applications
on the client, 6-2

N

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

O

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

P

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

Q

query, executing, 3-8

R

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

S

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
CHAR columns, 3-19
closing, 3-23
example, 3-16
external files, 3-23
LOBs, 3-23
LONG columns, 3-14
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
STRUCT object, 4-10
attributes, 4-11
casting, 4-63
creating, 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

T

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

U

updates to database, accumulating, 6-6
user connection property, 4-110
userid, specifying, 3-4
using, 5-10

V

VARCHAR2 columns, 6-7
varrays
example program, 7-16

W

WIDTH, parameter for APPLET tag, 5-19
writeSQL() method, 4-69, 4-71
implementing, 4-70


Prev
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents