beautypg.com

Sun Microsystems eWay JDBC/ODBC Adapter User Manual

Page 132

background image

Index

JDBC/ODBC eWay Adapter User’s Guide

132

Sun Microsystems, Inc.

JCD operations 59

delete(String sWhere) 59
deleteRow() 59
insert() 59
insertRow() 59
select(String where) 59
update(String sWhere) 59
updateRow() 59

JDBC

driver class 33, 35, 38

JDBC eWay Project

building and deploying (BPEL) 95
eInsight and eGate components 72
Importing 73
running sample projects 94, 115
running the SQL script 73

JDBC_BPEL_Sample 69

M

migration procedures 19
MySQL Connector/J Driver 121

O

operations 57
OTD, editing existing 56
outbound eWay properties 31
Outbound JDBC eWay Properties 32, 35, 37
outbound XA properties 31

P

PostgreSQL Driver 122
prepared statement

batch operations 67
executing 67

Project

importing 73

properties

ConnectionRetries 34, 37, 39
ConnectionRetryInterval 35, 37, 40
DatabaseName 33, 36, 38
Delimiter 33, 36, 38
Description 31, 32, 33, 35, 38
DriverProperties 33, 36, 38
MaxIdleTime 34, 37, 39
MaxPoolSize 34, 37, 39
MinPoolSize 34, 36, 39
Password 32, 33, 36, 38
PortNumber 33, 36, 38
ServerName 33, 35, 38
User 32, 33, 36, 38

R

ResultSet

collaboration usability for a stored procedure 66

ResultSet methods

available 65
enableResultSetandUpdateCounts 65
enableResultSetOnly 65
enableUpdateCountsOnly 65
getUpdateCount 65
next 65
resultsAvailable 65

S

sample Projects 73
sample projects, installing 19
Select Database Objects 43
Select Procedures 49
Select Table/Views 44
Sequelink Informix ODBC Driver 125
Sequelink MS Access ODBC Driver 126
Setting Properties

configuring JDBC eWay 25
connection retry settings 34, 37, 39
eWay Connectivity Map 25, 30
eWay environment properties 29
outbound eWay 31
outbound XA properties 31

SQL 60
SQL operations, table 60
SQL operations, table Delete 63
SQL operations, table Insert 61
SQL operations, table Select 60
SQL operations, table Update 62
Stored Procedure

executing 64
manipulating ResultSet and update count 65

supporting documents 15
Sybase JConnect Driver 124

T

Table

SQL operations 60
SQL operations, Delete 63
SQL operations, Insert 61
SQL operations, Select 60
SQL operations, Update 62

Teradata Driver 128
text conventions 15
Transaction Support Levels 27
Troubleshooting 130