INFORMIX
Informix JDBC Driver Programmer's Guide
Index
Contents

Index

A

ANSI compliance
level Intro-10
APPLET tag 1-13
Application server 3-9
ARCHIVE attribute of APPLET tag 1-13
Autocommit 2-27
AUTOFREE environment variable A-2
autofree.java example program 3-7, A-2

B

Browsers 1-13, 3-8
BYTE data type 2-14, 3-6
ByteType.java example program 2-16, 2-18, A-2

C

CallableStatement interface 2-14
cancel() method 2-32
catalogs, Informix JDBC Driver interpretation 2-14
Classes
IfxDriver 2-4
Message 2-27
Properties 2-10
SQLException 2-25, 2-27, 3-8
Version 2-30
CLASSPATH environment variable 1-12
Class.forName() method 2-4
close() method 2-21
Common Object Request Broker Architecture (CORBA) 3-9
Compliance with industry standards Intro-10
Connection interface 2-21, 2-27
Connections
creating 2-4, 2-7
establishing 2-3
Contents of Informix JDBC Driver 1-6
CreateDB.java example program A-2
Creating a connection 2-4, 2-7

D

Data types
BYTE 2-14, 3-6
INTERVAL 2-19
mapping between Informix and JDBC API 2-22
SERIAL 2-28
SERIAL8 2-28
TEXT 2-14, 3-6
Database
URL 2-5
Database server name, setting in database URLs 2-6
DatabaseMetaData interface 2-13, 2-30
Databases
names of, setting in database URLs 2-6
querying 2-14
URL 2-5
DBANSIWARN environment variable 2-11
DBConnection.java example program 2-8, A-2
DBDATE environment variable 2-10
DBMetaData.java example program A-2
DBSPACETEMP environment variable 2-11
DBUPSPACE environment variable 2-11
Deallocating resources 2-21
Debugging 3-3
DELIMIDENT environment variable 2-11
Driver interface 2-30
DriverManager interface 1-5, 2-4, 2-7, 2-10
DropDB.java example program A-2

E

Environment variables
AUTOFREE A-2
CLASSPATH 1-12
DBANSIWARN 2-11
DBDATE 2-10
DBSPACETEMP 2-11
DBUPSPACE 2-11
DELIMIDENT 2-11
FET_BUF_SIZE 2-11, 3-6, A-2
IFX_AUTOFREE 2-11, 3-7
INFORMIXCONRETRY 2-11
INFORMIXOPCACHE 2-11
INFORMIXSERVER 2-6, 2-7, 2-11
INFORMIXSTACKSIZE 2-11
NODEFDAC 2-12
OPTCOMPIND 2-12
OPTOFC 2-12, 3-7, A-2
PATH 2-12
PDQPRIORITY 2-12
PLCONFIG 2-12
PROTOCOLTRACE 3-4
PROTOCOLTRACEFILE 3-4
PSORT_DBTEMP 2-13
PSORT_NPROCS 2-13
specifying 2-7, 2-9
supported 2-10
TRACE 3-4
TRACEFILE 3-4
USEV5SERVER 2-13
Errors 2-25, 2-26, 2-27
Establishing a connection 2-3
Examples
autofree.java 3-7, A-2
ByteType.java 2-16, 2-18, A-2
CreateDB.java A-2
DBConnection.java 2-8, A-2
DBMetaData.java A-2
DropDB.java A-2
Interval.java 2-19, A-2
MultiRowCall.java A-2
OptimizedSelect.java A-2
optofc.java 2-10, 3-7, A-2
PropertyConnection.java A-2
RSMetaData.java A-2
SimpleCall.java A-2
SimpleConnection.java A-2
SimpleSelect.java A-2
TextType.java 2-17, 2-19, A-2
executeQuery() method 2-21
executeUpdate() method 2-8, 2-17
execute() method 2-21, 2-32

F

FET_BUF_SIZE environment variable 2-11, 3-6, A-2
File interface 2-17
FileInputStream interface 2-17

G

getCatalogName() method 2-32
getCatalogs() method 2-14
getConnection() method 2-4, 2-7, 2-10
getErrorCode() method 2-26
getJDBCVersion() method 2-30
getMajorVersion() method 2-30
getMessage() method 2-26
getMinorVersion() method 2-30
getSchemaName() method 2-32
getSchemas() method 2-14
getSerial8() method 2-28
getSerial() method 2-28
getTableName() method 2-32
getUnicodeStream() method 2-32
getXXX() method 2-17, 2-22, 2-23

H

Host names, setting in database URLs 2-6

I

IfxDriver class 2-4
ifxjdbc-g.jar 1-6, 1-13, 3-3
ifxjdbc.jar 1-6, 1-13
IFX_AUTOFREE environment variable 2-11, 3-7
Industry standards, compliance with Intro-10
Informix JDBC Driver
contents of 1-6
installing interactively 1-7
installing silently 1-9
loading 2-4
overview of 1-6
registering 2-4
tracing 3-4
uninstalling 1-11
using debug version of 3-3
using in an applet 1-13, 2-4
using in an application 1-12
INFORMIXCONRETRY environment variable 2-11
INFORMIXOPCACHE environment variable 2-11
INFORMIXSERVER environment variable 2-6, 2-7, 2-11
INFORMIXSTACKSIZE environment variable 2-11
InputStream interface 2-15
Installing Informix JDBC Driver 1-7, 1-9
Interfaces
CallableStatement 2-14
Connection 2-21, 2-27
DatabaseMetaData 2-13, 2-30
Driver 2-30
DriverManager 1-5, 2-4, 2-7, 2-10
File 2-17
FileInputStream 2-17
InputStream 2-15
PreparedStatement 2-14, 2-15, 2-21
ResultSet 2-14, 2-17, 2-21, 2-22, 2-23, 3-7
ResultSetMetaData 2-14
Statement 2-8, 2-14, 3-7
Types 2-22, 2-29
INTERVAL data type 2-19
Interval.java example program 2-19, A-2
IP address, setting in database URL 2-6
isDefinitelyWriteable() method 2-32
isReadOnly() method 2-32
isWriteable() method 2-32

J

JAR files
ifxjdbc-g.jar 1-6, 1-13, 3-3
ifxjdbc.jar 1-6, 1-13
jar utility 1-13
Java virtual machine (JVM) 1-12
javac, Java compiler 1-6
JavaSoft 1-3, 1-13
JDBC API 1-3, 1-4
JDBC driver, general 1-5

L

Limitations and restrictions of Informix JDBC Driver 2-31
Loading Informix JDBC Driver 2-4

M

Mapping between Informix and JDBC API data types 2-22
Message class 2-27
Metadata, accessing database 2-13
Methods
cancel() 2-32
Class.forName() 2-4
close() 2-21
executeQuery() 2-21
executeUpdate() 2-8, 2-17
execute() 2-21, 2-32
getCatalogName() 2-32
getCatalogs() 2-14
getConnection() 2-4, 2-7, 2-10
getErrorCode() 2-26
getJDBCVersion() 2-30
getMajorVersion() 2-30
getMessage() 2-26
getMinorVersion() 2-30
getSchemaName() 2-32
getSchemas() 2-14
getSerial8() 2-28
getSerial() 2-28
getTableName() 2-32
getUnicodeStream() 2-32
getXXX() 2-17, 2-22, 2-23
isDefinitelyWriteable() 2-32
isReadOnly() 2-32
isWriteable() 2-32
next() 2-22
prepareStatement() 2-21
put() 2-10
registerDriver() 2-4
registerOutParameter() 2-32
setAsciiStream() 2-15
setAutoCommit() 2-27
setBinaryStream() 2-15
setCatalog() 2-32
setMaxFieldSize() 2-32
setObject() 2-21
setQueryTimeout() 2-32
setReadOnly() 2-32
setUnicodeStream() 2-32
MultiRowCall.java example program A-2

N

Name-value pairs of database URL 2-7
next() method 2-22
NODEFDAC environment variable 2-12

O

ODBC 1-5
OPTCOMPIND environment variable 2-12
OptimizedSelect.java example program A-2
OPTOFC environment variable 2-12, 3-7, A-2
optofc.java example program 2-10, 3-7, A-2

P

Passwords, setting in database URL 2-7
PATH environment variable 2-12
PDQPRIORITY environment variable 2-12
Performance 3-6
PLCONFIG environment variable 2-12
Port numbers, setting in database URL 2-6
PreparedStatement interface 2-14, 2-15, 2-21
prepareStatement() method 2-21
Properties class 2-10
Property lists 2-10
PropertyConnection.java example program A-2
PROTOCOLTRACE environment variable 3-4
PROTOCOLTRACEFILE environment variable 3-4
PSORT_DBTEMP environment variable 2-13
PSORT_NPROCS environment variable 2-13
put() method 2-10

Q

Querying the database 2-14

R

registerDriver() method 2-4
Registering Informix JDBC Driver 2-4
registerOutParameter() method 2-32
Remote Method Invocation (RMI) 2-31, 3-9
Restrictions and limitations of Informix JDBC Driver 2-31
ResultSet interface 2-14, 2-17, 2-21, 2-22, 2-23, 3-7
ResultSetMetaData interface 2-14
Retrieving
database names 2-14
Informix error message text 2-27
user names 2-14
version information 2-30
RMI 2-31
RSMetaData.java example program A-2

S

Schemas, Informix JDBC Driver interpretation 2-14
Security issues 3-8
SERIAL data type 2-28
SERIAL8 data type 2-28
setAsciiStream() method 2-15
setAutoCommit() method 2-27
setBinaryStream() method 2-15
setCatalog() method 2-32
setMaxFieldSize() method 2-32
setObject() method 2-21
setQueryTimeout() method 2-32
setReadOnly() method 2-32
Setting autocommit 2-27
Setting properties 2-10
Setting the CLASSPATH environment variable 1-12
setUnicodeStream() method 2-32
setup.class class file 1-6, 1-7, 1-9, 1-10
SimpleCall.java example program A-2
SimpleConnection.java example program A-2
SimpleSelect.java example program A-2
Specifying environment variables 2-7, 2-9
SQLException class 2-25, 2-27, 3-8
Statement interface 2-8, 2-14, 3-7
Supported environment variables 2-10
Supported getXXX() methods 2-23
Syntax of Database URL 2-5
sysmaster database 2-13
systables system table 2-14

T

TEXT data type 2-14, 3-6
TextType.java example program 2-17, 2-19, A-2
TRACE environment variable 3-4
TRACEFILE environment variable 3-4
Tracing 3-4
Transactions, handling 2-27
Tuple buffer 2-11, 3-6
Types interface 2-22, 2-29

U

Uninstalling Informix JDBC Driver 1-11
URLs, database 2-5
User names, setting in database URLs 2-7
USEV5SERVER environment variable 2-13
Using debug version of Informix JDBC Driver 3-3
Using Informix JDBC Driver
in an applet 1-13, 2-4
in an application 1-12
Using INFORMIX-OnLine 5.x database servers 2-13
Using the Informix serial data types 2-28
Utilities
jar 1-13

V

Version class 2-30
Version, of Informix JDBC Driver 2-30

X

X/Open compliance level Intro-10



Informix JDBC Driver Programmer's Guide, Version 1.22
Copyright © 1998, Informix Software, Inc. All rights reserved.