Contents

Title and Copyright Information

Preface

• Documentation Accessibility
• Conventions

1 Introduction and Roadmap

• Document Scope and Audience
• Guide to this Document
• Related Documentation
• JDBC Samples and Tutorials
  • Avitek Medical Records Application (MedRec) and Tutorials
  • JDBC Examples in the WebLogic Server Distribution
• New and Changed JDBC Features in This Release

2 Using WebLogic Type 4 JDBC Drivers

• JDBC Specification Compliance
• Installation
• Supported Databases
• Connecting Through WebLogic JDBC Data Sources
• Specifying Connection Properties
  • Limiting Connection Creation Time with LoginTimeout
• Using IP Addresses
• Using Security
  • Authentication
    • Kerberos Authentication Requirements
    • NTLM Authentication Requirements
  • Data Encryption Across the Network
  • SSL Encryption
    • SSL Server Authentication
    • SSL Client Authentication (DB2 Drivers)
• Required Permissions for the Java Security Manager
  • Permissions for Establishing Connections
  • Granting Access to Java Properties
  • Granting Access to Temporary Files
  • Permissions for Kerberos Authentication
    • DB2
    • Microsoft SQL Server
    • Sybase
• XA Support
• Unicode Support
• Error Handling
  • Driver Errors
  • Database Errors

3 The DB2 Driver

• DB2 Driver Classes
• DB2 URL
• DB2 Connection Properties
• Performance Considerations
  • CatalogIncludesSynonyms
  • CatalogSchema
  • EncryptionMethod
  • InsensitiveResultSetBufferSize
  • ResultSetMetaDataOptions
  • SendStreamAsBlob
  • StripNewLines
  • UseCurrentSchema
• Setting the locationName on AS/400
• Creating a DB2 Package
  • Creating a DB2 Package Using dbping
  • Creating a DB2 Package Using Connection Properties
    • Example for DB2 for Linux/UNIX/Windows:
    • Example for DB2 for z/OS and iSeries:
  • Notes About Increasing Dynamic Sections in the DB2 Package
• Data Types
• Returning and Inserting/Updating XML Data
  • Returning XML Data
    • Character Data
    • Binary Data
  • Inserting/Updating XML Data
    • Character Data
    • Binary Data
• Authentication
  • Using the AuthenticationMethod Property
  • Configuring User ID/Password Authentication
  • Configuring Kerberos Authentication
    • Product Requirements
    • Configuring the Driver
  • Specifying User Credentials for Kerberos Authentication
  • Obtaining a Kerberos Ticket Granting Ticket
  • Configuring Client Authentication
• Data Encryption
  • Configuring SSL Encryption
  • SSL Connection Properties
• Non-Default Schemas for Catalog Methods
• SQL Escape Sequences
• Isolation Levels
• Using Scrollable Cursors
• JTA Support
• Large Object (LOB) Support
• Batch Inserts and Updates
• Parameter Metadata Support
  • Insert and Update Statements
  • Select Statements
  • Stored Procedures
• ResultSet Metadata Support
• Rowset Support
• Auto-Generated Keys Support
• Database Connection Property
• DatabaseName Connection Property
• New Data Types
• SQL Procedures for z/OS
• IPv6 Support

4 The Informix Driver

• Informix Driver Classes
• Informix URL
• Informix Connection Properties
  • Informix Limitation for Prepared Statements
• Performance Considerations
  • FetchBufferSize
  • InsensitiveResultSetBufferSize
• ResultSetMetaDataOptions
• Data Types
• SQL Escape Sequences
• Isolation Levels
• Using Scrollable Cursors
• Parameter Metadata Support
  • Insert and Update Statements
  • Select Statements
  • Stored Procedures
• ResultSet MetaData Support
• Rowset Support
• Blob and Clob Searches
• FILETOBLOB Feature Support
• Auto-Generated Keys Support
• Database Connection Property

5 The Sybase Driver

• Driver Classes
• Sybase URL
• Sybase Connection Properties
• Performance Considerations
  • BatchPerformanceWorkaround
  • EncryptionMethod
  • InsensitiveResultSetBufferSize
  • LongDataCacheSize
  • PacketSize
  • PrepareMethod
  • ResultSetMetaDataOptions
  • SelectMethod
• Data Types
• Authentication
  • Using the AuthenticationMethod Property
  • Configuring User ID/Password Authentication
  • Configuring Kerberos Authentication
    • Product Requirements
    • Configuring the Driver
  • Specifying User Credentials for Kerberos Authentication
  • Obtaining a Kerberos Ticket Granting Ticket
• Data Encryption
• SQL Escape Sequences
• Isolation Levels
• Using Scrollable Cursors
• Large Object (LOB) Support
• Batch Inserts and Updates
• Parameter Metadata Support
• ResultSet MetaData Support
• Rowset Support
• Auto-Generated Keys Support
• NULL Values
• Sybase JTA Support
• Database Connection Property

6 The MS SQL Server Driver

• Driver Class
• Microsoft SQL Server URL
• Connecting to Named Instances
• SQL Server Connection Properties
• Performance Considerations
  • EncryptionMethod
  • InsensitiveResultSetBufferSize
  • LongDataCacheSize
  • PacketSize
  • ResultSetMetaDataOptions
  • SelectMethod
  • SendStringParametersAsUnicode
  • SnapshotSerializable
  • UseServerSideUpdatableCursors
• Data Types
• Returning and Inserting/Updating XML Data
  • Returning XML Data
    • Character Data
    • Binary Data
  • Inserting/Updating XML Data
    • Character Data
    • Binary Data
• Authentication
  • Using the AuthenticationMethod Property
  • Configuring SQL Server Authentication
  • Configuring Kerberos Authentication
    • Product Requirements
    • Configuring the Driver
  • Specifying User Credentials for Kerberos Authentication
  • Obtaining a Kerberos Ticket Granting Ticket
  • Configuring NTLM Authentication
    • Product Requirements
    • Configuring the Driver
• Data Encryption
  • Using SSL with Microsoft SQL Server
  • Configuring SSL Encryption
• DML with Results (Microsoft SQL Server 2005)
• SQL Escape Sequences
• Isolation Levels
• Using the Snapshot Isolation Level (Microsoft SQL Server 2005 Only)
• Using Scrollable Cursors
• Server-Side Updatable Cursors
• Installing Stored Procedures for JTA
• Distributed Transaction Cleanup
  • Transaction Timeout
  • Explicit Transaction Cleanup
• Large Object (LOB) Support
• Batch Inserts and Updates
• Parameter Metadata Support
  • Insert and Update Statements
  • Select Statements
  • Stored Procedures
• ResultSet MetaData Support
• Rowset Support
• Auto-Generated Keys Support
• Null Values
• Database Connection Property

A JDBC Support

• JDBC Compatibility
• Supported Functionality
  • Array Object
  • Blob Object
  • CallableStatement Object
  • Clob Object
  • Connection Object
  • DatabaseMetaData Object
  • Driver Object
  • ParameterMetaData Object
  • PreparedStatement Object
  • Ref Object
  • ResultSet Object
  • ResultSetMetaData Object
  • SavePoint Object
  • Statement Object
  • Struct Object
  • XAConnection Object
  • XADataSource Object
  • XAResource Object

B GetTypeInfo

• DB2 Driver
• Informix Driver
• SQL Server Driver
• Sybase Driver

C SQL Escape Sequences for JDBC

• Date, Time, and Timestamp Escape Sequences
• Scalar Functions
• Outer Join Escape Sequences
• LIKE Escape Character Sequence for Wildcards
• Procedure Call Escape Sequences

D Tracking JDBC Calls with WebLogic JDBC Spy

• Configuring WebLogic JDBC Data Sources for WebLogic JDBC Spy
• WebLogic JDBC Spy URL Attributes
• WebLogic JDBC Spy Log Example