This document is intended for developers who want to develop applications using various application libraries provided by Tibero.
The user must have knowledge of the following in order to understand this guide:
Database
RDBMS
Java programming
tbPSM language and package usage
This guide does not contain all the information required to operate Tibero. For information related to installation, configuration, operation and management, refer to each relevant guide.
For more information about Tibero installation and configuration, refer to Tibero Installation Guide.
This guide consists of seven chapters and two appendixes. Descriptions for each section are as follows:
Chapter 1: Data Types
Describes the data types provided by Tibero and explains their usage.
Chapter 2: tbJDBC
Describes how to use tbJDBC.
Chapter 3: Trigger
Describes how to use a trigger.
Chapter 4: XA
Describes how to use XA (Extended Architecture) to handle distributed transactions.
Chapter 5: mod_tbPSM
Describes how to use mod_tbPSM that calls tbPSM procedures and gets HTML pages using Apache HTTP web server.
Chapter 6: Object Type
Describes Tibero object types and how they work.
Chapter 7: Collection Type
Describes Tibero collection types and how to use them.
Appendix A: tbJDBC Example
Provides the full source code of an example program written using tbJDBC.
Appendix B: Example of Integrating with Tuxedo
Provides the full source code of an example program that integrates Tibero with Tuxedo and relevant scripts.
| Convention | Meaning |
|---|---|
| <AaBbCc123> | Program source code file name |
| <Ctrl>+C | Hold down the Ctrl key and press the C key |
| [Button] | Name of a GUI button or menu |
| Bold | Emphasis |
| Italics | Reference to another guide |
| " " (Double quotation marks) | Reference to a chapter or section in this or another guide |
| 'Input' | User input on the screen |
Hyperlink
| Email account, website, or a reference to other chapters or sections |
| > | Proceeding order of menu |
| +---- | Files or directories exist in this directory |
| |---- | Files or directories do not exist in this directory |
Note | Reference or caution |
| [Figure 1.1] | Figure caption |
AaBbCc123 | Commands, screen output after executing command, or sample code |
| { } | Required items |
| [ ] | Optional items |
| | | Selective items |
| Version | Description |
|---|---|
System Requirements
Requirements Platform HP-UX 11i (IA64) Solaris (Solaris 10) AIX (PPC 5L/AIX 5.3) GNU (X86-64, IA-64) Linux kernel 2.6 or later Windows (x86) 32-bit/64-bit Hardware At least 2.5 GB hard disk space More than 1 GB RAM Compiler PSM (C99 support needed) tbESQL/C (C99 support needed)
| Document | Description |
|---|---|
Tibero Installation Guide | Describes the system requirements and specific methods for installation and uninstallation. |
Tibero tbCLI Guide | Describes the tbCLI (Call Level Interface) concepts, components and program structure, as well as data types, functions, and error messages needed to write tbCLI applications. |
Tibero External Procedure Guide | Describes how to create and use external procedures. |
Tibero JDBC Developer's Guide | Describes how to develop application programs by using the JDBC functions provided in Tibero. |
Tibero tbESQL/C Guide | Describes how to create various database application programs in the C programming language. |
Tibero tbESQL/COBOL Guide | Describes how to create various database application programs in the C programming language. |
Tibero tbPSM Guide | Introduces the concepts, syntax, and components of tbPSM (Procedure Storage Module). This guide also describes how to execute the control structure, complex type, sub programs, packages, and SQL statements required for creating a tbPSM program and to handle any errors. |
Tibero tbPSM Reference Guide | Introduces the tbPSM package, a storage procedure module. This guide also describes the prototypes, parameters, and examples of each procedure and function included in this package. |
Tibero Administrator's Guide | Describes how to manage Tibero in order to guarantee smooth operation. This guide also describes the various functions that support management. |
Tibero Utility Guide | Describes how to install, use, and configure the utilities that handle database related operations. |
Tibero TAS Guide | Describes how to manage files in Tibero Active Storage (TAS). |
Tibero Error Reference Guide | Describes troubleshooting methods for various errors that may occur while using Tibero. |
Tibero Reference Guide | Describes the initialization parameters, data dictionary, and static and dynamic views used by Tibero. |
Tibero SQL Reference Guide | Describes the SQL statements required for creating application programs or operating a database. |
Tibero Spatial Reference Guide | Describes the geometry type and spatial procedures and functions of Tibero and how to use them. |
Tibero TEXT Reference Guide | Describes how to create and use the text index provided by Tibero. |