Sun Microsystems JDBC/ODBC Adapter manual Jdbc

Models: JDBC/ODBC Adapter

1 133
Download 133 pages 48.36 Kb
Page 132
Image 132

Index

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

JDBC/ODBC eWay Adapter User’s Guide

132

Sun Microsystems, Inc.

Page 132
Image 132
Sun Microsystems JDBC/ODBC Adapter manual Jdbc