HXTT's JDBC Packages Documentation

Welcome to the HXTT Text (CSV) v4.2 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 Text (CSV) packages. The basic example is used here.

Index:

Chapter 1. Quick Start

  1. What Is the HXTT Text (CSV)?
  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. Table Level Encryption
  4. Bulk Insert
  5. Bulk Insert A ResultSet from any JDBC driver
  6. Transaction Processing
  7. RowSet
  8. PooledConnection
  9. SSL Connection
  10. Run HXTT Text (CSV)Server as Windows Service or Linux(Solaris) Daemon
  11. DBAdmin (A GUI Dtabase Server Manager)
  12. How to Use Memory-only Table, Physical Table, Url table, Compressed table, SAMBA table in a SQL.
  13. Create Table from any java.io.InputStream object.

Chapter 6. SQL Syntax

  1. Select
  2. Insert
  3. Update
  4. Delete
  5. CREATE CATALOG
  6. CREATE TABLE
  7. DROP TABLE
  8. ALTER TABLE
  9. TRUNCATE TABLE
  10. PACK TABLE
  11. RENAME TABLE
  12. LOCK TABLE
  13. UNLOCK TABLE
  14. CREATE INDEX
  15. DROP INDEX
  16. REINDEX
  17. CREATE SEQUENCE
  18. DROP SEQUENCE
  19. ALTER SEQUENCE
  20. SET TRANSACTION
  21. START TRANSACTION
  22. COMMIT
  23. ROLLBACK
  24. SAVEPOINT
  25. RELEASE SAVEPOINT
  26. Call Procedure
  27. Declare Variable
  28. SET Variable
  29. Comment Syntax
  30. 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. Miscellaneous Functions
  11. Aggregate Functions

Chapter 8. Answers to Frequently Asked Questions (FAQ) for the HXTT Text (CSV) 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
  3. Customer Connection
  4. Get the table structure creation sql from ODBC compatible schema ini file
Copyright © 2008 Hongxin Technology & Trade Ltd. | All Rights Reserved. |