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.