##### jdbc2http

- Overview
- Connection
- Limitations
- Download

##### Supported Databases

- Overview
- MySQL

##### Server Side Drivers

- Scripts
  - Login - dologin.php
  - Logout - dologout.php
  - Metadata - dodbmeta.php
  - Set Parameters - doparam.php
  - SQL - dosql.php
  - Prepared Statements

##### Project Documentation

- Project Information
- Project Reports

## dodbmeta.php

This script is a wrapper for scripts returning database meta data in result set format.

dodbmeta.php processes the following HTTP parameters:

PHPSESSID
  (required) the session ID returned from dologin.php
meta
  (required) the type of meta data requested. Must be one of the names in the table below.
format
  (optional) the format used to transmit the SQL result set. Can be either xml (default) or csv.
delimiter
  (optional) the column delimiter used for CSV downloads. Default is a semicolon (;).
quote
  (optional) the quote character used to enclose complex column values in CSV format. Defaults to a double quote (").

There may be more parameters depending on the type of meta data request.

The response structure returned by dodbmeta.php is the same as for dosql.php. Table structures of the meta data returned are described for each type below.

meta= | Information returned
catalogs | catalogs and their properties
columns | columns of a table and their properties
indexes | indexes of a table and their properties
schemas | schemas in database and their properties
tables | tables and their properties
tbltypes | tables and pseudo table types supported by database
typeinfo | types supported by database
Meta Data Types

## meta=catalogs

This meta data request returns information about the database's catalogs and their properties. It has no specific parameters.

The result set returned is described in DatabaseMetaData.getCatalogs() of the Java API.

## meta=columns

This meta data request returns information about the columns of a table in the database. Additional parameters are:

catalog
  (optional) catalog of the table
schema-pattern
  (optional) schema name pattern
name-pattern
  table name pattern
column-name-pattern
  (optional) column name pattern

More information about the parameters and the result set returned is described in DatabaseMetaData.getColumns() of the Java API.

## meta=indexes

This meta data request returns information about the indexes of a table in the database. Additional parameters are:

catalog
  (optional) catalog of the table
schema
  (optional) schema of the table
table
  table name
unique
  when true, return only indices for unique values; when false, return indices regardless of whether unique or not
approximate
  when true, result is allowed to reflect approximate or out of data values; when false, results are requested to be accurate

More information about the parameters and the result set returned is described in DatabaseMetaData.getIndexInfo() of the Java API.

## meta=schemas

This meta data request returns information about schemas in the database. It has no additional parameters.

Information about the result set returned is described in DatabaseMetaData.getSchemas() of the Java API.

## meta=tables

This meta data request returns information about tables in the database. Additional parameters are:

catalog
  (optional) catalog of the table
types
  (optional) schema of the table
schema-pattern
  (optional) schema name pattern
name-pattern
  table name pattern

More information about the parameters and the result set returned is described in DatabaseMetaData.getTables() of the Java API.

## meta=tbltypes

This meta data request returns table types used in the database. It has no additional parameters.

More information about the parameters and the result set returned is described in DatabaseMetaData.getTableTypes() of the Java API.

## meta=typeinfo

Retrieves a description of all the data types supported by this database. It has no additional parameters.

More information about the parameters and the result set returned is described in DatabaseMetaData.getTypeInfo() of the Java API.