English Español Português Italiano
Tutorials Guide Help
Sitemap Adobe Autodesk Microsoft Corel Sony GNU Others

DataDirect Connect JDBC Tutorial - Userīs guide and reference


 









DataDirect Connect JDBC Tutorial - Userīs guide and reference

DataDirect Connect JDBC Tutorial - Userīs guide and reference FREE DOWNLOAD THIS TUTORIAL
Tutorial in pdf format so you can save it to your PC, e-book reader or print.


Sponsored link



Note: The tutorial you are about to download is compressed format. Rar, if you do not have a decompressor rar files you can download 7-zip and you can display the Foxit PDF Reader.



Index DataDirect Connect JDBC Tutorial - Userīs guide and reference


Preface
Using This Book
Typographical Conventions
About Connect JDBC Documentation
Ordering Printed Books
Contacting Technical Support
1 Quick Start
Connecting to a Database
1. Setting the Classpath
2. Registering the Driver
3. Passing the Connection URL
Testing the Connection
2 Using Connect JDBC
About the Connect JDBC Components
Connect JDBC Drivers
JDBCTest
Spy JDBC Driver
Connecting Through the JDBC Driver Manager
URL Examples
Connecting Through Data Sources
How Connect JDBC Data Sources Are Implemented
Creating Connect JDBC Data Sources
Calling a Data Source in an Application
Using Connection Pooling
Specifying Connection Properties
Testing Connect JDBC Connections
Using the Connect JDBC Drivers on a Java 2 Platform
Error Handling
Connect JDBC Driver Errors
Database Errors
Connect JDBC Driver Directory Structure
3 Connect JDBC for DB2
Data Source and Driver Classes
Connection String Properties
Improving Character Set Conversion Performance
Data Types
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
4 Connect JDBC for Informix
Data Source and Driver Classes
Connection String Properties
Data Types
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
5 Connect JDBC for Oracle
Data Source and Driver Classes
Connection String Properties
Data Types
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
JTA Support
6 Connect JDBC for SQL Server
Data Source and Driver Classes
Connection String Properties
Data Types
SQL Server 2000
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
Installing Stored Procedures for JTA
7 Connect JDBC for Sybase
Data Source and Driver Classes
Connection String Properties
Data Types
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
A JDBC Support
JDBC Compatibility
Supported Functionality
B Connect JDBC GetTypeinfo
DB2 Drivers
Informix Driver
Oracle Driver
SQL Server Driver
SQL Server 2000 Only
Sybase Driver
C Designing JDBC Applications for Performance
Optimization
Using Database Metadata Methods
Minimizing the Use of Database Metadata Methods
Avoiding Search Patterns
Using a Dummy Query to Determine Table
Characteristics
Retrieving Data
Retrieving Long Data
Reducing the Size of Data Retrieved
Choosing the Right Data Type
Selecting JDBC Objects and Methods
Using Parameter Markers as Arguments to
Stored Procedures
Using the Statement Object instead of the
PreparedStatement Object
Choosing the Right Cursor
Designing JDBC Applications
Managing Connections
Managing Commits in Transactions
Choosing the Right Transaction Model
Updating Data
Using updateXXX Methods
Using getBestRowIndentifier()
Conclusion
D SQL Escape Sequences for JDBC
Date, Time, and Timestamp Escape Sequences
Scalar Functions
Outer Join Escape Sequences
Procedure Call Escape Sequences
E Using JDBCTest
JDBCTest Tutorial
Starting JDBCTest
Configuring JDBCTest
Connecting Using JDBCTest
Executing a Simple Select Statement
Executing a Prepared Statement
Retrieving Database Metadata
Scrolling Through a Result Set
Batch Execution on a Prepared Statement
F Tracking JDBC Calls with Spy
Loading the Spy JDBC Driver
Spy URL Syntax and Spy Attributes
Spy URL Examples
Using Spy with JDBC Data Sources
Spy Log Example
Index







Download the file decompressor 7-zip.
Download the PDF reader Foxit PDF Reader.




TutorialsPDF.com © 2008 - This work is licensed under a Creative Commons License.