XdbcFirebirdSqlUtilBase Module

Table of Contents

• XdbcFirebirdSqlUtilBase Module Introduction
• Schema Management on Firebird
  • Type Mapping
• Release Notes
  • XdbcFirebirdSqlUtilBase Module v0.1

XdbcFirebirdSqlUtilBase Module Introduction

The XdbcFirebirdSqlUtilBase module provides a high level API for working with Firebird database objects through xdbc and jdbc drivers in Qore.

Usually this module is loaded on demand from the SqlUtil module, however to use this module directly, use "%requires XdbcFirebirdSqlUtilBase" in your code.

All the public symbols in the module are defined in the XdbcFirebirdSqlUtilBase namespace

Note

• This module requires the xdbc or jni binary modules for communication with Firebird databases plus the Firebird client library and the Firebird XDBC driver or the Firebird JDBC drivers
• This module supports basic DDL / schema management for Firebird DBs and basic functionality for DML as well

Schema Management on Firebird

Type Mapping

Column types are mapped from Qore types as follows:

XdbcFirebird Column Type Mappings

Qore Type Name	Firebird Type Used
int	bigint
float	double precision
number	varchar
string	varchar
date	timestamp
binary	blob sub_type text
bool	boolean
SqlUtil::BLOB	blob
SqlUtil::CHAR	char
SqlUtil::CLOB	blob sub_type text

Release Notes

XdbcFirebirdSqlUtilBase Module v0.1

• initial release