##### jdbc2http

- Overview
- Connection
- Limitations
- Download

##### Supported Databases

- Overview
- MySQL

##### Server Side Drivers

- Scripts

##### Project Documentation

- Project Information
- Project Reports

## Limitations of the Database Driver

With the HTTP protocol used to transmit commands and data between the client application and the web server, there are some limitations in functionality.

1. The total amount of data retrieved by a single SELECT is limited by the maximum size of an HTTP response from the server
2. auto-commit must always remain true.
3. Savepoints are not implemented.
4. Several feature query methods in the java.sql.DatabaseMetaData interface remain unimplemented.
5. Blob handling is not implemented.
6. The SQLXML interface is not supported.
7. Structured types are not supported.
8. Rowids are not supported.
9. Statement pooling is not supported.
10. Streams for PreparedStatement parameters and ResultSet columns cannot be used.
11. PreparedStatement.getMetaData() is not implemented.
12. SQL DATALINK (URL) column values and PreparedStatement parameters are not supported.
13. CallableStatement methods are all unimplemented.
14. Updates, inserts, and deletes in result sets are not possible.