Feedback
2.5
Compatibility¶
Table of Contents
Version Notes¶
CrateDB¶
Consult the following table for CrateDB version compatibility notes:
Driver Version |
CrateDB Version |
Notes |
---|---|---|
1.x |
< 0.38 |
Not supported. |
1.x |
>= 0.38 |
Supported. Uses the (legacy, now removed) binary transport protocol, with a default port of 4300. |
Any |
< 0.55 |
Default schema selection is not supported. |
1.x |
>= 0.55 |
Not supported. |
2.x |
0.56.x |
Experimental support. The CrateDB For the JDBC driver, the
|
2.x |
>= 0.57.x |
Supported. The connection string changed to the same format used by the PostgreSQL JDBC driver. This means that setting the default schema with the connection string is not supported. Use setSchema() instead, or provide a schema name in the SQL statement. Also, support for the experimental
|
Any |
>= 2.1.x |
Client needs to connect with a valid database user to access CrateDB. The default CrateDB user is The enterprise edition of CrateDB allows you to create your own users. Prior versions of CrateDB do not support this feature. |
Implementation Notes¶
JDBC¶
The CrateDB JDBC driver follows the JDBC 4.1 standard.
However, the following notes apply:
ParameterMetaData (e.g. as returned by PreparedStatement) is not supported.
DataSource is not supported.
CallableStatement is not supported, as CrateDB itself does not support stored procedures.
ResultSet objects are read only (
TYPE_FORWARD_ONLY
,CONCUR_READ_ONLY
), so changes to aResultSet
are not supported.