HXTT's JDBC Packages Documentation

Welcome to the HXTT Paradox v6.0 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 Paradox packages. The basic example is used here.

Index:

Chapter 1. Quick Start

  1. What Is the HXTT Paradox?
  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 ParadoxServer 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 Paradox 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
Copyright © 2003-2019 Heng Xing Tian Tai Lab | All Rights Reserved. |