##### jdbc2http

- Overview
- Connection
- Limitations
- Download

##### Supported Databases

- Overview
- MySQL

##### Server Side Drivers

- Scripts

##### Project Documentation

- Project Information
- Project Reports

## Database URL

The general structure of database URLs for jdbc2http is

- `jdbc:jdbc2http:`http-url-to-php-scripts or
- `jdbc:jdbc2http:`server-side-database-url`@`http-url-to-php-scripts

Examples:

    jdbc:jdbc2http:http://www.satline.com/jdbc2http/mysql
    jdbc:jdbc2http:db.satline.com:3306/shopdb@http://www.satline.com/jdbc2http/mysql

## Connection Arguments

As with every JDBC driver jdbc2http interprets a set of arguments passed to the connect request as `java.util.Properties`.

The property names understood by all PHP scripts on the server side are as follows:

user
  the database user
password
  the database password
data-format
  defines the format used for result set transmission from the server to the client. Format may be either xml (default) or csv.
csv.delimiter
  is the column delimiter used in CSV format. Default is a semicolon.
csv.quote
  is the character in CSV format used around complex column contents.

The following properties are used by the HTTP client:

http.user
  User name for HTTP authentication.
http.password
  Password for HTTP authentication.
http.realm
  User's NTLM domain name for HTTP authentication.
http.auth-host
  Host name used for HTTP authentication.
proxy.host
  Host name or IP address of HTTP proxy server.
proxy.port
  Port number of HTTP proxy server.
proxy.user
  User name for proxy authentication.
proxy.password
  Password for proxy authentication.
proxy.realm
  User's NTLM domain name for proxy authentication.
proxy.auth-host
  Host name used for proxy authentication.
log.level
  The log level(s) for server side logging:
  LOG_FATAL
    for all fatal errors
  LOG_ERROR
    for all errors
  LOG_WARN
    for warnings
  LOG_INFO
    for informational messages
  LOG_DEBUG
    for debugging messages
  LOG_TRACE
    for trace messages
  LOG_ALL
    for all messages

  log.level may be specified in form of a PHP expression like LOG_ALL & ~LOG_TRACE

All properties starting with `database.` are passed as parameters to the login PHP script with the `database.` prefix removed from the property name.