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