3.00.5.0

New Features

Added support for the executeUpdate method of JDBCStatement and JDBCPreparedStatement to return the number of rows affected by delete, update, and insert into statements. This feature is available only when connected to DolphinDB Server version 3.00.5 or later.

Issues Fixed

Fixed the issue where calling clearBatch() on JDBCPreparedStatement incorrectly cleared the precompiled SQL statement.

3.00.4.0

New Features

• Added support for Array Vector.

Issues Fixed

• Fixed an SQL injection vulnerability.

3.00.2.2

• Fix SQL injection issue.

3.00.3.0

Improvements

• moved quotation marks from field names in the result of getSchemas.
• Swapped the positions of the TABLE_SCHEM and TABLE_NAME columns in the result returned by getTables.
• Added support for passing null as the schemaPattern parameter in getTables to match all schemas.

3.00.2.1

Improvements

• Added support for user login authentication to enhance security.

3.00.2.0

New Features

• Added support for method setQueryTimeout(int seconds) in JDBCStatement and JDBCPreparedStatement for setting SQL query timeout.

• Added reconnect parameter to JDBCConnection for automatic reconnection.

3.00.1.1

Improvements

• Job parallelism can be set on the server side using setMaxJobParallelism.

3.00.1.0

New Features

• For versions before 3.00.1.0, ResultSet may return a scalar/vector/matrix. Since version 3.00.1.0, these forms are converted and returned as tables.

  Note: This change may affect compatibility with existing code that expects scalar/vector/matri results.

• The getResult method of JDBCResultSet has been marked as deprecated.

• PreparedStatement aligns the handling logic of DECIMAL 32/64 data with DECIMAL128, which now supports string representation with setObject to ensure high-precision transmission.

• The getColumns method of DatabaseMetaData now supports retrieval of column information for all tables under a specified catalog.schema.

3.00.0.1

New Features

• Added support for methods on catalog operations such as supportsSchema and supportsCatalog.
• Added methods setFetchDirection and getFetchDirection for setting and getting the direction of fetching rows of ResultSet. Note that DolphinDB JDBC only supports ResultSet.FETCH_FORWARD.

Improvements

• Optimized the return value of getIdentifierQuoteString.
• Added support for querying fields containing special character $.
• Added support for calling data type conversion methods with brackets within the insert into statement.
• Added support for "NULL" or " " in the insert into statement when writing data to a DFS table.
• Methods executeQuery and executeUpdate of JDBCPreparedStatement class support statements without placeholders.
• Added support for calling loadTable in the update statement on DFS tables with class JDBCPreparedStatement or JDBCStatement.
• Optimized the logic of method clearParameter of the JDBCPreparedStatement class.

Issues Fixed

• Fixed an issue where connection was established in unauthenticated mode if the JDBC URL only specified user or password. An error is now reported.

1.30.22.5

1.30.22.5

New Features

• Added the following new methods to the JDBCDataBaseMetaData class:

  • setCatalog to set the database catalog name to select a subspace of the Connection object's database in which to work.
  • getCatalogs to get the database catalogs.
  • getTables to get information of specific tables.
  • getColumns to get information of specific columns.

• Added getBigDecimal method to the JDBCResult class to retrieve the value of specified column as BigDecimal type. It can be called in two ways:

  BigDecimal getBigDecimal(int columnIndex) throws SQLException;
  BigDecimal getBigDecimal(String columnLabel) throws SQLException;
  

• The commit() and rollback() methods of JDBCConnection class do not support transactions at user level and return null by default.

• Added method setMaxRows to the JDBCStatement class to set the upper limit for the number of records that a ResultSet object can contain.

• Added method getMaxRows to the JDBCStatement class to get the specified upper limit for the number of records applied to the ResultSet object.

• The insert into clause of JDBCPrepareStatement class now writes data in batches instead of by record.

• The insert into clause of JDBCPrepareStatement class now supports inserting data to specific columns, and null values are written to the rest columns.