HXTT's JDBC Packages Documentation

Current documentation can be found here. This documentation is not intended as a complete guide to JDBC programming, but should help to get you started. For more information, refer to the standard JDBC API documentation(supplied with Sun's JDK). Also, take a look at the examples included with the HXTT Cobol packages. The basic example is used here.

Index:

Chapter 1. Quick Start

1. What Is the HXTT Cobol?
2. Follow Me

Chapter 2. Installation

1. System Requirements
2. Setting the CLASSPATH
3. Loading the Driver
4. Connecting to the Database

Chapter 3. Statement

1. Creating a Statement Instance
2. Issuing a Query
3. Performing Updates
4. Creating and Modifying Database Objects

Chapter 4. ResultSet

1. ResultSet Overview
2. Providing Performance Hints
3. Performing Updates
4. Serializing ResultSet

Chapter 5. Advanced Programming

1. Sending Very Large IN Parameters
2. Set Record Lock Manually
3. Encryption
4. Bulk Insert
5. Bulk Insert A ResultSet from any JDBC driver
6. SELECT ... INTO OUTFILE Syntax
7. Transaction Processing
8. RowSet
9. PooledConnection
10. SSL Connection
11. Run HXTT CobolServer as Windows Service or Linux(Solaris) Daemon
12. DBAdmin (A GUI Dtabase Server Manager)
13. How to Use Memory-only Table, Physical Table, Url table, Compressed table, SAMBA table in a SQL.
14. Create Table from any java.io.InputStream object.
15. Create Database from any compressed java.io.InputStream object.

Chapter 6. SQL Syntax

1. Select
2. Insert
3. Update
4. Delete
5. CREATE CATALOG
6. CREATE DATABASE
7. DROP DATABASE
8. CREATE TABLE
9. DROP TABLE
10. ALTER TABLE
11. TRUNCATE TABLE
12. PACK TABLE
13. RENAME TABLE
14. LOCK TABLE
15. UNLOCK TABLE
16. CREATE INDEX
17. DROP INDEX
18. REINDEX
19. CREATE VIEW
20. DROP VIEW
21. CREATE SEQUENCE
22. DROP SEQUENCE
23. ALTER SEQUENCE
24. SET TRANSACTION
25. START TRANSACTION
26. COMMIT
27. ROLLBACK
28. SAVEPOINT
29. RELEASE SAVEPOINT
30. Call Procedure
31. EXPLAIN
32. Pseudo Tables
33. Pseudo Columns
34. Declare Variable
35. SET Variable
36. Common Table Expression
37. Comment Syntax
38. SQL States

Chapter 7. Scalar Functions and Aggregate Functions

1. Mathematical Functions
2. Trigonometric Functions
3. String Functions
4. Date/Time Functions
5. Boolean Functions
6. System Functions
7. Conversion Functions
8. Security Functions
9. Sequence Functions
10. Regular Expresson Functions
11. Miscellaneous Functions
12. Aggregate Functions
13. Table Functions
14. ETL Functions

Chapter 8. Answers to Frequently Asked Questions (FAQ) for the HXTT Cobol packge

1. General Questions
2. Applet Questions
3. Remote Access Questions and Client/Server Mode Questions
4. SQL Questions
5. Index Questions
6. Performance Questions
7. Concurrence Questions
8. Internationalization Questions
9. Interoperability Questions

Chapter 9. OpenAPI Programming

1. Extend SQL functions
2. Start/Stop Server Programmatically with/without GUI manager
3. Customer Connection

Chapter 10. XPath for XML and JSON

1. XPath Introduction
2. XPath Syntax for XML and JSON
3. XPath Sample for XML and JSON

Chapter 11. JSON (JavaScript Object Notation) Support

1. json and jsonb Operators
2. JSON Functions
3. JSON sample

Chapter 12. XML (eXtensible Markup Language) Support

1. Declaration of XML Types
2. XML Functions
3. XML sample

Chapter 13. Array Type

1. Declaration of Array Types
2. Array Functions
3. Array sample

Chapter 14. NoSQL (Not Only SQL)

1. Declaration of NoSQL Types
2. NoSQL Functions
3. NoSQL sample