About This Manual

This manual describes how to use the JDBC driver provided by Altibase. Altibase's JDBC drivers are mostly compliant with the JDBC specification, but in some cases operate out of specification. Before writing an application using JDBC, it is recommended that you read this manual to familiarize yourself with the JDBC specifications and other parts.

Audience

This manual has been prepared for the following users of Altibase:

• Database administrators
• Performance administrators
• Database users
• Application developers
• Technical Supporters

It is recommended for those reading this manual possess the following background knowledge:

• Java Programming Language

• SQL

• Stored Procedure

• Understanding Altibase

Organization

This manual is organized as follows:.

• Chapter 1: Starting JDBC
  This chapter offers basic instructions on how to use the Altibase JDBC driver.

• Chapter 2: Basic Functions
  This chapter explains how to connect to the database server with an IPv6 address and comparatively describes three statements that can be used in JDBC application programs.

• Chapter 3: Advanced Functions
  This chapter introduces advanced functions provided by the Altibase JDBC driver and explains how to use them.

• Chapter 4: Tips & Recommendation
  This chapter provides instructions for the efficient use of the Altibase JDBC driver.

• Chapter 5: Error Messages
  This chapter lists the SQL States of errors which can occur while using the Altibase JDBC driver.

• Appendix A: Data Type Mapping
  This appendix lists the compatibility between Altibase data types and standard JDBC data types/Java data types.

Documentation Conventions

This section describes the conventions used in this manual. Understanding these conventions will make it easier to find information in this manual and in the other manuals in the series.

There are two sets of conventions:

• Syntax diagram conventions
• Sample code conventions

Syntax Diagram Conventions

This manual describes command syntax using diagrams composed of the following elements:

Elements	Meaning
	Indicates the start of a command. If a syntactic element starts with an arrow, it is not a complete command.
	Indicates that the command continues to the next line. If a syntactic element ends with this symbol, it is not a complete command.
	Indicates that the command continues from the previous line. If a syntactic element starts with this symbol, it is not a complete command.
	Indicates the end of a statement.
	Indicates a mandatory element.
	Indicates an optional element.
	Indicates a mandatory element comprised of options. One, and only one, option must be specified.
	Indicates an optional element comprised of options
	Indicates an optional element in which multiple elements may be specified. A comma must precede all but the first element.

Sample Code Conventions

The code examples explain SQL statements, stored procedures, iSQL statements, and other command line syntax.

The following table describes the printing conventions used in the code examples.

Rules	Meaning	<Example>
[ ]	Indicates an optional item	VARCHAR [(size)] [[FIXED |] VARIABLE]
{ }	Indicates a mandatory field for which one or more items must be selected.	{ ENABLE | DISABLE | COMPILE }
|	A delimiter between optional or mandatory arguments.	{ ENABLE | DISABLE | COMPILE } [ ENABLE | DISABLE | COMPILE ]
. . .	Indicates that the previous argument is repeated, or that sample code has been omitted.	iSQL> SELECT e_lastname FROM employees; E_LASTNAME ------------------------ Moon Davenport Kobain . . . 20 rows selected.
Other Symbols	Symbols other than those shown above are part of the actual code.	EXEC :p1 := 1; acc NUMBER(11,2)
Italics	Statement elements in italics indicate variables and special values specified by the user.	SELECT * FROM table_name; CONNECT userID/password;
Lower case words	Indicate program elements set by the user, such as table names, column names, file names, etc.	SELECT ename FROM employee;
Upper case words	Keywords and all elements provided by the system appear in upper case.	DESC SYSTEM.SYS_INDICES;

Related Documentations

For more detailed information, please refer to the following documents.

• Administrator's Manual

• Replication Manual

• Spatial SQL Reference

Altibase Welcomes Your Comments and Feedbacks

We welcome your feedback on this manual. Your input is valuable in helping us improve future versions of the manual.

If you find any errors, omissions, or other technical issues in the Altibase manual, please report them through the Technical Support Portal, and we will address them with care. For immediate assistance with technical matters, you may also request support through the Technical Support Portal.